How check oracle tablespace on AIX with dbsnmp

[rom]

Hi,

This was discuss on this thread:
How check oracle tablespace on AIX 5.2 with native snmp
But no response seems to be given and some links don't work anymore

On AIX, we use the Intelligent Agent 'dbsnmp'. I don't know if it is really intelligent but in my case it don't works

First of all, I want to be sure my snmpd configuration is correct.
As the documentation says, I add the line: smux "" IP
For IP, I put the IP address of the host where the subagent 'dbsnmp' run, i.e. the IP of the host where Oracle and snmpd runs because all these services are on the same host.

Normally I don't need to do something else. But it don't work. Would I have forgotten something ?

Can someone could post an exemple of his configuration files.
Thanks in advance for any help.

[rom]

The agent start without error but when I enable trace, the message "nsopen: can not open transport" appears continuously.

A other very strange thing:
When I browse the AIX MIB and check it with tcpdump on port 162, all it's OK. But if I try to browse Oracle MIB (enterprises.111), I got a snmp timeout.
And tcpdump show nothing. If try an other time to browse the AIX MIB, I got a SNMP timeout again and tcpdump show nothing whereas it was working before browsing Oracle MIB!!!!

[rony]

Well, I have to first say, I hate the AIX SNMP agent. And I have said this to AIX tech support.

That being said, I would say you have failed to setup the correct smux or dpid2 entry in the snmpd.conf for the sub agent to properly communicate with snmpd. I would suggest you contact either Oracle support or IBM support. I personally would start with Oracle support.

[tirexx]

how make work oracle 9 snmp on aix 5.x:
for me help this steps:
1
in
/etc/snmpdv3.conf
add line

Code: Select all

VACM_VIEW defaultView        1.3.6.1.4.1.111            - included -

conf file looks like this

Code: Select all

# exclude snmpv3 related MIBs from the default view
VACM_VIEW defaultView        snmpModules                - excluded -
VACM_VIEW defaultView        1.3.6.1.6.3.1.1.4          - included -
VACM_VIEW defaultView        1.3.6.1.6.3.1.1.5          - included -
VACM_VIEW defaultView        1.3.6.1.4.1.111            - included -

# exclude aixmibd managed MIBs from the default view
VACM_VIEW defaultView        1.3.6.1.4.1.2.6.191        - excluded -

2
in files
/etc/snmpdv3.conf
/etc/snmpd.conf

before any smux line add

Code: Select all

smux 0.0 "" 10.10.10.10

where

Code: Select all

10.10.10.10

is

Code: Select all

# hostname
aixhost
# ping aixhost
PING aixhost: (10.10.10.10): 56 data bytes
64 bytes from 10.10.10.10: icmp_seq=0 ttl=255 time=0 ms
64 bytes from 10.10.10.10: icmp_seq=1 ttl=255 time=0 ms
--------------^^^^^^^^^^^^------------------------------

3
restart aix snmpd

Code: Select all

stopsrc -s aixmibd
stopsrc -s snmpmibd
stopsrc -s hostmibd
stopsrc -s snmpd

startsrc -s snmpd
startsrc -s snmpmibd
startsrc -s hostmibd
startsrc -s aixmibd

4
restart oracle dbsnmp

Code: Select all

agentctl stop
agentctl start

5
make shure
on

Code: Select all

tail /oracle/app/oracle/product/9.x.x.x.x/network/log/dbsnmp.log

not exists line like

Code: Select all

NMS-00001: Warning: dbsnmp unable to connect to SNMP master agent

6
test

Code: Select all

clsnmp walk -h localhost 1.3.6.1.4.1.111

p.s. in trace apears "nsopen: can not open transport" but test reveal lot of data