Quick Recap
In the previous post on GoldenGate implementation, we have completed the installation of GoldenGate Microservices.
In this post, we’ll perform the important aspects of Configurations of GoldenGate.
Create a New Credential in the OGG Administration Service
For Oracle GoldenGate to connect to a database, manage checkpoint tables and capture transaction information the crendential configuration is mandatory.
Login to OGG Administration Service Console as Admin user
Navigate: Home -> Hamburger Menu -> Configuration -> + icon next to Credentails
Username should be as follows:
c##avggadmin@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbser1.demo.com) (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=CDBDEM)(INSTANCE_NAME=CDBDEM1)))
Add the details for the below parameters.
Credential Domain – Name of the Credential/Connection
Credential Alias – Alias for the Credential
User ID – Input the user id as given format as above
Password – Password for the Credential
Verify Password – Re-enter the above password to verify
Once the details are provided, verify and Click Submit.
Once the credential details added it will appear as below.
Click on the Connect to Database button in Actions section to establish/validate the connection.
We’ll see the Connection to Database button will be Disconnect from Database in Actions and TRANDATA Information Section will appear.
Create a New Integrated Extract in Oracle GoldenGate Administration Server
Navigate to Home -> Administration Service -> Click on + button to add next extract.
In Extract addition wizard, fill the following details to complete the extract creation.
Extract Type – Integrated Extract and Click Next
Basic Information:
Process Name: Name of the extract
Description: Details of the extract
Intent: Unidirectional / Bidirectional (Based on the requirement)
Begin: Now
Trail Name: Trail Name (XML file will be generated with the prefix of this name)
Source Database Credential:
Select the Credential Created in the above section.
Registration Information:
Click on Register to PDB and select the PDB.
Other details, let it be as default and Click Next
In Parameter File step, include the extract parameter details to capture required data from the Source Database
Sample Extract will be as below, add required details and Click Create.
Note: Use the below as reference and add tables to capture the details on update and delete details.
EXTRACT EXT_AP USERIDALIAS Credential_Name DOMAIN Name EXTTRAIL a1 SOURCECATALOG Credential_Name IGNOREINSERTS UPDATERECORDFORMAT COMPACT TRANLOGOPTIONS INTEGRATEDPARAMS (_CHECKPOINT_FREQUENCY 10000, MAX_SGA_SIZE 256, _LOGMINER_READ_BUFFERS 256) TRANLOGOPTIONS CHECKPOINTRETENTIONTIME 2 TABLE AP.AP_INVOICES_ALL, GETBEFORECOLS (ON UPDATE ALL, ON DELETE ALL); TABLE AP.AP_INVOICE_DISTRIBUTIONS_ALL, GETBEFORECOLS (ON UPDATE ALL, ON DELETE ALL); TABLE AP.AP_INVOICE_LINES_ALL, GETBEFORECOLS (ON UPDATE ALL, ON DELETE ALL);
Verify the Extract Created
Target DB alertlog details after creating the extract
2026-06-18T15:06:16.112115+05:30
Thu Jun 18 15:06:16 2025
Logminer Bld: Done
DEMO(3):Thu Jun 18 15:06:16 2025
DEMO(3):Logminer Bld: Build started
DEMO(3):Thu Jun 18 15:06:16 2025
DEMO(3):Logminer Bld: Lockdown Complete. DB_TXN_SCN is 1534 4245016086 LockdownSCN is 6592724847935
2026-06-18T15:06:21.408318+05:30
Completed checkpoint up to RBA [0xfa5.2.10], SCN: 6592724843784
Completed checkpoint up to RBA [0xfa4.2.10], SCN: 6592724843740
2026-06-18T15:06:41.709318+05:30
DEMO(3):Thu Jun 18 15:06:41 2025
DEMO(3):Logminer Bld: Done
2026-06-18T15:06:41.709953+05:30
ALTER SYSTEM SWITCH ALL LOGFILE start (CDBDEM1)
2026-06-18T15:06:41.722361+05:30
Beginning log switch checkpoint up to RBA [0xfa6.2.10], SCN: 6592724878725
2026-06-18T15:06:41.722364+05:30
ALTER SYSTEM SWITCH ALL LOGFILE complete (CDBDEM1)
2026-06-18T15:06:41.722571+05:30
Thread 1 advanced to log sequence 4006 (LGWR switch), current SCN: 6592724878725
Current log# 2 seq# 4006 mem# 0: +DEMODATA/CDBDEMO/ONLINELOG/group_2.308.1201701269
2026-06-18T15:06:41.733607+05:30
ALTER SYSTEM ARCHIVE LOG
2026-06-18T15:06:41.971473+05:30
Beginning log switch checkpoint up to RBA [0xfa7.2.10], SCN: 6592724878733
2026-06-18T15:06:41.971670+05:30
Thread 1 advanced to log sequence 4007 (LGWR switch), current SCN: 6592724878733
Current log# 3 seq# 4007 mem# 0: +DEMODATA/CDBDEMO/ONLINELOG/group_3.331.1201701269
2026-06-18T15:06:42.018012+05:30
ARC1 (PID:17629556): Archived Log entry 17932 added for T-1.S-4006 ID 0xffffffffffc235f9 LAD:1
2026-06-18T15:06:42.065012+05:30
ARC0 (PID:10158356): Archived Log entry 17933 added for T-1.S-4005 ID 0xffffffffffc235f9 LAD:1
2026-06-18T15:06:47.710473+05:30
NET (PID:44499414): Archived Log entry 17934 added for T-2.S-7768 ID 0xffffffffffc235f9 LAD:1
2026-06-18T15:06:50.583053+05:30
GoldenGate Capture OGG$CAP_EXT_AP CAPTURE Created
2026-06-18T15:06:50.620038+05:30
GoldenGate CAPTURE OGG$CAP_EXT_AP: Start SCN: 6592724847935 (0xfd05cd3f.000005fe)
2026-06-18T15:06:50.620210+05:30
GoldenGate CAPTURE OGG$CAP_EXT_AP: First SCN: 6592724843784 (0xfd05bd08.000005fe)
2026-06-18T15:06:50.620383+05:30
GoldenGate CAPTURE OGG$CAP_EXT_AP: Required Checkpoint SCN: 0 (0x00000000.00000000)
2026-06-18T15:06:50.620589+05:30
GoldenGate CAPTURE OGG$CAP_EXT_AP: Captured SCN: 0 (0x00000000.00000000)
2026-06-18T15:06:50.620768+05:30
GoldenGate CAPTURE OGG$CAP_EXT_AP: Applied SCN: 0 (0x00000000.00000000)
CAPTURE OGG$CAP_EXT_AP: Capture Type: LOCAL
CAPTURE OGG$CAP_EXT_AP: Logminer Id: 1
CAPTURE OGG$CAP_EXT_AP: Source Database: DBSER1.DEMO.COM
CAPTURE OGG$CAP_EXT_AP: Source Root Name: CDBDBSER1.DEMO.COM
2026-06-18T15:06:52.080729+05:30
GoldenGate Apply: OGG$EXT_AP APPLY Created
2026-06-18T15:06:52.188428+05:30
Started service C##AVGGADMIN.OGG$Q_EXT_AP/SYS$C##AVGGADMIN.OGG$Q_EXT_AP.0.CDBDBSER1.DEMO.COM/SYS$C##AVGGADMIN.OGG$Q_EXT_AP.0.CDBDBSER1.DEMO.COM
2026-06-18T15:06:52.408116+05:30
APPLY OGG$EXT_AP: Apply User: C##AVGGADMIN
2026-06-18T15:06:52.408291+05:30
APPLY OGG$EXT_AP: Apply Tag: 00
2026-06-18T15:06:52.565513+05:30
GoldenGate CAPTURE OGG$CAP_EXT_AP:Setting XOUT_CLIENT_EXISTS to Y
2026-06-18T15:06:52.736158+05:30
GoldenGate CAPTURE CP01 for OGG$CAP_EXT_AP started with pid=293, OS id=39256370
2026-06-18T15:06:52.745725+05:30
Streams CAPTURE OGG$CAP_EXT_AP: Start SCN: 6592724847935 (0xfd05cd3f.000005fe)
2026-06-18T15:06:52.745899+05:30
Streams CAPTURE OGG$CAP_EXT_AP: First SCN: 6592724843784 (0xfd05bd08.000005fe)
2026-06-18T15:06:52.746092+05:30
Streams CAPTURE OGG$CAP_EXT_AP: Required Checkpoint SCN: 0 (0x00000000.00000000)
2026-06-18T15:06:52.746257+05:30
Streams CAPTURE OGG$CAP_EXT_AP: Captured SCN: 0 (0x00000000.00000000)
2026-06-18T15:06:52.746438+05:30
Streams CAPTURE OGG$CAP_EXT_AP: Applied SCN: 0 (0x00000000.00000000)
CAPTURE OGG$CAP_EXT_AP: Capture Type: LOCAL
CAPTURE OGG$CAP_EXT_AP: Logminer Id: 1
CAPTURE OGG$CAP_EXT_AP: Source Database: DBSER1.DEMO.COM
CAPTURE OGG$CAP_EXT_AP: Source Root Name: CDBDBSER1.DEMO.COM
2026-06-18T15:06:52.749302+05:30
CAPTURE OGG$CAP_EXT_AP: Parameter Set by User: _CHECKPOINT_FREQUENCY Value: 150
2026-06-18T15:06:52.785126+05:30
First applied SCN of the GoldenGate path from capture (OGG$CAP_EXT_AP) to propagation () to apply (OGG$EXT_AP) is set to SCN: 6592724843784 (0x000005fefd05bd08)
2026-06-18T15:06:55.895948+05:30
GoldenGate CAPTURE CP01 for OGG$CAP_EXT_AP with pid=293, OS id=39256370 is in combined capture and apply mode.
2026-06-18T15:06:55.896153+05:30
Capture OGG$CAP_EXT_AP is handling 1 applies.
2026-06-18T15:06:55.896344+05:30
-- capture is running in apply-state checkpoint mode.
2026-06-18T15:06:59.199242+05:30
Starting persistent Logminer Session with sid = 1 for GoldenGate Capture OGG$CAP_EXT_AP
LOGMINER: Parameters summary for session# = 1
LOGMINER: Number of processes = 0, Transaction Chunk Size = 1
LOGMINER: Memory Size = 30M, Checkpoint interval = 150M
LOGMINER: SpillScn 0, ResetLogScn 6551337513091
LOGMINER: summary for session# = 1, OS id=39256370
LOGMINER: StartScn: 6592724878733 (0x000005fefd06458d)
LOGMINER: EndScn: 0
LOGMINER: HighConsumedScn: 6592724847935 (0x000005fefd05cd3f)
LOGMINER: PSR flags: 0xb0
LOGMINER: Session Flags: 0x3fa8c2d0
LOGMINER: Session Flags2: 0x810243
LOGMINER: No PDML grouping is on
LOGMINER: DDL CKPT is on
LOGMINER: Read buffers: 64
LOGMINER: Region Queue size: 4096
LOGMINER: Redo Queue size: 65536
LOGMINER: Memory Size = 30M, HWM 20M, LWM 24M, 80%
LOGMINER: Memory Release Limit: 1M
LOGMINER: Max Decomp Region Memory: 1M
LOGMINER: Transaction Queue Size: 131072
LOGMINER: lowCkptScn: 0 (0x0000000000000000)
LOGMINER: highCkptScn: 0 (0x0000000000000000)
LOGMINER: SkipScn: 6592724843784 (0x000005fefd05bd08)
Initializing RBA broadcast for log mining
2026-06-18T15:06:59.451892+05:30
LOGMINER: Begin mining logfile during dictionary load for session 1 thread 1 sequence 4005, +DEMORECO/CDBDEMO/ARCHIVELOG/2025_11_20/thread_1_seq_4005.381.1217689601
2026-06-18T15:07:05.339351+05:30
LOGMINER: Preparing to load 2 dictionaries for session 1
LOGMINER: session# 1 Processing dictionary for pluggable database CDB$ROOT, pdbid 1
2026-06-18T15:07:08.250823+05:30
LOGMINER: Preparing to load next dictionary for session 1
LOGMINER: session# 1 Processing dictionary for pluggable database DEMO, pdbid 3
2026-06-18T15:07:09.551533+05:30
Completed checkpoint up to RBA [0xfa7.2.10], SCN: 6592724878733
Completed checkpoint up to RBA [0xfa6.2.10], SCN: 6592724878725
2026-06-18T15:07:28.374255+05:30
LOGMINER: End mining logfile during dictionary load for session 1 thread 1 sequence 4005, +DEMORECO/CDBDEMO/ARCHIVELOG/2025_11_20/thread_1_seq_4005.381.1217689601
2026-06-18T15:07:36.449777+05:30
LOGMINER: Finalizing dictionary load for session 1
2026-06-18T15:07:39.823711+05:30
LOGMINER: Gathering statistics on logminer dictionary. (incremental, nonparallel)
TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2503 (45980) VALUES LESS THAN (TO_DATE(' 2026-06-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2026-06-18T15:08:25.838562+05:30
LOGMINER: Completed dictionary load for session 1
2026-06-18T15:08:26.839031+05:30
LOGMINER: End mining logfiles during dictionary load for session 1
2026-06-18T15:08:30.333859+05:30
GoldenGate CAPTURE OGG$CAP_EXT_AP: Session Restart SCN: 6592724843784
2026-06-18T15:08:33.447818+05:30
GoldenGate CAPTURE OGG$CAP_EXT_AP: Start SCN: 6592724847935 (0xfd05cd3f.000005fe)
2026-06-18T15:08:33.447993+05:30
GoldenGate CAPTURE OGG$CAP_EXT_AP: First SCN: 6592724843784 (0xfd05bd08.000005fe)
2026-06-18T15:08:33.448225+05:30
GoldenGate CAPTURE OGG$CAP_EXT_AP: Required Checkpoint SCN: 0 (0x00000000.00000000)
2026-06-18T15:08:33.448390+05:30
GoldenGate CAPTURE OGG$CAP_EXT_AP: Captured SCN: 6592724843784 (0xfd05bd08.000005fe)
2026-06-18T15:08:33.448553+05:30
GoldenGate CAPTURE OGG$CAP_EXT_AP: Applied SCN: 0 (0x00000000.00000000)
CAPTURE OGG$CAP_EXT_AP: Capture Type: LOCAL
CAPTURE OGG$CAP_EXT_AP: Logminer Id: 1
CAPTURE OGG$CAP_EXT_AP: Source Database: DBSER1.DEMO.COM
CAPTURE OGG$CAP_EXT_AP: Source Root Name: CDBDBSER1.DEMO.COM
2026-06-18T15:08:33.449548+05:30
CAPTURE OGG$CAP_EXT_AP: Parameter Set by User: _CHECKPOINT_FREQUENCY Value: 150
2026-06-18T15:08:33.457700+05:30
GoldenGate CAPTURE OGG$CAP_EXT_AP: Bytes of Redo Mined: 0
2026-06-18T15:08:33.457876+05:30
GoldenGate CAPTURE OGG$CAP_EXT_AP: SGA Used: 14090540
2026-06-18T15:08:33.458041+05:30
GoldenGate CAPTURE OGG$CAP_EXT_AP: SGA Allocated: 31457280
2026-06-18T15:08:33.459554+05:30
GoldenGate CAPTURE CP01 for OGG$CAP_EXT_AP with pid=293, OS id=39256370 stopped
Start the Created Extract
Extract -> Action -> Start
To verify the extract creation after it is started
Navigate to the below location in GoldenGate server
cd /home/oragg/OGG/Deployment/var/lib/data
ps -ef |grep extract
Prepare Start and Stop Scripts
OGG Extract Services
Stop Script
cd /home/oragg/OGG/scripts
vi stopExts.sh
#!/bin/bash
OGG_HOME="/home/oragg/OGG/ogg_home/bin"
ADMINCLIENT="${OGG_HOME}/adminclient"
OGG_URL="GG_SERVER_IP:PORT"
OGG_USER="oggadmin"
OGG_PASS="Password"
cd "$OGG_HOME" || { echo "Failed to change directory to $GG_HOME"; exit 1; }
$ADMINCLIENT '<<'EOF ----Remove quotes ' ' from this line
connect $OGG_URL as $OGG_USER password $OGG_PASS
info all
stop extract *
info all
exit
EOF
echo "Oracle GoldenGate Extract Services Stopped Successfully."
Start Script
vi startExts.sh
#!/bin/bash
OGG_HOME="/home/oragg/OGG/ogg_home/bin"
ADMINCLIENT="${OGG_HOME}/adminclient"
OGG_URL="GG_SERVER_IP:PORT"
OGG_USER="oggadmin"
OGG_PASS="Password"
cd "$OGG_HOME" || { echo "Failed to change directory to $GG_HOME"; exit 1; }
$ADMINCLIENT '<<'EOF ----Remove quotes ' ' from this line
connect $OGG_URL as $OGG_USER password $OGG_PASS
info all
start extract *
info all
exit
EOF
echo "Oracle GoldenGate Extract Services Started Successfully."
ls -ltr
#ls -ltr total 8 -rw-r--r-- 1 oragg dba 424 Jun 18 14:51 stopExts.sh -rw-r--r-- 1 oragg dba 425 Jun 18 14:55 startExts.sh #
Validation
cd /home/oragg/OGG/scripts
ls -ltr
sh stopExts.sh
# sh stopExts.sh Oracle GoldenGate Administration Client for Oracle Version 21.19.0.0.0 OGGCORE_21.19.0.0.0OGGRU_PLATFORMS_250703.2256 Copyright (C) 1995, 2026, Oracle and/or its affiliates. All rights reserved. Oracle Linux 7, x64, 64bit (optimized) on Jul 4 2026 00:34:16 Operating system character set identified as UTF-8. OGG (not connected) 1> connect http://GG_SRV_IP:7201 as oggadmin password Password Using default deployment 'AVDFDeployment' OGG (http://GG_SRV_IP:7201 AVDFDeployment) 2> info all Program Status Group Type Lag at Chkpt Time Since Chkpt ADMINSRVR RUNNING DISTSRVR RUNNING PMSRVR RUNNING RECVSRVR RUNNING EXTRACT RUNNING EXT_AP INTEGRATED 00:00:00 00:00:02 OGG (http://GG_SRV_IP:7201 AVDFDeployment) 3> stop extract * 2026-07-04T15:35:44Z INFO OGG-08100 Sending STOP request to Extract group EXT_AP. 2026-07-04T15:35:44Z INFO OGG-02964 Extract group EXT_AP is down (gracefully). OGG (http://GG_SRV_IP:7201 AVDFDeployment) 4> info all Program Status Group Type Lag at Chkpt Time Since Chkpt ADMINSRVR RUNNING DISTSRVR RUNNING PMSRVR RUNNING RECVSRVR RUNNING EXTRACT STOPPED EXT_AP INTEGRATED 00:00:00 00:00:15 OGG (http://GG_SRV_IP:7201 AVDFDeployment) 5> exit Oracle GoldenGate Extract Services Stopped Successfully. #
Alert log details from Target DB
2026-07-04T21:07:06.774591+05:30 LOGMINER: session#=16 (OGG$CAP_EXT_AP), preparer MS0Y pid=185 OS id=51446028 sid=1129 stopped 2026-07-04T21:07:07.809768+05:30 OGG Capture client successfully detached from GoldenGate Capture OGG$CAP_EXT_AP (OS pid=33095994).
sh startExts.sh
# sh startExts.sh Oracle GoldenGate Administration Client for Oracle Version 21.19.0.0.0 OGGCORE_21.19.0.0.0OGGRU_PLATFORMS_250703.2256 Copyright (C) 1995, 2026, Oracle and/or its affiliates. All rights reserved. Oracle Linux 7, x64, 64bit (optimized) on Jul 4 2026 00:34:16 Operating system character set identified as UTF-8. OGG (not connected) 1> connect http://GG_SRV_IP:7201 as oggadmin password Welcome@123 Using default deployment 'AVDFDeployment' OGG (http://GG_SRV_IP:7201 AVDFDeployment) 2> info all Program Status Group Type Lag at Chkpt Time Since Chkpt ADMINSRVR RUNNING DISTSRVR RUNNING PMSRVR RUNNING RECVSRVR RUNNING EXTRACT STOPPED EXT_AP INTEGRATED 00:00:00 01:15:28 OGG (http://GG_SRV_IP:7201 AVDFDeployment) 3> start extract * 2026-07-04T16:50:58Z INFO OGG-00975 Extract group EXT_AP starting. OGG (http://GG_SRV_IP:7201 AVDFDeployment) 4> info all Program Status Group Type Lag at Chkpt Time Since Chkpt ADMINSRVR RUNNING DISTSRVR RUNNING PMSRVR RUNNING RECVSRVR RUNNING EXTRACT STOPPED EXT_AP INTEGRATED 00:00:00 01:15:29 OGG (http://GG_SRV_IP:7201 AVDFDeployment) 5> exit Oracle GoldenGate Extract Services Started Successfully. #
OGG Deployment Services
Stop Script
cd /home/oragg/OGG/scripts
vi stopGGServ.sh
#!/bin/bash
OGG_HOME="/home/oragg/OGG/ogg_home/bin"
ADMINCLIENT="${OGG_HOME}/adminclient"
OGG_URL="http://GG_SRV_IP:7201"
OGG_USER="oggadmin"
OGG_PASS="Password"
cd "$OGG_HOME" || { echo "Failed to change directory to $GG_HOME"; exit 1; }
$ADMINCLIENT '<<'EOF ---Remove quotes '' from this line
connect $OGG_URL as $OGG_USER password $OGG_PASS
info all
stop service *
info all
exit
EOF
echo "Oracle GoldenGate Deployment Services Stopped Successfully."
Start Script
cd /home/oragg/OGG/scripts
vi startGGServ.sh
#!/bin/bash
OGG_HOME="/home/oragg/OGG/ogg_home/bin"
ADMINCLIENT="${OGG_HOME}/adminclient"
OGG_URL="http://GG_SRV_IP:7201"
OGG_USER="oggadmin"
OGG_PASS="Password"
cd "$OGG_HOME" || { echo "Failed to change directory to $GG_HOME"; exit 1; }
$ADMINCLIENT '<<'EOF ----Remove quotes '' in this line
connect $OGG_URL as $OGG_USER password $OGG_PASS
info all
start service * DEPLOYMENT AVDFDeployment
status service * DEPLOYMENT AVDFDeployment
info all
exit
EOF
echo "Oracle GoldenGate Deployment Services Started Successfully."
Validation
cd /home/oragg/OGG/scripts
ls -ltr
sh stopGGServ.sh
# sh stopGGServ.sh Oracle GoldenGate Administration Client for Oracle Version 21.19.0.0.0 OGGCORE_21.19.0.0.0OGGRU_PLATFORMS_250703.2256 Copyright (C) 1995, 2026, Oracle and/or its affiliates. All rights reserved. Oracle Linux 7, x64, 64bit (optimized) on Jul 4 2026 00:34:16 Operating system character set identified as UTF-8. OGG (not connected) 1> connect http://GG_SRV_IP:7201 as oggadmin password Password Using default deployment 'AVDFDeployment' OGG (http://GG_SRV_IP:7201 AVDFDeployment) 2> info all Program Status Group Type Lag at Chkpt Time Since Chkpt ADMINSRVR RUNNING DISTSRVR RUNNING PMSRVR RUNNING RECVSRVR RUNNING EXTRACT STOPPED EXT_AP INTEGRATED 00:00:00 00:09:38 OGG (http://GG_SRV_IP:7201 AVDFDeployment) 3> stop service * Service 'ADMINSRVR' was stopped Service 'DISTSRVR' was stopped Service 'PMSRVR' was stopped Service 'RECVSRVR' was stopped OGG (http://GG_SRV_IP:7201 AVDFDeployment) 4> info all Program Status Group Type Lag at Chkpt Time Since Chkpt ADMINSRVR RUNNING DISTSRVR RUNNING PMSRVR RUNNING RECVSRVR RUNNING OGG (http://GG_SRV_IP:7201 AVDFDeployment) 5> exit Oracle GoldenGate Deployment Services Stopped Successfully. #
sh startGGServ.sh
# sh startDepServ.sh Oracle GoldenGate Administration Client for Oracle Version 21.19.0.0.0 OGGCORE_21.19.0.0.0OGGRU_PLATFORMS_250703.2256 Copyright (C) 1995, 2026, Oracle and/or its affiliates. All rights reserved. Oracle Linux 7, x64, 64bit (optimized) on Jul 4 2026 00:34:16 Operating system character set identified as UTF-8. OGG (not connected) 1> connect http://GG_SRV_IP:7201 as oggadmin password Password Default deployment not available. Connecting to Service Manager deployment instead. OGG (http://GG_SRV_IP:7201 ServiceManager) 2> info all Deployment Name Service Name Service Status AVDFDeployment ADMINSRVR STOPPED AVDFDeployment DISTSRVR STOPPED AVDFDeployment PMSRVR STOPPED AVDFDeployment RECVSRVR STOPPED OGG (http://GG_SRV_IP:7201 ServiceManager) 3> start service * DEPLOYMENT AVDFDeployment Service 'ADMINSRVR' was started Service 'DISTSRVR' was started Service 'PMSRVR' was started Service 'RECVSRVR' was started OGG (http://GG_SRV_IP:7201 ServiceManager) 4> status service * DEPLOYMENT AVDFDeployment Deployment Name Service Name Service Status AVDFDeployment ADMINSRVR RUNNING AVDFDeployment DISTSRVR RUNNING AVDFDeployment PMSRVR RUNNING AVDFDeployment RECVSRVR RUNNING OGG (http://GG_SRV_IP:7201 ServiceManager) 5> info all Deployment Name Service Name Service Status AVDFDeployment ADMINSRVR RUNNING AVDFDeployment DISTSRVR RUNNING AVDFDeployment PMSRVR RUNNING AVDFDeployment RECVSRVR RUNNING OGG (http://GG_SRV_IP:7201 ServiceManager) 6> exit Oracle GoldenGate Deployment Services Started Successfully. #
OGG Service Manager Service
Command for Service Manager registered as a service/daemon
systemctl status OracleGoldenGate
# systemctl status OracleGoldenGate
● OracleGoldenGate.service - Oracle GoldenGate Service Manager
Loaded: loaded (/etc/systemd/system/OracleGoldenGate.service; enabled; preset: disabled)
Active: active (running) since Mon 2026-06-01 16:43:10 IST; 1 month 5 days ago
Main PID: 923 (ServiceManager)
Tasks: 337 (limit: 100081)
Memory: 11.9G
CPU: 1d 3h 29min 22.440s
CGroup: /system.slice/OracleGoldenGate.service
├─ 923 /home/oragg/OGG/ogg_home/bin/ServiceManager --inventory "'/home/oragg/OGG/Service_Manager/etc/conf'"
├─ 2422 /home/oragg/OGG/ogg_home/bin/adminsrvr --config /home/oragg/OGG/Service_Manager/var/temp/AVDFDeployment-adminsrvr-config.dat --force --qui>
├─ 2424 /home/oragg/OGG/ogg_home/bin/distsrvr --config /home/oragg/OGG/Service_Manager/var/temp/AVDFDeployment-distsrvr-config.dat --force --quiet
├─ 2427 /home/oragg/OGG/ogg_home/bin/pmsrvr --config /home/oragg/OGG/Service_Manager/var/temp/AVDFDeployment-pmsrvr-config.dat --force --quiet
├─ 2433 /home/oragg/OGG/ogg_home/bin/recvsrvr --config /home/oragg/OGG/Service_Manager/var/temp/AVDFDeployment-recvsrvr-config.dat --force --quiet
└─113761 /home/oragg/OGG/ogg_home/bin/extract PARAMFILE /home/oragg/OGG/Deployment/etc/conf/ogg/EXT_AP.prm REPORTFILE /home/oragg/OGG/Deployment/va>
#
Stop Service Manager Service
sudo su – root
systemctl status OracleGoldenGate
systemctl stop OracleGoldenGate
systemctl status OracleGoldenGate
[oragg@GGSRV scripts]$ sudo su - root
[root@GGSRV ~]#
[root@GGSRV ~]# systemctl status OracleGoldenGate
● OracleGoldenGate.service - Oracle GoldenGate Service Manager
Loaded: loaded (/etc/systemd/system/OracleGoldenGate.service; enabled; preset: disabled)
Active: active (running) since Mon 2026-06-01 16:43:10 IST; 1 month 5 days ago
Main PID: 923 (ServiceManager)
Tasks: 16 (limit: 100081)
Memory: 4.5G
CPU: 1d 3h 51min 31.291s
CGroup: /system.slice/OracleGoldenGate.service
└─923 /home/oragg/OGG/ogg_home/bin/ServiceManager --inventory "'/home/oragg/OGG/Service_Manager/etc/conf'"
[root@GGSRV ~]# systemctl stop OracleGoldenGate
[root@GGSRV ~]#
[root@GGSRV ~]# systemctl status OracleGoldenGate
○ OracleGoldenGate.service - Oracle GoldenGate Service Manager
Loaded: loaded (/etc/systemd/system/OracleGoldenGate.service; enabled; preset: disabled)
Active: inactive (dead) since Tue 2026-06-01 21:30:26 IST; 8s ago
Duration: 1month 2w 5d 18h 17min 15.258s
Process: 923 ExecStart=/usr/bin/OracleGoldenGate.sh (code=exited, status=0/SUCCESS)
Main PID: 923 (code=exited, status=0/SUCCESS)
CPU: 1d 3h 51min 31.364s
Nov 25 21:24:16 GGSRV ServiceManager[923]: 2025-11-25T21:24:16.946+0530 INFO | 9492 {
"context": {
"httpContextKey": 140552485917216,
"requestId": 9492,
"code": "401 Unauthorized",
"headers": {
"Content-Type": "application/json",
"Content-Length": 571,
"WWW-Authenticate": [
"oggDigest realm=\"ServiceManager\",nonce=\"12504954234>
"oggBasic realm=\"ServiceManager\",charset=\"UTF-8\""
],
"Cache-Control": "max-age=0, no-cache, no-store, must-reval>
"Expires": "0",
"Pragma": "no-cache",
"Content-Security-Policy": "default-src 'self' 'unsafe-eval>
"Permissions-Policy": "autoplay=(),camera=(),geolocation=()>
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "SAMEORIGIN",
"X-XSS-Protection": "1; mode=block"
},
[root@GGSRV ~]#
logout
[root@GGSRV ~]#
[oragg@GGSRV scripts]$ systemctl status OracleGoldenGate
○ OracleGoldenGate.service - Oracle GoldenGate Service Manager
Loaded: loaded (/etc/systemd/system/OracleGoldenGate.service; enabled; preset: disabled)
Active: inactive (dead) since Tue 2026-07-06 21:30:26 IST; 20s ago
Duration: 1month 2w 5d 18h 17min 15.258s
Process: 923 ExecStart=/usr/bin/OracleGoldenGate.sh (code=exited, status=0/SUCCESS)
Main PID: 923 (code=exited, status=0/SUCCESS)
CPU: 1d 3h 51min 31.364s
Start Service Manager Service
sudo su – root
systemctl status OracleGoldenGate
systemctl start OracleGoldenGate
systemctl status OracleGoldenGate
[root@GGSRV ~]# systemctl start OracleGoldenGate
[root@GGSRV ~]#
[root@GGSRV ~]#
[root@GGSRV ~]# systemctl status OracleGoldenGate
● OracleGoldenGate.service - Oracle GoldenGate Service Manager
Loaded: loaded (/etc/systemd/system/OracleGoldenGate.service; enabled; preset: disabled)
Active: active (running) since Tue 2026-07-06 22:10:14 IST; 11s ago
Main PID: 416858 (ServiceManager)
Tasks: 16 (limit: 100081)
Memory: 42.7M
CPU: 473ms
CGroup: /system.slice/OracleGoldenGate.service
└─416858 /home/oragg/OGG/ogg_home/bin/ServiceManager --inventory "'/home/oragg/OGG/Service_Manager/etc/conf'"
Jul 06 22:10:14 GGSRV systemd[1]: Started Oracle GoldenGate Service Manager.
Jul 06 22:10:15 GGSRV ServiceManager[416858]: 2026-07-06T22:10:15.063+0530 INFO | Configuring user authorization enabled.
Jul 06 22:10:15 GGSRV ServiceManager[416858]: 2026-07-06T22:10:15.137+0530 INFO | Configuring user authorization secure store path as '/home/oragg/OGG>
Jul 06 22:10:15 GGSRV ServiceManager[416858]: 2026-07-06T22:10:15.137+0530 INFO | Configuring user session simple store path as '/home/oragg/OGG/Servi>
Jul 06 22:10:15 GGSRV OracleGoldenGate.sh[416858]: Oracle GoldenGate Service Manager for Oracle
Jul 06 22:10:15 GGSRV OracleGoldenGate.sh[416858]: Version 21.19.0.0.0 OGGCORE_21.19.0.0.0OGGRU_PLATFORMS_250703.2256
Jul 06 22:10:15 GGSRV OracleGoldenGate.sh[416858]: Copyright (C) 1995, 2026, Oracle and/or its affiliates. All rights reserved.
Jul 06 22:10:15 GGSRV OracleGoldenGate.sh[416858]: Oracle Linux 7, x64, 64bit (optimized) on Jul 4 2026 00:35:07
Jul 06 22:10:15 GGSRV OracleGoldenGate.sh[416858]: Operating system character set identified as UTF-8.
...skipping...
● OracleGoldenGate.service - Oracle GoldenGate Service Manager
Loaded: loaded (/etc/systemd/system/OracleGoldenGate.service; enabled; preset: disabled)
Active: active (running) since Tue 2026-07-06 22:10:14 IST; 11s ago
Main PID: 416858 (ServiceManager)
Tasks: 16 (limit: 100081)
Memory: 42.7M
CPU: 473ms
CGroup: /system.slice/OracleGoldenGate.service
└─416858 /home/oragg/OGG/ogg_home/bin/ServiceManager --inventory "'/home/oragg/OGG/Service_Manager/etc/conf'"
Jul 06 22:10:14 GGSRV systemd[1]: Started Oracle GoldenGate Service Manager.
Jul 06 22:10:15 GGSRV ServiceManager[416858]: 2026-07-06T22:10:15.063+0530 INFO | Configuring user authorization enabled.
Jul 06 22:10:15 GGSRV ServiceManager[416858]: 2026-07-06T22:10:15.137+0530 INFO | Configuring user authorization secure store path as '/home/oragg/OGG>
Jul 06 22:10:15 GGSRV ServiceManager[416858]: 2026-07-06T22:10:15.137+0530 INFO | Configuring user session simple store path as '/home/oragg/OGG/Servi>
Jul 06 22:10:15 GGSRV OracleGoldenGate.sh[416858]: Oracle GoldenGate Service Manager for Oracle
Jul 06 22:10:15 GGSRV OracleGoldenGate.sh[416858]: Version 21.19.0.0.0 OGGCORE_21.19.0.0.0OGGRU_PLATFORMS_250703.2256
Jul 06 22:10:15 GGSRV OracleGoldenGate.sh[416858]: Copyright (C) 1995, 2026, Oracle and/or its affiliates. All rights reserved.
Jul 06 22:10:15 GGSRV OracleGoldenGate.sh[416858]: Oracle Linux 7, x64, 64bit (optimized) on Jul 4 2025 00:35:07
Jul 06 22:10:15 GGSRV OracleGoldenGate.sh[416858]: Operating system character set identified as UTF-8.
~
~
~
~
~
~
[root@GGSRV ~]#
logout
[oragg@GGSRV scripts]$ systemctl status OracleGoldenGate
● OracleGoldenGate.service - Oracle GoldenGate Service Manager
Loaded: loaded (/etc/systemd/system/OracleGoldenGate.service; enabled; preset: disabled)
Active: active (running) since Tue 2026-07-06 22:10:14 IST; 45s ago
Main PID: 416858 (ServiceManager)
Tasks: 16 (limit: 100081)
Memory: 42.7M
CPU: 562ms
CGroup: /system.slice/OracleGoldenGate.service
└─416858 /home/oragg/OGG/ogg_home/bin/ServiceManager --inventory "'/home/oragg/OGG/Service_Manager/etc/conf'"
End of Post
Thanks for taking the time to read this post.
Stay tuned for the next post coming soon. . .
Pingback: How To Implement Oracle Audit Vault Database Firewall (AVDF) - Part 5