Use 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 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

• Performance Metrics Service

• VIEW REPORT command.

• 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 Oracle GoldenGate command line) 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:

    REPLICA 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, or INFO REPLICAT commands.