Creating a second instance

From: Lisa Lewis <lmg_at_isdsa.pgh.wec.com>
Date: 1997/11/18
Message-ID: <64svn7$21h6@sccat.pgh.wec.com>#1/1

Hi all,

I have to create a second Oracle instance. My platform is Unix and I am running Oracle 7.3.2. My background is NT and I'm a little shaky working with unix. Could someone please tell me if the following steps are correct for creating a second instance. Am I leaving steps out? Are there concerns that I should have or things to look out for?

(1) Set the environment variables ORACLE_SID to the new instance name.
(2) Create the new instance using oradim73.exe
(3) Connect internal
(4) startup the instance using the new initxxx.ora file w/NOMOUNT
(5) create the new database ... etc ...

Also, what do I have to do to ensure that this instance will be automatically started on reboot. ( I didn't set up the first instance and I am not a UNIX person).

Thanks for any help!

Lisa Received on Tue Nov 18 1997 - 00:00:00 CST