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

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

>

Evan what looks somewhat unusual to me is that you have some UPPERCASE stuff like FMPROD. You are running in a unix/solaris environment where case sensitivity at times is important.

We are running 9208 here on hpux ( recent upgrade from 9206 ). When I do a lsnrctl status I get lower case information returned for service and instance names.

Similarly my listener.ora has lower case entries in it. To me at least it is unusual to see upper case definitions in a unix environment.

Maybe you have some mismatch between the case of your entries and how the agent is trying to find things? Received on Wed Sep 27 2006 - 10:20:57 CDT