OMS node/database/listener discovery process

using 9207 database

$ oemctl status oms
OEMCTL for Solaris: Version 9.2.0.1.0 Production
Copyright (c) 1998, 2002, Oracle Corporation.  All rights reserved.

The Oracle Management Server on host [testwdb2] is functioning properly.

i have 6 total nodes i can discover but the database and listener are failing to be discovered.

listeners are running on both nodes and the databases are defined by global_dbname and present in listener.ora and oratab.  what am i missing?

please help
daniels
LVL 7
Daniel StanleyDatabase engineerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

techjiCommented:
You are missing an agent running on each of these nodes.

Start the agent -

lsnrctl start dbsnmp

OMS talks to agent for all the information. Also you can add the services manually if discovery failed. It should give you a option to define your own services.
Daniel StanleyDatabase engineerAuthor Commented:
the listener is running and i can connect to the database from other hosts.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 9.2.0.7.0 - Production
Start Date                07-SEP-2006 09:55:45
Uptime                    0 days 0 hr. 0 min. 12 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /orasw/app/oracle/product/9.2.0/network/admin/listener
.ora
Listener Log File         /orasw/app/oracle/product/9.2.0/network/log/listener.l
og
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.25.74.57)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "edge" has 1 instance(s).
  Instance "edge", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Daniel StanleyDatabase engineerAuthor Commented:
$ tnsping edge

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 07-SEP-2006 10:10:51

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
C:\oracle\ora92\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.25.74.57)(PORT = 1521))) (CONNECT_DATA = (SID = edge) (SERVER = DEDICATED)))
OK (30 msec)
OWASP: Forgery and Phishing

Learn the techniques to avoid forgery and phishing attacks and the types of attacks an application or network may face.

techjiCommented:
drs66,

agent is seperate from the listener. But it is started using the lsnrctl command.

go ahead and try this. It works.

$ lsnrctl start dbsnmp  <-- on the database server
Try to discover this database server from your OEM.

If the agent is running and the discovery failed, recyle the agent.
Daniel StanleyDatabase engineerAuthor Commented:
i understand how this all works and the agent is running fine.   i have 6 other nodes that are functioning properly and cannot figure out why this one node won't recognize database or listener.

bash-2.05$ agentctl status

DBSNMP for Solaris: Version 9.2.0.7.0 - Production on 07-SEP-2006 10:35:48

Copyright (c) 2003 Oracle Corporation.  All rights reserved.

Version             : DBSNMP for Solaris: Version 9.2.0.7.0 - Production
Oracle Home         : /orasw/app/oracle/product/9.2.0
Started by user     : oracle
Agent is running since 09/06/06 19:15:30
bash-2.05$
techjiCommented:
Hmmm. I misread your previous question.

Next logical step is to turn on tracing. Check if anything shows up.

9i Data Collection Service on Unix
----------------------------------
1. Stop the Intelligent Agent if it is started
   $> agentctl stop
2. Set the environment variable VP_DEBUG to 1
   $> setenv VP_DE<BUG:1> or export VP_DEBUG=1
3. Start the Intelligent Agent
   $> agentctl start

Data Collection Service debug information will be logged in the file dbsnmp.
nohup located in ORACLE_HOME/network/log (by default)
Daniel StanleyDatabase engineerAuthor Commented:
Discovering services on bsdeedb1 configured on host addresses {bsdeedb1 loghost 10.25.74.55}
Using oratab file /var/opt/oracle/oratab
Warning : LISTENER defined in /orasw/app/oracle/product/9.2.0/network/admin/listener.ora will be skipped, because it does not monitor
any of the valid SIDs {edge}
Warning : No Listener found for SID edge. edge will be skipped
Could not open emtab at /var/opt/oracle/emtab.


this is a odd warning see as though i'm not having having problems with the listener and i can connect to this sid with clients.

$ lsnrctl status

LSNRCTL for Solaris: Version 9.2.0.7.0 - Production on 07-SEP-2006 12:54:51

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 9.2.0.7.0 - Production
Start Date                07-SEP-2006 12:38:06
Uptime                    0 days 0 hr. 16 min. 44 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /orasw/app/oracle/product/9.2.0/network/admin/listener.ora
Listener Log File         /orasw/app/oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.25.74.55)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "edge" has 2 instance(s).
  Instance "edge", status UNKNOWN, has 1 handler(s) for this service...
  Instance "edge", status READY, has 1 handler(s) for this service...
Service "edge.gsm1900.org" has 1 instance(s).
  Instance "edge", status READY, has 1 handler(s) for this service...
Service "edge.t-mobile.com" has 1 instance(s).
  Instance "edge", status READY, has 1 handler(s) for this service...
Service "edgeXDB" has 1 instance(s).
  Instance "edge", status READY, has 1 handler(s) for this service...
The command completed successfully

techjiCommented:
hmmm.
Can you check other servers if their listeners have UNKNOWN status for the instances -

     Instance "edge", status UNKNOWN, has 1 handler(s) for this service...

But there is READY handler, meaning the database registered without any trouble.

Also can you check if the are any differences between CHMOD settings for the working dbsnmp and non-working.

It should usually be (if root.sh is run after the binaries installed) -

$ chmod 6755 dbsnmp (or chmod u+s dbsnmp)
$ chown root dbsnmp



Daniel StanleyDatabase engineerAuthor Commented:
there is only one instance (edge) running on this server.

this is from a working node:
-rwxr-x---   1 oracle   dba  
 
this is from problem node:
-rwsr-sr-x   1 oracle   dba

techjiCommented:
The permissions seem ok to me. There is a sticky bit but that is recommended by oracle.

At this time I am inclined to do a relink just for the agent.

$ cd $ORACLE_HOME/network/lib
$ make -f ins_oemagent.mk install

Daniel StanleyDatabase engineerAuthor Commented:
relinked to no avail
techjiCommented:
I am stumped :-(

More tracing is what I can think of right now. The following will trace every thing the agent does -

To turn on tracing for the 9i Intelligent Agent, you will need to modify the Agent’s snmp_rw.ora file. This file is normally in the $ORACLE_HOME\network\admin directory. The snmp_rw.ora is created the first time the Agent process is started. If the file is not created and you need to trace the startup process, manually create a text file and add the necessary tracing parameters to the file.

dbsnmp.trace_level = {OFF|USER|ADMIN|16}
dbsnmp.trace_file= <filename>
dbsnmp.trace_directory=< directory where the Agent has write privileges>
dbsnmp.trace_filecnt=<integer>
dbsnmp.trace_filesize=<integer in kilobytes>
dbsnmp.trace_unique={true/false}
dbsnmp.trace_timestamp={true/false}
dbsnmp.log_directory=<directory>
dbsnmp.log_file=<filename>
dbsnmp.log_unique={true/false}

By default the following log files get created under the Agent's ORACLE_HOME/network/log directory:
1. agntsrvc.log
2. dbsnmp.log
3. dbsnmp.nohup (for the watchdog script dbsnmpwd)
4. dbsnmpj.log
5. nmiconf.log (for discovery information)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.