Re: How to change SID?

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 24 Aug 1999 11:07:12 +0200
Message-ID: <7ptnd5$2qd$1@oceanite.cybercable.fr>

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
>
>
Received on Tue Aug 24 1999 - 04:07:12 CDT