Oracle GoldenGate Microservices REST API

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: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":[
            "2021-07-13T16:36:24.268+0000  INFO    OGG-01851  Oracle GoldenGate Distribution Service for Oracle:  filecaching started: thread ID: 140549286704896.",
            "2021-07-13T16:36:24.271+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/ogg/Local/var/temp/.",
            "2021-07-13T16:37:08.680+0000  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, EXT2.prm:  Extract group EXTRACT EXT2 starting.",
            "2021-07-13T16:37:08.681+0000  INFO    OGG-03059  Oracle GoldenGate Capture for Oracle, EXT2.prm:  Operating system character set identified as US-ASCII.",
            "2021-07-13T16:37:08.681+0000  INFO    OGG-02695  Oracle GoldenGate Capture for Oracle, EXT2.prm:  ANSI SQL parameter syntax is used for parameter parsing.",
            "2021-07-13T16:37:08.684+0000  INFO    OGG-01360  Oracle GoldenGate Capture for Oracle, EXT2.prm:  EXTRACT is running in Integrated mode.",
            "2021-07-13T16:37:08.781+0000  INFO    OGG-03541  Oracle GoldenGate Capture for Oracle, EXT2.prm:  Oracle Environment Variables: ",
            "                              TNS_ADMIN = /u02/ogg/Local/etc",
            "                              LD_LIBRARY_PATH = /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.292.b10-1.el7_9.x86_64/jre/lib/amd64/server:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.292.b10-1.el7_9.x86_64/jre/lib/amd64:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.292.b10-1.el7_9.x86_64/jre/../lib/amd64:/usr/lib/jvm/jre/lib/amd64/server:/u01/app/oracle/product/12cR2/dbhome/lib.",
            "2021-07-13T16:37:08.936+0000  INFO    OGG-02733  Oracle GoldenGate Capture for Oracle, EXT2.prm:  Heartbeat table found in the connected schema oggadmin, using this heartbeat table.",
            "2021-07-13T16:37:08.936+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.",
            "2021-07-13T16:37:08.949+0000  INFO    OGG-01851  Oracle GoldenGate Capture for Oracle, EXT2.prm:  filecaching started: thread ID: 140019459147520.",
            "2021-07-13T16:37:08.953+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.",
            "2021-07-13T16:37:08.988+0000  INFO    OGG-25340  Oracle GoldenGate Capture for Oracle, EXT2.prm:  ",
            "                              Database Version:",
            "                              Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production",
            "                              PL/SQL Release 12.2.0.1.0 - Production",
            "                              CORE\t12.2.0.1.0\tProduction",
            "                              TNS for Linux: Version 12.2.0.1.0 - Production",
            "                              NLSRTL Version 12.2.0.1.0 - Production.",
            "2021-07-13T16:37:08.988+0000  INFO    OGG-25341  Oracle GoldenGate Capture for Oracle, EXT2.prm:  ",
            "                              Database Language and Character Set:",
            "                              NLS_LANGUAGE     = \"AMERICAN\" ",
            "                              NLS_TERRITORY    = \"AMERICA\" ",
            "                              NLS_CHARACTERSET = \"AL32UTF8\".",
            "2021-07-13T16:37:08.998+0000  INFO    OGG-26025  Oracle GoldenGate Capture for Oracle, EXT2.prm:  ",
            "                              Database Unique Name: ORCL.",
            "2021-07-13T16:37:09.543+0000  INFO    OGG-06604  Oracle GoldenGate Capture for Oracle, EXT2.prm:  Connected to database ORCL, CPU info: CPU Count 40, CPU Core Count 20, CPU Socket Count 2.",
            "2021-07-13T16:37:09.543+0000  INFO    OGG-06618  Oracle GoldenGate Capture for Oracle, EXT2.prm:  Database ORCL Platform: Linux x86 64-bit.",
            "2021-07-13T16:37:24.340+0000  INFO    OGG-02248  Oracle GoldenGate Capture for Oracle, EXT2.prm:  Logmining server DDL filtering enabled.",
            "2021-07-13T16:37:28.883+0000  INFO    OGG-02068  Oracle GoldenGate Capture for Oracle, EXT2.prm:  Integrated capture successfully attached to logmining server OGG$CAP_EXT2 using OGGCapture API.",
            "2021-07-13T16:37:28.883+0000  INFO    OGG-02089  Oracle GoldenGate Capture for Oracle, EXT2.prm:  Source redo compatibility version is: 12.2.0.",
            "2021-07-13T16:37:28.883+0000  INFO    OGG-15446  Oracle GoldenGate Capture for Oracle, EXT2.prm:  Extract configured as OTHER_GROUPS resource group.",
            "2021-07-13T16:37:28.883+0000  INFO    OGG-02086  Oracle GoldenGate Capture for Oracle, EXT2.prm:  Integrated Dictionary will be used.",
            "2021-07-13T16:37:29.020+0000  WARNING OGG-02905  Oracle GoldenGate Capture for Oracle, EXT2.prm:  Replication of OID column in object tables may diverge.",
            "2021-07-13T16:37:29.020+0000  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, EXT2.prm:  Extract group EXTRACT EXT2 started.",
            "2021-07-13T16:37:29.020+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).",
            "2021-07-13T16:37:29.020+0000  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, EXT2.prm:  Output file X2 is using format RELEASE 12.3/18.1.",
            "2021-07-13T16:38:01.526+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.",
            "2021-07-13T16:38:40.548+0000  INFO    OGG-01021  Oracle GoldenGate Capture for Oracle, EXT2.prm:  Command received from application REST API: STATS HOURLY.",
            "2021-07-13T16:38:43.553+0000  INFO    OGG-01021  Oracle GoldenGate Capture for Oracle, EXT2.prm:  Command received from application adminsrvr: STOP.",
            "2021-07-13T16:38:44.554+0000  INFO    OGG-00991  Oracle GoldenGate Capture for Oracle, EXT2.prm:  Extract group EXTRACT EXT2 stopped normally.",
            "2021-07-13T16:38:50.813+0000  INFO    OGG-25701  Oracle GoldenGate Capture for Oracle, EXT2.prm:  The file caching thread was shutdown. Thread ID: 140019459147520.",
            "2021-07-13T16:38:51.797+0000  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, REP2.prm:  Replicat group REPLICAT REP2 starting.",
            "2021-07-13T16:38:51.798+0000  INFO    OGG-03059  Oracle GoldenGate Delivery for Oracle, REP2.prm:  Operating system character set identified as US-ASCII.",
            "2021-07-13T16:38:51.798+0000  INFO    OGG-02695  Oracle GoldenGate Delivery for Oracle, REP2.prm:  ANSI SQL parameter syntax is used for parameter parsing.",
            "2021-07-13T16:38:52.008+0000  INFO    OGG-03541  Oracle GoldenGate Delivery for Oracle, REP2.prm:  Oracle Environment Variables: ",
            "                              TNS_ADMIN = /u02/ogg/Local/etc",
            "                              LD_LIBRARY_PATH = /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.292.b10-1.el7_9.x86_64/jre/lib/amd64/server:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.292.b10-1.el7_9.x86_64/jre/lib/amd64:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.292.b10-1.el7_9.x86_64/jre/../lib/amd64:/usr/lib/jvm/jre/lib/amd64/server:/u01/app/oracle/product/12cR2/dbhome/lib.",
            "2021-07-13T16:38:52.371+0000  INFO    OGG-06451  Oracle GoldenGate Delivery for Oracle, REP2.prm:  Triggers will be suppressed by default.",
            "2021-07-13T16:38:52.388+0000  INFO    OGG-02733  Oracle GoldenGate Delivery for Oracle, REP2.prm:  Heartbeat table found in the connected schema oggadmin, using this heartbeat table.",
            "2021-07-13T16:38:52.396+0000  INFO    OGG-01851  Oracle GoldenGate Delivery for Oracle, REP2.prm:  filecaching started: thread ID: 140476346783488.",
            "2021-07-13T16:38:52.402+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.",
            "2021-07-13T16:38:52.406+0000  INFO    OGG-25340  Oracle GoldenGate Delivery for Oracle, REP2.prm:  ",
            "                              Database Version:",
            "                              Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production",
            "                              PL/SQL Release 12.2.0.1.0 - Production",
            "                              CORE\t12.2.0.1.0\tProduction",
            "                              TNS for Linux: Version 12.2.0.1.0 - Production",
            "                              NLSRTL Version 12.2.0.1.0 - Production.",
            "2021-07-13T16:38:52.408+0000  INFO    OGG-25341  Oracle GoldenGate Delivery for Oracle, REP2.prm:  ",
            "                              Database Language and Character Set:",
            "                              NLS_LANGUAGE     = \"AMERICAN\" ",
            "                              NLS_TERRITORY    = \"AMERICA\" ",
            "                              NLS_CHARACTERSET = \"AL32UTF8\".",
            "2021-07-13T16:38:52.410+0000  INFO    OGG-26025  Oracle GoldenGate Delivery for Oracle, REP2.prm:  ",
            "                              Database Unique Name: ORCL.",
            "2021-07-13T16:38:52.417+0000  INFO    OGG-06604  Oracle GoldenGate Delivery for Oracle, REP2.prm:  Connected to database ORCL, CPU info: CPU Count 40, CPU Core Count 20, CPU Socket Count 2.",
            "2021-07-13T16:38:52.560+0000  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, REP2.prm:  Replicat group REPLICAT REP2 started.",
            "2021-07-13T16:38:52.628+0000  INFO    OGG-30067  Oracle GoldenGate Delivery for Oracle, REP2.prm:  Opened trail file /u02/ogg/Local/var/lib/data/X2000000000, RBA: 0 at 2021-07-13 16:38:52.627032.",
            "2021-07-13T16:38:52.628+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.",
            "2021-07-13T16:38:52.628+0000  WARNING OGG-26027  Oracle GoldenGate Delivery for Oracle, REP2.prm:  The DbUniqueName token is not available in the source trail header. DBUNIQUENAME will be treated as a synonym of DBNAME.",
            "2021-07-13T16:38:52.630+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.",
            "2021-07-13T16:39:38.921+0000  INFO    OGG-01021  Oracle GoldenGate Delivery for Oracle, REP2.prm:  Command received from application REST API: STATS HOURLY.",
            "2021-07-13T16:39:40.428+0000  INFO    OGG-02950  Oracle GoldenGate Administration Service for Oracle:  Lag for Extract group EXT2 is 0:00:00.000 (checkpoint updated 0:00:56.874 ago).",
            "2021-07-13T16:39:40.436+0000  INFO    OGG-02953  Oracle GoldenGate Administration Service for Oracle:  Lag for Replicat group REP2 is 0:00:00.000 (checkpoint updated 0:00:04.530 ago)."
        ]
    }
}