OEM and agentctl oracle 9igreenspun.com : LUSENET : DBAzine : One Thread
I am adding nodes to the OEM server and I'm having trouble discovering the db's. The nodes refresh fine. TNS and LISTENER seem ok. Anyone have the same problem.
-- Scott Vecchiarello (email@example.com), January 16, 2004
Despite the fact that Oracle 9i databases are self-registering in the listener, you must still define entries for 9i databases in the listener.ora for agentctl to discover those databases.
Agentctl 'discovery' is not done through querying the listener - it is done by parsing the listener.ora file.
Therefore, make sure your listener.ora in $ORACLE_HOME/network/admin looks something like:
# LISTENER.ORA Network Configuration File: # /usr/app/oracle/product/9.2.0/network/admin/listener.or a # Generated by Oracle configuration tools.
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = node.company.com)(PORT = 1521)) ) ) )
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = sid.company.com) (ORACLE_HOME = /usr/app/oracle/product/9.2.0) (SID_NAME = sid) ) )
-- John Haynes (John.Haynes@poports.com.au), January 20, 2004.
Hi, For autodiscover the database....oracle intelligent agent should be runing on database server................and entry in TNS and LISTENER should be ok...
to start oracle agent ........$agentctl start
After that you will able to discover the DB from OEM.
-- Raj Kr Singh (firstname.lastname@example.org), January 21, 2004.