Problems integrating HP snmp & Oracle snmp

[Michael Treadwell_1]

I would like to use snmp to check an Oracle instance on my HP server. I started out able to poll the server mibs but not Oracle. Now, after following Oracle & HP directions, neither work correctly.
Can anyone point me in the right direction? Some 'accurate' instructions would be greatly appreciated!
Currently whan I run './start_peer -a' I get initialization errors from master_peer & endcap_peer. snmpdm is running but not responding.

Thanks.

[Jason VanDerMark]

Michael,

At my site we use the Oracle Emanate agent to get SNMP data from Oracle. We found that there were a few strange things with this agent in that it required that you maxfiles and maxfiles_lim had to be set to 2048 for the Emanate agent to work properly. I don't know if this is your problem of not, but I thought that I would share a gotcha with ya in case it comes up. Hope this helps.

Regards,
Jason V.

[Michael Treadwell_1]

We are using that agent as well and maxfiles is set to 2048 already. Thanks.

[Sridhar Bhaskarla]

Michael,

1. Restart your snmpd processes using the /sbin/init.d scripts for the OS. I don't know how to restart oracle emanate agent.
2. If you still have problems, it could be due to community issues. Edit /etc/SnmpAgent.d/snmpd.conf and check the get_community_name and set_community_name. Also you need to change the community names mentioned in your snmp server to match the ones you have in your snmpd.conf. There will be a corresponding configuration file for your oracle agent.
3. First use snmpget on your snmp server to query some OS and oracle MIBs on the server.

Please let us know what software are you trying to use to query the snmp agents on the system.

-Sri

[Michael Treadwell_1]

Checked the community names. Verified the conf files all agree. Have restarted several times. dbsnmp is running. No errors in any of the log files.
For querying I have used snmpget, Getif and MG-Soft MIB browser. For the last two, the mibs were added as appropriate.
System queries work, Oracle ones do not. Snmp polling is usually a straight forward process. This has been.... interesting.

[Jason VanDerMark]

Michael,

I almost forgot. When working with Oracle on the issues that we experienced with the emanate agent(same as your issues) I was told to install a set of patches. I kept the patches in an emanate patches directory, so here they are:

PHKL_22589
PHCO_23876
PHCO_23963
PHCO_24148
PHCO_23651
PHKL_23226
PHKL_23814
PHKL_24027
PHKL_24028
PHKL_24116

After installing these patches and ensuring that the maxfiles and maxfile_lim was set properly, emanate worked for us. I hope that this helps.

Regards,
Jason V.

Note: This requires some downtime and a few reboots to make it all happen.

[Sridhar Bhaskarla]

I do not know the OIDs associated with the oracle MIBs. Did you try snmpwalk and see if are sure you are not getting any replies from oracle MIB counters?. Do an snmpwalk and output the result to a file and verify the file.

-Sri

[Michael Treadwell_1]

Jason,
Forgot to mention. We're on 10.20 & Oracle 7.3.3. If I load the 10.20 equivilent of those patches, it breaks Oracle. Primarily its the libc patches that do it.

Sridhar,
Did the snmpwalk again to be sure. No Oracle responses at all.

[Jason VanDerMark]

Sorry about that. I always forget that there are still 10.20 shops out there. Again my appologies.

Regards,
Jason V.