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 ?
Check if the Oracle agent service on the target database is up and running.
Yes the Oracle Agent is running on the database server.
Configure the database manually instead of "Auto discovery".
Sometimes OEM is unable to discover the DB even if the Oracle agent is running.. (Don't know, why?)
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
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.
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.
Click Here to Expand Forum to Full Width