OBEY

Scripts are available in cURL and as OBEY commands to be run in Admin Client, to test the business reporting scenario. You can use the scripts available in the following topics to:

  • Add a data replication environment and view the processes that are created after the scripts runs successfully.

  • Check the statistical reports for Daily, Hourly, and Total committed DML and DDL operations.

  • Delete the data replication environment and verify that the environment was deleted after testing.

Bidirectional Configuration Using OBEY Files

Copy and use the following OBEY script to set up Oracle GoldenGate data replication environment on an pre-installed database.

Note:

The given sample script uses names and values of database server, parameter values, Extract, Replicat, and other processes. You must change these values according to your environment for this script to work. 

CONNECT https://north:9001 DEPLOYMENT depl_north AS ggma PASSWORD GGma_23ai !
ALTER CREDENTIALSTORE ADD USER ggadmin@dbnorth ALIAS ggnorth DOMAIN OracleGoldenGate PASSWORD ggadmin
INFO  CREDENTIALSTORE

CONNECT https://south:9101 DEPLOYMENT depl_south AS ggma PASSWORD GGma_23ai !
ALTER CREDENTIALSTORE ADD USER ggadmin@dbsouth ALIAS ggsouth DOMAIN OracleGoldenGate PASSWORD ggadmin
INFO  CREDENTIALSTORE

CONNECT https://north:9001 DEPLOYMENT depl_north AS ggma PASSWORD GGma_23ai !
DBLOGIN USERIDALIAS ggnorth DOMAIN OracleGoldenGate
ADD SCHEMATRANDATA hr
ADD CHECKPOINTTABLE ggadmin.ggs_checkpointtable
ADD HEARTBEATTABLE

CONNECT https://south:9101 DEPLOYMENT depl_south AS ggma PASSWORD GGma_23ai !
DBLOGIN USERIDALIAS ggsouth DOMAIN OracleGoldenGate
ADD SCHEMATRANDATA hr
ADD CHECKPOINTTABLE ggadmin.ggs_checkpointtable
ADD HEARTBEATTABLE

CONNECT https://north:9001 DEPLOYMENT depl_north AS ggma PASSWORD GGma_23ai !
DBLOGIN USERIDALIAS ggnorth DOMAIN OracleGoldenGate

ADD EXTRACT extn INTEGRATED TRANLOG BEGIN NOW 
REGISTER EXTRACT extn database
ADD EXTTRAIL north/ea, EXTRACT extn
START EXTRACT extn

ADD DISTPATH dpns SOURCE trail://north:9002/services/v2/sources?trail=north/ea TARGET wss://south:9103/services/v2/targets?trail=north/da !
START DISTPATH dpns

ADD REPLICAT reps, PARALLEL, EXTTRAIL south/da, CHECKPOINTTABLE ggadmin.ggs_checkpointtable
START REPLICAT reps

INFO ALL
INFO DISTPATH ALL

CONNECT https://south:9101 DEPLOYMENT depl_south AS ggma PASSWORD GGma_23ai !
DBLOGIN USERIDALIAS ggsouth DOMAIN OracleGoldenGate

ADD EXTRACT exts INTEGRATED TRANLOG BEGIN NOW
REGISTER EXTRACT exts database
ADD EXTTRAIL south/ea, EXTRACT exts
START EXTS

ADD DISTPATH dpsn SOURCE trail://south:9102/services/v2/sources?trail=south/ea TARGET wss://north:9103/services/v2/targets?trail=south/da !
START DISTPATH dpsn

ADD   REPLICAT repn, PARALLEL, EXTTRAIL north/da, CHECKPOINTTABLE ggadmin.ggs_checkpointtable
START REPLICAT repn

INFO ALL
INFO DISTPATH ALL

DISCONNECT
After creating the OBEY file, create a shell script to run in Admin Client. This script runs triggers the bidirectional replication setup using the .oby file:
#!/bin/bash

# Clean up environment
/home/oracle/scripts/misc/cleanup.sh > /dev/null

# Copy parameter file (usually edited with EDIT PARAMs)
cp EXTN.prm  /u01/app/oracle/deployments/depl_north/etc/conf/ogg/
cp REPS.prm  /u01/app/oracle/deployments/depl_north/etc/conf/ogg/

cp EXTS.prm  /u01/app/oracle/deployments/depl_north/etc/conf/ogg/
cp REPN.prm  /u01/app/oracle/deployments/depl_south/etc/conf/ogg/

# Run the GoldenGate Obey script
echo "obey add_replication_ActiveActive.oby" | adminclient | tee  add_replication_ActiveActive.log

Check the Processes in the Bidirectional Environment Using OBEY Files

Note:

The given sample script uses names and values of database server, parameter values, Extract, Replicat, and other processes. You must change these values according to your environment for this script to work. 
--
-- Connect the GoldenGate Deployment depl_north
--
CONNECT https://north:9001 DEPLOYMENT depl_north AS ggma PASSWORD GGma_23ai !

INFO  EXTRACT extn
SEND  EXTRACT extn, GETLAG
STATS EXTRACT extn, TOTAL, TOTALSONLY *.*

INFO DISTPATH  DPNS
STATS DISTPATH DPNS

INFO  REPLICAT reps
SEND  REPLICAT reps, GETLAG
STATS REPLICAT reps, TOTAL, TOTALSONLY *.*

--
-- Connect the GoldenGate Deployment depl_south
--

CONNECT https://south:9101 DEPLOYMENT depl_south AS ggma PASSWORD GGma_23ai !

INFO  EXTRACT exts
SEND  EXTRACT exts, GETLAG
STATS EXTRACT exts, TOTAL, TOTALSONLY *.*

INFO  DISTPATH DPSN
STATS DISTPATH DPSN

INFO  REPLICAT repn
SEND  REPLICAT repn, GETLAG
STATS REPLICAT repn, TOTAL, TOTALSONLY *.*

DISCONNECT
After creating the OBEY file, create a shell script to run in Admin Client:
echo "obey check_replication_ActiveActive.oby" | adminclient

Remove the Bidirectional Replication Environment Using OBEY Files

Note:

The given sample script uses names and values of database server, parameter values, Extract, Replicat, and other processes. You must change these values according to your environment for this script to work. 

CONNECT https://north:9001 DEPLOYMENT depl_north AS ggma PASSWORD GGma_23ai !
DBLOGIN USERIDALIAS ggnorth DOMAIN OracleGoldenGate

KILL   EXTRACT  extn
DELETE EXTRACT  extn
PURGE  EXTTRAIL north/ea

STOP   DISTPATH dpns
DELETE DISTPATH dpns
PURGE  EXTTRAIL south/da

KILL   REPLICAT reps
DELETE REPLICAT reps

INFO ALL
INFO DISTPATH ALL

DELETE SCHEMATRANDATA hr
DELETE CHECKPOINTTABLE ggadmin.ggs_checkpointtable !
DELETE HEARTBEATTABLE !

ALTER CREDENTIALSTORE DELETE USER ggadmin@dbnorth ALIAS ggnorth DOMAIN OracleGoldenGate
INFO CREDENTIALSTORE

CONNECT https://south:9101 DEPLOYMENT depl_south AS ggma PASSWORD GGma_23ai !
DBLOGIN USERIDALIAS ggsouth DOMAIN OracleGoldenGate

KILL   EXTRACT  exts
DELETE EXTRACT  exts
PURGE  EXTTRAIL south/ea

STOP   DISTPATH dpsn
DELETE DISTPATH dpsn
PURGE  EXTTRAIL north/da

KILL   REPLICAT repn
DELETE REPLICAT repn

INFO ALL
INFO DISTPATH ALL

DELETE SCHEMATRANDATA hr 
DELETE CHECKPOINTTABLE ggadmin.ggs_checkpointtable !
DELETE HEARTBEATTABLE !

ALTER CREDENTIALSTORE DELETE USER ggadmin@dbsouth ALIAS ggsouth DOMAIN OracleGoldenGate
INFO CREDENTIALSTORE

DISCONNECT
After creating the OBEY file, create a shell script to run in Admin Client:
#!/bin/bash

# Run the GoldenGate Obey script
echo "obey delete_replication_ActiveActive.oby" | adminclient | tee delete_replication_ActiveActive.log

# Clean up environment
/home/oracle/scripts/misc/cleanup.sh > /dev/null