AIX 5 and Oracle 9.2.01 dbsnmp

From: Michael Cheselka <cheselka_at_gmail.com>
Date: Thu, 29 Jun 2006 18:01:56 -0700
Message-ID: <3c6fb8810606291801t1289be5bkf722b5f86641745c@mail.gmail.com>

Hello,

Anyone on this list have experience getting snmpwalk info back from Oracle Intelligent Agent for Oracle 9i running on AIX 5? I would like to get this working.

I installed Oracle 9i 9.2.0.1 on AIX 5L( 5.2.0.10) box, along with the Oracle Intelligent Agent:

# netstat -an | egrep '161|162|199|1521|1748|1754|1808|1809'

tcp4       0      0  *.199                  *.*                    LISTEN
tcp4       0      0  *.1521                 *.*                    LISTEN
tcp4       0      0  10.100.100.53.1748     *.*                    LISTEN
tcp4       0      0  10.100.100.53.1754     *.*                    LISTEN
tcp4       0      0  10.100.100.53.1808     *.*                    LISTEN
tcp4       0      0  10.100.100.53.1809     *.*                    LISTEN
tcp4       0      0  127.0.0.1.199          127.0.0.1.34984        ESTABLISHED
tcp4       0      0  127.0.0.1.34984        127.0.0.1.199          ESTABLISHED
tcp4       0      0  10.100.100.53.199      10.100.100.53.35567    ESTABLISHED
tcp4       0      0  10.100.100.53.35567    10.100.100.53.199      ESTABLISHED
tcp4       0      0  10.100.100.53.199      10.100.100.53.35572    ESTABLISHED
tcp4       0      0  10.100.100.53.35572    10.100.100.53.199      ESTABLISHED
tcp4       0      0  10.100.100.53.1521     10.100.100.53.35568    ESTABLISHED
tcp4       0      0  10.100.100.53.35568    10.100.100.53.1521     ESTABLISHED
udp4       0      0  *.161                  *.*
f1000089c01a0800 stream      0      0 f100009e162cd7a0
0                0                0 /var/ct/IW/soc/mc/RMIBM.AuditRM.0
f1000089c01af800 dgram       0      0 f100009e1611c5d0
0                0                0 /dev/.SRC-unix/SRCv4AgUu

# ps auxww | egrep oracle | egrep -v egrep oracle 327690 93.0 3.0 32960 27468 pts/0 A 17:59:57 973:58
/opt/oracle/bin/dbsnmp

oracle   331946  0.3  3.0 55360 26500      - A      Jun 26  7:32 ora_qmn0_cittio
oracle   299040  0.0  2.0 51336 22476      - A      Jun 26  1:05 ora_ckpt_cittio
oracle   282804  0.0  2.0 50948 22088      - A      Jun 26  0:51 ora_cjq0_cittio
oracle   323670  0.0  3.0 58788 29928      - A      Jun 26  0:33 ora_s000_cittio
oracle   303322  0.0  2.0 51348 22488      - A      Jun 26  0:29 ora_lgwr_cittio
oracle   442442  0.0  1.0 15232 8604  pts/0 A    17:58:29  0:09


/opt/oracle/bin/tnslsnr LISTENER -inherit

oracle   266308  0.0  2.0 51356 22496      - A      Jun 26  0:17 ora_smon_cittio
oracle   352310  0.0  5.0 76116 47256      - A      Jun 26  0:17 ora_d000_cittio
oracle   258214  0.0  3.0 55780 26920      - A      Jun 26  0:17 ora_pmon_cittio
oracle    94376  0.0  3.0 53308 24448      - A      Jun 26  0:15 ora_dbw0_cittio

oracle 454734 0.0 0.0 732 772 pts/0 A 17:59:57 0:00 sh
/opt/oracle/bin/dbsnmpwd

oracle 315494 0.0 2.0 51128 22268 - A 18:00:09 0:00 oraclecittio (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) oracle 278742 0.0 2.0 50940 22080 - A Jun 26 0:00 ora_reco_cittio

I can run "tnsping" on 1748 and 1754 but not 1808 or 1809. How can I get data back from the agent? Do I need to install a second smux running on 1001 or 1161 to snmpwalk dbsnmp?

snmpwalking any of 1748, 1754, 1808, or 1809 fails to return anything:

snmpalk -c public -v 1 192.168.1.52:1748 .1.3.6.1.4.1.111

What am I doing wrong?

Much Thanks!
Mike

-- 
When in the Potemkin Wired be a Potemkin Lain.
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 29 2006 - 20:01:56 CDT