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

lanas,

oradim is an NT-only tool.
Linux does not have a "registry for services". You have to configure your init scripts and oratab files if you want the instance(s) and listener(s) to start automatically upon server restart.

Paul

lanas wrote:
>
> 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 Sun Sep 30 2001 - 23:26:41 CDT