Problem with OEM

I run oracle8i on win2k. I want to use OEM but when I try to use the service discovery option of OEM, it finds the node but not the database (but I can connect to the database with SQLplus).
does anyone have an answer ?
TIA

Check if the Oracle agent service on the target database is up and running.

Nizar

Yes the Oracle Agent is running on the database server.

Configure the database manually instead of "Auto discovery".
It works..
Sometimes OEM is unable to discover the DB even if the Oracle agent is running.. (Don't know, why?)
Sanjay

How do you configure the database manually ?
I didn't even know it was possible.

Make sure your listerner.ora is correct. And delete snmp_ro.ora and snmp_rw.ora. Then atart your agent again.

Once the agent start, the Windows NT agent will first check the Windows NT registry values:
ORACLE_HOME and ORACLE_SID. The registry keys are located in:

HKEY_LOCAL_MACHINE => System => CurrentControlset => Services => OracleServicexx
The Agent checks the entire harddrive and builds a list of all ORACLE HOMEs.
This list also indicates the SID's in each ORACLE HOME. Another list is also
constructed for all the services in these ORACLE HOMEs (if more than one).
After all the information about SIDs, Listeners and other services are obtained
and analyzed, a summary will be written to the "services.ora" file. This file
is ALWAYS written to "ORACLE_HOME/network/agent" or "ORACLE_HOME/net80/agent"
directory. The "services.ora" file is used when the EM Console's Communication
Daemon or the Oracle Management Server checks for discovered services on a
specific node.

The Agent also generates two other configuration files "snmp_ro.ora" and
"snmp_rw.ora". These files are written to either "ORACLE_HOME/network/admin" or
"ORACLE_HOME\NET80\admin". The files can also be written to the "TNS_ADMIN"
location. The two files contain Agent configuration information. The
"snmp_ro.ora" file is read only and cannot be edited. It contains all the
services information the SIDs and ORACLE_HOMEs.

To configure database manually type in the discovery pannel either Host name or it IP address.
regards
akhadar

even when configuring the database manually, it doesn' work.
The file 'services.ora' contains :
dbserver = (ORACLE_NODE, dbserver, dbserver, (PLATFORM=(osName=Windows NT)(osVersion=5.0)))

the file 'snmp_rw.ora' is empty

and the file 'snmp_ro.ora' contains :
snmp.visibleservices = ()
ifile = D:\oracle\Oracle\network\admin\snmp_rw.ora

The files 'listener.ora' and 'tnsnames.ora' are probably correct because I can connect to the database with SQLplus.

In your tnsname.ora and listenser.ora, host have to be same for that database. You can't use IP address for one and hostname for another. Alse check $ORACLE_HOME/network/log for error information. Check following log file.
dbsnmpc.log
dbsnmpw.log
nmiconf.log

I your snmp_ro.ora, your should have entries for:

snmp.oraclehome.listerner=


snmp.SID.your database name=

OK, i found the answer in the logs.
in the file 'listener.ora' there was SID_NAME = PLSExtProc
I replaced PLSExtProc by the service name for my database and it works!

Thanks for your help!

Search your Oracle directory for more than one tnsnames.ora file.

All copies need to be the same.

What version is your OEM? Make suer that you have configured the tnsnames.ora and listener.ora correctly. If not, modify and restart the listener, then the intelligent agent. Then start the OEM console and try to discover the node. When to try this, if you encounter any error message, note that down and let us know of the error message and the number. In the mean time what is your oracle version and have you applied all the necessary patches for NT too?

Sam