ORA-12504: TNS:listener was not given the SERVICE_NAME ??

[xpertech]

I download "Oracle Tablespace Wizard" and "Oracle Server Wizard" and refer document (http://assets.nagios.com/downloads/nagi ... lation.pdf), when using Nagios XI monitor Oracle Server, there was an error "ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA (DBD ERROR: OCIServerAttach)", what could be the problem?

I search google but still don't know what to do next?!

https://www.google.com/#hl=zh-TW&safe=o ... 40&bih=785

[scottwilkerson]

Did you add the LD_LIBRARY_PATH and ORACLE_HOME to your commands as outlined on page 2-3?

[xpertech]

Did you add the LD_LIBRARY_PATH and ORACLE_HOME to your commands as outlined on page 2-3?

Yes, we did.
We use that two wizard to test Oracle DB express version and it work fine, but when testing in our client's full version DB there was an error?!

[scottwilkerson]

Can you post the full command that the system is attempting to run

[xpertech]

Can you post the full command that the system is attempting to run

Looks like this:
check_xi_oracletablespace!--connect "192.168.1.135:1521" --username system --password "password" --name SYSTEM --mode tablespace-can-allocate-next --warning 20 --critical 30

Some guys said need to edit "listener.ora" and "tnsnames.ora" in oracle server side, the others said need to edit NagiosXI side?!

We edit listener.ora and tnsnames.ora in oracle server side, and it did work, but if oracle server not allowed to edit, is there possible to edit NagiosXI command syntax?

[scottwilkerson]

A little out of my expertise, but the connect string can be changed on the nagios side, If you look at the following post you can see what someone else is using after --connect=""

http://support.nagios.com/forum/viewtop ... 185#p24194

[xpertech]

A little out of my expertise, but the connect string can be changed on the nagios side, If you look at the following post you can see what someone else is using after --connect=""

http://support.nagios.com/forum/viewtop ... 185#p24194

Hi Scott,
This works on our Oracle DB Server(testing lab), but still error when monitoring Oracle DB Server at our client's site.
We export client's Oracle DB Server VM and import to our VM lab for testing, no luck!

Is it possible that you or your team connect to our lab and take a look? that error need to be fix asap, thanks.

[nscott]

Editing those files on the Oracle server is required as thats how the Oracle DB knows how to allow anybody to access them. Its somewhat akin to a firewall, or Access Control List. So yes, you'll have to edit those on the server.