Cannot determine ORACLE_HOME

[Beniben]

./check_oracle --connect //x.x.x.x/XE --mode connection-time --password test --report long --username nagios
Cannot determine ORACLE_HOME for sid //x.x.x.x/XE

I am currently trying to run the script in shell only, however I am getting this error message. I have also tried with the environment variable, but this leads to the same result

./check_oracle --connect //x.x.x.x/XE --mode connection-time --password test --report long --username nagios -environment ORACLE_HOME=/opt/oracle/product/21c/dbhomeXE
Cannot determine ORACLE_HOME for sid //x.x.x.x/XE

Does -environment work at all or have I forgotten something?
It works if I already set the Oracle_Home itself before running it (export oracle_home=....), but I need it with -environment

[lausser]

Is it -environment…. or --environment? I guess you missed one hyphen, right? Gerhard Von: Beniben ***@***.*** Gesendet: Montag, 17. Oktober 2022 13:48 An: lausser/check_oracle_health ***@***.***> Cc: Subscribed ***@***.***> Betreff: [lausser/check_oracle_health] Cannot determine ORACLE_HOME (Issue #39) ./check_oracle --connect //x.x.x.x/XE --mode connection-time --password test --report long --username nagios Cannot determine ORACLE_HOME for sid //x.x.x.x/XE I am currently trying to run the script in shell only, however I am getting this error message. I have also tried with the environment variable, but this leads to the same result ./check_oracle --connect //x.x.x.x/XE --mode connection-time --password test --report long --username nagios -environment ORACLE_HOME=/opt/oracle/product/21c/dbhomeXE Cannot determine ORACLE_HOME for sid //x.x.x.x/XE Does -environment work at all or have I forgotten something? It works if I already set the Oracle_Home itself before running it (export oracle_home=....), but I need it with -environment — Reply to this email directly, view it on GitHub <#39> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/AABQSODZDDTCULQZAPVR4W3WDU4FVANCNFSM6AAAAAARG7QRDI> . You are receiving this because you are subscribed to this thread. <https://github.com/notifications/beacon/AABQSOBH2TKHF7UOAND47RLWDU4FVA5CNFSM6AAAAAARG7QRDKWGG33NNVSW45C7OR4XAZNFJFZXG5LFVJRW63LNMVXHIX3JMTHFIIFZ5U.gif> Message ID: ***@***.*** ***@***.***> >

[Beniben]

Hello,

i tried it both ways and its still not working. The path to the Oracle-Home is correct because if I export it manually it works again (export ORACLE_HOME=...), but unfortunately I need --environment for my current use-case.

[lausser]

Run it with an extra „-v” Von: Beniben ***@***.*** Gesendet: Donnerstag, 20. Oktober 2022 13:09 An: lausser/check_oracle_health ***@***.***> Cc: Gerhard Lausser ***@***.***>; Comment ***@***.***> Betreff: Re: [lausser/check_oracle_health] Cannot determine ORACLE_HOME (Issue #39) Hello, i tried both ways and its still not working <https://user-images.githubusercontent.com/38496822/196932973-894eb982-15fd-40ba-98be-b8c227f142e6.png> — Reply to this email directly, view it on GitHub <#39 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/AABQSOHRQXEUCGOVL6VLHVTWEER3TANCNFSM6AAAAAARG7QRDI> . You are receiving this because you commented. <https://github.com/notifications/beacon/AABQSOEWAXWK3RPHFJARVDDWEER3TA5CNFSM6AAAAAARG7QRDKWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTSMTTAPG.gif> Message ID: ***@***.*** ***@***.***> >

[Beniben]

was there some output i should have expected?

[lausser]

Sey, you should see something like this ***@***.***:~$ ./check_oracle_health --connect 'pridb01:1521/db0002' --username 'nagios' --password '.....' --timeout 180 --negate warning=critical --mode connection-time --method sqlplus --warning 20 --critical 20 --environment ORACLE_HOME=/not/exist -v new ORACLE_HOME=/not/exist forces restart ORACLE_HOME = /not/exist Thu Oct 20 13:49:06 2022: ORACLE_HOME is now /not/exist Thu Oct 20 13:49:06 2022: try to find /not/exist/bin/sqlplus Thu Oct 20 13:49:06 2022: try to find /not/exist/sqlplus CRITICAL - cannot connect to pridb01:1521/db0002. nosqlplus Thu Oct 20 13:49:06 2022: try to clean up command and result files p.s. you should under no circumstances run plugins as root, but only as the monitoring user. (1. because of possibly different environment, path,… and 2. because it can leave temporary files behind which the monitoring user can’t read later) Von: Beniben ***@***.*** Gesendet: Freitag, 21. Oktober 2022 07:55 An: lausser/check_oracle_health ***@***.***> Cc: Gerhard Lausser ***@***.***>; Comment ***@***.***> Betreff: Re: [lausser/check_oracle_health] Cannot determine ORACLE_HOME (Issue #39) <https://user-images.githubusercontent.com/38496822/197122795-4993d169-3e9e-42e4-acd7-c587039a3a5c.png> was there some output i should have expected? — Reply to this email directly, view it on GitHub <#39 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/AABQSODP5YJL62BZL2AOAZDWEIV3RANCNFSM6AAAAAARG7QRDI> . You are receiving this because you commented. <https://github.com/notifications/beacon/AABQSOCWF2UIXX2E73KUEYTWEIV3RA5CNFSM6AAAAAARG7QRDKWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTSMVZLTM.gif> Message ID: ***@***.*** ***@***.***> >