GoldenGate ggsci command failed with error while loading shared libraries: libnnz12.so, libons.so, libclntsh.so.12.1, libclntshcore.so.12.1

advertisements

_____________________________________________________________________________________________________________________

Error Description

GoldenGate ggsci command invoke failed with following error message.

[oracle@Node 1 goga]$ ./ggsci
./ggsci: error while loading shared libraries: libnnz12.so: cannot open shared object file: No such file or directory
[oracle@Node 1 goga]$ ./ggsci
./ggsci: error while loading shared libraries: libons.so: cannot open shared object file: No such file or directory

[oracle@Node 1 goga]$ ./ggsci
./ggsci: error while loading shared libraries: libclntsh.so.12.1: cannot open shared object file: No such file or directory
[oracle@Node 1 goga]$ ./ggsci
./ggsci: error while loading shared libraries: libclntshcore.so.12.1: cannot open shared object file: No such file or directory

Solution Description 

Go to the GoldenGate installation directory execute ldd ggsci command. This command will list out the shared library files associated with ggsci command. Check for the missing libraries with not found message against each file.

[oracle@Node 1 goga]$ ldd ggsci
        linux-vdso.so.1 =>  (0x00007fffac7cb000)
        librt.so.1 => /lib64/librt.so.1 (0x00007f3fedbd9000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f3fed9d4000)
        libgglog.so => /u02/goga/./libgglog.so (0x00007f3fed5b0000)
        libggrepo.so => /u02/goga/./libggrepo.so (0x00007f3fed33e000)
        libdb-6.1.so => /u02/goga/./libdb-6.1.so (0x00007f3fecf59000)
        libggperf.so => /u02/goga/./libggperf.so (0x00007f3fecd29000)
        libggparam.so => /u02/goga/./libggparam.so (0x00007f3febc1f000)
        libicui18n.so.48 => /u02/goga/./libicui18n.so.48 (0x00007f3feb82f000)
        libicuuc.so.48 => /u02/goga/./libicuuc.so.48 (0x00007f3feb4ae000)
        libicudata.so.48 => /u02/goga/./libicudata.so.48 (0x00007f3fe9ce9000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f3fe9acc000)
        libxerces-c.so.28 => /u02/goga/./libxerces-c.so.28 (0x00007f3fe9506000)
        libantlr3c.so => /u02/goga/./libantlr3c.so (0x00007f3fe92ed000)
        libnnz12.so => not found
        libclntsh.so.12.1 => not found
        libons.so => not found
        libclntshcore.so.12.1 => not found
        libggnnzitp.so => /u02/goga/./libggnnzitp.so (0x00007f3fe880d000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f3fe850b000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f3fe8148000)
        /lib64/ld-linux-x86-64.so.2 (0x00007f3feddea000)
        libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f3fe7e3f000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f3fe7c28000)

advertisements

 

Now find out the corresponding library files in the server. Most of them will be available in the ORACLE HOME/lib directory. Create soft link for this file from GoldenGate home to ORACLE_HOME/lib directory.

[oracle@Node 1 goga]$ cd $ORACLE_HOME/lib/
[oracle@Node 1 lib]$ ls -tlr libnnz12.so
-rwxr-xr-x 1 oracle oinstall 6318657 Aug  1 02:08 libnnz12.so
[oracle@Node 1 lib]$ cd -
/u02/goga
[oracle@Node 1 goga]$ ln -s $ORACLE_HOME/lib/libnnz12.so libnnz12.so
[oracle@Node 1 goga]$ pwd
/u02/goga

[oracle@Node 1 goga]$ ln -s $ORACLE_HOME/lib/libclntsh.so.12.1 libclntsh.so.12.1
[oracle@Node 1 goga]$ ln -s $ORACLE_HOME/lib/libons.so libons.so
[oracle@Node 1 goga]$ ln -s $ORACLE_HOME/lib/libclntshcore.so.12.1 libclntshcore.so.12.1

Now invoke the GoldenGate ggsci

$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.


Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

_____________________________________________________________________________________________________________________

Website Stats