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.
>
Yes, I am sure it is relevant. I have a SR open, but it is low severity,
so the news group is often faster for stuff like this.
Evan
Received on Wed Sep 27 2006 - 09:57:31 CDT
