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.