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

From: <roni.hursti_at_laatukolmio.fi>
Date: Thu, 19 Oct 2000 06:57:25 GMT
Message-ID: <8sm60j$cco$1@nnrp1.deja.com>

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. Received on Thu Oct 19 2000 - 01:57:25 CDT