Re: Creating 2nd Oracle 7.3.2 instance on Novell 4.1

you can create another instance on the same server and make both of them work

do the following instructions:

1 - make a copy of the current instance intial file, the initial file should be by default in the directory \oranw\dbs and its name looks like initorc1.ora where orc1 is the name of your current instance.
 make a copy to the name initorc2.ora where orc2 is the name of the new instance (you can change it).

2 - modify the content of initorc2.ora (the most important values is the database name , the other are optional)

3 - start the svrmgr

4 - set the instance to orc2 (here i am not very sure, how to do this on novell cause i ledft it a long time but i remeber something like set instance = orc2)

5 - connect internal

6 - startup nomount

7 - Now , issue the create database command (you should prepare this before and write it in a text file that you can called from svrmgr)

8 - after you created the database , you have on the same server two instances, you have to add the second to the listener,

9 - modify listener.ora to add the new instance name to the instances list, and unload it and reload it again.

10 - The end. Received on Sat Sep 26 1998 - 12:52:02 CDT