Re: How to change SID?

Hey! That saves me some work!

Michel Cadot wrote:

> Here's a previous answer from Erwin Dondorp to same question:
>
> -----------------------------------------------------------------------------
> Hi,
>
> Please take care that the database sid and the database name are 2 different
> things!
> The database name is the name that belongs to the data (that is stored in your
> database files)
> The database sid is the name of the running processes that make the database
> work.
> Most of the time these are the same.
>
> [Assuming you have Oracle on UNIX]
> If you only want to change the SID:
> - shutdown
> - rename the sid in the file /etc/oratab
> - rename the file $ORACLE_HOME/dbs/initSID.ora to the new SID
> - startup
> - ready (don't forget to tell all clients that the SID changed: change their
> environment variable ORACLE_SID or their TNS names definition to reflect the
> new SID)
>
> If you want to change the database name:
> - Use the procedure below (in the original reply)
>
> Erwin
>
> D Parent wrote:
>
> > In essence you use the ALTER DATABASE BACKUPCONTROLFILE TO TRACE command to
> > create a control file recreation scipt, edit the script to set the name you
> > want, shutdown the database, change the definition for ORACLE_SID and then
> > use the script to rebuild the control file and restart the database
> >
> > <mailto:manash_at_superlinknet> wrote in message
> > news:7p4iep$kss$1_at_earth.superlink.net...
> > > Hi,
> > >
> > > I have to change the sid of my database,
> > > I am not very clear about the steps
> > > should be followed to do this job.
> > >
> > > I need help from any body has experience
> > > of this nature or has any knoledge of this operation,
> > > please
> > >
> > > thanks in advance
> > > dhruba
> > >
> > >
>
> --
> Erwin Dondorp
> <http://www.wxs.nl/~erwindon>
>
> -------------------------------------------------------------------------
>
> Cheong a écrit dans le message <37c22937_at_news.lhsgroup.com>...
> >Hi:
> >
> >Surely there's are ways to change SID without recreating a db.
> >
> >I've scanned through the posted messages but found none, unfortunately.
> >
> >Can someone give me a hint or point me to where I could find some info on
> >this?
> >
> >Thanks in advance!
> >
> >Best regards,
> >Cheong
> >
> >

--
Erwin Dondorp
<http://www.wxs.nl/~erwindon> Received on Tue Aug 24 1999 - 12:51:34 CDT