Solved

Oracle dbconsole SNMP traps are recieved as coming from 127.0.0.1

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

Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Bandwidth cap???? 8 100
VLAN 1 Line Protocol Down 9 86
Oracle SQL Developer - SubString 2 55
Moving Oracle Database to other server 2 47
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.
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 Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

710 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