Re: Can I change db_name or SID for a exist db or How?

From: FaheemRao <faheemrao_at_yahoo.com>
Date: 28 Sep 2001 00:42:27 -0700
Message-ID: <43b58913.0109272342.5606f809@posting.google.com>

ok
Lawrence answers only one part of the question of the question,

the other part was how to change the SID name,

for changing the SID we have to do following

1.. Shutdown the Database 
2.. Drop the Orcle Service , by Oradim , and recreate it.
3.. Change the Oracle_SID in registry if windows or for linux in

.bash_profile and for unix I dont know (may be same as of linux) . 4.. restart the Oralce Instance .

and you are done.

"Lawrence Simela" <lsimela_at_mahalini.prestel.co.uk> wrote in message news:<9ou38t$740$2_at_phys-ma.sol.co.uk>...
> Yes you can change the Db name of an existing database.
> This topic has been covered on this newsgroup in the past so you may want to
> look at the archives as well. But a brief guide is as follows:
>
> 1. Issue an ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement
> This will create in your udump directory a file with all the commands to
> recreate the control file.
> 2. Backup your existing control file including the mirrored version.
> 3. Shutdown database and remove existing control files
> 4. Edit the file created in 1 to change the database name
> 5. edit the init.ora file to change the SID and db_name as appropriate
> 6. Run the file created in 1 and edited in 4
> 7. Issue a statement to change the global name of the database as follows
> ALER DAtABASE RENAME GLOBAL_NAME TO new_db_name.domain;
>
> And you are done.
>
> Lawrence
>
>
> "lanas" <lanas_at_263.net> wrote in message
> news:5abaade9.0109261706.33c91ea1_at_posting.google.com...
> > thanx all
Received on Fri Sep 28 2001 - 02:42:27 CDT