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 13:01:12 +0200
Message-ID: <bgtbdl$s4bv3$1@ID-74096.news.uni-berlin.de>

> Check your listener.ora. For a start, unless the services are listed
> explicitly in the SID_LIST section, the agent doesn't know about them, and
> they won't be discovered. Second, make sure you've set up the init.ora for
> both nodes/instances so that automatic registration of the instances with
> their respective listeners works. Registration will require you use
> SERVICE_NAME= rather than SID= if you want to be able to connect to a
> single entity, the cluster... which you'll need for load balancing and
> failover purposes. Third, make sure each instance is registering itself
> correctly with the *remote* listeners (so, for #2, you need to set
> local_listener, and for #3, you need to set remote_listener).
>
> In short, post your listener.ora, your init.ora and your tnsnames.ora if
> you want a fuller answer.
>
> ~QM

Hi,
excuse me for replying late but I've had a lot of other things to do. As I told before I can connect, through the OMS, to the (2) nodes of the cluster.
But I can't set jobs on it.
This is the entry in the tnsnames on the second node, the sids are pgol2 and pgol1 the db_name is pgoldb, service_names is 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)

    )
  )

And this is the listener
LISTENER_PGOL2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = pgoldbsys01-2)(PORT = 1521))
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )

    )
  )

SID_LIST_LISTENER_PGOL2 =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /export/home/app/oracle/product/9.2.0)
      (PROGRAM = extproc)

(ENVS="EXTPROC_DLLS=ANY,LD_LIBRARY_PATH=/export/home/app/oracle/product/9.2. 0/lib:/usr/lib:/usr/local/lib,LD_LIBRARY_PATH_64=/usr/local/lib/sparcv9:/usr /lib/sparcv9"))

    (SID_DESC =

      (ORACLE_HOME = /export/home/app/oracle/product/9.2.0)
      (SID_NAME = pgol2)
      (SERVICE_NAME = pgoldb.pgoldbsys)

    )
  )

From the init:

local_listener                       string      LISTENER_PGOL2
db_name                              string      pgoldb
global_names                         boolean     FALSE
instance_name                        string      pgol2
service_names                        string      pgoldb.pgoldbsys

Thanks,
FC Received on Thu Aug 07 2003 - 06:01:12 CDT