Oracle Tablespace Monitoring Service Error

[IT-OPS-SYS]

hi team,

i have added a oracle server for the tablespace monitoring but for the services i am getting an error "CRITICAL - cannot connect to 149.24.41.37:1521/oraqa3. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach)"
oracle vers 19

Does the Nagios driver into oracle use an ojdbc?

[cdienger]

What version of the client are you using? Did you follow the steps in https://assets.nagios.com/downloads/nag ... ios-XI.pdf ? What is the full command that you are running to get this error and are you running it in the web UI or command line? Try both if you haven't already and test with both the nagios and root account on the command line if you haven't already. You can switch to the nagios account with:

Code: Select all

su - nagios

On the Oracle DB, try running the query:

Code: Select all

select value from v$parameter where name='service_names'

per https://www.ibm.com/support/pages/ora-1 ... descriptor

The plugin Nagios uses relies on the Oracle client that is installed. I believe the client uses ojdbc as I see these on a lab machine:

/usr/lib/oracle/12.1/client64/lib/ojdbc6.jar
/usr/lib/oracle/12.1/client64/lib/ojdbc7.jar

[IT-OPS-SYS]

tried with nagios same issue.
command for the service is as below:

/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib ORACLE_HOME=/usr/lib/oracle/12.2/client64 /usr/local/nagios/libexec/check_oracle_health --connect '149.24.41.37:1521/oraqa3' --username 'system' --password 'xxxxx' --mode tablespace-fragmentation --warning 30: --critical 20

[cdienger]

Is there an entry in the tnsnames.ora file for oraqa3? For an example of a tnsnames entry, look at https://www.orafaq.com/wiki/Tnsnames.ora. This would be on the Oracle server.

[IT-OPS-SYS]

will this work on oracle version 19c as well.

PLease tell me wat needs to be done on the oracle client side so that i can make the changes all once.

[cdienger]

19c has the same file:

https://docs.oracle.com/en/database/ora ... -file.html