How do I set up multiple instances on the same machine?

From: Dave Snyder <dsnyder_at_netgenics.com>
Date: Thu, 14 May 1998 21:13:17 GMT
Message-ID: <355B5F81.D9E57424@netgenics.com>

Hi, we are running Oracle 7.3.3 on Solaris... This machine is currently set up with one instance for use with an application, and I would like to set up another instance run concurrently for development use.

Anyway, I have created a new init.ora file for the new instance and set a new database name, and have added an entry to the tnsnames.ora file (we have one listener process I believe.. and I did bounce this so the changes in tnsnames.ora would be recognized)

Ok, so now the default instance is running...

when I try to SET INSTANCE XXXX I get:
MGR-00301: cannot SET INSTANCE while connected to a database

also, when I try to start using startup pfile=initXXXX.ora i get: ORA-01081: cannot start already-running ORACLE - shut it down first

Now, if I try to shut down the database, I can start up the other instance in it's place

What am I missing here? Do we need to have multithreaded server enabled? How about parallel server? Is there some network configuration file I missed?

Any help would be greatly appreciated!

Dave Snyder

David Snyder (dsnyder_at_netgenics.com)

NetGenics, Inc.
1717 East 9th St., Suite 1550
Cleveland, OH 44114-2803

216-861-4007 voice
216-861-4777 fax


------------------------------------

Received on Thu May 14 1998 - 16:13:17 CDT