GGSCI (host) 4> ADD CREDENTIALSTORE
Credential store created in ./dircrd/.
GGSCI (host) 5> ALTER CREDENTIALSTORE ADD USER ggadm, password xxxxx alias ggadm
Credential store in ./dircrd/ altered.
GGSCI (host) 6> dblogin useralias ggadm
SQL> GRANT DBA TO C##GOLDENADMIN CONTAINER=ALL
ggsci > create wallet ggsci > Add CredentialStore ggsci > alter CredentialStore Add User ogg@ORCL Password ogg Alias aogg ggsci > info CredentialStore ggsci > dblogin useridalias aogg
Sub-directories | Description |
dirbdb | This directory contains the GoldenGat e datastor e files |
dirchk | This directory contains the GoldenGate checkpoint files. Extract and Replicat processes stores current read and write positions in the checkpoint file to support data accuracy and fault tolerance. Extension of the file is either .cpe for Extract checkpoint files or .cpr for Replicat checkpoint files. |
dircrd | This directory contains the GoldenGate Credential Store |
dirdat | This directory contains the GoldenGate trail files. Created by Extract/Pump processes to store records of extracted data for further processing (example to be processed further by replicat process).File name format starts with a user-defined two-character prefix. |
dirdef | This directory contains the GoldenGate definition mapping files. data definitions files are created by the DEFGEN utility and it contain source or target data definitions used in a heterogeneous synchronization environment. Written in external ASCII. File name format is a user-defined name specified in the DEFGEN parameter file. |
dirdmp | This directory contains the GoldenGate process dump |
dirjar | This directory contains the GoldenGate Java Archive |
dirout | This directory contains the GoldenGate output files |
dirpcs | This directory contains the GoldenGate process files. It is default location for status files. File name is <group>.<extension> where <group> is the name of the group and <extension> is either pce (Extract), pcr (Replicat), or pcm (Manager). These files are only created while a process is running. The file shows the program name, the process name, the port and process id that is running. |
dirprm | This directory contains the GoldenGate process parameter files. It store run-time parameters for GoldenGate process groups or utilities. Written in external ASCII format. File name format is <group name/user-defined name>.prm or mgr.prm. |
dirrpt | This directory contains the GoldenGate process report. It is default location for process report files created by Extract, Replicat, and Manager processes to report statistical information relating to a processing run. Written in external ASCII format. File name format is <group name><sequence number>.rpt where <sequence number> is a sequential number appended to aged files. |
dirsql | This directory contains the GoldenGate user defined files. It iis default location for scripts created by the TRIGGEN utility to contain SQL syntax for creating GoldenGate logging triggers and GoldenGate log tables. Written in external format.
File name format is a user-defined name or the defaults of GGSLOG (table-creation script) or the table name (trigger-creation script), with the extension of .sql.
These scripts can be edited if needed. |
dirtmp | This directory contains the GoldenGate temporary files. It is default location for storing large transactions when the size exceeds the allocated memory size. |
dirwlt | This directory contains the GoldenGate wallet files |
dirwww | This directory contains the GoldenGate web pages |
dirver | This directory contains the GoldenGate Veridata files |
DBOPTIONS INTEGRATEDPARAMS (parallelism 6)
SQLEXEC "alter session set commit_wait = 'NOWAIT'";
DBOPTIONS INTEGRATEDPARAMS (EAGER_SIZE 18000)
COMMAND | DESCRIPTION |
INFO MANAGER or INFO MGR or STATUS MANAGER | Displays the Manager process status information. |
START MANAGER | Starts the Manager process. |
STOP MGR or STOP MANAGER or STOP MANAGER! | Stops the Manager process. If you put ! mark in the end then it will not ask you y/n prompt also and directly stop it. |
SEND MANAGER | Not used very frequently but is very useful when you are troubleshooting some issues. Checks addition status information when used with extra options.Example to get the port information use like below: SEND MANAGER GETPORTINFO DETAIL |
COMMAND | DESCRIPTION |
INFO <EXTRACT_NAME> or INFO EXTRACT <EXTRACT_NAME> OR STATUS EXTRACT | Displays the status summary for an Extract process. Use “DETAIL” keyword to get further details.
INFO EXTRACT, DETAIL
It also supports wild card, Example like below you can get details of all EXTRACT process that starts with E in single statement.
INFO E*, DETAIL
|
ADD EXTRACT | creates a new Extract group
Example for Integrated Extract:
ADD EXTRACT ESOURCE01, INTEGRATED TRANLOG, BEGIN NOW
|
ALTER EXTRACT | This command alters an existing Extract group |
STOP EXTRACT | This command stops the Extract process Supports wildcards too:STOP EXTRACT * |
STATS EXTRACT | Displays the Extract process statistics. |
START EXTRACT | This command starts the Extract process. Supports wildcards too:START EXTRACT * |
REGISTER EXTRACT | Registers an Extract process group with its source database |
UNREGISTER EXTRACT | Unregisters an Extract process group from its source database |
KILL EXTRACT | Kills an Extract process. Use when the process cannot be stopped gracefully. |
LAG EXTRACT | Displays the lag time between the Extract process and the data source |
CLEANUP EXTRACT | Deletes the run history for the specified Extract group. you must stop the Extract before cleaning it up. |
DELETE EXTRACT | It will delete the Extract group. The Extract process must first be stopped. |
SEND EXTRACT | It will direct Extract process to generate statistics/reports |
VIEW REPORT | Allows process reports generated by the SEND command to be viewed |
COMMAND | DESCRIPTION |
INFO REPLICAT <REPLICAT_NAME> or STATUS REPLICAT <REPLICAT_NAME> | Displays the status summary for the Replicat process
The DETAIL option provides more information:
INFO REPICAT, DETAIL
|
START REPLICAT <REPLICAT_NAME> | Starts the Replicat process |
STATS REPLICAT <REPLICAT_NAME> | Displays the Replicat process statistics. |
STOP REPLICAT <REPLICAT_NAME> | Stops the Replicat process |
KILL REPLICAT <REPLICAT_NAME> | kills the Replicat process and is used when the process cannot be stopped gracefully. |
LAG REPLICAT <REPLICAT_NAME> | Displays the lag time between the Replicat process and the data source. |
REGISTER REPLICAT <REPLICAT_NAME> | Registers the Replicat process group with its target database |
UNREGISTER REPLICAT <REPLICAT_NAME> | unregisters an Replicat from its target database. |
CLEANUP REPLICAT <REPLICAT_NAME> | Deletes the run history for the specified Replicat group. The Replicat process must be stopped first. |
DELETE REPLICAT <REPLICAT_NAME> | This command deletes an Extract group. The Replicat process must be stopped first. |
SEND REPLICAT <REPLICAT_NAME> | Sends ad hoc report generation or trace file generation command to Replicat |
VIEW REPORT <REPLICAT_NAME> | Allows process to view reports generated by the SEND command |
COMMAND | DESCRIPTION |
ADD EXTTRAIL | Creates a local trail for an Extract group. |
ALTER EXTTRAIL | Can alter local trail example if you want to edit the trail file size |
ADD RMTTRAIL | Creates a remote trail for an Extract or data pump group |
ALTER RMTTRAIL | Can be used to alter the remote trail size |
INFO EXTTRAIL | Provides information on the local trail status |
INFO RMTTRAIL | Provides information on the remote trail status |
DELETE EXTTRAIL | Deletes the local trail |
DELETE RMTTRAIL | Deletes the remote trail |
VIEW PARAMS | Allows a process’ parameter file to be viewed |
EDIT PARAMS | Allows a process’ parameter file to be edited |
ADD CREDENTIALSTORE | Creates a Credentials Store wallet to store database user/password |
INFO CREDENTIALSTORE | Lists all users defined in the Credentials Store wallet. |
DBLOGIN | provides access to the database with the username and password OR you can also use db login alias. Example:
DBLOGIN USERIDALIAS sourcepass
|
ADD SCHEMATRANDATA | This command can be run only after you have connected to database using dblogin. It adds database schema level supplemental logging |
ADD TRANDATA | This command can be run only after you have connected to database using dblogin. It adds supplemental logging to a database table. |
DELETE TRANDATA | This command stops the supplemental logging on a database table |
INFO TRANDATA | Provides the supplemental logging status on a database table |
INFO SCHEMATRANDATA | Provides the supplemental logging status on a database schema |
HISTORY | Lists a history of GGSCI commands that were used. |
ADD CHECKPOINTTABLE | Adds a checkpoint table on the target database. |
DELETE CHECKPOINTTABLE | Deletes the checkpoint table from the database. |
INFO CHECKPOINTTABLE | Shows the checkpoint table status and creation date |
OBEY | You can run a set of command in chunks by putting those commands in .oby file and executing it
Example:
OBEY dirprm/conf.oby
|
SHELL | Allows OS commands to be executed from GGSCI command prompt SHELL df -h dirdat |