Solved

Oracle dbconsole SNMP traps are recieved as coming from 127.0.0.1

Posted on 2011-09-19
7
747 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Suggested Courses

624 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