GGSCI stands for Golden Gate Software Command Interface. YES..! It is a command interface that executes Oracle golden gate commands.

To work with GGSCI interface first go to your Golden Gate installation directory

[oracle@localhost oracle]$cd /u02/ggate

Now, open ggsci prompt using ./ggsci command :

[oracle@localhost ggate]$ ./ggsci
./ggsci: error while loading shared libraries: libnnz12.so: cannot open shared object file: No such file or directory

We can see here , it gives an error saying “error while loading shared libraries”

So we need to set LD_LIBRARY_PATH environment variable .

[oracle@localhost ggate]$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

Now try to login through ggsci.

[oracle@localhost ggate]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.3.0.1.4 OGGCORE_12.3.0.1.0_PLATFORMS_180415.0359_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Apr 16 2018 00:53:30
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2018, Oracle and/or its affiliates. All rights reserved.



GGSCI (localhost.localdomain) 1>

We can see here error is gone and I got ggsci prompt.

You can get any help regarding Golden Gate commands with help command :

GGSCI (localhost.localdomain) 1> help

This file describes the commands that can be issued through the Oracle GoldenGate  
Software Command Interface (GGSCI). This is the command interface between  
users and Oracle GoldenGate functional components.  
 
 
Summary of Manager Commands  
Use the Manager commands to control the Manager process. Manager is the parent  
process of Oracle GoldenGate and is responsible for the management of its processes  
and files, resources, user interface, and the reporting of thresholds and errors.  
 
Command                     Description   
INFO MANAGER                Returns information about the Manager port and process id.   
SEND MANAGER                Returns information about a running Manager process and optionally 
                            child processes.   
START MANAGER               Starts the Manager process.   
STATUS MANAGER              Returns the state of the Manager port and process ID.   
STOP MANAGER                Stops the Manager process.   
 
 
Summary of Extract Commands  
Use the Extract commands to create and manage Extract groups. The Extract process  
captures either full data records or transactional data changes, depending on configuration  
parameters, and then sends the data to a trail for further processing by a downstream  
process, such as a data-pump Extract or the Replicat process.  
 
Command                     Description   
ADD EXTRACT                 Creates an Extract group.   
ALTER EXTRACT               Changes attributes of an Extract group   
CLEANUP EXTRACT             Deletes run history for an Extract group   
DELETE EXTRACT              Deletes an Extract group.   
INFO EXTRACT                Returns information about an Extract group.   
KILL EXTRACT                Forcibly terminates the run of an Extract group.   
LAG EXTRACT                 Returns information about Extract lag.   
REGISTER EXTRACT            Registers an Extract group with an Oracle database.   
SEND EXTRACT                Sends instructions to, or returns information about, a running   
                            Extract group.   
START EXTRACT               Starts an Extract group.   
STATS EXTRACT               Returns processing statistics for an Extract group.   
STATUS EXTRACT              Returns the state of an Extract group.   
STOP EXTRACT                Stops an Extract group.   
FORCEAPPEND                 Allows data pump to add new trail files on top of existing initial load files 
UNREGISTER EXTRACT          Unregisters an Extract group from an Oracle database.  
 
 
Summary of Replicat Commands  
Use the Replicat commands to create and manage Replicat groups. The Replicat  
process reads data extracted by the Extract process and applies it to target tables  
or prepares it for use by another application, such as a load application.  
 
Command                     Description   
ADD REPLICAT                Adds a Replicat group.   
ALTER REPLICAT              Changes attributes of a Replicat group.   
CLEANUP REPLICAT            Deletes run history of a Replicat group.   
DELETE REPLICAT             Deletes a Replicat group.   
INFO REPLICAT               Returns information about a Replicat group.   
KILL REPLICAT               Forcibly terminates a Replicat group.   
LAG REPLICAT                Returns information about Replicat lag.   
REGISTER REPLICAT           Registers a Replicat group with an Oracle database.   
SEND REPLICAT               Sends instructions to, or returns information about, a running   
                            Replicat group.   
START REPLICAT              Starts a Replicat group.   
STATS REPLICAT              Returns processing statistics for a Replicat group.   
STATUS REPLICAT             Returns the state of a Replicat group.   
STOP REPLICAT               Stops a Replicat group.   
SYNCHRONIZE REPLICAT        Returns all threads of a coordinated Replicat to a uniform  
                            start point after an unclean shutdown of the Replicat process.   
UNREGISTER REPLICAT         Unregisters a Replicat group from an Oracle database.   
 
 
Summary of the ER Command 
Use the ER command to issue standard Extract and Replicat commands to multiple 
Extract and Replicat groups as a unit. See "ER" for how to use this command. 
 
Command                     Description 
INFO ER *                   Returns information about the specified wildcarded groups. 
KILL ER *                   Forcibly terminates the specified wildcarded groups. 
LAG ER *                    Returns lag information about the specified wildcarded groups 
SEND ER *                   Sends instructions to, or returns information about, the 
                            specified wildcarded groups. 
START ER *                  Starts the specified wildcarded groups. 
STATS ER *                  Returns processing statistics for the specified wildcarded 
                            groups. 
STATUS ER *                 Returns the state of the specified wildcarded groups. 
STOP ER *                   Stops the specified wildcarded groups. 
 
 
Summary of Wallet Commands  
Use the wallet commands to manage the master-key wallet that stores Oracle GoldenGate  
master encryptions keys, and to add master keys to this wallet.  
 
Command                     Description   
CREATE WALLET               Creates a wallet that stores master encryption keys.   
OPEN WALLET                 Opens a master-key wallet.   
PURGE WALLET                Permanently removes from a wallet the master keys that are   
                            marked as deleted.   
ADD MASTERKEY               Adds a master key to a master-key wallet.   
INFO MASTERKEY              Returns information about master keys.   
RENEW MASTERKEY             Adds a new version of a master key.   
DELETE MASTERKEY            Marks a master key for deletion.   
UNDELETE MASTERKEY          Changes the state of a master key from being marked as deleted   
                            to marked as available.   
 
 
Summary of Credential Store Commands  
Use the credential store commands to manage an Oracle GoldenGate credential store and  
to add credentials to the credential store.  
 
Command                     Description  
ADD CREDENTIALSTORE         Creates a credentials store (wallet) that stores encrypted   
                            database user credentials.   
ALTER CREDENTIALSTORE       Changes the contents of a credentials store.   
INFO CREDENTIALSTORE        Returns information about a credentials store.   
DELETE CREDENTIALSTORE      Deletes the wallet that serves as a credentials store.   
 
 
Summary of Trail Commands  
Use the trail commands to create and manage Oracle GoldenGate trails. A trail is a series  
of files in which Oracle GoldenGate temporarily stores extracted data on disk until it has  
been applied to the target location.  
 
Command                     Description  
 
ADD EXTTRAIL                Adds a local trail to the Oracle GoldenGate configuration.   
ADD RMTTRAIL                Adds a remote trail to the Oracle GoldenGate configuration.   
ALTER EXTTRAIL              Changes attributes of a local trail.   
ALTER RMTTRAIL              Changes attributes of a remote trail.   
DELETE EXTTRAIL             Removes a local trail from the Oracle GoldenGate configuration.   
DELETE RMTTRAIL             Removes a remote trail from the Oracle GoldenGate configuration.   
INFO EXTTRAIL               Returns information about a local trail.   
INFO RMTTRAIL               Returns information about a remote trail.   
 
 
Summary of Parameter Commands  
Use the parameter commands to view and manage Oracle GoldenGate parameter files.  
See Administering Oracle GoldenGate for more information about how to work with parameter  
files.  
 
Command                     Description  
EDIT PARAMS                 Opens a parameter file for editing in the default text editor.   
SET EDITOR                  Sets the default text editor program for editing parameter files.   
VIEW PARAMS                 Displays the contents of a parameter file in read-only mode on-screen.   
INFO PARAM                  Returns parameter definition information.   
 
 
Summary of Database Commands  
Use the database commands to interact with the database from GGSCI.  
 
Command                     Description   
DBLOGIN                     Logs the GGSCI session into a database so that other commands that  
                            affect the database can be issued.   
DUMPDDL                     Shows the data in the Oracle GoldenGate DDL history table.   
ENCRYPT PASSWORD            Encrypts a database login password.   
FLUSH SEQUENCE              Updates an Oracle sequence so that initial redo records are  
                            available at the time that Extract starts capturing transaction  
                            data after the instantiation of the replication environment.   
LIST TABLES                 Lists the tables in the database with names that match the input specification.   
MININGDBLOGIN               Specifies the credentials of the user that an Oracle GoldenGate process  
                            uses to log into an Oracle mining database.   
SET NAMECCSID               Sets the CCSID of the GGSCI session in a DB2 for i environment.   
 
 
Summary of Trandata Commands  
Use trandata commands to configure the appropriate database components to provide the  
transaction information that Oracle GoldenGate needs to replicate source data operations.  
 
Command                     Description   
ADD SCHEMATRANDATA          Enables schema-level supplemental logging.   
ADD TRANDATA                Enables table-level supplemental logging.   
DELETE SCHEMATRANDATA       Disables schema-level supplemental logging.    
DELETE TRANDATA             Disables table-level supplemental logging.   
INFO SCHEMATRANDATA         Returns information about the state of schema-level   
                            supplemental logging.   
INFO TRANDATA               Returns information about the state of table-level supplemental   
                            logging.   
SET_INSTANTIATION_CSN       Sets whether and how table instantiation CSN filtering is used.   
CLEAR_INSTANTIATION_CSN     Clears table instantiation CSN filtering.   
 
 
Summary of Checkpoint Table Commands  
Use the checkpoint table commands to manage the checkpoint table that is used by Oracle  
GoldenGate to track the current position of Replicat in the trail.  
For more information about checkpoints and using a checkpoint table,  
see Administering Oracle GoldenGate. 
 
Command                     Description   
ADD CHECKPOINTTABLE         Creates a checkpoint table in a database.   
CLEANUP CHECKPOINTTABLE     Removes checkpoint records that are no longer needed.   
DELETE CHECKPOINTTABLE      Removes a checkpoint table from a database.   
INFO CHECKPOINTTABLE        Returns information about a checkpoint table.   
UPGRADE CHECKPOINTTABLE     Adds a supplemental checkpoint table when upgrading Oracle  
                            GoldenGate from version 11.2.1.0.0 or earlier.   
 
 
Summary of Oracle Trace Table Commands  
Use the trace table commands to manage the Oracle GoldenGate trace table that is used  
with bidirectional synchronization of Oracle databases. Replicat generates an operation  
in the trace table at the start of each transaction. Extract ignores all transactions  
that begin with an operation to the trace table. Ignoring Replicat's operations  
prevents data from looping back and forth between the source and target tables.  
For more information about bidirectional synchronization, see Administering  
Oracle GoldenGate for Windows and UNIX 
 
Command                     Description   
ADD TRACETABLE              Creates a trace table.   
DELETE TRACETABLE           Removes a trace table.   
INFO TRACETABLE             Returns information about a trace table.   
 
 
Summary of Oracle GoldenGate Monitor JAgent Commands  
Use the JAgent commands to control the Oracle GoldenGate Monitor JAgent.  
 
Command                     Description   
INFO JAGENT                 Returns information about the JAgent.   
START JAGENT                Starts the JAgent.   
STATUS JAGENT               Returns the state of the JAgent.   
STOP JAGENT                 Stops the JAgent.   
 
 
Summary of  PMSRVR COMMANDS 
 
Use the PMSRVR commands to control the Performance Metrics Server process. The  
Performance Metrics Server uses the metrics service to collect and store  
instance deployment performance results. 
 
Command                     Description   
INFO PMSRVR                 Returns information about the PMSRVR.   
START PMSRVR                Starts the PMSRVR.   
STATUS PMSRVR               Returns the state of the PMSRVR.   
STOP PMSRVR                 Stops the PMSRVR.   
 
 
Summary of Oracle GoldenGate Automatic Heartbeat Commands  
Use the heartbeat table commands to control the Oracle GoldenGate automatic  
heartbeat functionality.  
 
Command                     Description   
ADD HEARTBEATTABLE          Creates the objects required for automatic heartbeat functionality.   
ALTER HEARTBEATTABLE        Alters existing heartbeat objects.   
DELETE HEARTBEATTABLE       Deletes existing heartbeat objects.   
DELETE HEARTBEATENTRY       Deletes entries in the heartbeat table.   
INFO HEARTBEATTABLE         Displays heartbeat table information.   
 
 
Summary of Procedural Replication Commands 
 
Use the following commands to enable, delete or retrieve information about procedures  
that have supplemental logging turned on. 
 
Command                     Description   
ADD PROCEDURETRANDATA       Adding supplemental logging for Procedural Replication. 
DELETE PROCEDURETRANDATA    Remove supplemental logging for Procedural Replication. 
INFO PROCEDURETRANDATA      Display display supplemental logging information about Procedural Replication. 
 
 
Summary of Miscellaneous Oracle GoldenGate Commands  
Use the following commands to control various other aspects of Oracle GoldenGate.  
Command                     Description  
 
!                           Executes a previous GGSCI command without modifications.   
ALLOWNESTED | NOALLOWNESTED Enables or disables the use of nested OBEY files.   
CREATE SUBDIRS              Creates the default directories within the Oracle GoldenGate home directory. 
DEFAULTJOURNAL              Sets a default journal for multiple tables or files for the ADD   
                            TRANDATA command when used for a DB2 for i database.   
FC                          Allows the modification and re-execution of a previously issued   
                            Provides assistance with syntax and usage of GGSCI commands.   
HISTORY                     Shows a list of the most recently issued commands since the   
                            startup of the GGSCI session.   
INFO ALL                    Displays status and lag for all Oracle GoldenGate processes on   
                            a system.   
OBEY                        Processes a file that contains a list of Oracle GoldenGate commands. 
SHELL                       Executes shell commands from within the GGSCI interface.   
SHOW                        Displays the attributes of the Oracle GoldenGate environment.   
VERSIONS                    Displays information about the operating system and database.   
VIEW GGSEVT                 Displays the Oracle GoldenGate error log (ggserr.logfile).   
VIEW REPORT                 Displays the process report or the discard file that is generated   
                            by Extract or Replicat.   
 

For help on a specific command, type HELP <command> <object>.

Example: HELP ADD REPLICAT

GGSCI (localhost.localdomain) 2>

To get help of specific command you can apply help command with that specific command

For example :

GGSCI (localhost.localdomain) 2> help add extract

 
Use ADD EXTRACT to create an Extract group. Unless a SOURCEISTABLE task or  
an alias Extract is specified, ADD EXTRACT creates an online group that uses  
checkpoints so that processing continuity is maintained from run to run.  
 
For DB2 for i, this command establishes a overall start point for all journals  
and is a required first step. After issuing the ADD EXTRACT command, you can  
then optionally position any given journal at a specific journal sequence  
number by using the ALTER EXTRACT command with an appropriate journal option.  
 
Oracle GoldenGate supports up to 5,000 concurrent Extract and Replicat  
groups per instance of Oracle GoldenGate Manager. At the supported level,  
all groups can be controlled and viewed in full with GGSCI commands such  
as the INFO and STATUS commands. Oracle GoldenGate recommends keeping the  
combined number of Extract and Replicat groups at the default level of  
300 or below in order to manage your environment effectively.  
 
This command cannot exceed 500 bytes in size for all keywords and input,  
including any text that you enter for the DESC option.  
 
Syntax for a Regular, Passive, or Data Pump Extract  
 
ADD EXTRACT group_name 
{, SOURCEISTABLE | 
   , TRANLOG [bsds_name | LRI_number] | 
   , INTEGRATED TRANLOG | 
   , VAM | 
   , EXTFILESOURCE file_name | 
   , EXTTRAILSOURCE trail_name | 
   , VAMTRAILSOURCE VAM_trail_name} 
 BEGIN {NOW | yyyy-mm-dd[ hh:mi:[ss[.cccccc]]]} | 
 EXTSEQNO sequence_number, EXTRBA relative_byte_address | 
 EOF | 
 LSN [value] | 
 EXTRBA relative_byte_address | 
 EOF | LSN value | 
 PAGE data_page, ROW row_ID | 
 SEQNO sequence_number 
 SCN value 
 THREADS [n] 
 PASSIVE 
 PARAMS file_name 
 REPORT file_name 
 DESC 'description' 
 SOCKSPROXY {host_name | IP_address}[:port] [PROXYCSALIAS credential_store_alias 
[PROXYCSDOMAIN credential_store_domain]]] 
 RMTNAME passive_Extract_name] 
 DESC [description] 
} 
 
group_name  
 
The name of the Extract group. The name of an Extract group can contain  
up to eight characters. See for group naming conventions. See Administering  
Oracle GoldenGate for group naming conventions. 
 
SOURCEISTABLE  
 
Creates an Extract task that extracts entire records from the database  
for an initial load using the Oracle GoldenGate direct load method or  
the direct bulk load to SQL*Loader method. If SOURCEISTABLE is not  
specified, ADD EXTRACT creates an online change-synchronization process,  
and one of the other data source options must be specified. When using  
SOURCEISTABLE, do not specify any service options. Task parameters  
must be specified in the parameter file.  
 
For more information about initial load methods, see Administering Oracle  
GoldenGate.  
 
TRANLOG [bsds_name| LRI_NUMBER]  
 
Specifies the transaction log as the data source. Use this option for all  
databases except Teradata. TRANLOG requires the BEGIN option.  
 
(DB2 on z/OS) You can use the bsds_name option for DB2 on a z/OS system to  
specify the Bootstrap Data Set file name of the transaction log, though it  
is not required and is not used. You do not need to change existing TRANLOG  
parameters.  
 
(DB2 LUW) You can use the LRI_NUMBER option for DB2 LUW systems to specify  
the LRI record value for the checkpoint transaction log.  
 
(Oracle) As of Oracle Standard or Enterprise Edition 11.2.0.3, this mode  
is known as classic capture mode. Extract reads the Oracle redo logs  
directly. See INTEGRATED TRANLOG for an alternate configuration.  
 
 
INTEGRATED TRANLOG  
 
(Oracle) Adds this Extract in integrated capture mode. In this mode, Extract  
integrates with the database logmining server, which passes logical change  
records (LCRs) directly to Extract. Extract does not read the redo log. Before  
using INTEGRATED TRANLOG, use the REGISTER EXTRACT command. For information  
about integrated capture, see the Oracle GoldenGate documentation for your database. 
 
VAM  
 
(MySQL and Teradata) Specifies that the Extract API known as the  
Vendor Access Module (VAM) will be used to transfer change data to Extract.  
 
EXTFILESOURCE file_name  
 
Specifies an extract file as the data source. Use this option with a secondary  
Extract group (data pump) that acts as an intermediary between a primary  
Extract group and the target system.  
 
For file_name, specify the relative or fully qualified path name of the file,  
for example dirdat/extfile or c:\ggs\dirdat\extfile.  
 
EXTTRAILSOURCE trail_name  
 
Specifies a trail as the data source. Use this option with a secondary Extract  
group (data pump) that acts as an intermediary between a primary Extract group  
and the target system.  
 
For trail_name, specify the relative or fully qualified path name of the trail,  
for example dirdat/aa or c:\ggs\dirdat\aa.  
 
VAMTRAILSOURCE VAM_trail_name  
(Teradata) Specifies a VAM trail. Use this option when using Teradata maximum  
protection mode.  
 
For VAM_trail_name, specify the relative or fully qualified path name of the VAM  
trail to which the primary Extract group is writing. Use a VAM-sort Extract group  
to read the VAM trail and send the data to the target system.  
 
BEGIN {NOW | yyyy-mm-dd[ hh:mi:[ss[.cccccc]]]}  
Specifies a timestamp in the data source at which to begin processing.  
     
    NOW  
 
    For all databases except DB2 LUW, NOW specifies the time at which the  
    ADD EXTRACT command is issued.  
 
    For DB2 LUW, NOW specifies the time at which START EXTRACT takes effect. It  
    positions to the first record that approximately matches the date and time.  
    This is because the only log records that contain timestamps are the commit  
    and stop transaction records, so the starting position can only be calculated  
    relative to those timestamps. This is a limitation of the API that is used  
    by Oracle GoldenGate.  
 
    Do not use NOW for a data pump Extract except to bypass data that was captured  
    to the trail prior to the ADD EXTRACT statement.  
 
    yyyy-mm-dd[ hh:mi:[ss[.cccccc]]]  
 
    A date and time (timestamp) in the given form. For an Oracle Extract in  
    integrated mode, the timestamp value must be greater than the timestamp at  
    which the Extract was registered with the database.  
     
    * Positioning by timestamp in a SQL Server transaction log is affected by  
    the following characteristics of SQL Server:  
 
      - The timestamps recorded in the SQL Server transaction log use a 3.333  
      microsecond (ms) granularity. This level of granularity may not allow  
      positioning by time between two transactions, if the transactions began  
      in the same 3.333 ms time interval.  
 
      - Timestamps are not recorded in every SQL Server log record, but only in  
      the records that begin and commit the transaction, as well as some others  
      that do not contain data.  
 
      - SQL Server timestamps are not from the system clock, but instead are  
      from an internal clock that is specific to the individual processors in use.  
      This clock updates several times a second, but between updates it could get  
      out of sync with the system clock. This further reduces the precision of  
      positioning by time.  
 
      - Timestamps recorded for log backup files may not precisely correspond to  
      times recorded inside the backup (however this imprecision is less than a  
      second).  
 
    Positioning to an LSN is precise. 
 
EXTSEQNO sequence_number, EXTRBA relative_byte_address  
 
Valid for a primary Extract in classic capture mode for Oracle and a data pump  
Extract. Not supported for an Oracle Extract in integrated mode. Specifies  
either of the following:  
 
* sequence number of an Oracle redo log and RBA within that log at which  
to begin capturing data.  
 
* the file in a trail in which to begin capturing data (for a data pump).  
Specify the sequence number, but not any zeroes used for padding. For  
example, if the trail file is c:\ggs\dirdat\aa000026, you would specify  
EXTSEQNO 26. By default, processing begins at the beginning of a trail  
unless this option is used.  
 
Contact Oracle Support before using this option. For more information, go to  
http://support.oracle.com. 
 
EXTRBA relative_byte_address  
 
Valid for DB2 on z/OS. Specifies the relative byte address within a transaction  
log at which to begin capturing data. The required format is 0Xnnn, where  
nnn is a 1 to 20 digit hexadecimal number (the first character is the digit  
zero, and the second character can be upper or lower case letter x).  
 
EOF  
 
Valid for SQL Server and DB2 for i. Configures processing to start at the end  
of the log files (or journals) that the next record will be written to. Any  
active transactions will not be captured.  
 
LSN [value]  
 
Valid for SQL Server. Specifies the LSN in a transaction log  
at which to start capturing data. The specified LSN should exist in a log  
backup or the online log. An alias for this option is EXTLSN.  
 
For SQL Server, an LSN is composed of one of these, depending on how the  
database returns it:  
 
* Colon separated hex string (8:8:4) padded with leading zeroes and 0X prefix,  
as in 0X00000d7e:0000036b:01bd  
 
* Colon separated decimal string (10:10:5) padded with leading zeroes,  
as in 0000003454:0000000875:00445  
 
* Colon separated hex string with 0X prefix and without leading zeroes,  
as in 0Xd7e:36b:1bd  
 
* Colon separated decimal string without leading zeroes, as in 3454:875:445  
 
* Decimal string, as in 3454000000087500445  
 
 
In the preceding, the first value is the virtual log file number, the  
second is the segment number within the virtual log, and the third is  
the entry number. You can find the LSN for named transactions by using  
a query like:  
select [Current LSN], [Transaction Name], [Begin Time] from fn_dblog(null, null)  
where Operation = 'LOP_BEGIN_XACT' and [Begin Time] = 'time'  
 
The time format that you should use in the query should be similar to  
'2015/01/30 12:00:00.000' and not '2017-01-30 12:00:00.000'.  
 
You can determine the time that a particular transaction started, then find  
the relevant LSN, and then position between two transactions with the same  
begin time.  
 
EOF | LSN [value]  
 
Valid for DB2 LUW. Specifies a start position in the transaction logs when  
Extract starts.  
 
    EOF  
 
    Configures processing to start at the active LSN in the log files. The  
    active LSN is the position at the end of the log files that the next  
    record will be written to. Any active transactions will not be captured.  
 
    LSN [value]  
 
    Configures processing to start at an exact LSN if a valid log record  
    exists there. If one does not exist, Extract will abend. Note that,  
    although Extract might position to a given LSN, that LSN might not  
    necessarily be the first one that Extract will process. There are  
    numerous record types in the log files that Extract ignores, such as  
    DB2 internal log records. Extract will report the actual starting LSN  
    to the Extract report file.  
 
SEQNO sequence_number  
 
Valid for DB2 for i. Starts capture at, or just after, a system sequence  
number, which is a decimal number up to 20 digits in length.  
 
SCN [value]  
 
Valid for Oracle. Starts Extract at the transaction in the redo log  
that has the specified Oracle system change number (SCN). This option  
is valid for Extract both in classic capture and integrated modes. For  
Extract in integrated mode, the SCN value must be greater than the SCN  
at which the Extract was registered with the database. For more  
information, see REGISTER EXTRACT. 
 
PARAMS file_name  
 
Specifies the full path name of an Extract parameter file in a location  
other than the default of dirprm within the Oracle GoldenGate directory.  
 
REPORT file_name  
 
Specifies the full path name of an Extract report file in a location other  
than the default of dirrpt within the Oracle GoldenGate directory.  
 
THREADS [n]  
 
Valid for Oracle classic capture mode. Specifies the number of producer  
threads that Extract maintains to read redo logs.  
 
Required in an Oracle RAC configuration to specify the number of producer  
threads. These are the Extract threads that read the different redo logs  
on the various RAC nodes. The value must be the same as the number of nodes  
from which you want to capture redo data.  
 
 
PASSIVE  
 
Specifies that this Extract group runs in passive mode and can only be  
started and stopped by starting or stopping an alias Extract group on  
the target system. Source-target connections will be established not  
by this group, but by the alias Extract from the target.  
 
This option can be used for a regular Extract group or a data-pump  
Extract group. It should only be used by whichever Extract on the  
source system is the one that will be sending the data across the  
network to a remote trail on the target.  
 
For instructions on how to configure passive and alias Extract groups,  
see Administering Oracle GoldenGate.  
 
DESC 'description'  
 
Specifies a description of the group, such as 'Extracts account_tab on  
Serv1'. Enclose the description within single quotes. You may use the  
abbreviated keyword DESC or the full word DESCRIPTION.  
 
SOCKSPROXY{host_name| IP_address}[:port] [PROXYCSALIAS credential_store_alias 
[PROXYCSDOMAINcredential_store_domain]  
 
Use for an alias Extract. Specifies the DNS host name or IP address of the  
proxy server. You can use either one to define the host though you must use  
the IP address if your DNS server is unreachable. If you are using an IP  
address, use either an IPv6 or IPv4 mapped address, depending on the stack  
of the destination system. You must specify the PROXYCSALIAS. In addition,  
you can specify the port to use, and the credential store domain.  
 
RMTNAME passive_extract_name  
 
Use for an alias Extract. Specifies the passive Extract name, if different  
from that of the alias Extract.  
 
Examples  
 
Example 1  
 
The following creates an Extract group named finance that extracts database  
changes from the transaction logs. Extraction starts with records generated  
at the time when the group was created with ADD EXTRACT.  
 
ADD EXTRACT finance, TRANLOG, BEGIN NOW  
 
Example 2  
 
The following creates an Extract group named finance that extracts database  
changes from Oracle RAC logs. Extraction starts with records generated at  
the time when the group was created. There are four RAC instances, meaning  
there will be four Extract threads.  
 
ADD EXTRACT finance, TRANLOG, BEGIN NOW, THREADS 4  
 
Example 3  
 
The following creates an Extract group named finance that extracts database  
changes from the transaction logs. Extraction starts with records generated  
at 8:00 on January 21, 2011.  
 
ADD EXTRACT finance, TRANLOG, BEGIN 2017-01-21 08:00  
 
Example 4  
 
The following creates an integrated capture Extract group.  
ADD EXTRACT finance, INTEGRATED TRANLOG, BEGIN NOW  
 
Example 5  
 
The following creates an Extract group named finance that interfaces with  
a Teradata TAM in either maximum performance or maximum protection mode.  
No BEGIN point is used for Teradata sources.  
 
ADD EXTRACT finance, VAM  
 
Example 6  
 
The following creates a VAM-sort Extract group named finance. The process  
reads from the VAM trail /ggs/dirdat/vt.  
 
ADD EXTRACT finance, VAMTRAILSOURCE dirdat/vt  
 
Example 7  
 
The following creates a data-pump Extract group named finance. It reads  
from the Oracle GoldenGate trail c:\ggs\dirdat\lt.  
 
ADD EXTRACT finance, EXTTRAILSOURCE dirdat/lt  
 
Example 8  
 
The following creates an initial-load Extract named load.  
 
ADD EXTRACT load, SOURCEISTABLE  
 
Example 9  
 
The following creates a passive Extract group named finance that extracts  
database changes from the transaction logs.  
 
ADD EXTRACT finance, TRANLOG, BEGIN NOW, PASSIVE  
 
Example 10  
 
The following creates an alias Extract group named financeA. The alias  
Extract is associated with a passive extract named finance on source system  
sysA. The Manager on that system is using port 7800.  
 
ADD EXTRACT financeA, RMTHOST sysA, MGRPORT 7800, RMTNAME finance  
 
Example 11  
 
The following examples create and position Extract at a specific Oracle  
system change number (SCN) in the redo log.  
 
ADD EXTRACT finance TRANLOG SCN 123456  
ADD EXTRACT finance INTEGRATED TRANLOG SCN 123456  
 
 
Example 12  
 
The following example creates an alias Extract specifying the host to use.  
 
ADD EXTRACT apmp desc "alias extract" RMTHOST lc01abc MGRPORT 7813 RMTNAME  
ppmp SOCKSPROXY lc02def:3128 PROXYCSALIAS proxyAlias  
 
Example 13  
 
The following example creates an Extract on a DB2 LUW system.  
 
ADD EXTRACT extcust, TRANLOG LRI 8066.322711  
 


GGSCI (localhost.localdomain) 3> 

You will find all the details regarding your command with examples.

Let us see some examples of ggsci commands :

1. Let’s try adding an extract file :

GGSCI (localhost.localdomain) 4> add extract ext1, tranlog begin now    
EXTRACT added.

2. “!” the sign is used to repeat any command we have applied previously

GGSCI (localhost.localdomain) 5> !
add extract ext1, tranlog begin now
ERROR: EXTRACT EXT1 already exists.

We have already added extract so it gives me an error when I used ! sign as it repeats the command previously given.

3. Stopping and Starting manager of Golden Gate

GGSCI (localhost.localdomain) 6> stop manager
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)?Y

Sending STOP request to MANAGER ...
Request processed.
Manager stopped.


GGSCI (localhost.localdomain) 7> Start Manager
Manager started.


GGSCI (localhost.localdomain) 8>

4. Get details of specific extract group

GGSCI (localhost.localdomain) 10> info extract ext1 , detail

EXTRACT    EXT1      Initialized   2018-09-18 11:28   Status STOPPED
Checkpoint Lag       00:00:00 (updated 00:02:49 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2018-09-18 11:28:32  Seqno 0, RBA 0
                     SCN 0.0 (0)
                     *** No TARGETEXTTRAILS specified yet ***

  Extract Source                          Begin             End             

  Not Available                           * Initialized *   2018-09-18 11:28


Current directory    /u02/ggate

Report file          /u02/ggate/dirrpt/EXT1.rpt (does not yet exist)
Parameter file       /u02/ggate/dirprm/ext1.prm (does not yet exist)
Checkpoint file      /u02/ggate/dirchk/EXT1.cpe
Process file         /u02/ggate/dirpcs/EXT1.pce
Error log            /u02/ggate/ggserr.log


GGSCI (localhost.localdomain) 11>

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.