Informatica Repository Service Error (REP_51002 Database driver event)

Error Syntax:

            serviceType     serviceName    severity            timestamp        threadName    messageCode  message

RS       UAT_REP_SERVICE           1$_:_$ERROR           01/21/2014 12:54:29.412 PM 140524809037552            REP_51002     Database driver event...Error occurred loading library [libclntsh.so.10.1: cannot open shared object file: No such file or directory]Database driver event...Error occurred loading library [libpmora8.so]

REP_51002 informatica

REP_51002 Database driver event...Error occurred loading library [libclntsh.so.10.1: cannot open shared object file: No such file or directory]Database driver event...Error occurred loading library [libpmora8.so]

Cause:

            This is because environment setup and oracle client installation.

Solution:

1.      $ LD_LIBRARY_PATH variable need to set properly ($ORACLE_HOME/lib)

2.      Check missing lib file (libclntsh.so.10.1) is available in $ORACLE_HOME/lib location. If you don’t have exact name, you might have file like libclntsh.so.11.1, which is higher than the missing one. You need to create symbolic for the same as below:

create s symbolic

ln -s libclntsh.so.11.1 libclntsh.so.10.1