Re: How can I run multiply instances in Oracle at the same time?

From: wegorz <wegorz_at_winuel.com.pl>
Date: Thu, 19 Oct 2000 09:45:16 +0200
Message-ID: <8sm8hl$9bh$1@news.tpi.pl>

>I have a problem when I want to run multiply instances in Oracle
>(Oracle 8.1.6, Sun Solaris 7) at the same time?

That is not a problem ;-)

>DBASE1:/opt/oracle/product/8.1.6:Y
>DBASE2:/opt/oracle/product/8.1.6:Y

This does not mean that it will be the same database. It is only list of SIDs and ORACLE_HOMEs.

>So I want that both SIDs use the same database.

Hmm...

>so that the both instances uses the same database.

It is impossible to do such things. If you want to do this you must use Oracle Parallel Server, but it is quite different problem.

IMHO that what you want to do (two instances running on one machine using the same DB) is impossible.

>Then when I start up the lsnrctl evething goes right:

Listener configuration is OK.

>but when I try to start up the svrmgr:
>LRM-00109: could not open parameter file '?/dbs/init@.ora'

You forgot to set ORACLE_SID...

BTW, what are you trying to do? Maybe it is quite easy and you have just chosen the wrong way?

Andrew Rajczakowski Received on Thu Oct 19 2000 - 02:45:16 CDT