Re: DBAs : SID Change ?

From: Dipankar <dasdipa_at_zeus.franklin.edu>
Date: 1995/10/24
Message-ID: <1995Oct24.004400.10432_at_zeus.franklin.edu>#1/1

>In article nalini.vallampati_at_daytonoh.attgis.com writes:
 

>>In article <463pd4$5nv_at_news4.digex.net> Joe Nardone writes:
>>Harshan Ramarathnam (dbhayes_at_amoco.com) wrote:
>>: If you are on UNIX , you can set the environmental ORACLE_SID.
>>
>>I think they meant "change the SID of an existing database".
>>
>>Joe
>>
>
>Would it help to change the SID in all the files that has a SID ( oratab,
>init.ora/config.ora, .profile ) and then restart the database ? Or does
>the SID get into some Oracle binary file somewhere along the line and
>really cannot be changed ?
>
>Nalini
>
>
>
>
>Nalini Vallampati
>UNIX Admin/Oracle DBA
>AT&T Capital - GIS
>Miamisburg, OH 45342
>
>

Control file (binary) will have the SID or existing DB name. As this file can't be edited, it needs to be reproduced by "ALTER DATABASE BACKUP CONTROLFILE TO TRACE". This trace file containing necessary commands to create the control file can then be edited. Assuming necessary modifications in other files have already been made at this point, the database may be started with the new SID. However, I would backup my entire database before I attempt to change SID of an existing database this way.

Hope this helps,

Dasdipa

---

isclaimer - Opinions expresssed are just mine and not liable to guarantee

             the desired effects. Received on Tue Oct 24 1995 - 00:00:00 CET