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

Evan wrote:
> 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.

Part of your posting included this information:

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

Maybe it's relevant?

Opening a service request with oracle is one way to pursue this problem. Received on Tue Sep 26 2006 - 17:28:01 CDT