This content has been marked as final. Show 17 replies
make sure you have LD_LIBRARY_PATH variable defined that points to the correct Oracle database client libraries. I'd guess you might be needing something liek this:
where ORACLE_HOME is the database client home, NOT the BI home.
then restart the presentation service.
We have done that.
See below :
[oracle@mn210 none bi_1/] set|grep LD_LIBRARY
[oracle@mn210 none bi_1/] ls -l $LD_LIBRARY_PATH/libclntsh*
-rw-r----- 1 oracle dba 22914247 May 05 2006 /opt/oracle/product/10.1.0/db_1/lib//libclntsh.a
-rwxr-x--- 1 oracle dba 22145031 May 05 2006 /opt/oracle/product/10.1.0/db_1/lib//libclntsh.so
-rw-r--r-- 1 oracle dba 19426158 Oct 18 2005 /opt/oracle/product/10.1.0/db_1/lib//libclntsh.so.10.1
do you have a lib64 or a lib32 directory in the $ORACLE_HOME directory?
If you have a lib32, that should mean that the lib/ contains 64 bit libraries. if you have a lib64 then your lib/ contains 32 bit libraries and your LD_LIBRARY_PATH should then point to $ORACLE_HOME/lib64 instead.
also, I think you should create a simlink to the library
ln -s /opt/oracle/product/10.1.0/db_1/lib/libclntsh.so.10.1 /opt/oracle/product/10.1.3/bi_1/server/Bin64/libclntsh.so.10.1
I've made the symbolic link, but the results are still the same. Details of the link:
[oracle@mn210 none Bin64/] pwd
[oracle@mn210 none Bin64/] ls -l libclntsh.so
lrwxrwxrwx 1 oracle dba 48 Sep 12 14:19 libclntsh.so -> /opt/oracle/product/10.1.0/db_1/lib/libclntsh.so
The privs on the lib in the software tree:
[oracle@mn210 none Bin64/] ls -l /opt/oracle/product/10.1.0/db_1/lib/libclntsh.so
-rwxr-x--- 1 oracle dba 22145031 May 05 2006 /opt/oracle/product/10.1.0/db_1/lib/libclntsh.so
what about my suggest regarding the 32 bit and 64 bit libraries?
I've changed the link but the problem remains:
[oracle@mn210 none Bin64/] pwd
[oracle@mn210 none Bin64/] ls -l libcln*
lrwxrwxrwx 1 oracle dba 50 Sep 19 08:18 libclntsh.so - /opt/oracle/product/10.1.0/db_1/lib32/libclntsh.so
Has anyone any ideas how to solve this problem?
BI suite 10.2.0.3 expects a certain version of the oracle database software, e.a. sqlplus. Adding the correct ORACLE_HOME in our BI start script solved the problem. This is a 10.2.0.1.0 Oracle version
I had this exact same problem with BI EE 10.1.3.3.1 on Linux. I tried adding the LD_LIBRARY_PATH environment variable and it didn't help. What fixed the problem for me was adding the following "$ORACLE_HOME/lib:/usr/local/lib:/usr/lib:/lib" to the PATH environment variable for the user which starts the BI EE.
I am running against the same problem. I am not using an Oracle Client but the Oracle InstantClient. OBI-EE with Oracle InstantClient I can get to work in Windows but in Linux it keeps having problems finding the libnqsdbgatewayoci10g.so DLL. I have set the LD_LIBRARY_PATH to point to the Oracle InstantClient directory. The Oracle InstantClient SQLPlus works fine. Is there anyone that has gor OBI-EE (10.1.3.3.1 Linux) to work with Oracle InstantClient?
I had the same problem!
I have DB server EE 10g R2 10.2.0.1.0 64-bit on Red Hat Enterprise Linux 4 and Itanium 64-bit platform.
I also have BI EE 10.1.3.3.0 32-bit on an emulator for 32-bit (for Itanium does not exist BI EE 64 bits)
When I update row count in Adm. Tool or Interactive Dashboard get errors:
nQSError: 43093 An error ocurred while processing the EXECUTE PHYSICAL statement. libclntsh.s0.10.1: cannot open shared obtect file: No such file or directory
nQSError: 46029 Failed to load the DLL /oracle/app/oracle/product/10.1.3.3.0/obi_1/installloc/server/Bin/libnqsdbgatewayoci10g.so. Check if 'Oracle OCI 10g' database client is installed
ls -l /oracle/app/oracle/product/10.1.3.3.0/obi_1/installloc/server/Bin/libclnt*
lrwxrwxrwx 1 oracle oinstall 55 Dec 20 10:26 /oracle/app/oracle/product/10.1.3.3.0/obi_1/installloc/server/Bin/libclntsh.so -> /oracle/app/oracle/product/10.2.0/db_1/lib/libclntsh.so
lrwxrwxrwx 1 oracle oinstall 60 Dec 20 10:09 /oracle/app/oracle/product/10.1.3.3.0/obi_1/installloc/server/Bin/libclntsh.so.10.1 -> /oracle/app/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1
Help me please now!
I came across similar problem and I was able to get it to work successfully. I have documented the steps below.
Creating the link below elliminates the error. (db_2 is my 10g client home)
oracle:/opt/oracle/product/10gOBI/OracleBI/server/Bin >ln -s /opt/oracle/product/10.2.0/db_2/lib32/libclntsh.so.10.1 libclntsh.so.10.1
Can someone help to resolve the current issue ? (sorry the message was in french, I've translated),
0509-153 the file /u01/app/oracle/OraHome_3/lib/libclntsh.a is not a valid archive or cannot be read correctly
0509-026 system error : Impossible to run a file without correct format
When I check the file format, below the result (the file seems empty):
$ ls -l libcln*
-rwxrwxr-x 1 oracle oinstall 0 12 ao¹ 2005 libclntsh.a
but the same file in lib32 directory has a different size, unfortunately I cannot use it as my server is running under AIX 64bit
$ cd ../lib32
$ ls libcln*
-rwxr-xr-x 1 oracle oinstall 21815633 09 ao¹ 2005 libclntsh.a l
Edited by: tarzem on 1 juin 2009 10:32