Error while monitoring a Oracle Database

[nscott]

Could you PM me your listener.ora and tnsname.ora?

[HAL]

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.

Hi
We are waiting for this?

Can you get back to us ASAP ? We are running short of time

[HAL]

Hi ,
Please check the required files.

[HAL]

Hi,
We are awaiting your reply, can you please respond as this is on priority

Also one more thing, when we change the password to anything (wrong password) still we get the service information as "Null".
Is there a way to check it manually from Nagios Server to validate the plugin/wizard?

[nscott]

It looks like that should be ok, can you log into the Oracle DB command line and run

Code: Select all

SQL> show parameter local_listener
SQL> show parameter service_names

And also what is the name of the service and or listener you added for Nagios?

[HAL]

The services are- Connected Users, Connection Time, Tablespace Usage.
Uptime and Ping are just working fine.

I will send the output little later.

[HAL]

please find the attached output

[HAL]

Any updates on this?

[nscott]

In the tnsnames and listener.ora file, what is the name of the Nagios service?

[HAL]

There is no Nagios service name in those files. Are there any entries to be made manually?