メッセージの取得
get
/services/{version}/messages
必要なロール: ユーザー
Oracle GoldenGateデプロイメントからメッセージを取得します。
リクエスト
パス・パラメータ
- version(必須): string
Oracle GoldenGateサービスのAPIバージョン。
指定できる値:[ "v2" ]
レスポンス
サポートされるメディア・タイプ
- application/json
200レスポンス
Oracle GoldenGateデプロイメントによって発行されたすべてのメッセージが取得されました。
ルート・スキーマ: Oracle GoldenGate Messages
型:
objectタイトル:
Oracle GoldenGate MessagesOracle GoldenGateプロセスによって発行されたメッセージ
ソースの表示
- $schema:
指定できる値:
[ "ogg:messages" ] - messages(必須): array messages
最小アイテム数:
0最大アイテム数:2147483647
レスポンスの例(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)."
]
}
}