Hi,
I am trying to create an extract process with Oracle GoldenGate Microservice against 19c Oracle database but got API payload is poorly formatted. I use the following reference guide:
https://docs.oracle.com/goldengate/c1230/gg-winux/OGGRA/op-services-version-extracts-extract-post.html
Return message:
{
"$schema": "api:standardResponse",
"links": [
{
"href": "http://fseast:7001/services/v2/extracts/pp",
"mediaType": "application/json",
"rel": "canonical"
},
{
"href": "http://fseast:7001/services/v2/extracts/pp",
"mediaType": "application/json",
"rel": "self"
}
],
"messages": [
{
"$schema": "ogg:message",
"code": "OGG-12110",
"issued": "2020-02-17T01:20:40Z",
"severity": "ERROR",
"title": "JSON element '/uri/extract' value does not match the required pattern",
"type": "http://docs.oracle.com/goldengate/c1910/gg-winux/GMESG/oggus.htm#OGG-12110"
}
]
}
Attempt to open the above URL but got 404 (page not found) Is there a more recent reference manual I can refer to?
Environment: All running on Oracle Linux 7x64
DB: 19.6 CDB: boston01 with PDB name: play19
GG: 19.1.0.4 for Oracle (Microservice)
Here is my script:
[oracle@workstation Downloads]$ cat yy
#!/bin/bash
vPayload='{
"config":[
"Extract pp",
"ExtTrail zz",
"UseridAlias boston01",
"sourcecatalog play19;",
"table soe.warehouses;",
"table soe.orderentry_metadata;"
],
"source":{
"tranlogs":"integrated"
},
"credentials":{
"alias":"bosplay19"
},
"registration":{
"containers": [ "play19" ],
"optimized":false
},
"begin":"now",
"targets":[
{
"name":"zz"
}
],
"status":"running"
}'
echo $vPayload | python -mjson.tool
curl -s -X POST \
http://fseast:7001/services/v2/extracts/pp \
--user "oggadmin:"oracle_4U \
-H 'Cache-Control: no-cache' \
-d $vPayload | python -mjson.tool
[oracle@workstation Downloads]$