Oracle GoldenGate – Process Report File, ggserr.log File, Error and System Log

Process Report Files

  • Process reports (depending on the process) enable you to view the following:
    – Parameters in use
    – Table and column mapping
    – Database information
    – Run time messages and errors
    – Run time statistics for the number of operations processed
  • These reports can be viewed with:
    – Browser using the MA Administration Server
    – View Report command using adminclient (MA) or GGSCI (CA)
    – Any text editor
    – Oracle Management Pack for Oracle GoldenGate
  • The reports are located by default in the following directories:
    – MA: $OGG_VAR_HOME/lib/report/
    – CA: $OGG_HOME/dirrpt

Using ggserr.log Error Log

  • You can use the Oracle GoldenGate error log to view the following:
    – A history of GGSCI commands
    – The Oracle GoldenGate processes that started and stopped
    – The processing that was performed
    – The errors that occurred
    – Informational and warning messages

Because the error log shows events as they occurred in sequence, it is a good tool for detecting the cause (or causes) of an error. For example, you might discover that someone stopped a process or a process failed to make a TCP/IP or database connection.

  • To view the error log, use any of the following:
  • A standard shell command to view the ggserr.log file
  • Oracle Management Pack for Oracle GoldenGate ( Oracle GoldenGate Plug-in for EMCC and/or Oracle GoldenGate Monitor)
  • The View GGSEVT command in GGSCI (CA) or the adminclient (MA)
    -An external table

The ggserr.log is located in the following default directories:
– MA: $OGG_VAR_HOME/log/ggserr.log
– CA: $LOG_HOME/ggserr.log

Using the System Logs

Oracle GoldenGate writes errors that are generated at the level of the operating system:
– Event Viewer on Windows
– syslog on UNIX and LINUX

The Oracle GoldenGate errors that appears in the system logs also appear in the Oracle GoldenGate error log.
Use the ogg-ggserr.xml ggserr.Syslog parameter to control the types of messages that Oracle GoldenGate sends to the system logs on a Windows or Unix system.

By using the ggserr parameter, messages can be filtered to:
– ggserr.Standard (default). All applications write to the file, ggserr.log
– ggserr.Legacy. All applications write to the file, ggserr.log
– ggserr.Syslog. Application messages are sent to the local system log.
– ggserr.None. Application messages are discarded.

The ogg-ggserr.xml file is located in the following default directories:
– MA: $OGG_ETC_HOME/logging/ogg-ggserr.xml
– CA: $OGG_HOME/direct/ogg-ggserr.xml

Obtaining Process Information using adminclient or GGSCI

Commands:

* Info {Extract | Replicat } <group> [Detail]
* Info Manager (Only CA)
* Info All
* Stats {Extract | Replicat} <group>
* Status {Extract | Replicat} <group>
* Status Manager (Only CA)
* Lag {Extract | Replicat} <group>
* Info {ExtTrail | RmtTrail} <path_name>
* Send Manager (Only CA)
* Send {Extract | Replicat}
* View Report <group>
* View GGSEvt
* <command> ER <wildcard>

Share This

Muhammad Rawish Siddiqui

Master in Computer Science (Database Engineering) and PGD in Management Information System.
45+ Online Certifications, which includes EDRP (EC-Council Disaster Recovery Professional), Data Management, Security+, DBaaS - Cloud Certified Expert, Oracle Cloud Autonomous Database Specialist, Oracle Database Cloud Certified Professional, Oracle Cloud Infrastructure, OCP 7.3, 10g, 11g, 11i, R12, OCE/OCS 11i System Administration, Solaris, Linux and Real Application Cluster 10g, 11g, Oracle Autonomous Database, Real Application Cluster, Oracle Data Guard and Performance Tuning etc. .

Foremost interested areas include, Data Management, Oracle Databases and EBS Health Checks, Real Application Cluster, Disaster Recovery, GoldenGate and Oracle Cloud.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments