Oracle GoldenGate 12c Installation And Configuration -2

Hi,

I will continue to tell Oracle Goldengate product with this post.

 

You should following first article before this post read.

Oracle GoldenGate 12c Installation And Configuration -1

 

 

You should do following configurations after Goldengate installation.

 

1. First of all we need to create tablespace, user and grant permission for the goldengate user.

CREATE USER GOLDENGATE IDENTIFIED BY gg_123 DEFAULT TABLESPACE GOLDENGATE
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 3 Roles for GOLDENGATE 
GRANT RESOURCE TO GOLDENGATE;
GRANT CONNECT TO GOLDENGATE;
GRANT SELECT_CATALOG_ROLE TO GOLDENGATE;
ALTER USER GOLDENGATE DEFAULT ROLE ALL;
-- 10 System Privileges forGOLDENGATE 
GRANT CREATE SESSION TO GOLDENGATE;
GRANT ALTER SESSION TO GOLDENGATE;
GRANT SELECT ANY DICTIONARY TO GOLDENGATE;
GRANT FLASHBACK ANY TABLE TO GOLDENGATE;
GRANT SELECT ANY TABLE TO GOLDENGATE;
GRANT UNLIMITED TABLESPACE TO GOLDENGATE;
-- 1 Tablespace Quota for GOLDENGATE 
ALTER USER GOLDENGATE QUOTA UNLIMITED ON TSGOLDENGATE;
-- 2 Object Privileges for GOLDENGATE 
GRANT EXECUTE ON SYS.DBMS_FLASHBACK TO GOLDENGATE;
GRANT FLASHBACK ON SYS.USER_SOURCE TO GOLDENGATE;
exec dbms_goldengate_auth.grant_admin_privilege(‘GOLDENGATE’);

 

 

CREATE TABLESPACE goldengate DATAFILE '+DATA' SIZE 10M AUTOEXTEND ON NEXT 1024M MAXSIZE UNLIMITED
LOGGING
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

 

 

 

2. Create same user on ASM instance

[oracle@MehmetSalih admin]$ sqlplus / as sysasm

SQL*Plus: Release 12.2.0.1.0 Production on Wed Aug 1 09:43:07 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> create user GOLDENGATE identified by gg_123;
User Created
SQL> grant sysdba to GOLDENGATE;
User Granted

 

3. Add ASM tns entry to tnsnames.ora file

 

[oracle@MehmetSalih admin]$ cat tnsnames.ora

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = MehmetSalih.DEVECI.local)(PORT = 1521))

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = MehmetSalih.DEVECI.local)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.DEVECI.local)
)
)

ASM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = MehmetSalih.DEVECI.local)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = +ASM)
)
)

 

 

4. Please make sure database in archive log mode

sqlplus / as sysdba
SQL> archive log list;
Database log mode Archive Mode 
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 217747
Next log sequence to archive 217749
Current log sequence 217749

If Database is Noarchive Mode

SQL>shutdown
SQL> startup mount;
Database Mounted

SQL>alter database archivelog;
Database altered.

SQL>alter database open;
Database altered.

 

 

5. Enable Force and Supplemental Log

 

alter database force logging;
Database altered.

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA(PRIMARY KEY) COLUMNS;
Database altered.

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA(UNIQUE) COLUMNS;
Database altered.

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA(FOREIGN KEY) COLUMNS;
Database altered.

6. Enable Goldengate Parameter ( Database 12c Version )

alter system set enable_goldengate_replication=true scope=both;

Database altered.

 

7. Download Oracle GoldenGate from oracle downloads or edelivery.com

http://download.oracle.com/otn/goldengate/12301/123014_fbo_ggs_Linux_x64_shiphome.zip

 

8.  Unzip file and run runinstaller from unzipped directory.

 

cd fbo_ggs_Linux_x64_shiphome/Disk1/

./runInstaller

Install Next option, You just need to select database version.

 

9. Before run goldengate, set environment

[oracle@MEHMETSALIH   goldengate]$ . oraenv

ORACLE_SID = [oracle] ? orcl

The Oracle base has been set to /u01/app/oracle

 

 

I will continue to tell in the next post you can read with following link.

Oracle GoldenGate 12c Installation And Configuration -3

 

 

 

Do you want to learn Oracle Goldengate, then read the following articles.

https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/