Monday, March 18, 2013

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


pmrep: error while loading shared libraries: libACE.so.5.4.7: cannot open shared object file

pmrep: error while loading shared libraries:  and  pmcmd: error while loading shared libraries

When we are trying to access the domain in the infomatica we need  pmrep and pmcmd commands to communicate.. we are getting this error due to no env variables once place the correct env variables in the .bash_profile then the things will start to work

pmrep: error while loading shared libraries: libACE.so.5.4.7: cannot open shared object file: No such file or directory

pmcmd: error while loading shared libraries: libpmasrt.so: cannot open shared object file: No such file or directory


Step 1
execute the pmrep and pmcmd commands


The commands will not be loaded due to the enc variables and the path are not set so we need to set path and the env variables

Step 2
Set the env variables accordingly


Set the INFA_HOME               =[root directory of the infomatica ]
Set the PM_HOME                  =[root directory of the infomatica]
Set the PATH                            =$INFA_HOME/server/bin
Set the LD_LIBRARY_PATH =$INFA_HOME/server/bin
Now test the commands and then Place the entries in the .bash_profile

add all this entries in the .bash_profile
export PATH
INFA_HOME=/u03/app/oracle/Informatica/9.0.1
export INFA_HOME
PM_HOME=/u03/app/oracle/Informatica/9.0.1
export PM_HOME
PATH=${PATH}:/u03/app/oracle/Informatica/9.0.1/server/bin
export PATH
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/u03/app/oracle/Informatica/9.0.1/server/bin
export LD_LIBRARY_PATH
and stop the infaservice and logout  and login and start the infaservice

[orainfa@bitst ~]$ pmcmd

Informatica(r) PMCMD, version [9.0.1 HotFix2], build [242.1111], LINUX 64-bit
Copyright (c) Informatica Corporation 1994 - 2010
All Rights Reserved.

Invoked at Mon Mar 18 13:58:03 2013

pmcmd>

[orainfa@bitst ~]$ pmrep

Informatica(r) PMREP, version [9.0.1 HotFix2], build [242.1111], LINUX 64-bit
Copyright (c) Informatica Corporation 1994 - 2010
All Rights Reserved.
This Software is protected by U.S. Patent Numbers 5,794,246; 6,014,670; 6,016,501; 6,029,178; 6,032,158; 6,035,307; 6,044,374; 6,092,086; 6,208,990; 6,339,775; 6,640,226; 6,789,096; 6,820,077; 6,823,373; 6,850,947; 6,895,471; 7,117,215; 7,162,643; 7,254,590; 7,281,001; 7,421,458; and 7,584,422, international Patents and other Patents Pending.

Invoked at Mon Mar 18 13:57:56 2013

pmrep>exit