REP_51002 : Database driver event...Error occurred loading library [libclntsh.so.10.1:

 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]

When this error is hit then we need to create the symbolic link between the database server library file if we had installed the infomatica and the db in the single Linux box .. if the infomatica is installed in the separate Linux box then we need to link the libraries in the  oracle Client

Step 1

Create the new repository service in the infomatica 

Legends

Name                :=Name of the Repository

Description       :=Repository's Description

Location           :=The Domain Location .. [when you have the multiple Domains then we can        choose from the drop down list of Domains]

License             :=The License number which is created at the time of installing

Node                 :=Node Name in which the informatica is installed

Step 2

Provide the Database details

Legends

Database Type          :=Oracle [or any other db vendor]

User Name               :=Db username which is created for the repository schema.

Password                  :=Db username's Password

ConnectionString     :=Db connection String

Code Page                :=The Character Settings of the fonts

We need to select the No content exitst... when we are creating the new repository

Error

 When we are trying to start the repository service the we can get this kind of error

Once you are getting this error's then we need to link the library file which is present in the ORACLE_HOME/lib

ln -s libclntsh.so.10.1 libclntsh.so

[oracle@bitst lib]$ ll libclntsh.so.10.1
lrwxrwxrwx 1 oracle oinstall 56 Mar  7 02:48 libclntsh.so.10.1 -> /u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so

once the linking is done then restart the service 

[orainfa@bitst bin]$ ./infaservice.sh shutdown
Stopping Informatica services on node 'node01_bitst.<domain>.com'
 

[orainfa@bitst bin]$ ./infaservice.sh startup
Starting Informatica services on node 'node01_bitst.<domain>.com'
Using CURRENT_DIR:     /u03/app/oracle/Informatica/9.0.1/tomcat/bin
Using INFA_HOME:       /u03/app/oracle/Informatica/9.0.1