8 Replies Latest reply: May 16, 2012 4:27 AM by 902923 RSS

    ggsci fatal error

    902923
      Hi Experts,

      After unzip and untar the GG software im getting the below error message , Please help on this,

      Env Sun os 64 bit

      Oracle DB 11g

      [ggate@gg] # ./ggsci
      ld.so.1: ggsci: fatal: libclntsh.so.11.1: open failed: No such file or directory
      Killed


      binary is ggs_Solaris_sparc_ora11g_64bit.tar

      Thanks
        • 1. Re: ggsci fatal error
          amardeep.sidhu
          Why you are running it from root ?
          • 2. Re: ggsci fatal error
            Kamal_Sharma
            Hi,

            Check if the Sun OS is on Sparc system by using uname -p.

            Make sure you set the ORACLE_HOME & LD_LIBRARY_PATH properly.

            echo $ORACLE_HOME
            echo $ LD_LIBRARY_PATH
            ldd ./ggsci

            Thanks,
            Kamal.
            • 3. Re: ggsci fatal error
              902923
              Hi ,

              I'm not running from root , running from ggate user only


              echo $LD_LIBRARY_PATH
              /lib:/apps/goldengate


              ldd ./ggsci
              libm.so.1 => /lib/sparcv9/libm.so.1
              libnsl.so.1 => /lib/sparcv9/libnsl.so.1
              libdl.so.1 => /lib/sparcv9/libdl.so.1
              librt.so.1 => /lib/sparcv9/librt.so.1
              libumem.so.1 => /lib/sparcv9/libumem.so.1
              libicui18n.so.38 => /apps/goldengate/libicui18n.so.38
              libicuuc.so.38 => /apps/goldengate/libicuuc.so.38
              libicudata.so.38 => /apps/goldengate/libicudata.so.38
              libpthread.so.1 => /lib/sparcv9/libpthread.so.1
              libsocket.so.1 => /lib/sparcv9/libsocket.so.1
              libxerces-c.so.28 => /apps/goldengate/libxerces-c.so.28
              libclntsh.so.11.1 => (file not found)
              libnnz11.so => (file not found)
              libkstat.so.1 => /lib/sparcv9/libkstat.so.1
              libresolv.so.2 => /lib/sparcv9/libresolv.so.2
              libgen.so.1 => /lib/sparcv9/libgen.so.1
              libsched.so.1 => /usr/lib/sparcv9/libsched.so.1
              libCstd.so.1 => /usr/lib/sparcv9/libCstd.so.1
              libCrun.so.1 => /usr/lib/sparcv9/libCrun.so.1
              libthread.so.1 => /lib/sparcv9/libthread.so.1
              libc.so.1 => /lib/sparcv9/libc.so.1
              libmp.so.2 => /lib/64/libmp.so.2
              libmd.so.1 => /lib/64/libmd.so.1
              libscf.so.1 => /lib/64/libscf.so.1
              libaio.so.1 => /lib/64/libaio.so.1
              libdoor.so.1 => /lib/64/libdoor.so.1
              libuutil.so.1 => /lib/64/libuutil.so.1
              libm.so.2 => /lib/64/libm.so.2
              /platform/SUNW,T5240/lib/sparcv9/libc_psr.so.1
              /platform/SUNW,T5240/lib/sparcv9/libmd_psr.so.1


              these libs not found ,

              libclntsh.so.11.1 => (file not found)
              libnnz11.so => (file not found)


              How to resolve this ?

              # ./ggsci
              ld.so.1: ggsci: fatal: libclntsh.so.11.1: open failed: No such file or directory
              Killed





              Thanks,
              • 4. Re: ggsci fatal error
                Kamal_Sharma
                Hi ,

                The LD_LIBRARY_PATH should generally be set to the location where the Oracle Libraries are present i.e $ORACLE_HOME/lib

                Does that /apps/goldengate contain the lib files?

                Please point it to the correct ORACLE_HOME lib directory and then retest it.

                Edit: Please check if these files (libclntsh.so.11.1 & libnnz11.so) are present in ORACLE_HOME lib folder)

                Thanks,
                Kamal

                Edited by: Kamal on May 7, 2012 5:50 AM
                • 5. Re: ggsci fatal error
                  amardeep.sidhu
                  Apart from what Kamal said also verify that ggate user has the permissions to access ORACLE_HOME directory.
                  • 6. Re: ggsci fatal error
                    902923
                    Thanks all,

                    Can you please confirm, the below env set is correct ,

                    export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/apps/goldengate
                    • 7. Re: ggsci fatal error
                      amardeep.sidhu
                      Is your GGSCI working now ?
                      • 8. Re: ggsci fatal error
                        902923
                        No. Still facing the same problem after set the below environment variable,

                        Please help,

                        echo $ORACLE_HOME

                        /data/oracle/product/11.1.0.7

                        export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/apps/goldengate


                        echo $LD_LIBRARY_PATH
                        /data/oracle/product/11.1.0.7/lib:/apps/goldengate

                        ./ggsci
                        ld.so.1: ggsci: fatal: libclntsh.so.11.1: open failed: No such file or directory

                        ldd ggsci

                        => /apps/goldengate/libxerces-c.so.28
                        libclntsh.so.11.1 => (file not found)
                        libnnz11.so => (file not found)






                        please guide me how to resolve this issue