For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hello, is there a Tablespace compression in 21XE? When i import data with datapump, the "tablespace use" in XE21 is smaller then in 19c.
MfG Matthias
We use the following templates to create (POST) and alter (PATCH) an extract process. This works for us.
POST:
{
"description": "Integrated Extract", "source": { "tranlogs": "integrated" }, "credentials": { "alias": "{{ gg_user_alias }}" }, "registration":"default", "begin": "now", "targets": [{ "name": "{{ gg_trail_prefix }}", "sizeMB": 250 }], "status": "stopped"}
PATCH
"credentials": { "alias": "{{ gg_user_alias }}" }, "config": [ "extract {{ gg_process_name }}", "extTrail {{ gg_trail_prefix }}", "useridAlias {{ gg_user_alias }}", ]}
Hi Martin,
Thanks for your reply. However I am having problem create the extract. As far as I can tell, my payload matches the JSON specification. Do you happen to have a working JSON payload that you can share so that I know the difference between the 2?
BTW, I am assuming the 2 payload you have are from ansiable template, and I will replace {{ xx }} with the actual value, say if you have
The real payload becomes
(want to make sure I am not missing brackets or quotes.....)
What version of GolenGate Microservice do you have?
Hi Mr Huang
Yes, that's correct, we're using ansible to create the extract process. Here are the 2 payloads we submit to OGG
cat ansible.2s4lnb2fbuild/extract.post.body.json{ "description": "Integrated Extract", "source": { "tranlogs": "integrated" }, "credentials": { "alias": "ecdpt01" }, "registration":"default", "begin": "now", "targets": [{ "name": "g2", "sizeMB": 250 }], "status": "stopped"}
oraadmt04:/tmp> cat ansible.5pcj45xbbuild/extract.patch.body.json{ "credentials": { "alias": "ecdpt01" }, "config": [ "extract EXDPT01", "extTrail g2", "useridAlias ecdpt01", ]}
We're using the following Version of OGG:
Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054
Kind regards,
Martin
Thank you Martin,
Let me try to add an integrated extract with noncdb to see if it works.
I am getting the same error.
[oracle@workstation ~]$ cat yy
#!/bin/bash
vPayload='{
"description": "Integrated Extract",
"source": {
"tranlogs": "integrated"
},
"credentials": {
"alias": "ds01"
"registration":"default",
"begin": "now",
"targets": [{
"name": "g2",
"sizeMB": 250
}],
"status": "stopped"
}'
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 ~]$
[oracle@workstation ~]$ ./yy
"registration": "default",
"status": "stopped",
"targets": [
}
]
} <--------------------------------------------------------------- this step confirms I have a good json document
"$schema": "api:standardResponse",
"links": [
"href": "http://fseast:7001/services/v2/extracts/pp",
"mediaType": "application/json",
"rel": "canonical"
"rel": "self"
],
"messages": [
"$schema": "ogg:message",
"code": "OGG-12110",
"issued": "2020-02-24T00:27:19Z",
"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"
Maybe I am using the wrong port?
7000 is server manager
7001 is admin server
If I change the port to 7000, I got the following:
"links": [],
"code": "OGG-12031",
"issued": "2020-02-24T00:30:39Z",
"title": "The requested resource does not exist.",
"type": "http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1"
Hi.. did you get this to work. I am hitting the same issue. Can you please help me to get past the issue.