Differences

This shows you the differences between two versions of the page.

--- oracle_12_goldengate_conf_prepare_source [2020/10/27 12:32] – andonovj
+++ oracle_12_goldengate_conf_prepare_source [2020/11/09 19:50] (current) – andonovj
@@ Line 18: / Line 18: @@
 So let's get started. You can set supplemental logging in Oracle database in three levels:
-  * Database Level
 <Code:bash|Database Level>
 SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
@@ Line 24: / Line 23: @@
 </Code>
-  * Schema Level
 <Code:bash|Schema Level>
 GGSCI> ADD SCHEMATRANDATA schema [ALLCOLS|NOSCHEDULINGCOLS]
 </Code>
-  * Table Level
 <Code:bash|Table Level>
 GGSCI> ADD TRANDATA [container.]schema.table[ALLCOLS|NOSCHEDULINGCOLS]
@@ Line 156: / Line 153: @@
 Successfully logged into database.
+---Add the Classical Extract
 GGSCI (sourceSRV.izb.local as ggate@DBNAME) 2> add extract EBKEXT1, TRANLOG, BEGIN NOW
 EXTRACT added.
+---Create Local Trail and associate it with the Classical Extract
 GGSCI (sourceSRV.izb.local as ggate@DBNAME) 5> add exttrail ./dirdat/lt, EXTRACT EBKEXT1
 EXTTRAIL added.
+---Create Data Pump process and associate it with the local trail
 GGSCI (sourceSRV.izb.local as ggate@DBNAME) 6> add EXTRACT EBKDMP1, EXTTRAILSOURCE ./dirdat/lt
 EXTRACT added.
+---Add Remote trail and associate it with the Data pump process
 GGSCI (sourceSRV.izb.local as ggate@DBNAME) 7> add RMTTRAIL ./dirdat/rt, EXTRACT EBKDMP1
 RMTTRAIL added.
+---Add Supplemental logging for the schema
 GGSCI (sourceSRV.izb.local as ggate@DBNAME) 8> ADD SCHEMATRANDATA SCHEMANAME1   <- Schema name
@@ Line 182: / Line 183: @@
 *****************************************************************************************
+---Add supplemental logging for 2nd schema
 GGSCI (sourceSRV.izb.local as ggate@DBNAME) 9> add schematrandata SCHEMANAME2
@@ Line 235: / Line 236: @@
 Wait them for couple minutes, to assure that they will not end abnormally (ABEND)
-=====Configure Credential Wallet(Optional)=====
-Credential wallet is a store which contains credentials. The logic behind it, is to facilitate the dblogin operations by not exposing the password:
-To create and configure the wallet follow the steps:
-<Code:bash|Create & Configure wallet>
-[oracle@edvmr1p0 oggtrg]$ ./ggsci
-Oracle GoldenGate Command Interpreter for Oracle
-Version 12.3.0.1.0 OGGCORE_12.3.0.1.0_PLATFORMS_170721.0154_FBO
-Linux, x64, 64bit (optimized), Oracle 12c on Jul 21 2017 23:31:13
-Operating system character set identified as UTF-8.
-Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.
-GGSCI (edvmr1p0) 1> Create Wallet
-Created wallet at location 'dirwlt'.
-Opened wallet at location 'dirwlt'.
-GGSCI (edvmr1p0) 2> Add CredentialStore
-Credential store created in /u01/ogg/oggtrg/dircrd/.
-GGSCI (edvmr1p0) 3> alter CredentialStore Add User c##OGG_Admin@amer Password oracle_4U Alias oggadmin_amer
-Credential store in /u01/ogg/oggtrg/dircrd/ altered.
-GGSCI (edvmr1p0) 4> alter CredentialStore Add User c##OGG_Admin@euro Password oracle_4U Alias oggadmin_euro
-Credential store in /u01/ogg/oggtrg/dircrd/ altered.
-GGSCI (edvmr1p0) 5> alter CredentialStore Add User c##OGG_Admin Password oracle_4U Alias oggadmin_root
-Credential store in /u01/ogg/oggtrg/dircrd/ altered.
-GGSCI (edvmr1p0) 6> info CredentialStore
-Reading from /u01/ogg/oggtrg/dircrd/:
-Default domain: OracleGoldenGate
-  Alias: oggadmin_euro
-  Userid: c##OGG_Admin@euro
-  Alias: oggadmin_amer
-  Userid: c##OGG_Admin@amer
-  Alias: oggadmin_root
-  Userid: c##OGG_Admin
-GGSCI (edvmr1p0) 7> DBLogin UserIDAlias oggadmin_amer
-Successfully logged into database AMER.
-GGSCI (edvmr1p0 as c##OGG_Admin@orcl/AMER) 8> DBLogin UserIDAlias oggadmin_euro
-Successfully logged into database EURO.
-GGSCI (edvmr1p0 as c##OGG_Admin@orcl/EURO) 9>
-</Code>