Re: 9i OMS restrictions

From: Tarby777 <nick_williamson_at_mentorg.com>
Date: 22 Sep 2005 05:17:14 -0700
Message-ID: <1127391434.430956.23510@o13g2000cwo.googlegroups.com>

Hi Sybrand,

By "does not find it", I mean that running the "discover node" routine in OEM does not add the database to the tree (whereas, if I run the same routine and choose the Unix box as the node rather than choosing the laptop as the node, the databases on the Unix box ARE added to the tree).

The Agent *is* running on the laptop; the Control Panel service has a status of "started", and the "ping Agent" utility in OEM returns the status "successful".

I don't have a LISTENER.ORA file on the laptop, although the listener is running, I do have a LISTENER.LOG and I can TNSPING the database. LSNRCTL STATUS returns this:

LSNRCTL for 32-bit Windows: Version 9.0.1.1.1 - Production on 22-SEP-2005 13:09:34
Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521)) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 9.0.1.1.1
- Production
Start Date                22-SEP-2005 11:34:14
Uptime                    0 days 1 hr. 35 min. 21 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Log File         C:\oracle\ora90\network\log\listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=GBA-NICKW-XP.gba.mentorg.com)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=137.202.205.127)(PORT=2482))(PRESENTATION=GIOP)(SESSION=RAW))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=137.202.205.127)(PORT=2481))(PRESENTATION=GIOP)(SESSION=RAW))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=137.202.205.127)(PORT=9090))(PRESENTATION=http://admin)(SESSION=RAW))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=137.202.205.127)(PORT=8080))(PRESENTATION=http://admin)(SESSION=RAW))
Services Summary...
Service "MODOSE" has 1 instance(s).
Instance "OEMREP", status READY, has 1 handler(s) for this service... Service "OEMREP.gba.mentorg.com" has 1 instance(s). Instance "OEMREP", status READY, has 3 handler(s) for this service... Service "testbed" has 1 instance(s).
Instance "testbed", status READY, has 2 handler(s) for this service...
The command completed successfully

The entry for the database in TNSNAMES.ORA looks like this:

TESTBED =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = testbed)
    )
  )

TIA
Nick Received on Thu Sep 22 2005 - 07:17:14 CDT