Re: New Instance

Joe,

   Don't create a new database over the existing one unless you want to lose your existing database too !!

   The crdb files shud be located somewhere in ORACLE_HOME/rdbms/admin else in ORACLE_HOME/rdbms/install

HTH,
Chetan

Joe F wrote in message ...
>
>Thanks Chetan
>
>I'm using Oracle 7.3 running on NT
>I can't find the two files you mentioned
>
>Do I CREATE a new DATABASE over the existing ones?
>
>Thanks
>J
>---------------------------------------------------------------------------
>Chetan Wagle wrote in message <7sf4k7$3pk$1_at_herald.ctp.com>...
>>Hi Joe,
>>
>> What you will have to do is the foll steps (I assume u are on UNIX) :
>>
>>1. Goto ORACLE_HOME/rdbms/install/rdbms and locate two files called
>crdb.orc
>>and crdb2.orc. Rename these to .sql and edit them properly to create the
>>database the way you want it to be.
>>2. Create the init.ora and config.ora files
>>3. Set your ORACLE_SID etc properly and run svrmgrl
>>4. Run the crdb.sql script followed by crdb2.sql script
>>5. Run ORACLE_HOME/rdbms/admin/catalog.sql, catproc.sql and catexp.sql
>>
>>Now you have two Oracle instances with the same ORACLE_HOME.
>>
>>It would help to seek the guidance of someone who ahas already done this
>>operation.
>>
>>HTH,
>>Chetan
>>
>>
>
>
Received on Sat Sep 25 1999 - 00:17:46 CDT