createautonomousdb (Release 9.2.5.3)

API Name

createautonomousdb

Description

Creates the JDE schema on an autonomous database instance on Oracle Cloud Infrastructure.

Note: This API can be used for cloud provisioning only.

REST Methods

POST

Precondition

The autonomous database instance must be up and running on Oracle Cloud Infrastructure and a bucket must be created in the Oracle Cloud Infrastructure Object storage.
Note: It is recommended to create a private bucket.

Input Params

oraPRIST,

oraCRP,

oraDEV,

oraPRODDEMO,

oraPRISTDEMO,

oraCRPDEMO,

oraDEVDEMO,

oraDBJdbcUrl,

oraDBInstallDir,

oraDBIndexDir,

oraDBTableDir,

ociUserName,

ociAuthToken,

ociRegion,

ociTenancy,

and ociBucket.

Sample Request

{"instanceName": "atp_1", "agentHostName":"jdesma.example.com","targetType":"oradb", "jdeHome":"/u01/jde_agent/SCFHA","componentName": "E1_ORACLEDB_9.2.5.0_06-29-2020_18_39.jar","oradbInstance": {"oraDBHost":"localhost","oraDBPort":"1521","oraDBSid": "jdeorcl","oraDBPdbName": "PDB1","oraDBPass":"ovsadminE1","oraD +E9BJdePass":"test123","oraDBInstallDir":"/u01/compute_v2","oraDBJdbcUrl": "jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = denhost)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = jdeorcl)))","oraSHARED":true,"oraADF":true,"oraOVR":true,"oraASM": false,"oraRTE":true,"oradbSchema":{"oraPROD":false,"oraPRIST": false,"oraCRP":false,"oraDEV":true},"oradbDemoSchema":{"oraPRODDEMO": false,"oraPRISTDEMO":false,"oraCRPDEMO":false,"oraDEVDEMO":true}, "ociDetails":{"ociUserName": "test@example.com","ociAuthToken": ".JD].uEWGw:hjsu89","ociRegion":"us-ashburn-1","ociTenancy":"jde","ociBucket":"myBucket"}}}

Return

HTTP status 201 is returned.

Sample Response

Exception

400 or 409 for error.