Details for GoldenGate
Logging details for GoldenGate logs.
Resources
- GoldenGate deployments
Log Categories
API value (ID): | Console (Display Name) | Description |
---|---|---|
process_logs | Process | Contains content from several log files for the Administration Service, Distribution Service, Performance Metrics Service, Receiver Service, and Extract/Replicate Events. |
error_logs | Error | Contains content from the ggserr.log file that logs processing events, messages, errors, and warnings generated by GoldenGate. |
Availability
GoldenGate logging is available in all the regions of the commercial realms.
Comments
You can enable Process and Error logs for a particular deployment.
Contents of GoldenGate Process and Error Logs
Property | Description |
---|---|
level | Log level of the message, such as INFO, DEBUG, ERROR. |
message | Describes the event details. |
processName | (Process Logs only) Name of the Oracle GoldenGate process writing to the log. |
resourceId | GoldenGate deployment OCID. |
Example GoldenGate Process Log
{
"ts": "2023-05-25T09:27:28.219Z",
"source": "ocid1.goldengatedeployment.oc1.us-sanjose-1.<unique_ID>",
"id": "<unique_ID>.<unique_ID>",
"oracle": {
"compartmentid": "ocid1.compartment.oc1..<unique_ID>",
"logid": "ocid1.log.oc1.us-sanjose-1.<unique_ID>"
},
"specversion": "1.0",
"type": "com.oraclecloud.goldengate.deployment.process_logs",
"data": {
"message": "Rollback transaction 0x00002987",
"level": "WARN",
"resourceId": "ocid1.goldengatedeployment.oc1.us-sanjose-1.<unique_ID>",
"processName": "pmsrvr"
}
}
{
"time": "2023-05-25T09:21:05.192Z",
"source": "ocid1.goldengatedeployment.oc1.us-sanjose-1.<unique_ID>",
"id": "<unique_ID>.<unique_ID>",
"oracle": {
"compartmentid": "ocid1.compartment.oc1..<unique_ID>",
"logid": "ocid1.log.oc1.us-sanjose-1.<unique_ID>"
},
"specversion": "1.0",
"type": "com.oraclecloud.goldengate.deployment.process_logs",
"data": {
"message": "CSRFTokenProtection: ENABLED.\nCross-Site Request Forgery checks using CSRF-Tokens will be performed.",
"level": "INFO",
"resourceId": "ocid1.goldengatedeployment.oc1.us-sanjose-1.<unique_ID>",
"processName": "distsrvr"
}
}
Example GoldenGate Error Log
{
"time": "2023-05-25T09:22:48.202Z",
"source": "ocid1.goldengatedeployment.oc1.us-sanjose-1.<unique_ID>",
"id": "<unique_ID>.<unique_ID>",
"oracle": {
"compartmentid": "ocid1.compartment.oc1..<unique_ID>",
"logid": "ocid1.log.oc1.us-sanjose-1.<unique_ID>"
},
"specversion": "1.0",
"type": "com.oraclecloud.goldengate.deployment.error_logs",
"data": {
"message": "INFO OGG-03541 Oracle GoldenGate Capture for Oracle: Oracle Environment Variables: \nTNS_ADMIN = /u02/Deployment/etc\nLD_LIBRARY_PATH =
/usr/lib64/<user_ID>/test-ee-java8/jre/lib/amd64/server:/usr/lib64/<user_ID>/test-ee-java8/jre/lib/amd64/server:.",
"level": "INFO",
"resourceId": "ocid1.goldengatedeployment.oc1.us-sanjose-1.<unique_ID>"
}
}
{
"time": "2023-05-25T09:22:48.815Z",
"source": "ocid1.goldengatedeployment.oc1.us-sanjose-1.<unique_ID>",
"id": "<unique_ID>.<unique_ID>",
"oracle": {
"compartmentid": "ocid1.compartment.oc1..<unique_ID>",
"logid": "ocid1.log.oc1.us-sanjose-1.<unique_ID>"
},
"specversion": "1.0",
"type": "com.oraclecloud.goldengate.deployment.error_logs",
"data": {
"message": "ERROR OGG-00053 Oracle GoldenGate Capture for Oracle: No extraction maps specified.",
"level": "ERROR",
"resourceId": "ocid1.goldengatedeployment.oc1.us-sanjose-1.<unique_ID>"
}
}