Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Error occurred loading library [libclntsh.so.10.1: cannot oopen shared obje

-user2Dec 25 2011 — edited Dec 28 2011
error:
OBJM_54538 Unable to connect to the reposiREP_51002 Database driver event...Error occurred loading library [libclntsh.so.10.1: cannot oopen shared object file:No such file or directory] Database driver event...Error occurred loading library [libpmora8.so]
Hi

i'm on Oracle Enterprise Linux 5 update 6 32-bit
oracle 11g. r2 32 bit without client (as i've got both oracle &infa on same box)
infa 9.0.1 32 bit

i'm able to successfully connect to sqlplus sh/pswd@orcl.localdomain & repo user/domain users too connected good

tnsping is good
lsnrctl startup is good
tnsnames.ora is good

i already have libclntsh.so.10.1 in $ORACLE_HOME/lib/ ...i also copied the same file to $INFA_HOME/server/bin/....alredy added all env variables including LD_LIBRARY_PATH ...also i even i copied two files to /lib.. .still no luck..

literally i'm exhausted of ideas after googling for the past 48 hrs,,,:( any expert advice on what i'm missing would be gr8tly apprected. tq.
[infa901hf2@oel5u6 root]$ which libpmora8.so
~/Informatica/9.0.1/server/bin/libpmora8.so
 
[infa901hf2@oel5u6 root]$ which libclntsh.so.10.1
/usr/bin/which: no libclntsh.so.10.1 in (/usr/lib/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin:/usr/sbin:/home/oracle/app/oracle/product/11.2.0/dbhome_2/bin:/home/infa901hf2/Informatica/9.0.1/server/bin:/home/infa901hf2/Informatica/9.0.1/server/tomcat/bin)
 
[infa901hf2@oel5u6 root]$ ls -al /home/infa901hf2/Informatica/9.0.1/server/bin/libclntsh.so.10.1
lrwxrwxrwx 1 infa901hf2 infa901hf2 69 Dec 25 01:02 /home/infa901hf2/Informatica/9.0.1/server/bin/libclntsh.so.10.1 -> /home/oracle/app/oracle/product/11.2.0/dbhome_2/lib/libclntsh.so.11.1
 
[infa901hf2@oel5u6 root]$  ls -al /home/infa901hf2/Informatica/9.0.1/server/bin/libpmora8.so
-rwxrwxrwx 1 infa901hf2 infa901hf2 314325 Dec 24 22:17 /home/infa901hf2/Informatica/9.0.1/server/bin/libpmora8.so
 
OBJM_54538 Unable to connect to the repository RepoSrvc on database orcl
REP_51002 Database driver event...Error occurred loading library [libclntsh.so.10.1: cannot oopen shared object file:No such file or directory] Database driver event...Error occurred loading library [libpmora8.so]
.bash_profile with all env variables set is below
======================================
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
ORACLE_HOSTNAME=oel5u6.localdomain; export ORACLE_HOSTNAME
ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME
ORACLE_BASE=/home/oracle/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_2; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
PATH=$PATH:/usr/sbin:$ORACLE_HOME/bin; export PATH
 
LD_LIBRARY_PATH=.:$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
 
# JAVA HOME
JAVA_HOME=/usr/java/jdk1.6.0_30; export JAVA_HOME
 
 
#INFA ENV VARIABLES
LANG=C; export LANG
LC_ALL=C; export LC_ALL
INFA_JAVA_OPTS=-Xmx1024m; export INFA_JAVA_OPTS
INFA_HOME=/home/infa901hf2/Informatica/9.0.1; export INFA_HOME
INFA_DOMAINS_FILE=/home/infa901hf2/Informatica/9.0.1/domains.infa; export INFA_DOMAINS_FILE
LC_CTYPE=en_US.utf8; export LC_CTYPE
INFA_DEFAULT_DOMAIN=Domain_oel5u6.localdomain; export INFA_DEFAULT_DOMAIN
 
 
PATH=$PATH:$INFA_HOME/server/bin:$INFA_HOME/server/tomcat/bin; export PATH
LD_LIBRARY_PATH=.:$LD_LIBRARY_PATH:$INFA_PATH/server/bin; export LD_LIBRARY_PATH
listener.ora
# listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin/listener.ora
# Generated by Oracle configuration tools.
 
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = oel5u6.localdomain)(PORT = 1521))
    )
  )
 
 
ADR_BASE_LISTENER = /home/oracle/app/oracle
tnsnames.ora
 
# tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
 
 
LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = oel5u6.localdomain)(PORT = 1521))
 
 
 
 
ORCL.LOCALDOMAIN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oel5u6.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL.LOCALDOMAIN)
    )
  )
tnsping successful
[oracle@oel5u6 bin]$ tnsping orcl.localdomain
 
 
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 25-DEC-2011 00:20:33
 
 
Copyright (c) 1997, 2009, Oracle.  All rights reserved.
 
 
Used parameter files:
/home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin/sqlnet.ora
 
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oel5u6.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL.LOCALDOMAIN)))
OK (0 msec)
listener startup successful
[oracle@oel5u6 bin]$ lsnrctl start
 
 
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 25-DEC-2011 00:19:48
 
 
Copyright (c) 1991, 2009, Oracle.  All rights reserved.
 
 
Starting /home/oracle/app/oracle/product/11.2.0/dbhome_2/bin/tnslsnr: please wait...
 
 
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin/listener.ora
Log messages written to /home/oracle/app/oracle/diag/tnslsnr/oel5u6/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel5u6.localdomain)(PORT=1521)))
 
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                25-DEC-2011 00:19:48
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin/listener.ora
Listener Log File         /home/oracle/app/oracle/diag/tnslsnr/oel5u6/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel5u6.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
tq.
This post has been answered by Ahsan Shah on Dec 28 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 25 2012
Added on Dec 25 2011
#business-intelligence-applications
2 comments
6,642 views