Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Oracle dbconsole SNMP traps are recieved as coming from 127.0.0.1

Posted on 2011-09-19
7
Medium Priority
?
756 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
7 Comments
 
LVL 35

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 35

Expert Comment

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

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

As dyndns has reduced the capabilities of the free service, I looked around for other free providers of Dynamic DNS service. After testing several I decided to move my DNS hosting to Hurricane Electric as then domains that require dynamic hostnam…
David Varnum recently wrote up his impressions of PRTG, based on a presentation by my colleague Christian at Tech Field Day at VMworld in Barcelona. Thanks David, for your detailed and honest evaluation!
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

730 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