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.

 

 

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.

 

 

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

 

 

Mehmet Salih Deveci

I am Founder of IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com.-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

One thought on “Oracle GoldenGate 12c Installation And Configuration -2

Leave a Reply

Your email address will not be published. Required fields are marked *