Node discovery issue on 9.2.0.6. My node is not discovering correctly.

Node discovery issue on 9.2.0.6. My node is not discovering correctly.

Please review the stuff below and let me know if you see any errors (in typing or thought).

• - - - - Expected Results: I should have one database instance (standalone, not RAC), one listener, no web servers and of course the node itself. The agent is not seeing the listener or the database.
• - - - - The error message in /u01/app/oracle/product/920/network/log/nmiconf.log is:

DBSNMP for SunOS 5.8: release 9.2.0.6.0 - Production on 21-SEP-06 15:49:09 Discovering services on fortuna configured on host addresses {fortuna loghost 170.140.204.26}
Using oratab file /var/opt/oracle/oratab Warning : LISTENER defined in
/u01/app/oracle/product/920/network/admin/listener.ora will be skipped, because it does not monitor any of the valid SIDs {FMPROD} Warning : No Listener found for SID FMPROD. FMPROD will be skipped Could not open emtab at /var/opt/oracle/emtab.

• - - - - - -BUT if I am doing it right, then it should work. My oratab has FMPROD:/u01/app/oracle/product/920:Y *:/u01/app/oracle/product/920:N
• - - - - And my listener status shows this: LSNRCTL> status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fortuna.EmoryUniv.edu)(PORT=1521))) STATUS of the LISTENER

  ---

  Alias LISTENER Version TNSLSNR for Solaris: Version 9.2.0.6.0 - Production Start Date 06-AUG-2006 15:09:51 Uptime 51 days 2 hr. 30 min. 0 sec Trace Level off Security ON SNMP OFF Listener Parameter File /u01/app/oracle/product/920/network/admin/listener.ora Listener Log File /u01/app/oracle/product/920/network/log/listener.log Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fortuna)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fortuna)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=FMPROD.WORLD)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=FMPROD)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=FMPROD.EmoryUniv.edu)))
  Services Summary... Service "FMPROD" has 1 instance(s). Instance "FMPROD", status READY, has 1 handler(s) for this service... Service "FMPRODEmoryUniv.edu" has 1 instance(s). Instance "FMPROD", status UNKNOWN, has 1 handler(s) for this service... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully
  • = = = How I build the agent files: I start by ensuring that the node is not showing in OEM and the agent is down on the box. I delete snmp_ro.ora and snmp_rw.ora in the $TNS_ADMIN directory. I delete *.q and services.ora files in $TNS_ADMIN/../agent

I issue an "agentctl start".

• = = = The results of the "agentctl start": At this point I have: an empty snmp_rw.ora. a 149 byte snmp_ro.ora containing: snmp.visibleservices = () ifile = /u01/app/oracle/product/920/network/admin/snmp_rw.ora ifile = /u01/app/oracle/product/920/network/admin/sqlnet.ora

In the agent directory, I have the following files:

    -rw-rw-r--   1 oraclep  oinstall     327 Sep 26 15:22 services.ora
    -rw-rw----   1 oraclep  oinstall     100 Sep 26 15:22 dbsnmp.ver
    -rw-rw----   1 oraclep  oinstall    1024 Sep 26 15:22 blackout.q
    -rw-rw----   1 oraclep  oinstall    8192 Sep 26 15:22 user.q
    -rw-rw----   1 oraclep  oinstall    2048 Sep 26 15:22 jstat1.q
    -rw-rw----   1 oraclep  oinstall    1024 Sep 26 15:22 job.q
    -rw-rw----   1 oraclep  oinstall    2048 Sep 26 15:22 evocc1.q
    -rw-rw----   1 oraclep  oinstall    1024 Sep 26 15:22 ereg.q

Services.ora has the following:
     fortuna = (ORACLE_NODE, fortuna, fortuna,
     PLATFORM=(osName=SunOS)(osVersion=5.8)
     (oracleHomes=/u01/app/oracle/product/920)))

     fortuna:443 = (oracle_sysman_webserver, fortuna,
     http://fortuna:443/server-status, unavailable,
     /u01/app/oracle/product/920/Apache/Apache/conf/httpd.conf,
     /u01/app/oracle/product/920/Apache/Apache)

• = = = = = = Details: Oracle and agent are all 9.2.0.6 + quarterly patches due to vendor restrictions.

O/S is solaris 5.8

There is one database on the box and the box should NOT have an apache server. Received on Tue Sep 26 2006 - 16:57:25 CDT