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

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)
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.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google