OEM and agentctl oracle 9i

greenspun.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.

Thx

-- Scott Vecchiarello (svecchia@hartehanks.com), January 16, 2004

Answers

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.

With regards

-- Raj Kr Singh (rajinmumbai@rediffmail.com), January 21, 2004.


Moderation questions? read the FAQ