Thursday, April 9, 2015

How to create a DBCS Instance using REST APIs?

The following shows how to create an Oracle Database Cloud Service instance 11g using the REST API:

1.Create a JSON script (createDB.json)
This document defines the details of the service instance.
For example : 
 {
"serviceName": "DB11g-EE-REST",
"version": "11.2.0.4",
"level": "PAAS",
"edition": "EE",
"subscriptionType": "HOURLY",
"description": "DBCS REST TEST",
"shape": "oc3",
"parameters": [
{
"type": "db",
"usableStorage": "10",
"adminPassword": "Manager12#",
"sid": "ORCL",
"failoverDatabase": "no",
"backupDestination": "BOTH",
"cloudStorageContainer": "Storage-froraclejpp/backup_container",
"cloudStorageUser": "jpp_user",
"cloudStoragePwd": " JPP_PASSWORD "
}
],
"vmPublicKeyText": "ssh-rsa AAAAB3NzaC1yc2EAAAABJ= rsa-key-20150105"



2. Invoke the script 

curl -i -X POST -u user:password
-d
@createDB.json
-H "X-ID-TENANT-NAME:
IdentityDomain"
-H "Content-
Type:application/json"
https://dbaas.oraclecloud.com/jaas/db/api/v1.1/instances/
IdentityDomain



3. Check the creation process from the DBCS Overview page 



4. The new DBCS Instance is now Up and Running