Jump to

• Request
• Response

Get database by ID

get

/databases/{databaseId}

Describe database details by ID

Request

Supported Media Types

• application/json

Path Parameters

• databaseId: string
  database ID

Query Parameters

• dbvms(optional): string
  DBVMs where the entity comes from. Name list is delimited by comma, like 's1,s2'.
• includeDBVMEntity(optional): boolean
  include DBVM entities

  Default Value: false
• includeLocalEntity(optional): boolean
  include local entities

  Default Value: true

Back to Top

Response

Supported Media Types

• application/json

200 Response

OK

Body ()

Root Schema : DB

Type: object

Show Source

• associatedNetworks(optional): array associatedNetworks
• backupConfigId(optional): string
• cloudStorageContainer(optional): string
  if the object store backup is selected, then which container should the database backup go to.
• cpupool(optional): string
  Defines the CPU Pool name
• createTime(optional): string(date-time)
• databaseUniqueName(optional): string
• dbCharacterSet(optional): object DbCharacterSet
• dbClass(optional): string
  Allowed Values: [ "OLTP", "DSS", "IMDB" ]
• dbConsoleEnable(optional): boolean
• dbDomainName(optional): string
• dbEdition(optional): string
  Database Edition.
• dbHomeId(optional): string
  The database home resource identifier for associating this database.
• dbId(optional): string
  The database id
• dbName(optional): string
• dbRedundancy(optional): string
• 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", "odb42", "odb48", "odb56", "odb64" ]
• dbStorage(optional): string
  Allowed Values: [ "ASM", "ACFS", "PMEM" ]
• dbTargetNodeName(optional): string
• dbTargetNodeNumber(optional): string
• dbType(optional): string
  Allowed Values: [ "RAC", "RACOne", "SI" ]
• dbVersion(optional): string
• enableEEHA(optional): boolean
  Enable HA for EE SI database
• enableSEHA(optional): boolean
• enableTDE(optional): boolean
  Flag to create TDE enabled database
• entitySource(optional): string
  Where the database is created. Null for local system.
• id(optional): string
• instanceOnly(optional): boolean
  do not create the database files. Used in case of standby case to create standby instance.
• isAutoBackupDisabled(optional): boolean
• isBcfgInSync(optional): boolean
• isCdb(optional): boolean
• level0BackupDay(optional): string
  Allowed Values: [ "monday", "tuesday", "wednesday", "thursday", "friday", "saturday", "sunday" ]
• name(optional): string
  display name for the resource
• pdbAdminUserName(optional): string
• pdBName(optional): string
• pdbs(optional): array pdbs
  List of PDB objects that are present in the CDB
• quota(optional): string
  disk space quota for a database.
• registerOnly(optional): boolean
  Use to migrate existing database
• remark(optional): string
  Remark for database status
• rmanBkupPassword(optional): string
• state(optional): object ResourceState
• tdePassword(optional): string
  Password for Password Protected KeyStore
• tdeWalletManagement(optional): string
  Specify wallet management method for TDE enabled database. Allowed values are ODA and EXTERNAL.
• updatedTime(optional): string(date-time)

{
    "properties":{
        "associatedNetworks":{
            "items":{
                "type":"string"
            },
            "type":"array"
        },
        "backupConfigId":{
            "type":"string"
        },
        "cloudStorageContainer":{
            "description":"if the object store backup is selected, then which container should the database backup go to.",
            "type":"string"
        },
        "cpupool":{
            "description":"Defines the CPU Pool name",
            "type":"string"
        },
        "createTime":{
            "format":"date-time",
            "type":"string"
        },
        "databaseUniqueName":{
            "type":"string"
        },
        "dbCharacterSet":{
            "$ref":"#/definitions/DbCharacterSet"
        },
        "dbClass":{
            "enum":[
                "OLTP",
                "DSS",
                "IMDB"
            ],
            "type":"string"
        },
        "dbConsoleEnable":{
            "type":"boolean"
        },
        "dbDomainName":{
            "type":"string"
        },
        "dbEdition":{
            "description":"Database Edition.",
            "type":"string"
        },
        "dbHomeId":{
            "description":"The database home resource identifier for associating this database.",
            "type":"string"
        },
        "dbId":{
            "description":"The database id",
            "type":"string"
        },
        "dbName":{
            "type":"string"
        },
        "dbRedundancy":{
            "type":"string"
        },
        "dbRole":{
            "description":"Database role (PRIMARY/STANDBY).",
            "type":"string"
        },
        "dbShape":{
            "enum":[
                "odb1s",
                "odb1",
                "odb2",
                "odb4",
                "odb6",
                "odb8",
                "odb10",
                "odb12",
                "odb16",
                "odb20",
                "odb24",
                "odb28",
                "odb32",
                "odb36",
                "odb42",
                "odb48",
                "odb56",
                "odb64"
            ],
            "type":"string"
        },
        "dbStorage":{
            "enum":[
                "ASM",
                "ACFS",
                "PMEM"
            ],
            "type":"string"
        },
        "dbTargetNodeName":{
            "type":"string"
        },
        "dbTargetNodeNumber":{
            "type":"string"
        },
        "dbType":{
            "enum":[
                "RAC",
                "RACOne",
                "SI"
            ],
            "type":"string"
        },
        "dbVersion":{
            "type":"string"
        },
        "enableEEHA":{
            "description":"Enable HA for EE SI database",
            "type":"boolean"
        },
        "enableSEHA":{
            "type":"boolean"
        },
        "enableTDE":{
            "description":"Flag to create TDE enabled database",
            "type":"boolean"
        },
        "entitySource":{
            "description":"Where the database is created. Null for local system.",
            "type":"string"
        },
        "id":{
            "type":"string"
        },
        "instanceOnly":{
            "description":"do not create the database files. Used in case of standby case to create standby instance.",
            "type":"boolean"
        },
        "isAutoBackupDisabled":{
            "type":"boolean"
        },
        "isBcfgInSync":{
            "type":"boolean"
        },
        "isCdb":{
            "type":"boolean"
        },
        "level0BackupDay":{
            "enum":[
                "monday",
                "tuesday",
                "wednesday",
                "thursday",
                "friday",
                "saturday",
                "sunday"
            ],
            "type":"string"
        },
        "name":{
            "description":"display name for the resource",
            "type":"string"
        },
        "pdBName":{
            "type":"string"
        },
        "pdbAdminUserName":{
            "type":"string"
        },
        "pdbs":{
            "description":"List of PDB objects that are present in the CDB",
            "items":{
                "$ref":"#/definitions/Pdb"
            },
            "type":"array"
        },
        "quota":{
            "description":"disk space quota for a database.",
            "type":"string"
        },
        "registerOnly":{
            "description":"Use to migrate existing database",
            "type":"boolean"
        },
        "remark":{
            "description":"Remark for database status",
            "type":"string"
        },
        "rmanBkupPassword":{
            "type":"string"
        },
        "state":{
            "$ref":"#/definitions/ResourceState"
        },
        "tdePassword":{
            "description":"Password for Password Protected KeyStore",
            "type":"string"
        },
        "tdeWalletManagement":{
            "description":"Specify wallet management method for TDE enabled database. Allowed values are ODA and EXTERNAL.",
            "type":"string"
        },
        "updatedTime":{
            "format":"date-time",
            "type":"string"
        }
    }
}

Nested Schema : associatedNetworks

Type: array

Show Source

• Array of: string

{
    "items":{
        "type":"string"
    },
    "type":"array"
}

Nested Schema : DbCharacterSet

Type: object

Show Source

• characterSet(optional): string
• dbLanguage(optional): string
• dbTerritory(optional): string
• nlsCharacterset(optional): string

{
    "properties":{
        "characterSet":{
            "type":"string"
        },
        "dbLanguage":{
            "type":"string"
        },
        "dbTerritory":{
            "type":"string"
        },
        "nlsCharacterset":{
            "type":"string"
        }
    }
}

Nested Schema : pdbs

Type: array

List of PDB objects that are present in the CDB

Show Source

• Array of: object Pdb

{
    "description":"List of PDB objects that are present in the CDB",
    "items":{
        "$ref":"#/definitions/Pdb"
    },
    "type":"array"
}

Nested Schema : ResourceState

Type: object

Show Source

• status(optional): string
  Allowed Values: [ "CREATING", "CONFIGURED", "UPDATING", "DELETING", "FAILED", "RUNNING", "ENABLED", "DISABLED", "STALE" ]

{
    "properties":{
        "status":{
            "enum":[
                "CREATING",
                "CONFIGURED",
                "UPDATING",
                "DELETING",
                "FAILED",
                "RUNNING",
                "ENABLED",
                "DISABLED",
                "STALE"
            ],
            "type":"string"
        }
    }
}

Nested Schema : Pdb

Type: object

Show Source

• id(optional): string
  PDB Id
• pdbName(optional): string
  Name of the PDB
• sourcePdbArchivePath(optional): string
  The absolute file name of the PDB archive file if ARCHIVE is used in sourceType
• sourcePdbName(optional): string
  The source PDB name if PDB is used in pdbSource
• sourceType(optional): string
  Allowed Values: [ "SEED", "PDB", "ARCHIVE" ]

  The source type to create the PDB
• state(optional): object ResourceState

{
    "properties":{
        "id":{
            "description":"PDB Id",
            "type":"string"
        },
        "pdbName":{
            "description":"Name of the PDB",
            "type":"string"
        },
        "sourcePdbArchivePath":{
            "description":"The absolute file name of the PDB archive file if ARCHIVE is used in sourceType",
            "type":"string"
        },
        "sourcePdbName":{
            "description":"The source PDB name if PDB is used in pdbSource",
            "type":"string"
        },
        "sourceType":{
            "description":"The source type to create the PDB",
            "enum":[
                "SEED",
                "PDB",
                "ARCHIVE"
            ],
            "type":"string"
        },
        "state":{
            "$ref":"#/definitions/ResourceState"
        }
    }
}

Default Response

An unexpected error has occurred

Body ()

Root Schema : Error

Type: object

Show Source

• code: string
• message: string

{
    "required":[
        "code",
        "message"
    ],
    "properties":{
        "code":{
            "type":"string"
        },
        "message":{
            "type":"string"
        }
    }
}

Back to Top