Error while monitoring a Oracle Database

[HAL]

HI,

We have configured the oracle wizards to monitor oracle databases/servers. we have tried testing it this morning to check the connection time for the database wh an error "cannot connect to 10.202.23.16:1521. ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA (DBD ERROR: OCIServerAttach)"

we are using nagios xi on RHEl 64-bit. I have checked the variables and they are set on the right path.

[scottwilkerson]

This post outlines the same issue
http://support.nagios.com/forum/viewtop ... 326#p33778

You need to edit "listener.ora" and "tnsnames.ora" in oracle server side

[HAL]

Am i Expected to do that on all the servers i intend to monitor??

The situation has changed now...I see that the parameters i'm monitoring are green and ok but the stus information is shown as null...!! What could have gone wrong and Should we wait sometime before we start worrying about it?

[scottwilkerson]

If you click on the service does the detail page have additional output? By default only the first line is displayed when viewing multiple services.

[HAL]

Hi,

Please find the screen shots in the attachment showing the details page of the service and the service history

[scottwilkerson]

This is just the connection time. You will need to resolve the issue with the SERVICE_NAME in order to get an accurate result.

[HAL]

HI
Can you give us the configuration to be done in Tnsnames.ora and listner.ora?

[scottwilkerson]

Here is a website that goes over what kind of information should be in these
http://www.dba-oracle.com/t_oracle_sid_ ... e_name.htm

[HAL]

HI
We are getting Null values for tablespace utilization and Connection time details.

We have followed all the steps given in the PDF which is given in above replies.

We have also added the entries in listner at Oracle DB side as follows
MYSQL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Nagios server hostname)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mysql.lhc4net.lhc.com)
)
)

Still we are facing issue.

We have given read priviliage to the DB user created.

Please help

[scottwilkerson]

I'm going to have a developer that has worked with this a bit take a look at this when he get in tomorrow and get back to you.