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.

To know basic about RESTAPI

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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.