Retrieve Messages
get
/services/{version}/messages
Retrieve messages from the Oracle GoldenGate deployment.
Request
Path Parameters
-
version: string
Oracle GoldenGate Service API version.
Allowed Values:[ "v2" ]
Response
Supported Media Types
- application/json
200 Response
All messages issued by the Oracle GoldenGate deployment retrieved.
Root Schema : Oracle GoldenGate Messages
Type:
object
Title:
Oracle GoldenGate Messages
Messages issued by Oracle GoldenGate processes
Show Source
-
$schema:
Allowed Values:
[ "ogg:messages" ]
-
messages:
array messages
Minimum Number of Items:
0
Maximum Number of Items:2147483647
Nested Schema : messages
Type:
array
Minimum Number of Items:
0
Maximum Number of Items:
Show Source
2147483647
-
[0]:
string
Minimum Length:
0
Maximum Length:4095
Example Response (application/json)
{
"$schema":"api:standardResponse",
"links":[
{
"href":"http://localhost:11001/services/v2/messages",
"mediaType":"application/json",
"rel":"canonical"
},
{
"href":"http://localhost:11001/services/v2/messages",
"mediaType":"application/json",
"rel":"self"
},
{
"href":"http://localhost:11001/services/v2/metadata-catalog/messages",
"mediaType":"application/schema+json",
"rel":"describedby"
}
],
"messages":[
],
"response":{
"$schema":"ogg:messages",
"messages":[
"2017-12-14T12:41:48.379+0000 INFO OGG-01851 Oracle GoldenGate Distribution Server for Oracle: filecaching started: thread ID: 140617734678272.",
"2017-12-14T12:41:48.393+0000 INFO OGG-01815 Oracle GoldenGate Distribution Server for Oracle: Virtual Memory Facilities for: COM",
" anon alloc: mmap(MAP_ANON) anon free: munmap",
" file alloc: mmap(MAP_SHARED) file free: munmap",
" target directories:",
" /u02/ogg/Local/var/temp/.",
"2017-12-14T12:42:16.432+0000 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, EXT2.prm: EXTRACT EXT2 starting.",
"2017-12-14T12:42:16.433+0000 INFO OGG-03059 Oracle GoldenGate Capture for Oracle, EXT2.prm: Operating system character set identified as US-ASCII.",
"2017-12-14T12:42:16.433+0000 INFO OGG-02695 Oracle GoldenGate Capture for Oracle, EXT2.prm: ANSI SQL parameter syntax is used for parameter parsing.",
"2017-12-14T12:42:16.438+0000 INFO OGG-01360 Oracle GoldenGate Capture for Oracle, EXT2.prm: EXTRACT is running in Integrated mode.",
"2017-12-14T12:42:16.602+0000 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, EXT2.prm: Setting session time zone to source database time zone 'GMT'.",
"2017-12-14T12:42:16.611+0000 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, EXT2.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint.",
"2017-12-14T12:42:16.617+0000 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, EXT2.prm: Virtual Memory Facilities for: BR",
" anon alloc: mmap(MAP_ANON) anon free: munmap",
" file alloc: mmap(MAP_SHARED) file free: munmap",
" target directories:",
" /u02/ogg/Local/var/run/BR/EXT2.",
"2017-12-14T12:42:16.637+0000 INFO OGG-01851 Oracle GoldenGate Capture for Oracle, EXT2.prm: filecaching started: thread ID: 139990793692928.",
"2017-12-14T12:42:16.643+0000 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, EXT2.prm: Virtual Memory Facilities for: COM",
" anon alloc: mmap(MAP_ANON) anon free: munmap",
" file alloc: mmap(MAP_SHARED) file free: munmap",
" target directories:",
" /u02/ogg/Local/var/temp.",
"2017-12-14T12:42:16.742+0000 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, EXT2.prm: Setting session time zone to source database time zone 'GMT'.",
"2017-12-14T12:42:17.320+0000 INFO OGG-06604 Oracle GoldenGate Capture for Oracle, EXT2.prm: Database ORCL CPU info: CPU Count 40, CPU Core Count 20, CPU Socket Count 2.",
"2017-12-14T12:42:31.576+0000 INFO OGG-02248 Oracle GoldenGate Capture for Oracle, EXT2.prm: Logmining server DDL filtering enabled.",
"2017-12-14T12:42:36.106+0000 INFO OGG-02068 Oracle GoldenGate Capture for Oracle, EXT2.prm: Integrated capture successfully attached to logmining server OGG$CAP_EXT2 using OGGCapture API.",
"2017-12-14T12:42:36.106+0000 INFO OGG-02089 Oracle GoldenGate Capture for Oracle, EXT2.prm: Source redo compatibility version is: 12.2.0.",
"2017-12-14T12:42:36.106+0000 INFO OGG-02086 Oracle GoldenGate Capture for Oracle, EXT2.prm: Integrated Dictionary will be used.",
"2017-12-14T12:42:36.338+0000 WARNING OGG-02905 Oracle GoldenGate Capture for Oracle, EXT2.prm: Replication of OID column in object tables may diverge.",
"2017-12-14T12:42:36.350+0000 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, EXT2.prm: EXTRACT EXT2 started.",
"2017-12-14T12:42:36.351+0000 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, EXT2.prm: No recovery is required for target file X2000000000, at RBA 0 (file not opened).",
"2017-12-14T12:42:36.351+0000 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, EXT2.prm: Output file X2 is using format RELEASE 12.3.",
"2017-12-14T12:42:36.765+0000 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, EXT2.prm: Setting session time zone to source database time zone 'GMT'.",
"2017-12-14T12:43:10.000+0000 INFO OGG-02557 Oracle GoldenGate Capture for Oracle, EXT2.prm: Heartbeat table OGGADMIN.GG_HEARTBEAT_SEED metadata is resolved and will write to trail file X2.",
"2017-12-14T12:43:39.980+0000 INFO OGG-01971 Oracle GoldenGate Capture for Oracle, EXT2.prm: The previous message, 'INFO OGG-02557', repeated 1 times.",
"2017-12-14T12:43:48.149+0000 INFO OGG-01021 Oracle GoldenGate Capture for Oracle, EXT2.prm: Command received from REST API: STATS HOURLY.",
"2017-12-14T12:43:51.162+0000 INFO OGG-01021 Oracle GoldenGate Capture for Oracle, EXT2.prm: Command received from GGSCI: STOP.",
"2017-12-14T12:43:51.170+0000 INFO OGG-00991 Oracle GoldenGate Capture for Oracle, EXT2.prm: EXTRACT EXT2 stopped normally.",
"2017-12-14T12:43:58.636+0000 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, REP2.prm: REPLICAT REP2 starting.",
"2017-12-14T12:43:58.638+0000 INFO OGG-03059 Oracle GoldenGate Delivery for Oracle, REP2.prm: Operating system character set identified as US-ASCII.",
"2017-12-14T12:43:58.638+0000 INFO OGG-02695 Oracle GoldenGate Delivery for Oracle, REP2.prm: ANSI SQL parameter syntax is used for parameter parsing.",
"2017-12-14T12:43:59.091+0000 INFO OGG-06451 Oracle GoldenGate Delivery for Oracle, REP2.prm: Triggers will be suppressed by default.",
"2017-12-14T12:43:59.105+0000 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, REP2.prm: Virtual Memory Facilities for: COM",
" anon alloc: mmap(MAP_ANON) anon free: munmap",
" file alloc: mmap(MAP_SHARED) file free: munmap",
" target directories:",
" /u02/ogg/Local/var/temp.",
"2017-12-14T12:43:59.116+0000 INFO OGG-06604 Oracle GoldenGate Delivery for Oracle, REP2.prm: Database ORCL CPU info: CPU Count 40, CPU Core Count 20, CPU Socket Count 2.",
"2017-12-14T12:43:59.182+0000 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, REP2.prm: REPLICAT REP2 started.",
"2017-12-14T12:43:59.183+0000 INFO OGG-02243 Oracle GoldenGate Delivery for Oracle, REP2.prm: Opened trail file /u02/ogg/Local/var/lib/data/X2000000000 at 2017-12-14 12:43:59.183357.",
"2017-12-14T12:43:59.184+0000 INFO OGG-03522 Oracle GoldenGate Delivery for Oracle, REP2.prm: Setting session time zone to source database time zone 'GMT'.",
"2017-12-14T12:43:59.184+0000 INFO OGG-03506 Oracle GoldenGate Delivery for Oracle, REP2.prm: The source database character set, as determined from the trail file, is UTF-8.",
"2017-12-14T12:43:59.187+0000 INFO OGG-02756 Oracle GoldenGate Delivery for Oracle, REP2.prm: The definition for table OGGADMIN.GG_HEARTBEAT_SEED is obtained from the trail file.",
"2017-12-14T12:44:44.514+0000 INFO OGG-01021 Oracle GoldenGate Delivery for Oracle, REP2.prm: Command received from REST API: STATS HOURLY."
]
}
}