Re: Creating new SID

From: Venkat <vreddy_at_no_spamix.netcom.com>
Date: Fri, 22 May 1998 11:39:32 -0400
Message-ID: <6k467l$5ne@sjx-ixn8.ix.netcom.com>

Follow these steps
1. Make a copy of the current initSID.ora file and rename it with the new SID. Make appropriate changes (db_name, control_files, trace file locations etc) to reflect the new SID

2. SET ORACLE_SID=newSID
3. STARTUP NOMOUNT pfile=full path to new initSID file
4.  Run create database script.  A sample script can be found in one of the

directories in $ORACLE_HOME.

Be sure that you have set the new SID (SET ORACLE_SID) before running the create database script. Otherwise it will mess up/overwrite your current database. Read the manuals before you venture into this. If you have access to Oracle support call and ask them to fax the paper 'creating a second database on UNIX'. You can also get it from http://support.oracle.com/metalink if you have access to it.

HTH
Venkat

>We had already installed oracle 8.0.4 on our solaris box with the
>sid=ora1 and we decided to make ora1 as our test database and create new
>sid for our actual production database, is it possible to have two sid
>on same server ,if so what is required to be done..., i mean do i have
>to install whole oracle again in new oracle home and oracle base with
>new sid... or can i use the same oracle home and if i use same oracle
>home will it delete any tables from old sid(ora1).....
>any comments or help in this matter welcome...
>thank you all...
>Jayesh Thakker
>jthakker_at_nortel.com
>
Received on Fri May 22 1998 - 10:39:32 CDT