shadabshaukat

curl -u <user>:"<password>"
-H "Content-Type: application/json"
-H "Accept: application/json" 
-X GET https://pxxxxxq.deployment.goldengate.us-ashburn-1.oci.oraclecloud.com/services/v2/extracts

shadabshaukat

curl -u <user>:"<password>"
-H "Content-Type: application/json"
-H "Accept: application/json" 
-X POST https://5xxxxxxa.deployment.goldengate.ap-sydney-1.oci.oraclecloud.com/services/v2/commands/execute
-d '{ "name":"stop", "processName":"<replicat name>"}'

shadabshaukat

curl -u <user>:"<password>"
-H "Content-Type: application/json"
-H "Accept: application/json" 
-X POST https://5xxxxxa.deployment.goldengate.ap-sydney-1.oci.oraclecloud.com/services/v2/commands/execute
-d '{ "name":"start", "processName":"<replicat name>"}'

shadabshaukat

curl -u <user>:"<password>" 
-H "Content-Type: application/json" 
-H "Accept: application/json" 
-X POST "https://pxxxxxq.deployment.goldengate.us-ashburn-1.oci.oraclecloud.com/services/v2/replicats/<replicat name>" 
-d '{"config":["REPLICAT <replicat name>","UseridAlias <alias>", "MAP <schema>.<table>, TARGET <schema>.<table>;" ], "source": {"name": "<trail file name>"}, "credentials":{"alias":"<alias>"}, "checkpoint":{"table":"<schema>.<table>"}, "mode":{ "type":"nonintegrated", "parallel": false}, "registration":"none", "begin":"now", "status":"stopped"}'

shadabshaukat

curl -u <user>:"<password>"
-H "Content-Type: application/json"
-H "Accept: application/json" 
-X POST https://5xxxxxa.deployment.goldengate.ap-sydney-1.oci.oraclecloud.com/services/v2/commands/execute
-d '{ "name":"stop", "processName":"<extract name>"}'

shadabshaukat

curl -u <user>:"<password>" 
-H "Content-Type: application/json"
-H "Accept: application/json"
-X POST https://5xxxxxa.deployment.goldengate.ap-sydney-1.oci.oraclecloud.com/services/v2/commands/execute
-d '{ "name":"start", "processName":"<extract name>"}'

shadabshaukat

curl -X "POST" "https://pxxxxxq.deployment.goldengate.us-ashburn-1.oci.oraclecloud.com/services/v2/extracts/<extract name>" \
 -H 'Content-Type: application/json' \
 -H 'Accept: application/json' \
 -u 'user:password' \
 -d $'{"config":["Extract <extract name>","ExtTrail <trail file name>","UseridAlias <alias>", "Table <schema>.<table>;"], "source":{"tranlogs":"integrated" },"credentials":{"alias":"<alias>"},"registration":{"optimized":false},"begin":"now","targets":[{"name":"<trail file name>"}]}'

shadabshaukat

import cx_Oracle

### Autonomous Database Loading Block ###
username='ADMIN'
pwd='*******'
dsn_name="""(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1521)(host=adb.ap-sydney-1.oraclecloud.com))(connect_data=(service_name=******_low.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes)(ssl_server_cert_dn="CN=adb.ap-sydney-1.oraclecloud.com, OU=Oracle ADB SYDNEY, O=Oracle Corporation, L=Redwood City, ST=California, C=US")))"""
encoding_name="UTF-8"

connection = cx_Oracle.connect(user=username,password=pwd,dsn=dsn_name,encoding=encoding_name)
cur = connection.cursor()

shadabshaukat

$ sudo yum install httpd-tools
$ ab -n 5000 -c 500 http://ip_address/

This is ApacheBench, Version 2.3 <$Revision: 1843412 $>
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Licensed to The Apache Software Foundation, http://www.apache.org/

Benchmarking 140.x.x.x (be patient)
Completed 500 requests
Completed 1000 requests

shadabshaukat

$ sudo yum install httpd-tools

$ ab -n 5000 -c 500 http://ip-address/

This is ApacheBench, Version 2.3 <$Revision: 1843412 $>
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Licensed to The Apache Software Foundation, http://www.apache.org/

Benchmarking 140.238.201.240 (be patient)
Completed 500 requests