Re: Changing Oracle SID

Yes it can be done. How it's done depends on the platform. On unix it's quite simple. You need to do the following:

1. shutdown database.
2. ORACLE_SID=new_sid_name.
3. in the $ORACLE_HOME/dbs directory, change the name of the init file from initOLDSID.ora to initNEWSID.ora.
4. Modify the sid name in the inittab.ora (location varies depending on which unix).
5. startup database.

If you have remote clients connecting through a listener, you'll need to modify the sid name in the listener.ora file on the server, and the tnsnames.ora files on the clients.

--
Chuck Hamilton
chuckh_at_safeaccess.net

But the angel said to them, "Do not be afraid; for I bring you tidings of great joy which shall be for all the people; for today in the city of David there has been born for you a Saviour, who is Christ the Lord." (NASB Luke 2:10-11)

On Fri, 11 Dec 1998 20:07:19 GMT, abalbekov_at_usa.net wrote:

>In article <74m8gk$a41$1_at_nnrp1.dejanews.com>,
> kromerm_at_comcell.com wrote:
>> Is it possible to change the Oracle Server SID
>> after installation? What I would like to do is
>> to have two separate applications that use the
>> SAME Oracle server to access their own individual
>> Oracle instance.
>>
>> Any ideas on how this can be done??
>>
>> Thanks!
>>
>Probably what you want to do is to have ONE Oracle server software,
>TWO instances and TWO databases. There is one-to-one relationship
>between instances and databases (except for Parallel Server configuration -
>but that is a different story). Each application will connect to it's own
>instance.
>
>Regarding your question, you should be able to change
>the SID (just set ORACLE_SID environment variable, go to svrmgrl and
>start database with right pfile). SID is not recorded inside the database.
>It's on OS level.
>
>Albert
Received on Mon Dec 14 1998 - 09:04:24 CST