Page 2 of 2

Re: error in running python plugin

Posted: Sun Mar 24, 2019 8:41 pm
by magpantayr
Hello,

Actually --mode is already included.
However, no output is being generated

Code: Select all

[root@CBAS035A ~]# /usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib ORACLE_HOME=/usr/lib/oracle/12.1/client64 /usr/local/nagios/libexec/check_oracle_health --connect 'CBDB017.cb.ph.conti.de:1521/CTEPIDB.cb.ph.conti.de' --username 'dbaread' --password 'cbdbaread' --tablespace 'PROD_DATA' --mode tablespace-usage --tablespace PROD_DATA
[root@CBAS035A ~]#
Running with -v

Code: Select all

[root@CBAS035A ~]# /usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib ORACLE_HOME=/usr/lib/oracle/12.1/client64 /usr/local/nagios/libexec/check_oracle_health --connect 'CBDB017.cb.ph.conti.de:1521/CTEPIDB.cb.ph.conti.de' --username 'dbaread' --password 'cbdbaread' --tablespace 'PROD_DATA' --mode tablespace-usage --tablespace PROD_DATA -v
[root@CBAS035A ~]#

Re: error in running python plugin

Posted: Mon Mar 25, 2019 8:16 am
by lmiltchev
It's unfortunate that the "verbose" output doesn't give us anything.

Do any other commands work for you? Do you get the expected output when you run the command below?

Code: Select all

/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib ORACLE_HOME=/usr/lib/oracle/12.1/client64 /usr/local/nagios/libexec/check_oracle_health --connect 'CBDB017.cb.ph.conti.de:1521/CTEPIDB.cb.ph.conti.de' --username 'dbaread' --password 'cbdbaread' --tablespace 'PROD_DATA' --mode list-tablespaces
Is opening a support ticket via our Support Center an option for you? We may need to schedule a remote session to further troubleshoot this issue.

Re: error in running python plugin

Posted: Mon Apr 22, 2019 3:26 am
by magpantayr
Hello,

unfortunately, remote session is not an option for us.

running the command you sent give the same results (no output).

I want to try to reinstall oracle but im afraid that it might affect other working configs again.

I referred here during my oracle installation: https://assets.nagios.com/downloads/nag ... ios-XI.pdf

will running again the oracleinstall.sh reinstall the oracle client?

Re: error in running python plugin

Posted: Mon Apr 22, 2019 11:48 am
by lmiltchev
Before rerunning the "oracleinstall.sh" script, let's check something else. Can you run the following command, and show the output?

Code: Select all

ls -lR /usr/lib/oracle