OGG upgrade runs ggsic newspaper Unable to find library & # 39. Libclntsh.so.11.1
Our system is Oracle 10.2.0.5 for hp-ux ia64 11.31 established in 2009. At present, we need to create number verification. After successful docking, the old system is abolished, and the synchronous replication software used is Oracle Goldengate. Because Oracle Goldengate 12C does not support Oracle Database 10g, we can only use Oracle Goldengate 11g. Add mgr on the source end, after the extraction and delivery process, start the extraction process and stop reporting the error 5 minutes.
2016-08-17 16:40:57 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, ext07cb.prm: error 9 (Bad file number) positioning into log, rba 174680064.
2016-08-17 16:58:36 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, ext07cb.prm: Error validating file info for sequence 43907 because of an inval
Id thread ID (2)
Can only upgrade to Version 11.2.1.0.6, upgrade package is really difficult to find. I almost chose Shareplex of Quest company as synchronization software. It is relatively easy to upgrade Ogg. Package the original ogg directory without deleting the original directory and decompress the upgrade package directly to the original directory.
However, an error occurred when logging in to the Ogg management side using ggsci:
Essdb3_ Oracle [/ orabak01/ogg] $ggsci
/ usr/lib/hpux64/dld.so: Unable to find library 'libclntsh.so.11.1'. Killed
It feels like it's caused by the lack of some lib library file. You can use the ldd command to view (ldd is just a shell, not a program. Ldd is used to determine what dynamic library an executable binary file contains)
Essdb5_ Oracle [/ home/oracle] $cd / orabak01/ogg
Essdb5_ Oracle [/ orabak01/ogg] $ldd ggsci
Libm.so.1 = > / usr/lib/hpux64/libm.so.1
Librt.so.1 = > / usr/lib/hpux64/librt.so.1
Libgglog.sl = > / orabak01/ogg/libgglog.sl
Libggrepo.sl = > / orabak01/ogg/libggrepo.sl
Libdb-5.2.so = > / orabak01/ogg/libdb-5.2.so
Libicui18n.sl.38 = > / orabak01/ogg/libicui18n.sl.38
Libicuuc.sl.38 = > / orabak01/ogg/libicuuc.sl.38
Libicudata.sl.38 = > / orabak01/ogg/libicudata.sl.38
Libpthread.so.1 = > / usr/lib/hpux64/libpthread.so.1
Libxerces-c.so.28 = > / orabak01/ogg/libxerces-c.so.28
Libantlr3c.so = > / orabak01/ogg/libantlr3c.so
Libclntsh.so.11.1 = > / oracle/product/10.2/database/lib/libclntsh.so.11.1
Unable to find library 'libnnz11.so'.
Essdb5_ Oracle [/ orabak01/ogg] $cd $ORACLE_HOME/lib
Essdb5_ Oracle [/ oracle/product/10.2/database/lib] $ls-ald libnnz*
-rw-r--r-- 1 oracle oinstall 16907362 April 22, 2008 libnnz10.a
-r-xr-xr-x 1 oracle oinstall 5337112 April 22, 2008 libnnz10.so
Essdb5_ Oracle [/ oracle/product/10.2/database/lib] $ln-s $ORACLE_HOME/lib/libnnz10.so libnnz11.so
Essdb5_ Oracle [/ orabak01/ogg] $cd $ORACLE_HOME/lib
Essdb5_ Oracle [/ oracle/product/10.2/database/lib] $ls-ald libclntsh.so*
Lrwxr-xr-x 1 oracle oinstall 17 December 19, 2009 libclntsh.so-> libclntsh.so.10.1
-rwxr-xr-x 1 oracle oinstall 36877216 December 19, 2009 libclntsh.so.10.1
Essdb5_ Oracle [/ oracle/product/10.2/database/lib] $ln-s $ORACLE_HOME/lib/libclntsh.so.10.1 libclntsh.so.11.1
Essdb5_ Oracle [/ oracle/product/10.2/database/lib] $cd / orabak01/ogg
Essdb5_ Oracle [/ orabak01/ogg] $ldd ggsci
Libm.so.1 = > / usr/lib/hpux64/libm.so.1
Librt.so.1 = > / usr/lib/hpux64/librt.so.1
Libgglog.sl = > / orabak01/ogg/libgglog.sl
Libggrepo.sl = > / orabak01/ogg/libggrepo.sl
Libdb-5.2.so = > / orabak01/ogg/libdb-5.2.so
Libicui18n.sl.38 = > / orabak01/ogg/libicui18n.sl.38
Libicuuc.sl.38 = > / orabak01/ogg/libicuuc.sl.38
Libicudata.sl.38 = > / orabak01/ogg/libicudata.sl.38
Libpthread.so.1 = > / usr/lib/hpux64/libpthread.so.1
Libxerces-c.so.28 = > / orabak01/ogg/libxerces-c.so.28
Libantlr3c.so = > / orabak01/ogg/libantlr3c.so
Libclntsh.so.11.1 = > / oracle/product/10.2/database/lib/libclntsh.so.11.1
Libnnz11.so = > / oracle/product/10.2/database/lib/libnnz11.so
Libdl.so.1 = > / usr/lib/hpux64/libdl.so.1
Libnsl.so.1 = > / usr/lib/hpux64/libnsl.so.1
Libunwind.so.1 = > / usr/lib/hpux64/libunwind.so.1
Libstd_v2.so.1 = > / usr/lib/hpux64/libstd_v2.so.1
LibCsup.so.1 = > / usr/lib/hpux64/libCsup.so.1
Libc.so.1 = > / usr/lib/hpux64/libc.so.1
Libpthread.so.1 = > / usr/lib/hpux64/libpthread.so.1
Libc.so.1 = > / usr/lib/hpux64/libc.so.1
Libicuuc.sl.38 = > / orabak01/ogg/libicuuc.sl.38
Libicudata.sl.38 = > / orabak01/ogg/libicudata.sl.38
Libpthread.so.1 = > / usr/lib/hpux64/libpthread.so.1
Libpthread.so.1 = > / usr/lib/hpux64/libpthread.so.1
Libpthread.so.1 = > / usr/lib/hpux64/libpthread.so.1
Libnsl.so.1 = > / usr/lib/hpux64/libnsl.so.1
Libicuuc.sl.38 = > / orabak01/ogg/libicuuc.sl.38
Libicudata.sl.38 = > / orabak01/ogg/libicudata.sl.38
Libnnz10.so = > / oracle/product/10.2/database/lib/libnnz10.so
Librt.so.1 = > / usr/lib/hpux64/librt.so.1
Libnss_dns.so.1 = > / usr/lib/hpux64/libnss_dns.so.1
Libdl.so.1 = > / usr/lib/hpux64/libdl.so.1
Libm.so.1 = > / usr/lib/hpux64/libm.so.1
Libpthread.so.1 = > / usr/lib/hpux64/libpthread.so.1
Libunwind.so.1 = > / usr/lib/hpux64/libunwind.so.1
Libnsl.so.1 = > / usr/lib/hpux64/libnsl.so.1
Libc.so.1 = > / usr/lib/hpux64/libc.so.1
Libxti.so.1 = > / usr/lib/hpux64/libxti.so.1
Libuca.so.1 = > / usr/lib/hpux64/libuca.so.1
Libdl.so.1 = > / usr/lib/hpux64/libdl.so.1
Essdb5_ Oracle [/ orabak01/ogg] $ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.6 16211226 OGGCORE_11.2.1.0.6_PLATFORMS_130418.1829
HP/UX, IA64, 64bit (optimized), Oracle 11g on Apr 18 2013 20:29:17
Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.
Summary: Oracle 0gg requires a minimum of 11.2.1.0.6 for bug on the HP-ia64 bare device platform. The Symantec VXVM file system used in another system does not have such bug. Record it.
