Re: New Instance

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

Joe F wrote in message ...
>Can you please tell me how to create a new instance on a database.
>One Instance is already running and I'd like to add an additional one.
>
>Many thanks
>J
>
>
Received on Fri Sep 24 1999 - 00:51:30 CDT