After upgraded to 5.6.0 Oracle Services Critical

[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?

[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

[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$

[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.

[brucej543]

This post can be closed.