Re: Can't see a RAC instance in available targets (to set events and run Jobs).

From: Kantix <cantisano_at_tin.it>
Date: Thu, 7 Aug 2003 17:32:31 +0200
Message-ID: <bgtrad$s7jab$1@ID-74096.news.uni-berlin.de>

Hi,
the app is using the RAC (that I'm starting to monitor since one week) non really as a RAC. They run some applications on one node and other applications (different) on the other node. So they use to connect specifying the sid to be sure to be on the 'right' instance.
On each node there is a listener.ora that points only to the local instance. (as stated in Oracle config manual)
local_listener defaults to LISTENER_PGOL2 on the node 2 and LISTENER_PGOL1 on the node 1

With OEM I see the instances as a cluster database

The tnsnames contains
PGOL2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = pgoldbsys01-2)(PORT = 1521))     (CONNECT_DATA =

      (SERVICE_NAME = pgoldb.pgoldbsys)
      (INSTANCE_NAME = pgol2)

    )
  )

PGOL1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = pgoldbsys01-1)(PORT = 1521))     (CONNECT_DATA =

      (SERVICE_NAME = pgoldb.pgoldbsys)
      (INSTANCE_NAME = pgol1)

    )
  )

PGOLDB =
  (DESCRIPTION =
    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = pgoldbsys01-2)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = pgoldbsys01-1)(PORT = 1521))
      (LOAD_BALANCE = off)

    )
    (CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = pgoldb.pgoldbsys)

    )
  )

FC

>
> Like I said: look at your listener.ora. It has an explicir SID_DESC
listing
> for EXTPROC, but not for both the instances (unless I'm reading it wrong).
> I see PGOL2 listed, but not PGOL1. If both are not listed, then the agent
> on the node for this listener won't know that both exist. You'll see both
> instances listed in OEM, because each node (and hence each agent) knows
> about its own instance, but that's two separate instance. You need both
> listeners to know about both instances.
>
> You also need to stop using SID=xxxx, because that doesn't permit a single
> cluster to be viewed as a single entity. You need SERVICE=yyy and set that
> to be the single service name that both instances use to register with the
> listener.
>
> And you also need both instances to register with both listeners if you
> want load balancing (not the issue at hand, I realise) in which case...
> where is your remote_listener parameter in your init.ora??
>
> (All of which was mentioned in my first reply)
>
> ~QM
Received on Thu Aug 07 2003 - 10:32:31 CDT