Create database
post
/databases
Create new database in Oracle Database Appliance using DBRequest parameters. Ensure that the repository is updated with Oracle RDBMS Clone files for the database version, before creating the database.
Request
Supported Media Types
- application/json
Header Parameters
-
opc-idempotency-token: string
Minimum Length:
1
Maximum Length:64
A user-supplied token that uniquely identifies a request. A single request will be acted upon among many requests that share the same token. Idempotency tokens expire after 30 minutes.
database creation parameters
Root Schema : DBRequest
Type:
Show Source
object
-
adminPassword(optional):
string
Admin password
-
associatedNetworkNames(optional):
array associatedNetworkNames
names of associated networks
-
associatedNetworks(optional):
array associatedNetworks
ids of associated networks
-
backupConfigId(optional):
string
Backup Config resource ID
-
backupConfigName(optional):
string
Backup Config resource name
-
cpuPool(optional):
string
Defines the CPU Pool name
-
databaseUniqueName(optional):
string
Database unique name
-
dbCharacterSet(optional):
object DbCharacterSet
-
dbClass(optional):
string
Allowed Values:
[ "OLTP", "DSS", "IMDB" ]
Database Class EE: OLTP/DSS/IMDB, SE: OLTP (default:OLTP) -
dbConsoleEnable(optional):
boolean
Flag to enable database console
-
dbDomainName(optional):
string
Database domain name
-
dbEdition(optional):
string
Database Home Edition(EE/SE).
-
dbHomeId(optional):
string
The database home resource identifier for associating this database to.
-
dbName:
string
Database name
-
dbOnFlashStorage(optional):
boolean
Option to select FLASH for storing database data files
-
dbRedundancy(optional):
string
Database redundancy
-
dbRole(optional):
string
Database role (PRIMARY/STANDBY).
-
dbShape(optional):
string
Allowed Values:
[ "odb1s", "odb1", "odb2", "odb4", "odb6", "odb8", "odb10", "odb12", "odb16", "odb20", "odb24", "odb28", "odb32", "odb36" ]
Database Shape{odb1s,odb1,odb2,etc.} (default:odb1) -
dbStorage(optional):
string
Allowed Values:
[ "ASM", "ACFS" ]
Database Storage {ACFS|ASM} (non case-sensitive) (default:ASM) 11.2.0.4 databases can be created only on ACFS storage -
dbTargetNodeName(optional):
string
-
dbTargetNodeNumber(optional):
string
In case of EE dbType, what is the target node for the database to run on.
-
dbType(optional):
string
Allowed Values:
[ "RAC", "RACOne", "SI" ]
Database Type: SI, RAC, RACOne (default:SI) -
dbVersion(optional):
string
Database version
-
enableEEHA(optional):
boolean
Enable HA for EE SI database
-
enableFlashCache(optional):
boolean
Option to enable FLASH CACHE
-
enableSEHA(optional):
boolean
Enable HA for SE for 19c and later SI database
-
enableTDE(optional):
boolean
Flag to enable Transparent Data Encryption which uses software keystore
-
instanceOnly(optional):
boolean
Do not create the database files. Flag to create standby instance.
-
isCdb(optional):
boolean
Flag to create container database
-
isFileConversionComplete(optional):
boolean
Flag to check if the permissions and ownership of db files have been modified
-
level0BackupDay(optional):
string
Allowed Values:
[ "monday", "tuesday", "wednesday", "thursday", "friday", "saturday", "sunday" ]
-
pdbAdminuserName(optional):
string
Pluggable database admin user name
-
pdBName(optional):
string
Pluggable database name
-
registerOnly(optional):
boolean
Flag to migrate existing database
-
rmanBkupPassword(optional):
string
RMAN backup password
-
tdePassword(optional):
string
Password used for password protected software keystore.
-
unifiedAuditing(optional):
string
Enable unified auditing for the database or not (TRUE/FALSE).
Response
Supported Media Types
- application/json
200 Response
OK
Root Schema : ServiceJobReport
Type:
object
Job Request Status
Show Source
-
createTimestamp(optional):
string(date-time)
Job creation timestamp
-
description(optional):
string
Job description
-
jobId(optional):
string
Job ID
-
message(optional):
string
Job message
-
reports(optional):
array reports
-
resourceList(optional):
array resourceList
-
status(optional):
string
Allowed Values:
[ "Created", "Scheduled", "Running", "Success", "Failure", "Retrying", "Waiting", "InternalError", "Reverting", "Reverted", "NodeDisconnectedFailure" ]
Job status -
updatedTime(optional):
string(date-time)
Job modification timestamp
Nested Schema : resourceList
Type:
Show Source
array
-
Array of:
object JobResourceInfo
Resource information
Nested Schema : TaskReport
Type:
Show Source
object
-
endTime(optional):
string(date-time)
-
jobId(optional):
string
-
parentTaskId(optional):
string
-
reportLevel(optional):
string
Allowed Values:
[ "Verbose", "Info", "Error" ]
-
startTime(optional):
string(date-time)
-
status(optional):
string
Allowed Values:
[ "Created", "Scheduled", "Running", "Success", "Failure", "Retrying", "Waiting", "InternalError", "Reverting", "Reverted", "NodeDisconnectedFailure", "Skipped" ]
-
tags(optional):
array tags
-
taskDescription(optional):
string
-
taskId(optional):
string
-
taskName(optional):
string
-
taskResult(optional):
string
-
updatedTime(optional):
string(date-time)
Nested Schema : JobResourceInfo
Type:
object
Resource information
Show Source
-
jobId(optional):
string
Job ID
-
resourceId(optional):
string
Resource ID
-
resourceNewType(optional):
string
-
resourceType(optional):
string
Allowed Values:
[ "Backup", "BackupConfig", "DB", "DbHome", "Grid", "Recovery", "Report", "Tde", "ObjectStoreSwift" ]
Resource type -
updatedTime(optional):
string(date-time)
Last updated timestamp
Default Response
An unexpected error has occurred