Cannot see database in 9i Enterprise Manager

[mzhu]

I had problem to run 9i Enterprise Manager -- Database does not show on the tree. Discovering node run OK, but in the log file nmiconf.log, there was a Warning like: "No Listener found for SID db1. db1 will be skipped" (db1 is the instance name). In the file listener.ora, there is a service for db1 like:

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=db1.salescentrix.com)
(SID_NAME=db1)
(ORACLE_HOME=/usr/local/oracle)
)
)

I checked Listener, Agent and Management Server and they all run OK.

There is no any problem if I run Enterprise manager with Standalone mode.

Thanks for any help.

[sambavan]

Check the tnsnames.ora file in the OEM installation side?

Sam

[mzhu]

In the file tnsnames.ora,

DB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.64.6)(PORT = 1521))
)
(CONNECT_DATA = (SID = db1)(SERVER = DEDICATED))
)

[Shestakov]

Originally posted by mzhu

1 --> I checked Listener, Agent and Management Server and they all run OK.
2 --> There is no any problem if I run Enterprise manager with Standalone mode.

1. Agent works thru SMNP protocol and use oratab file (place depend from O/S) for resolve instance name
and
listener.ora file for resolve listener (and agent try to find this file in $ORACLE_HOME/network/admin) u should check it

2. when u use Standalone mode, then agent and SNMP protocol doesn't works (not needed)
Standalone mode works thru sqlnet.

Then ur problem may be:
-- pathes and files (listener.ora, oratab, ???->tnsnames.ora)
-- SNMP deamon itself (check it works or not)

[mzhu]

When I checked the log file dbsnmp.log, I found:

NMS-00001: Warning : dbsnmp unable to connect to SNMP master agent.

What does that mean? How can I check if SNMP works?

Thanks.

[Shestakov]

Ur SNMP deamon (this is unix program, not oracle) doesn't work.
Ask ur sysadmin (or find in unix documentation) how u can configure and start it.