Mostly, DBA configures and manages GoldenGate components by using GGSCI command-line Interface. GGSCI stands for GoldenGate Software Command Interface. It allows you to perform various tasks related to the administration and monitoring of Oracle GoldenGate components.
Help command use to get all available commands with details.
GGSCI> help
Manager Commands:
GGSCI> INFO MANAGER GGSCI> SEND MANAGER GGSCI> START MANAGER GGSCI> STOP MANAGER GGSCI> STATUS MANAGER
Note: We can either use MANAGER or MGR. Commands are not case sensitive.
Extract/Replicat Commands: (PUMP process also consider as Extract)
GGSCI> ADD EXTRACT E_GROUP_NAME - use for creating an extract process. GGSCI> ADD EXTRACT P_NAME - use for creating a pump process. GGSCI> ADD REPLICAT R_GROUP_NAME - use for creating a replicat process.
Below mentioned commands can be used for Extract or Replicat Processes.
GGSCI> ALTER/CLEANUP/DELETE EXTRACT - use for maintaining the extract process. GGSCI> REGISTER/UNREGISTER EXTRACT - use for register or unregister an extract group to or from Oracle database. GGSCI> START/STOP PROCESS_NAME - use to start or stop the extract process. GGSCI> INFO PROCESS_NAME GGSCI> INFO PROCESS_NAME SHOWCH GGSCI> INFO PROCESS_NAME DETAIL GGSCI> SEND PROCESS_NAME - sends instructions to, or returns information about. GGSCI> KILL PROCESS_NAME GGSCI> LAG PROCESS_NAME GGSCI> STATS PROCESS_NAME - use to get processing statistics GGSCI> STATUS PROCESS_NAME - use to get status of the process.
Credential Store Commands:
GGSCI> ADD CREDENTIALSTORE - use to create a credentials store /wallet/ that stores encrypted database user credentials. GGSCI> ALTER/DELETE CREDENTIALSTORE - use to maintain or delete the contents of a credentials store. GGSCI> INFO CREDENTIALSTORE - use to returns information for all credentials store.
