Debugging an Oracle GoldenGate Replication Configuration

Language:

Debugging the replication status resource by obtaining extensive logging and a korn shell trace.

pnycb # clrs set -p debug_level=2 rep-rs
pnycb # ksh -x /opt/ORCLscGoldenGate/geocontrol/bin/goldengate_geo_replication_probe -R rep-rs -G rep-rg -T \
ORCl.GoldenGate_geo

Setting the debug_level property to 3 results in extensive debug messages for the replication status resource in the following file:
```
/var/cluster/logs/DS/ORCL.GoldenGate_geo/message_log.resource name
```
For more information about the debug_level property, see the ORCL.gds(7) man page.
Debugging the SBP control scripts by obtaining extensive logging and a korn shell trace for a script.
- In the file /opt/ORCLscGoldenGate/geocontrol/etc/config, set the variable SET_DEBUG to ALL or set it to the replication component that you are debugging on the node that you want to debug. On this node, call the SBP control script that you want to debug.
```
ksh -x /opt/ORCLscGoldenGate/geocontrol/bin/goldengate_geo_control
      -O gg-comp -r rep-rs -g rep-rg -R gg-rs -G mys-rg -T 60 -o
      nyc:mysqlex1,nyc:mysqlre2,sfo:mysqlex2,sfo:mysqlre1 function=create_configuration pg=gg-pg
      validate_parameters=false currentRole=PRIMARY is Modify=false
```
- To obtain all the SBP controls and its parameters, scan the cacao log.
```
/var/cacao/instances/default/logs
```