Thinking Out Loud

August 3, 2013

Oracle Golden Gate 11.2.1.0.7 on 12c and OEL 6.4 Install

Filed under: 12c,GoldenGate — mdinh @ 6:20 pm

It does not look like the latest version of OGG 11.2.1.0.7 is ready for 12c out of the box.

The workaround is to create soft link to 12c libnnz12.so

oracle@san:cdb01:/u01/app/ggs01
> ggsci

ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory

oracle@san:cdb01:/u01/app/ggs01
> ldd ggsci

        linux-vdso.so.1 =>  (0x00007fff9e5ff000)
        libdl.so.2 => /lib64/libdl.so.2 (0x0000003fd1600000)
        libgglog.so => /u01/app/ggs01/./libgglog.so (0x00007f0cef304000)
        libggrepo.so => /u01/app/ggs01/./libggrepo.so (0x00007f0cef19f000)
        libdb-5.2.so => /u01/app/ggs01/./libdb-5.2.so (0x00007f0ceef04000)
        libicui18n.so.38 => /u01/app/ggs01/./libicui18n.so.38 (0x00007f0ceeba3000)
        libicuuc.so.38 => /u01/app/ggs01/./libicuuc.so.38 (0x00007f0cee86a000)
        libicudata.so.38 => /u01/app/ggs01/./libicudata.so.38 (0x00007f0ced88e000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x0000003fd1e00000)
        libxerces-c.so.28 => /u01/app/ggs01/./libxerces-c.so.28 (0x00007f0ced376000)
        libantlr3c.so => /u01/app/ggs01/./libantlr3c.so (0x00007f0ced260000)
        libnnz11.so => not found
        libclntsh.so.11.1 => /u01/app/oracle/product/12.1.0/dbhome_1/lib/libclntsh.so.11.1 (0x00007f0cea570000)
        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x0000003fdd600000)
        libm.so.6 => /lib64/libm.so.6 (0x0000003fd2200000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x0000003fdd200000)
        libc.so.6 => /lib64/libc.so.6 (0x0000003fd1a00000)
        /lib64/ld-linux-x86-64.so.2 (0x0000003fd1200000)
        libnnz12.so => /u01/app/oracle/product/12.1.0/dbhome_1/lib/libnnz12.so (0x00007f0ce9e58000)
        libons.so => /u01/app/oracle/product/12.1.0/dbhome_1/lib/libons.so (0x00007f0ce9c14000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x0000003fde600000)
        librt.so.1 => /lib64/librt.so.1 (0x0000003fd2600000)
        libaio.so.1 => /lib64/libaio.so.1 (0x00007f0ce9a12000)
        libclntshcore.so.12.1 => /u01/app/oracle/product/12.1.0/dbhome_1/lib/libclntshcore.so.12.1 (0x00007f0ce94c1000)

oracle@san:cdb01:/u01/app/ggs01
> ln -s $ORACLE_HOME/lib/libnnz12.so $GG_HOME/libnnz11.so

oracle@san:cdb01:/u01/app/ggs01
> ldd ggsci

        linux-vdso.so.1 =>  (0x00007fff785ff000)
        libdl.so.2 => /lib64/libdl.so.2 (0x0000003fd1600000)
        libgglog.so => /u01/app/ggs01/./libgglog.so (0x00007f660d37a000)
        libggrepo.so => /u01/app/ggs01/./libggrepo.so (0x00007f660d215000)
        libdb-5.2.so => /u01/app/ggs01/./libdb-5.2.so (0x00007f660cf7a000)
        libicui18n.so.38 => /u01/app/ggs01/./libicui18n.so.38 (0x00007f660cc19000)
        libicuuc.so.38 => /u01/app/ggs01/./libicuuc.so.38 (0x00007f660c8e0000)
        libicudata.so.38 => /u01/app/ggs01/./libicudata.so.38 (0x00007f660b904000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x0000003fd1e00000)
        libxerces-c.so.28 => /u01/app/ggs01/./libxerces-c.so.28 (0x00007f660b3ec000)
        libantlr3c.so => /u01/app/ggs01/./libantlr3c.so (0x00007f660b2d6000)
        libnnz11.so => /u01/app/ggs01/./libnnz11.so (0x00007f660abbf000)
        libclntsh.so.11.1 => /u01/app/oracle/product/12.1.0/dbhome_1/lib/libclntsh.so.11.1 (0x00007f6607ed0000)
        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x0000003fdd600000)
        libm.so.6 => /lib64/libm.so.6 (0x0000003fd2200000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x0000003fdd200000)
        libc.so.6 => /lib64/libc.so.6 (0x0000003fd1a00000)
        /lib64/ld-linux-x86-64.so.2 (0x0000003fd1200000)
        libclntshcore.so.12.1 => /u01/app/oracle/product/12.1.0/dbhome_1/lib/libclntshcore.so.12.1 (0x00007f660797e000)
        libons.so => /u01/app/oracle/product/12.1.0/dbhome_1/lib/libons.so (0x00007f660773a000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x0000003fde600000)
        librt.so.1 => /lib64/librt.so.1 (0x0000003fd2600000)
        libaio.so.1 => /lib64/libaio.so.1 (0x00007f6607538000)

oracle@san:cdb01:/u01/app/ggs01
> ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.7 16934304 OGGCORE_11.2.1.0.7_PLATFORMS_130709.1600.1_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Jul 18 2013 07:04:28
Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.

GGSCI (san.localdomain) 1> dblogin userid ggs@pdb01, password ggs

Successfully logged into database.

GGSCI (san.localdomain) 2> versions

Operating System:
Linux
Version #1 SMP Fri Feb 22 18:16:18 PST 2013, Release 2.6.39-400.17.1.el6uek.x86_64
Node: san.localdomain
Machine: x86_64

Database:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
PL/SQL Release 12.1.0.1.0 - Production
CORE 12.1.0.1.0 Production
TNS for Linux: Version 12.1.0.1.0 - Production
NLSRTL Version 12.1.0.1.0 - Production

GGSCI (san.localdomain) 4> exit
oracle@san:cdb01:/u01/app/ggs01
>

Software Download
OracleLinux-R6-U4-Server-x86_64-dvd.iso
Oracle Database 12c Release 1 (12.1.0.1.0)
p16762459_112107_Linux-x86-64 (OGG 11.2.1.0.7)
Download VirtualBox

About these ads

1 Comment »

  1. oracle@san and You’re still asking me what oracle-fu means ?:)
    Good reading as always Michael .
    Greg

    Comment by Greg — August 4, 2013 @ 10:04 am | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Rubric Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 302 other followers

%d bloggers like this: