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

In article <8sm60j$cco$1_at_nnrp1.deja.com>,   roni.hursti_at_laatukolmio.fi wrote:
> Hi
>
> I have a problem when I want to run multiply instances in Oracle
> (Oracle 8.1.6, Sun Solaris 7) at the same time?
>
> My /var/opt/oracle/oratab is the following
> ------------------------------------------
> DBASE1:/opt/oracle/product/8.1.6:Y
> DBASE2:/opt/oracle/product/8.1.6:Y
> ------------------------------------------
>
> So I want that both SIDs use the same database.
>
> Then I have configured
> /opt/oracle/product/8.1.6/admin/dbase/pfile/initDBASE2.ora
> and /opt/oracle/product/8.1.6/admin/dbase/pfile/initDBASE1.ora files
> to the following:
>
> initDBASE1.ora:
> -------------------------------
> ...
> db_name = "dbase"
> db_domain = mydomain
>
> instance_name = DBASE1
>
> service_names = dbase.mydomain
> ...
> -------------------------------
>
> and then
>
> initDBASE2.ora:
> -------------------------------
> db_name = "dbase"
> db_domain = mydomain
>
> instance_name = DBASE2
>
> service_names = dbase.mydomain
> -------------------------------
>
> so that the both instances uses the same database.
>
> The the /opt/oracle/product/8.1.6/network/admin/listener.ora is the
> following:
>
> ------------------------------------------------------------------
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = mydomain)(PORT = 1521))
> )
> )
> (DESCRIPTION =
> (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
> )
> (ADDRESS = (PROTOCOL = TCP)(HOST = mydomain)(PORT = 2481))
> )
> )
>
> ...
> DBASE1.MYDOMAIN =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = mydomain)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = dbase.mydomain)
> )
> )
> DBASE2.MYDOMAIN =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = mydomain)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = dbase.mydomain)
> )
> )
> ...
>
> (SID_DESC =
> (GLOBAL_DBNAME = dbase.mydomain)
> (ORACLE_HOME = /opt/oracle/product/8.1.6)
> (SID_NAME = DBASE1)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = dbase.mydomain)
> (ORACLE_HOME = /opt/oracle/product/8.1.6)
> (SID_NAME = DBASE2)
> )
> )
> ...
> ------------------------------------------------------------------
> Then when I start up the lsnrctl evething goes right:
>
> ...
> Listening on:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mydomain)(PORT=1521)))
> ...
> Services Summary...
> PLSExtProc has 1 service handler(s)
> DBASE1 has 1 service handler(s)
> DBASE2 has 1 service handler(s)
> The command completed successfully
>
> but when I try to start up the svrmgr:
>
> ...
> SVRMGR> connect internal
> Connected.
> SVRMGR> startup
> LRM-00109: could not open parameter file '?/dbs/init@.ora'
> ORA-01078: failure in processing system parameters
> ...
>
> although those ?/dbs/initDBASE1.ora and ?/dbs/initDBASE2.ora files
> exists
>
> ls -l /opt/oracle/product/8.1.6/dbs/
> ...
> initDBASE1.ora ->
> /opt/oracle/product/8.1.6/admin/nap/pfile/initDBASE1.ora
> lrwxrwxrwx 1 oracle 54 Oct 19 09:06 initDBASE2.ora ->
> /opt/oracle/product/8.1.6/admin/nap/pfile/initDBASE2.ora
>
> and those links are the files described below.
>
> If I run so that there is only DBASE1 alone then everything goes right
> but not when there are both of them.
>
> Regards
>
> Roni
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

You need Parallel Server to do this. If you don't have Parallel Server (included in the Enterprise Edition only) it won't work. If you do have Parallel Server, IMO, there is not much use in running 2 instances of the same server.

Regards,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.