Page 1 of 1
After upgraded to 5.6.0 Oracle Services Critical
Posted: Wed Apr 24, 2019 9:37 am
by brucej543
Completed Upgrade to 5.6.0 and all services for Oracle databases have error out with cannot open shared object file.
I have included screen shots of service problems, event log and Oracle commands.
What needs to be done to correct this issue?
Re: After upgraded to 5.6.0 Oracle Services Critical
Posted: Wed Apr 24, 2019 9:59 am
by brucej543
Additional information from the service alert:
Info: CRITICAL - cannot connect to bcfintdb02:1521/fintest2. install_driver(Oracle) failed: Cant load /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so for module DBD::Oracle: libclntsh.so.12.1: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 190.
at (eval 14) line 3.\nCompilation failed in require at (eval 14) line 3.\nPerhaps a required shared library or dll isnt installed where expected\n at /usr/local/nagios/libexec/check_oracle_health line 6151.\n
Re: After upgraded to 5.6.0 Oracle Services Critical
Posted: Wed Apr 24, 2019 10:16 am
by brucej543
Corrected issue. The path to Oracle modules changed. Corrected to the new 12.2/client64 paths on the commands.
This change was not noted in the Change log and there was no special instructions to that said to change the paths on the check_xi_oracleXXXXX commands.
Old Path Settings:
/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib ORACLE_HOME=/usr/lib/oracle/11.2/client $USER1$/check_oracle_health $ARG1$
New Path settings:
/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib ORACLE_HOME=/usr/lib/oracle/12.2/client64 $USER1$/check_oracle_health $ARG1$
Re: After upgraded to 5.6.0 Oracle Services Critical
Posted: Wed Apr 24, 2019 1:10 pm
by lmiltchev
Old Path Settings:
/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib ORACLE_HOME=/usr/lib/oracle/11.2/client $USER1$/check_oracle_health $ARG1$
New Path settings:
/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib ORACLE_HOME=/usr/lib/oracle/12.2/client64 $USER1$/check_oracle_health $ARG1$
The first path is the "default" path in the wizard. The command needs to be modified, depending on the client version that you are using. Unfortunately, on minor upgrades (like 5.5 -> 5.6) we force reinstalling wizards, and the "modified" command gets overwritten. This is not ideal, and we are looking into ways of changing (fixing) that.
Re: After upgraded to 5.6.0 Oracle Services Critical
Posted: Thu Apr 25, 2019 1:35 pm
by brucej543
This post can be closed.