:= 12c Golden
gate installation for 11g Database.
Operating system details:
[oracle@localhost ~]$ cat
/etc/redhat-release
Red Hat Enterprise Linux
Server release 6.4 (Santiago)
Database version details:
SQL> select * from
v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g
Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 -
Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version
11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 -
Production
Golden gate version details:
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.0
OGGCORE_12.2.0.1.0_PLATFORMS_151101.1925.2_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Nov 11 2015
01:38:14
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All
rights reserved.
1)Create directory structure and user for goleden gate.
[gg_user@localhost ~]$ mkdir –p /u01/app/oracle/product/12.1.0.1/db_1/11.2.0/db_1
[gg_user@localhost ~]$ mkdir –p /u01/app/gg_user/product/12.1.2/oggcore_1
2)Got to golden gate s/w folder
[gg_user@localhost Disk1]$ ls -ltr
total 16
drwxr-xr-x. 4 gg_user oinstall 4096 Nov 11 21:05 install
drwxr-xr-x. 11 gg_user oinstall 4096 Nov 11 21:05 stage
-rwxr-xr-x. 1 gg_user oinstall 918 Nov 11 21:05 runInstaller
drwxrwxr-x. 2 gg_user oinstall 4096 Nov 11 21:05 response
[gg_user@localhost Disk1]$ ./runInstaller
Note: To install Oracle Golden Gate 12c for 11g database,
select Oracle GoldenGate for Oracle Database 11g. If you select
oracle database 11g option, the installation will be valid but will not start
against an 11g database due to shared libraries: libnnz11.so file and
libclntsh.so.11.1.
Solution:
[gg_user@localhost
oggcore_1]$ ln -s /u01/app/oracle/product/12.1.0.1/db_1/11.2.0/db_1/lib/libnnz11.so
libnnz11.so
[gg_user@localhost
oggcore_1]$ ln -s
/u01/app/oracle/product/12.1.0.1/db_1/11.2.0/db_1/lib/libclntsh.so.11.1
libclntsh.so.11.1
[gg_user@localhost]$cd /u01/app/gg_user/product/12.1.2/oggcore_1
[gg_user@localhost oggcore_1]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.0
OGGCORE_12.2.0.1.0_PLATFORMS_151101.1925.2_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Nov 11 2015
01:38:14
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All
rights reserved.
GGSCI (localhost.localdomain) 1> info all
Program
Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (localhost.localdomain) 2>
********END*********
No comments:
Post a Comment