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.
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.
Do you want to learn Oracle Goldengate, then read the following articles.
https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/