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

Hi! Dear friend .
It's great for me that you have done at the part of Change db sid , but , now ,I can find command Oradim for our database base on linux . Can you tell me how I may do the same that drop oracle serive in linux ?

Thank much!

faheemrao_at_yahoo.com (FaheemRao) wrote in message news:<43b58913.0109272342.5606f809_at_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 - 20:29:11 CDT