Oracle GoldenGate 23ai Microservices Architecture REST API Documentation

Retrieve Messages

get

/services/{version}/messages

Required Role: User

Retrieve messages from the Oracle GoldenGate deployment.

Request

Path Parameters

version(required): 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(required): array messages

Minimum Number of Items: 0

Maximum Number of Items: 2147483647

{
    "title":"Oracle GoldenGate Messages",
    "description":"Messages issued by Oracle GoldenGate processes",
    "required":[
        "messages"
    ],
    "type":"object",
    "properties":{
        "$schema":{
            "enum":[
                "ogg:messages"
            ]
        },
        "messages":{
            "type":"array",
            "items":{
                "type":"string",
                "minLength":"0",
                "maxLength":"4095"
            },
            "minItems":"0",
            "maxItems":"2147483647"
        }
    },
    "additionalProperties":false
}

Nested Schema : messages

Type: array

Minimum Number of Items: 0

Maximum Number of Items: 2147483647

Show Source

Array of: string

Minimum Length: 0

Maximum Length: 4095

{
    "type":"array",
    "items":{
        "type":"string",
        "minLength":"0",
        "maxLength":"4095"
    },
    "minItems":"0",
    "maxItems":"2147483647"
}

Example Response (application/json)

{
    "$schema":"api:standardResponse",
    "links":[
        {
            "href":"http://localhost:9012/services/v2/messages",
            "mediaType":"application/json",
            "rel":"canonical"
        },
        {
            "href":"http://localhost:9012/services/v2/messages",
            "mediaType":"application/json",
            "rel":"self"
        },
        {
            "href":"http://localhost:9012/services/v2/metadata-catalog/messages",
            "mediaType":"application/schema+json",
            "rel":"describedby"
        }
    ],
    "messages":[
    ],
    "response":{
        "$schema":"ogg:messages",
        "messages":[
            "2024-04-03T22:33:10.115+0000  INFO    OGG-01851  Oracle GoldenGate Distribution Service for Oracle:  filecaching started: thread ID: 140610444646144.",
            "2024-04-03T22:33:10.140+0000  INFO    OGG-01815  Oracle GoldenGate Distribution Service 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/Deployment/var/temp/.",
            "2024-04-03T22:33:17.212+0000  INFO    OGG-25701  Oracle GoldenGate Distribution Service for Oracle:  The file caching thread was shutdown. Thread ID: 140610444646144.",
            "2024-04-03T22:33:17.381+0000  INFO    OGG-01851  Oracle GoldenGate Distribution Service for Oracle:  filecaching started: thread ID: 139832057325312.",
            "2024-04-03T22:33:17.382+0000  INFO    OGG-01815  Oracle GoldenGate Distribution Service 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/Deployment/var/temp/.",
            "2024-04-03T22:33:51.573+0000  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Extract group EXTRACT EXTN starting.",
            "2024-04-03T22:33:51.573+0000  INFO    OGG-03059  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Operating system character set identified as UTF-8.",
            "2024-04-03T22:33:51.573+0000  INFO    OGG-02695  Oracle GoldenGate Capture for Oracle, EXTN.prm:  ANSI SQL parameter syntax is used for parameter parsing.",
            "2024-04-03T22:33:51.573+0000  INFO    OGG-02742  Oracle GoldenGate Capture for Oracle, EXTN.prm:  GLOBALS parameter GGSCHEMA set to 'ggadmin'. This schema contains objects that are managed by Oracle GoldenGate. Objects in this schema are not included in wildcard resolution rules. To capture objects in schema 'ggadmin', please explicitly map using a fully qualified object name.",
            "2024-04-03T22:33:51.591+0000  INFO    OGG-01360  Oracle GoldenGate Capture for Oracle, EXTN.prm:  EXTRACT is running in Integrated mode.",
            "2024-04-03T22:33:51.704+0000  INFO    OGG-03541  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Oracle Environment Variables: ",
            "                              TNS_ADMIN = /u02/Deployment/etc",
            "                              LD_LIBRARY_PATH = /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.402.b06-2.0.1.el8.x86_64/jre/lib/amd64/server:.",
            "2024-04-03T22:33:51.776+0000  INFO    OGG-06644  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Connection recovery inactive, TAF failover mode type 'SELECT' is required for connection recovery.",
            "2024-04-03T22:33:51.793+0000  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Default source catalog name dbnorth_pdb1 will be used for source table name hr.* mapping.",
            "2024-04-03T22:33:51.795+0000  INFO    OGG-02734  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Using heartbeat table from schema ggadmin.",
            "2024-04-03T22:33:51.796+0000  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, EXTN.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/Deployment/var/temp/BR/EXTN.",
            "2024-04-03T22:33:51.797+0000  INFO    OGG-01851  Oracle GoldenGate Capture for Oracle, EXTN.prm:  filecaching started: thread ID: 140218918737664.",
            "2024-04-03T22:33:51.798+0000  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, EXTN.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/Deployment/var/temp.",
            "2024-04-03T22:33:51.816+0000  INFO    OGG-25340  Oracle GoldenGate Capture for Oracle, EXTN.prm:  ",
            "                              Database Version:",
            "                              Oracle Database 23c Enterprise Edition Release 23.0.0.0.0 - Development",
            "                              Version 23.4.0.23.00.",
            "2024-04-03T22:33:51.819+0000  INFO    OGG-25341  Oracle GoldenGate Capture for Oracle, EXTN.prm:  ",
            "                              Database Language and Character Set:",
            "                              NLS_LANGUAGE     = \"AMERICAN\" ",
            "                              NLS_TERRITORY    = \"AMERICA\" ",
            "                              NLS_CHARACTERSET = \"AL32UTF8\".",
            "2024-04-03T22:33:51.824+0000  INFO    OGG-26025  Oracle GoldenGate Capture for Oracle, EXTN.prm:  ",
            "                              Database Unique Name: ORCLCDB.",
            "2024-04-03T22:33:51.824+0000  INFO    OGG-03146  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Performing output trail file scan on the trail file 'north/ea'.",
            "2024-04-03T22:33:52.053+0000  INFO    OGG-06604  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Connected to database ORCLCDB, CPU info: CPU Count 64, CPU Core Count 64, CPU Socket Count 1.",
            "2024-04-03T22:33:52.053+0000  INFO    OGG-06618  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Database ORCLCDB Platform: Linux x86 64-bit.",
            "2024-04-03T22:34:24.965+0000  INFO    OGG-02248  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Logmining server DDL filtering enabled.",
            "2024-04-03T22:34:29.937+0000  INFO    OGG-02339  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Integrated capture successfully attached to logmining server OGG$CAP_EXTN using 60 second streaming duration.",
            "2024-04-03T22:34:29.946+0000  INFO    OGG-02089  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Source redo compatibility version is: 23.0.0.",
            "2024-04-03T22:34:29.995+0000  INFO    OGG-15446  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Extract configured as OTHER_GROUPS resource group.",
            "2024-04-03T22:34:29.995+0000  INFO    OGG-02086  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Integrated Dictionary will be used.",
            "2024-04-03T22:34:30.283+0000  WARNING OGG-02905  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Replication of OID column in object tables may diverge.",
            "2024-04-03T22:34:30.283+0000  INFO    OGG-02776  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Native data capture is enabled for Oracle NUMBER data type.",
            "2024-04-03T22:34:30.283+0000  INFO    OGG-01971  Oracle GoldenGate Capture for Oracle, EXTN.prm:  The previous message, 'INFO OGG-02776', repeated 1 times.",
            "2024-04-03T22:34:30.283+0000  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Extract group EXTRACT EXTN started.",
            "2024-04-03T22:34:30.283+0000  INFO    OGG-01052  Oracle GoldenGate Capture for Oracle, EXTN.prm:  No recovery is required for target file north/ea000000000, at RBA 0 (file not opened).",
            "2024-04-03T22:34:30.283+0000  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Output file north/ea is using format RELEASE 19.1/21.1/23.1.",
            "2024-04-03T22:34:31.219+0000  INFO    OGG-01515  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Positioning to begin time 2024 M04 3 22:33:44.",
            "2024-04-03T22:34:31.219+0000  INFO    OGG-02845  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Position of first record processed Sequence 4, RBA 21241360, SCN 2065844, Time 2024 M04 3 22:33:46.",
            "2024-04-03T22:34:36.401+0000  INFO    OGG-02557  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Heartbeat table DBNORTH_PDB1.GGADMIN.GG_HEARTBEAT_SEED metadata is resolved and will write to trail file north/ea.",
            "2024-04-03T22:34:36.403+0000  WARNING OGG-30426  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Error mapping update record, because key column(s) of table DBNORTH_PDB1.GGADMIN.GG_HEARTBEAT_SEED is/are missing from the trail.",
            "2024-04-03T22:35:21.944+0000  INFO    OGG-01021  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Command received from application REST API: STATS HOURLY.",
            "2024-04-03T22:35:21.944+0000  INFO    OGG-01680  Oracle GoldenGate Capture for Oracle, EXTN.prm:  ",
            "                              Start of statistics at 2024-04-03 22:35:21.",
            "                              ",
            "                              Output to north/ea:",
            "                              ",
            "                              Extracting from DBNORTH_PDB1.GGADMIN.GG_HEARTBEAT_SEED to DBNORTH_PDB1.GGADMIN.GG_HEARTBEAT_SEED:",
            "                              ",
            "                              *** Hourly statistics since 2024-04-03 22:34:36 ***",
            "                                  Total inserts                              0.00",
            "                                  Total updates                              3.00",
            "                                  Total deletes                              0.00",
            "                                  Total upserts                              0.00",
            "                                  Total discards                             0.00",
            "                                  Total operations                           3.00",
            "                                  Total metadata records                     1.00",
            "                              ",
            "                              End of statistics.",
            "2024-04-03T22:35:23.965+0000  INFO    OGG-01021  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Command received from application adminsrvr: STOP.",
            "2024-04-03T22:35:23.965+0000  INFO    OGG-01680  Oracle GoldenGate Capture for Oracle, EXTN.prm:  .",
            "2024-04-03T22:35:24.968+0000  INFO    OGG-00991  Oracle GoldenGate Capture for Oracle, EXTN.prm:  Extract group EXTRACT EXTN stopped normally.",
            "2024-04-03T22:35:28.885+0000  INFO    OGG-25701  Oracle GoldenGate Capture for Oracle, EXTN.prm:  The file caching thread was shutdown. Thread ID: 140218918737664.",
            "2024-04-03T22:35:29.924+0000  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, REPS.prm:  Replicat group REPLICAT REPS starting.",
            "2024-04-03T22:35:29.924+0000  INFO    OGG-03059  Oracle GoldenGate Delivery for Oracle, REPS.prm:  Operating system character set identified as UTF-8.",
            "2024-04-03T22:35:29.924+0000  INFO    OGG-02695  Oracle GoldenGate Delivery for Oracle, REPS.prm:  ANSI SQL parameter syntax is used for parameter parsing.",
            "2024-04-03T22:35:29.924+0000  INFO    OGG-02743  Oracle GoldenGate Delivery for Oracle, REPS.prm:  GLOBALS parameter GGSCHEMA is set to 'ggadmin'.",
            "2024-04-03T22:35:29.954+0000  INFO    OGG-01360  Oracle GoldenGate Delivery for Oracle, REPS.prm:  REPLICAT is running in Integrated mode.",
            "2024-04-03T22:35:30.261+0000  INFO    OGG-03541  Oracle GoldenGate Delivery for Oracle, REPS.prm:  Oracle Environment Variables: ",
            "                              TNS_ADMIN = /u02/Deployment/etc",
            "                              LD_LIBRARY_PATH = /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.402.b06-2.0.1.el8.x86_64/jre/lib/amd64/server:.",
            "2024-04-03T22:35:31.467+0000  INFO    OGG-02679  Oracle GoldenGate Delivery for Oracle, REPS.prm:  The Replicat process logged on to database DBNORTH_PDB1 and can only apply to that database.",
            "2024-04-03T22:35:31.489+0000  INFO    OGG-02669  Oracle GoldenGate Delivery for Oracle, REPS.prm:  Default catalog name DBNORTH_PDB1 will be used for target table name hr.* mapping.",
            "2024-04-03T22:35:31.502+0000  INFO    OGG-06451  Oracle GoldenGate Delivery for Oracle, REPS.prm:  Triggers will be suppressed by default.",
            "2024-04-03T22:35:31.526+0000  INFO    OGG-02733  Oracle GoldenGate Delivery for Oracle, REPS.prm:  Heartbeat table found in the connected schema ggadmin, using this heartbeat table.",
            "2024-04-03T22:35:31.530+0000  INFO    OGG-01851  Oracle GoldenGate Delivery for Oracle, REPS.prm:  filecaching started: thread ID: 140219451614976.",
            "2024-04-03T22:35:31.542+0000  INFO    OGG-01815  Oracle GoldenGate Delivery for Oracle, REPS.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/Deployment/var/temp.",
            "2024-04-03T22:35:31.546+0000  INFO    OGG-25340  Oracle GoldenGate Delivery for Oracle, REPS.prm:  ",
            "                              Database Version:",
            "                              Oracle Database 23c Enterprise Edition Release 23.0.0.0.0 - Development",
            "                              Version 23.4.0.23.00.",
            "2024-04-03T22:35:31.546+0000  INFO    OGG-25341  Oracle GoldenGate Delivery for Oracle, REPS.prm:  ",
            "                              Database Language and Character Set:",
            "                              NLS_LANGUAGE     = \"AMERICAN\" ",
            "                              NLS_TERRITORY    = \"AMERICA\" ",
            "                              NLS_CHARACTERSET = \"AL32UTF8\".",
            "2024-04-03T22:35:31.556+0000  INFO    OGG-26025  Oracle GoldenGate Delivery for Oracle, REPS.prm:  ",
            "                              Database Unique Name: ORCLCDB.",
            "2024-04-03T22:35:31.564+0000  INFO    OGG-06604  Oracle GoldenGate Delivery for Oracle, REPS.prm:  Connected to database DBNORTH_PDB1, CPU info: CPU Count 64, CPU Core Count 64, CPU Socket Count 1.",
            "2024-04-03T22:35:31.674+0000  INFO    OGG-30192  Oracle GoldenGate Delivery for Oracle, REPS.prm:  Target Table DDL Notification turned ON.",
            "2024-04-03T22:35:31.674+0000  INFO    OGG-02545  Oracle GoldenGate Delivery for Oracle, REPS.prm:  Parameter GROUPTRANSOPS is ignored by Integrated Replicat when parallelism is greater than 1.",
            "2024-04-03T22:35:35.151+0000  INFO    OGG-02528  Oracle GoldenGate Delivery for Oracle, REPS.prm:  Replicat group REPS successfully registered with database as inbound server OGG$REPS.",
            "2024-04-03T22:35:35.311+0000  INFO    OGG-06627  Oracle GoldenGate Delivery for Oracle, REPS.prm:  Replicat sets the key columns for each table replicated by inbound server OGG$REPS.",
            "2024-04-03T22:35:35.465+0000  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, REPS.prm:  Replicat group REPLICAT REPS started.",
            "2024-04-03T22:35:46.260+0000  INFO    OGG-02530  Oracle GoldenGate Delivery for Oracle, REPS.prm:  Integrated replicat successfully attached to inbound server OGG$REPS.",
            "2024-04-03T22:36:16.312+0000  INFO    OGG-01021  Oracle GoldenGate Delivery for Oracle, REPS.prm:  Command received from application REST API: STATS HOURLY.",
            "2024-04-03T22:36:16.312+0000  INFO    OGG-01680  Oracle GoldenGate Delivery for Oracle, REPS.prm:  ",
            "                              No active replication maps.",
            "                              ",
            "                              Integrated Replicat statistics:",
            "                              ",
            "                              \tTotal transactions            \t\t           0.00",
            "                              \tRedirected                    \t\t           0.00",
            "                              \tReplicated procedures         \t\t           0.00",
            "                              \tDDL operations                \t\t           0.00",
            "                              \tStored procedures             \t\t           0.00",
            "                              \tDatatype functionality        \t\t           0.00",
            "                              \tOperation type functionality  \t\t           0.00",
            "                              \tEvent actions                 \t\t           0.00",
            "                              \tDatabase compatibility        \t\t           0.00",
            "                              \tDirect transactions ratio     \t\t           0.00%.",
            "2024-04-03T22:36:16.604+0000  INFO    OGG-02950  Oracle GoldenGate Administration Service for Oracle:  Lag for Extract group EXTN is 0:00:03.965 (checkpoint updated 0:00:52.638 ago).",
            "2024-04-03T22:36:16.606+0000  INFO    OGG-02953  Oracle GoldenGate Administration Service for Oracle:  Lag for Replicat group REPS is 0:00:00.000 (checkpoint updated 0:00:00.290 ago)."
        ]
    }
}