1 2 Previous Next 17 Replies Latest reply: Jun 2, 2009 9:50 AM by rmoff RSS

    Dependent module libclntsh.a(shr.o) could not be loaded

    Raymond Vermeer
      We are facing the error below on our Dashboard :

      Foutcodes: OPR4ONWY:U9IM8TAC:OI2DL65P

      Toestand: HY000. Code: 603538432. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. 0509-022 Cannot load module /opt/oracle/product/10.1.3/bi_1/server/Bin64/libnqsdbgatewayoci10g64.so. 0509-150 Dependent module libclntsh.a(shr.o) could not be loaded. 0509-022 Cannot load module libclntsh.a(shr.o). 0509-026 System error: A file or directory in the path name does not exist. 0509-022 Cannot load module /opt/oracle/product/10.1.3/bi_1/server/Bin64/libnqsdbgatewayoci10g64.so. 0509-150 Dependent module /opt/oracle/product/10.1.3/bi_1/server/Bin64/libnqsdbgatewayoci10g64.so could not be loaded. [nQSError: 46029] Failed to load the DLL /opt/oracle/product/10.1.3/bi_1/server/Bin64/libnqsdbgatewayoci10g64.so. Check if 'Oracle OCI 10G' database client is installed. (HY000)

      Does anyone know the solution for this ?
        • 1. Re: Dependent module libclntsh.a(shr.o) could not be loaded
          29997
          Hi

          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:

          export LD_LIBRARY_PATH=$ORACLE_HOME/lib/

          where ORACLE_HOME is the database client home, NOT the BI home.

          then restart the presentation service.

          Borkur
          • 2. Re: Dependent module libclntsh.a(shr.o) could not be loaded
            Raymond Vermeer
            We have done that.
            See below :

            [oracle@mn210 none bi_1/] set|grep LD_LIBRARY
            LD_LIBRARY_PATH=/opt/oracle/product/10.1.0/db_1/lib/
            [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
            • 3. Re: Dependent module libclntsh.a(shr.o) could not be loaded
              29997
              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.
              • 4. Re: Dependent module libclntsh.a(shr.o) could not be loaded
                29997
                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
                • 5. Re: Dependent module libclntsh.a(shr.o) could not be loaded
                  Jeroen Udo
                  I've made the symbolic link, but the results are still the same. Details of the link:

                  [oracle@mn210 none Bin64/] pwd
                  /opt/oracle/product/10.1.3/bi_1/server/Bin64
                  [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

                  Any suggestions?
                  • 6. Re: Dependent module libclntsh.a(shr.o) could not be loaded
                    29997
                    what about my suggest regarding the 32 bit and 64 bit libraries?
                    • 7. Re: Dependent module libclntsh.a(shr.o) could not be loaded
                      Jeroen Udo
                      Hi Borkur,

                      I've changed the link but the problem remains:

                      [oracle@mn210 none Bin64/] pwd
                      /opt/oracle/product/10.1.3/bi_1/server/Bin64
                      [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?
                      Regards,
                      Jeroen
                      • 8. Re: Dependent module libclntsh.a(shr.o) could not be loaded
                        Jeroen Udo
                        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
                        • 9. Re: Dependent module libclntsh.a(shr.o) could not be loaded
                          607622
                          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.

                          Yan
                          • 10. Re: Dependent module libclntsh.a(shr.o) could not be loaded
                            508457
                            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?

                            Raymond
                            • 11. Re: Dependent module libclntsh.a(shr.o) could not be loaded
                              502745
                              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

                              -----------
                              echo $ORACLE_HOME
                              /oracle/app/oracle/product/10.2.0/db_1

                              echo $LD_LIBRARY_PATH
                              /oracle/app/oracle/product/10.2.0/db_1/lib

                              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!
                              • 12. Re: Dependent module libclntsh.a(shr.o) could not be loaded
                                635997
                                Hello:

                                I came across similar problem and I was able to get it to work successfully. I have documented the steps below.

                                http://oracletechapp.blogspot.com/2008/05/obiee-connectivity-errors.html
                                • 13. Re: Dependent module libclntsh.a(shr.o) could not be loaded
                                  666363
                                  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
                                  • 14. Re: Dependent module libclntsh.a(shr.o) could not be loaded
                                    222793
                                    Hi

                                    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
                                    1 2 Previous Next