RE: Login.sql and global name value

From: Willett, Mark <mwillett_at_sunnen.com>
Date: Wed, 31 May 2000 07:54:45 -0500
Message-Id: <10514.107271@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_000_01BFCAFF.6564F690

Content-Type: text/plain

In our clone process, after we have used svrmgrl to create the control file and have altered the database open, we "Select * from v$database" to make sure we didn't screw up the sid for this instance. Then we "select * from global_name". This shows the name of the db from which we cloned. We then "alter database rename global_name to <your name here>" to correct the global name. In our case it is: "alter database rename global_name to bogus.world.com" where "bogus" is the sid name. So far, this has not caused us any harm.

HTH Mark Willett
Database Administrator
Sunnen Products Company
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\ The statements and opinions expressed herein are my own and do not necessarily reflect those of Sunnen Products Company. \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/

-----Original Message-----

From: Lyall Barbour [mailto:lyallbarbour_at_sanfranmail.com] Sent: Wednesday, May 31, 2000 4:18 AM
To: Multiple recipients of list ORACLE-L Subject: 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------

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: May 30, 2000 7:07:07 PM GMT

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

FREE Personalized Email at Mail.com
Sign up at http://www.mail.com/?sr=signup

--

Author: Lyall Barbour
INET: lyallbarbour_at_sanfranmail.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

------_=_NextPart_000_01BFCAFF.6564F690

Content-Type: application/octet-stream;

name="Willett, Mark.vcf"
Content-Disposition: attachment;

filename="Willett, Mark.vcf"

BEGIN:VCARD
VERSION:2.1 Received on Wed May 31 2000 - 07:54:45 CDT