Sunday, 6 December 2015

12c Golden gate installation steps.

:=  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

work on autovacuum postgreSQL parameter

 In This blog, we are discussing the auto vacuum parameter on a small scale. we will understand the below parameters and will see how to mod...