RE: Login.sql and global name value

It's an ALTER SYSTEM or ALTER DATABASE command. SET GLOBAL_NAME = blah;

This flushes the shared pool, so it might take a little while to complete.

Lyall

------Original Message------
From: rsands_at_lendleaserei.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: May 30, 2000 7:07:07 PM GMT
Subject: Login.sql and global name value

I liked the script too ... but when I put it in place, I discovered that the global name value is incorrect for several instances that were cloned by recreating the control file. How do I get the global name value reset to match
the name value in v$database? Can I update, or will I do irreversible harm to
my databases?

Robyn

Ari D Kaplan <akaplan_at_interaccess.com> on 05/30/2000 11:56:03 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Robyn Sands/US1/Lend Lease)

Nice script. I like to SET LONG 100000 (more than 800, which is good for viewing trigger and view definitions). Also, I think there should be spaces after the ')', such as:

to_char(sysdate,'MM/DD/YY HH24:MI') d from global_name; ^

See what you mean about everyone having access to GLOBAL_NAME. I am sure that everyone has their favorite prompt and appreciate seeing what people do out there. I personally like seeing the machine name and SID in my prompt.

Take care,

-Ari

www.arikaplan.com

On Tue, 30 May 2000 dgoulet_at_vicr.com wrote:

> Ari,
>
> Try this as your login.sql. Everyone has access here.
>
> set numwidth 10
> set pagesize 24
> set linesize 79
> set pause 'Press ENTER/Return for more .....>'
> set copycommit 5
> set long 800
> column text format A70 word
> define _editor=edit
> column d format A15
> set arraysize 1
> break on name on user
> column gname new_value _name noprint
> column user new_value _user noprint
> column d heading 'Current date/time' format A18
> select substr(global_name,1,instr(global_name,'.')-1)gname,user,
> to_char(sysdate,'MM/DD/YY HH24:MI')d from global_name;
> set sqlprompt "&_name:&_user> "
> clear breaks
> clear column
> set arraysize 15
> --
> Author:
> INET: dgoulet_at_vicr.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

--
Author: Ari D Kaplan
INET: akaplan_at_interaccess.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).






--
Author:
INET: rsands_at_lendleaserei.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).