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

From: Dave Snyder <dsnyder_at_netgenics.com>
Date: Thu, 14 May 1998 23:31:37 GMT
Message-ID: <355B7FED.5B7F639C@netgenics.com>

Ok... right after I sent this I figure out that I had not set up the listener.ora file correctly... I have fixed that but I still have a problem:

When I run svrmgrl, I can connect as internal with no problem (to the default instance), but I want to change to my new instance and connect as internal so I can create my database...

so, in a disconnected state, I type

SVRMGR> SET INSTANCE XXXX
** some messages about oracle **
SVRMGR> CONNECT internal
password: #######
ORA-01017: unsername/password not correct

My first question is why does it prompt me for a password in the first place? (I am logged into the server machine as a user in the dba group) also, when I type in the password, why wont it let me connect to the new instance?

Please Help! Dave

Dave Snyder wrote:

> 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
> ------------------------------------

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 - 18:31:37 CDT