Re: Two instances with same SID in a same machine

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Mon, 30 Aug 2004 02:15:34 GMT
Message-ID: <a5wYc.32399$A8.14480@edtnps89>

Igor Laletin wrote:

> Hans Forbrich <forbrich_at_yahoo.net> wrote in message
> news:<RXaYc.71105$X12.53526_at_edtnps84>...

>> So perhaps you could help with this test I've got here .... one userid,
>> two oracle homes, two listeners.

>
> Without looking at listener.ora and unix environments it would be just
> guessing. Any chance you forget to change ORACLE_HOME in SID_DESC?

No - the OH is correct. That can be verified by the fact that when only the one instance is up (either one), things access the instance correctly and attempt to access the other instance fails with a 'not there' message.

When both are up, only the last one started is accessible (regardless of which order in which they are started.)

>
> Also did you install the second OH from scratch or copied it from the
> first one? Shouldn't actually matter with the right environment but
> again I can't see yours. If latter, try to relink it with the right
> LD_LIBRARY_PATH or set it explicitly.

Completely separate install and DBCA.

listener.ora for OH 'a'

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = fcc02)(PORT = 1521))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/ora904)
      (PROGRAM = extproc)

    )
    (SID_DESC =

      (GLOBAL_DBNAME = pts1.xyz.ca)
      (ORACLE_HOME = /opt/oracle/product/ora904)
      (SID_NAME = pts1)

    )
  )

listener.ora for OH 'B',

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = fcc02)(PORT = 1531))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME = pts1.xyz.ca)
      (ORACLE_HOME = /opt/oracle/product/ora904b)
      (SID_NAME = pts1)

    )
  )

Note the IPC protocol on OH 'B' is removed because second listeners complains that IPC is already on use.

Comment:

I would actively discourage duplication of an instance name on a single machine in any case. This test is only to verify whether it's possible, not whether it's a good idea.

I still stick with my original analogy. <g> Wanna continue?

/Hans Received on Sun Aug 29 2004 - 21:15:34 CDT