Using the Process Report

Use the process report to view (depending on the process):

  • parameters in use

  • table and column mapping

  • database information

  • runtime messages and errors

  • runtime statistics for the number of operations processed

Every Extract, Replicat, and Manager process generates a report file. The report can help you diagnose problems that occurred during the run, such as invalid mapping syntax, SQL errors, and connection errors.

To view a process report, use any of the following:

  • standard shell command for viewing a text file

  • Oracle GoldenGate Monitor

  • VIEW REPORT command in GGSCI.

  • To view information if a process abends without generating a report, use the following command to run the process from the command shell of the operating system (not GGSCI) to send the information to the terminal.

    process paramfile path.prm

    Where:

    • The value for process is either extract or replicat.

    • The value for path.prm is the fully qualified name of the parameter file, for example: 

      replicat paramfile /ogg/dirdat/repora.prm

By default, reports have a file extension of .rpt, for example EXTORA.rpt. The default location is the dirrpt sub-directory of the Oracle GoldenGate directory. However, these properties can be changed when the group is created. Once created, a report file must remain in its original location for Oracle GoldenGate to operate properly after processing has started.

To determine the name and location of a process report, use the INFO EXTRACT, INFO REPLICAT, or INFO MANAGER command in GGSCI.