Solved

Oracle dbconsole SNMP traps are recieved as coming from 127.0.0.1

Posted on 2011-09-19
7
739 Views
Last Modified: 2012-05-12
I am trying to configure SNMP trap alerts on an Oracle DB server.
The server is running a local instance of OEM dbconsole. I am NOT running GridControl.

I have configure the dbconsole to with a Notification Method to send snmp traps to my 3rd party trap receiver.
I can use the "Test SNMP Trap" button in the dbconsole to send a test trap to the receiver.
The test trap is received with one problem....
The receiver is seeing the trap as coming from the localhost address of 127.0.0.1 .
This has to be on the Oracle side of things. I have lots of other servers sending traps to this receiver both RedHat and Windows that work fine.
It looks like dbconsole is setting the snmp "aggent-addr" field to the 127.0.0.1 address.
Any ideas how to fix this so the receiver sees the traps as coming from the actual address of the sending host?

I am not sure if this an issue with Oracle setup, hosts file, snmp.conf file or other.
0
Comment
Question by:afcnoc
  • 3
  • 2
7 Comments
 
LVL 34

Expert Comment

by:Duncan Roe
ID: 36572538
Is the trap coming from the same system that runs Oracle? 127.0.0.1 is fine if so, otherwise completely wrong. Systems don't have a "real" address - they just have a number of network interfaces each with its own address. The local interface at 127.0.0.1 is one of these.
0
 

Author Comment

by:afcnoc
ID: 36573885
I do understand IP networking.
When the EM dbconsole send it's trap to the trap reciever (running on a different server, not the Oracle server) it is seen by the trap reciever as coming from the 127.0.0.1 address and not the address bound to the NIC in the db server.
Example:
The DB server has a single NIC connected to the network.
The IPv4 address bound to this NIC is 192.168.1.2
When the trap reciever gets the trap, it sees the trap as coming from the 127.0.0.1.
It should see the trap as coming from 192.168.1.2 not the loopback/local host address.
This is certainly not normal.

I have other RedHat servers with the same snmpd.conf file sending traps to this trap reciever and all of their traps are seen as coming from the IP of the NIC.
Granted, none of these serevers is running Oracle so the traps are coming from other agents. But their traps are still seen as coming from the correct IP.
0
 

Author Comment

by:afcnoc
ID: 36574188
I ran another test to try and isolate this issue.
I have hardware "health" agents running on the DB server that send SNMP traps to the same reciever.
I triggered some traps via the health agents and they were seen by the receiver as coming from the IP address of the NIC. Not the 127.0.0.1 address.
I really think this is an EM dbconsole issue putting the wrong IP in the SNMP trap for some reason.
0
 

Accepted Solution

by:
afcnoc earned 0 total points
ID: 37041732
I figured it out.
I had to add a line to the hosts file on the DB server that had the IP/hostname of the DB server.
0
 
LVL 34

Expert Comment

by:Duncan Roe
ID: 37043549
Yes you need that. Good pickup
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Data center, now-a-days, is referred as the home of all the advanced technologies. In-fact, most of the businesses are now establishing their entire organizational structure around the IT capabilities.
PRTG Network Monitor lets you monitor your bandwidth usage, so you know who is using up your bandwidth, and what they're using it for.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question