The following example shows how to view detailed information about a Database Cloud Service instance by submitting a GET request on the REST endpoint using cURL.
In last post, we created an instance with RestApi. Now, in this post, we will see how to get the information about that instance.
In this example, the identity domain is “idcs-bac676f0a2c643a281868616b45986da” ,the service instance is Skant and the Oracle Cloud user name and password are “clouduser” and “Pa$$word“.
cURL Command
[oracle@edvmr1p0 Solution_files]$ curl -X GET -i -H "X-ID-TENANT-NAME: idcs-bac676f0a2c643a281868616b45986da" -u "clouduser:Pa$$word" "https://dbaas.oraclecloud.com/paas/service/dbcs/api/v1.1/instances/idcs-bac676f0a2c643a281868616b45986da/Skant"
HTTP Status Code and Response Headers
HTTP/1.0 200 Connection established X-RBT-SCAR: 10.135.5.92:897497276:1000 HTTP/1.1 200 OK Server: Oracle-Application-Server-11g Strict-Transport-Security: max-age=31536000;includeSubDomains Content-Language: en Service-URI: https://dbaas.oraclecloud.com:443/paas/service/dbcs/api/v1.1/instances/idcs-bac676f0a2c643a281868616b45986da/Student015-skant Access-Control-Allow-Headers: Content-Type, api_key, Authorization, X-ID-TENANT-NAME, X-USER-IDENTITY-DOMAIN-NAME Access-Control-Allow-Methods: GET, POST, DELETE, PUT, OPTIONS, HEAD X-ORACLE-DMS-ECID: 005PwX8Qrrj6uHFpR0H7id0004NZ0003WR X-ORACLE-DMS-ECID: 005PwX8Qrrj6uHFpR0H7id0004NZ0003WR Access-Control-Allow-Origin: * X-Frame-Options: DENY Content-Type: application/json Vary: user-agent Date: Mon, 19 Mar 2018 18:39:50 GMT Content-Length: 1790 Connection: keep-alive
Response Body
{
"service_name": "Skant",
"service_uuid": "3F8E9558D32244F8BC08164D83F5F34A",
"version": "12.1.0.2",
"status": "Running",
"description": "Example service instance",
"identity_domain": "idcs-bac676f0a2c643a281868616b45986da",
"creation_time": "2018-03-19T18:03:54.397+0000",
"last_modified_time": "2018-03-19T18:37:04.774+0000",
"created_by": "ora015",
"sm_plugin_version": "18.1.6-551",
"tags": "{\"items\":[],\"totalResults\":0,\"hasMore\":false}",
"tools_version": "18.1.6-551",
"backup_supported_version": "16.2.3",
"service_uri": "https://dbaas.oraclecloud.com:443/paas/service/dbcs/api/v1.1/instances/idcs-bac676f0a2c643a281868616b45986da/Skant",
"num_nodes": 1,
"level": "PAAS",
"edition": "EE_HP",
"shape": "oc3",
"use_high_performance_storage": false,
"subscriptionType": "HOURLY",
"creation_job_id": "23333903",
"num_ip_reservations": 1,
"backup_destination": "BOTH",
"cloud_storage_container": "Storage-ocuocictrng16/Skant_storage",
"failover_database": false,
"rac_database": false,
"byol": false,
"serviceEntitlementId": "588580658",
"serviceSubscriptionId": "1700020",
"current_version": "12.1.0.2.171017",
"sid": "ORCL",
"pdbName": "MYPDB",
"demoPdb": "",
"listenerPort": 1521,
"timezone": "UTC",
"dbUsableStorage": 15,
"em_url": "https://129.150.218.67:5500/em",
"connect_descriptor": "Student015-skant:1521/MYPDB.588580657.oraclecloud.internal",
"connect_descriptor_with_public_ip": "129.150.218.67:1521/MYPDB.588580657.oraclecloud.internal",
"apex_url": "https://129.150.218.67/apex/mypdb/",
"ords_url": "https://129.150.218.67/ords",
"glassfish_url": "",
"dbaasmonitor_url": "https://129.150.218.67/dbaas_monitor",
"charset": "AL32UTF8",
"ncharset": "AL16UTF16",
"is_clone": false,
"clone_supported_version": "16.3.1",
"service_associations": [],
"region": "uscom-central-1",
"jaas_instances_using_service": ""
}
Stay tuned for More articles on Oracle Cloud and RESTapi
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Telegram Channel : https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
