Re: ********changing of db name********

From: Erwin Dondorp <erwindon_at_wxs.nl>
Date: Sun, 15 Aug 1999 23:18:45 +0200
Message-ID: <37B72EB4.AC41AF56@wxs.nl>

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> Received on Sun Aug 15 1999 - 16:18:45 CDT