Re:Login.sql and global name value

One caveat...

> No this will not hurt anything.

Provided this site is not part of an Advanced Replication environment. Altering the global_name does not update the replication catalog and replication is quite dependent on the global_name.

• Anita
  • dgoulet_at_vicr.com wrote:
    > Alter database rename global name to
    > <whatever>.<whatever>;
    >
    > No this will not hurt anything.
    >
    > ____________________Reply
    > Separator____________________
    > Author: rsands_at_lendleaserei.com
    > Date: 5/30/00 11:07 AM
    >
    >
    >
    > 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).
    > --
    > 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