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
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'
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
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