DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: OEM node discovery fails!!!

  1. #1
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Does any one have an idea on how to discover a node using OEM that has multiple listeners configured under listener.ora file.

    OEM v2.2

    I have the agentt that would complain me of that all the secondary listeners would be ingnored except the primary default one. Did any one encounter this problem? if so what was your solution to it.


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Did u thing about using 1 listener and dynamic registration of instances?

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Since my brains're fried up badbly, would you mind explaining what you ment?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    I use this solution on two boxes (1 sun solaris and 1 linux).
    u exclude from SID_LIST_LISTENER section information about instanses (SID/SERVICE)
    for example:
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxx)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /opt/oracle/product/9.0.1)
    (PROGRAM = extproc)
    )
    )

    and listener connect to instanses itself.

    LSNRCTL> services
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    Service "sssssss" has 2 instance(s).
    Instance "xxxx1", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:22 refused:0 state:ready
    LOCAL SERVER
    Instance "xxxx2", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0 state:ready
    REMOTE SERVER
    (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bbbbbb02)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=linx)(INS TANCE_NAME=linx2)))

    (this example from cluster, but it possible on independed instances)

    Dynamic registration of instances possible in 8.1.7 and 9i.



    [Edited by Shestakov on 02-08-2002 at 03:10 PM]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width