Re: Login.sql and global name value

• Original Message ----- From: Willett, Mark <mwillett_at_sunnen.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: 31 May 2000 15:39 Subject: RE: Login.sql and global name value

> 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

[large snip]

You can also change the db_name in the control file recreate using 'SET DATABASE <db_name>'.

Regards.

Tony

--
S. Anthony Sequeira

Wait for the ricochet

Opinions expressed herein are my own and do
not necessarily represent those of my employer