GoldenGate Installation (12c)

Notes

• Based on instruction : <a href="http://docs.oracle.com/goldengate/1212/gg-winux/GIORA.pdf" title="http://docs.oracle.com/goldengate/1212/gg-winux/GIORA.pdf">http://docs.oracle.com/goldengate/1212/gg-winux/GIORA.pdf</a>
• GG source: http://edelivery.oracle.com

Installation

Oracle Universal Installer (OUI)

• Unzip the file as normal with Oracle software that is downloaded

                        cd ~/oracle_binaries unzip ./121200_fbo_ggs_Linux_x64_shiphome.zip

• Run the following command to start the OUI

                        cd ~/fbo_ggs_Linux_x64_shiphome
                        ./runInstaller

• Select the database for the OGG installation: To install Oracle Golden Gate 12c against an 11g database, select the option for Oracle GoldenGate for Oracle Database 11g. If you select the option for Database 12c, the installation will be valid but will not start against an 11g database due to shared libraries needed (libnnz12.so ). Support version for Integrated Replicat is Oracle 11g (11.2.0.4)

• Follow the instructions until dialog box is over

Silent install

• Unzip the file as normal with Oracle software that is downloaded

                        cd ~/oracle_binaries unzip ./121200_fbo_ggs_Linux_x64_shiphome.zip

• Look for the file called oggcore.rsp, which is needed to be edited to contain the items for silent install

                         cd ~/fbo_ggs_Linux_x64_shiphome/Disk1/response 
                         vi oggcore.rsp

• Change the parameters as follows

• Once the response file is filled out, then it can be used with the runInstaller utility (just the same as with other Oracle tools)

• Otherwise, the response file will be used as runInstaller utility

                         ../runInstaller -silent -responseFile /home/oracle/Downloads/ggate/fbo_ggs_Linux_x64_shiphome/Disk1 ./response/oggcore.rsp 

Post Installation

• Create subdirectories using GGSCI tool

                         cd $ORACLE_BASE/product/OGG12 ./ggsci CREATE SUBDIRS EXIT 

If command was executed sucessfully directory listing should appear

                         GGSCI (itrac910.cern.ch) 1> CREATE SUBDIRS

                         Creating subdirectories under current directory /ORA/dbs01/oracle/product/OGG12

                         Parameter files                /ORA/dbs01/oracle/product/OGG12/dirprm: created
                         Report files                   /ORA/dbs01/oracle/product/OGG12/dirrpt: created
                         Checkpoint files               /ORA/dbs01/oracle/product/OGG12/dirchk: created
                         Process status files           /ORA/dbs01/oracle/product/OGG12/dirpcs: created
                         SQL script files               /ORA/dbs01/oracle/product/OGG12/dirsql: created
                         Database definitions files     /ORA/dbs01/oracle/product/OGG12/dirdef: created
                         Extract data files             /ORA/dbs01/oracle/product/OGG12/dirdat: created
                         Temporary files                /ORA/dbs01/oracle/product/OGG12/dirtmp: created
                         Stdout files                   /ORA/dbs01/oracle/product/OGG12/dirout: created

Preparing Databases

--ONLY ON SOURCE DB. Check supplemental logging is enabled and change the state if it is needed

                         SELECT SUPPLEMENTAL_LOG_DATA_MIN, FORCE_LOGGING FROM V$DATABASE;

--If it is needed, to do

                          ALTER DATABASE ADD SUPPLEMENTAL LOG DATA SCOPE=BOTH SID='*'; 
                          ALTER DATABASE FORCE LOGGING;

--Needed on both databases (enables integrated extract and replicat)

                        ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION=TRUE;

--Tablespaces. Introduce the values 50M(INITSIZE)/1G(NEXTSIZE)/100G(MAXSIZE)

                       CREATE BIGFILE TABLESPACE _<&TS_DATA>_ DATAFILE SIZE <&INITSIZE> AUTOEXTEND ON NEXT <&NEXTSIZE> MAXSIZE <&MAXSIZE> EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;

Creation Users

• Creation schema GGADMIN

                       CREATE USER GGADMIN IDENTIFIED BY _<&password>_ DEFAULT TABLESPACE <&tablespace> TEMPORARY TABLESPACE TEMP;

--To give privileges related to create Checkpoint table

                        GRANT CONNECT TO _GGADMIN_ ; GRANT CREATE TABLE TO _GGADMIN_ ; 

--Give quota to the user's allocated space on the tablespace

                        ALTER USER GGADMIN QUOTA 1000M ON _<&tablespace>_;

--On the source and target database in one add full privs exec

                        EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE('GGADMIN');

-- For source only

                        EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE('GGADMIN','CAPTURE'); 

-- For target database only

                        EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE('APPLY');

--Some privileges needed to the GGADMIN

                         GRANT select on sys."_DBA_APPLY_PROGRESS" to _GGADMIN_ ; 
                         GRANT ALTER ANY INDEX to _GGADMIN_ ; 
                         GRANT ALTER ANY MATERIALIZED VIEW to _GGADMIN_ ; 
                         GRANT ALTER ANY PROCEDURE to _GGADMIN_ ; 
                         GRANT ALTER ANY SEQUENCE to _GGADMIN_ ; 
                         GRANT ALTER ANY TABLE to _GGADMIN_ ; 
                         GRANT CREATE ANY INDEX to _GGADMIN_ ; 
                         GRANT CREATE ANY MATERIALIZED VIEW to _GGADMIN_ ; 
                         GRANT CREATE ANY PROCEDURE to _GGADMIN_ ; 
                         GRANT CREATE ANY SEQUENCE to _GGADMIN_ ; 
                         GRANT CREATE ANY SYNONYM to _GGADMIN_ ; 
                         GRANT CREATE ANY TABLE to _GGADMIN_ ; 
                         GRANT CREATE ANY VIEW to _GGADMIN_ ; 
                         GRANT DELETE ANY TABLE to _GGADMIN_ ; 
                         GRANT DROP ANY INDEX to _GGADMIN_ ; 
                         GRANT DROP ANY MATERIALIZED VIEW to _GGADMIN_ ; 
                         GRANT DROP ANY PROCEDURE to _GGADMIN_ ; 
                         GRANT DROP ANY SEQUENCE to _GGADMIN_ ; 
                         GRANT DROP ANY SYNONYM to _GGADMIN_ ; 
                         GRANT DROP ANY TABLE to _GGADMIN_ ; 
                         GRANT DROP ANY VIEW to _GGADMIN_ ; 
                         GRANT EXECUTE ANY PROCEDURE to _GGADMIN_ ; 
                         GRANT INSERT ANY TABLE to _GGADMIN_ ; 
                         GRANT SELECT ANY SEQUENCE to _GGADMIN_ ; 
                         GRANT SELECT ANY TABLE to _GGADMIN_ ; 
                         GRANT UPDATE ANY TABLE to _GGADMIN_ ;

--The DDL scripts are not needed in OGG 12c and 11.2.0.4 due to Integrated extract

• Creation GGUSER

                         CREATE BIGFILE TABLESPACE _&TS_DATA_ DATAFILE SIZE _&INITSIZE_ AUTOEXTEND ON NEXT &NEXTSIZE MAXSIZE _&MAXSIZE_ EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;

--Create schema to be replicated (GGUSER test schema as example.It is better if ggadmin and gguser are in different tablespace)

                         CREATE USER GGUSER IDENTIFIED BY _&password_ DEFAULT TABLESPACE _&tablespace_ TEMPORARY TABLESPACE TEMP;

-- To give Grants to the user

                         GRANT CREATE SESSION, CREATE TABLE TO _GGUSER_; GRANT CONNECT, RESOURCE TO _GGUSER_;
                         CREATE USER GGUSER IDENTIFIED BY _&password_ DEFAULT TABLESPACE _&tablespace_ TEMPORARY TABLESPACE TEMP;

--Give quota to the user's allocated space on the tablespace

                         ALTER USER "GGUSER" QUOTA 1000M ON _&tablespace_;

Set up environment

Notes

• Execute always "rlwrap ./ggsci" for accesing to GoldenGate environment in order to save all the previous commands executed
• Always make sure being logged into database before doing any creation/registration/deletion/unregistration operation
• To specify the checkpoint table in the Oracle GoldenGate configuration

                                    EDIT PARAMS ./GLOBALS
                                    --add following line modifying default values for parameters
CHECKPOINTTABLE _[container.]schema.table_   -- save the file and exit

Manager process (Source and Target)

• Edit parameter and start the process (if it was not specified during the installation)

EDIT PARAMS MGR
--add following line modifying default values for parameters
PORT _<port>_
AUTORESTART ER *,RETRIES 3, WAITMINUTES 4
AUTOSTART ER *
PURGEOLDEXTRACTS *, USECHECKPOINTS, MINKEEPDAYS 15
-- save the file and exit

• Start Manager process

START MANAGER

Extract process (Source)

• Make sure being logged into database

                                    dblogin _<ggadmin@database>_, password *****

• Edit parameter

EDIT PARAMS _<name_extract>_
--add following line modifying default values for parameters

EXTRACT _<name_extract>_
USERID _<ggadmin@database>_, PASSWORD *************
TRANLOGOPTIONS INTEGRATEDPARAMS (max_sga_size 200, parallelism 1,_CHECKPOINT_FREQUENCY 1000)
TRANLOGOPTIONS checkpointretentiontime 1
--SOURCECATALOG _<database>_
comment DDL INCLUDE MAPPED
DDL INCLUDE OBJNAME _<schema_to_be_replicated>._*
DDLOPTIONS REPORT
LOGALLSUPCOLS
EXTTRAIL </trail_files_path/TT>_
TABLE _<schema_to_be_replicated>._*;

 -- save the file and exit

• Add the Extract group

 ADD EXTRACT<name_extract>, INTEGRATED TRANLOG, BEGIN NOW

• Add the trail files path and associate with the extract

ADD EXTTRAIL </trail_files_path/TT>, EXTRACT _<name_extract>_

• Register the extract process into the database (Make sure being correctly logged to use the parameter "database")

REGISTER  EXTRACT <name_extract> DATABASE

• Start Extract process

START  _<name_extract>_ 

Data Pump process (Source)

• Make sure being logged into database

                                     dblogin _<ggadmin@database>_, password *****

• Edit parameter

EDIT PARAMS <name_datapump>
--add following line modifying default values for parameters

EXTRACT <name_datapump>
USERID _<ggadmin@database>_, PASSWORD *************
rmthost <remote_name_host>, mgrport _<port>_
rmttrail </remote_trail_files_path/zz>
discardfile ./dirrpt/name_file.dsc, PURGE, MEGABYTES 500
PASSTHRU
TABLE _<schema_to_be_replicated>_.*;

 -- save the file and exit

• Add the Data Pump process

ADD EXTRACT<name_datapump>, EXTTRAILSOURCE</trail_files_path/TT>

• Add the trail files REMOTE path and associate with the data pump process

ADD RMTTRAIL </remote_trail_files_path/zz>, EXTRACT <name_datapump>

• Start Extract process

START   <name_datapump>

Replicat process (Target)

• Make sure being logged into database

                                     dblogin userid _<ggadmin@database>_, password *****

• Edit parameter

EDIT PARAMS _<name_replicat>_
--add following line modifying default values for parameters

REPLICAT _<name_replicat>_
DBOPTIONS LIMITROWS, INTEGRATEDPARAMS(parallelism 6, max_parallelism 6)
USERID _<ggadmin@database>_, PASSWORD *************
NODISCARDFILE
ASSUMETARGETDEFS
DDL INCLUDE MAPPED
BATCHSQL
MAP _<schema_to_be_replicated>_.*, TARGET<schema_to_be_replicated>.*;

-- save the file and exit

• Add the Replicat group

 ADD REPLICAT<name_replicat>, EXTTRAIL _</trail_files_path/TT>_ , BEGIN NOW

• Register the Replicat process into the database (Make sure being correctly logged to use the parameter "database")

REGISTER  REPLICAT _<name_replicat>_ DATABASE

• Start Replicat process

START  _<name_replicat>_