Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.