Thursday, November 3, 2011

Missing Oracle client on Application Server

The Scenrio is that one of the application servers of PEQ is not starting. When we checked the database connection it is showing return code 12 with R3trans -d command.

trans.log shows that the version of oracle client can't be ascertained.

we checked the env with env command

and it shows that variable SHLIB_PATH contains value

SHLIB_PATH=/usr/sap/PEQ/SYS/exe/run:/oracle/PEQ/client/11x_64/instantclient

Here in this environment the oracle client is maintained for each SID separately but we verified the physical path of oracle client it is present in /oracle/client/11x_64/instantclient


so we temperarily changed the env to physical path and it worked

$setenv SHLIB_PATH /usr/sap/PEQ/SYS/exe/run:/oracle/client/11x_64/instantclient

$R3trans -d
This is R3trans version 6.22 (release 720 - 02.05.11 - 15:56:00).
unicode enabled version
R3trans finished (0000).

No comments: