ListDbSystems

GET {{baseUrl}}/dbSystems?compartmentId=<string>&limit=10&page=<string>&backupId=<string>&sortBy=TIMECREATED&sortOrder=ASC&lifecycleState=<string>&availabilityDomain=<string>&displayName=<string>

Lists the DB systems in the specified compartment. You can specify a backupId to list only the DB systems that support creating a database using this backup in this compartment.

Note: Deprecated for Exadata Cloud Service systems. Use the new resource model APIs instead.

For Exadata Cloud Service instances, support for this API will end on May 15th, 2021. See Switching an Exadata DB System to the New Resource Model and APIs for details on converting existing Exadata DB systems to the new resource model.

Request Params

KeyDatatypeRequiredDescription
compartmentIdstring(Required) The compartment OCID.
limitnumberThe maximum number of items to return per page.
pagestringThe pagination token to continue listing from.
backupIdstringThe OCID of the backup. Specify a backupId to list only the DB systems or DB homes that support creating a database using this backup in this compartment.
sortBystringThe field to sort by. You can provide one sort order (sortOrder). Default order for TIMECREATED is descending. Default order for DISPLAYNAME is ascending. The DISPLAYNAME sort order is case sensitive.

Note: If you do not include the availability domain filter, the resources are grouped by availability domain, then sorted. | | sortOrder | string | | The sort order to use, either ascending (ASC) or descending (DESC). | | lifecycleState | string | | A filter to return only resources that match the given lifecycle state exactly. | | availabilityDomain | string | | A filter to return only resources that match the given availability domain exactly. | | displayName | string | | A filter to return only resources that match the entire display name given. The match is not case sensitive. |

HEADERS

KeyDatatypeRequiredDescription
Acceptstring

RESPONSES

status: OK

[{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;compartmentId&quot;:&quot;\u003cstring\u003e&quot;,&quot;lifecycleState&quot;:&quot;PROVISIONING&quot;,&quot;displayName&quot;:&quot;\u003cstring\u003e&quot;,&quot;availabilityDomain&quot;:&quot;\u003cstring\u003e&quot;,&quot;subnetId&quot;:&quot;\u003cstring\u003e&quot;,&quot;shape&quot;:&quot;\u003cstring\u003e&quot;,&quot;sshPublicKeys&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;cpuCoreCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;databaseEdition&quot;:&quot;STANDARD_EDITION&quot;,&quot;hostname&quot;:&quot;\u003cstring\u003e&quot;,&quot;domain&quot;:&quot;\u003cstring\u003e&quot;,&quot;backupNetworkNsgIds&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;backupSubnetId&quot;:&quot;\u003cstring\u003e&quot;,&quot;clusterName&quot;:&quot;\u003cstring\u003e&quot;,&quot;dataCollectionOptions&quot;:{&quot;isDiagnosticsEventsEnabled&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isHealthMonitoringEnabled&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isIncidentLogsEnabled&quot;:&quot;\u003cboolean\u003e&quot;},&quot;dataStoragePercentage&quot;:&quot;\u003cinteger\u003e&quot;,&quot;dataStorageSizeInGBs&quot;:&quot;\u003cinteger\u003e&quot;,&quot;dbSystemOptions&quot;:{&quot;storageManagement&quot;:&quot;ASM&quot;},&quot;definedTags&quot;:{&quot;ad23&quot;:{&quot;anim_9&quot;:{}}},&quot;diskRedundancy&quot;:&quot;NORMAL&quot;,&quot;faultDomains&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;freeformTags&quot;:{&quot;officia_9&quot;:&quot;\u003cstring\u003e&quot;},&quot;kmsKeyId&quot;:&quot;\u003cstring\u003e&quot;,&quot;lastMaintenanceRunId&quot;:&quot;\u003cstring\u003e&quot;,&quot;lastPatchHistoryEntryId&quot;:&quot;\u003cstring\u003e&quot;,&quot;licenseModel&quot;:&quot;LICENSE_INCLUDED&quot;,&quot;lifecycleDetails&quot;:&quot;\u003cstring\u003e&quot;,&quot;listenerPort&quot;:&quot;\u003cinteger\u003e&quot;,&quot;maintenanceWindow&quot;:{&quot;customActionTimeoutInMins&quot;:&quot;\u003cinteger\u003e&quot;,&quot;daysOfWeek&quot;:[{&quot;name&quot;:&quot;SATURDAY&quot;},{&quot;name&quot;:&quot;WEDNESDAY&quot;}],&quot;hoursOfDay&quot;:[&quot;\u003cinteger\u003e&quot;,&quot;\u003cinteger\u003e&quot;],&quot;isCustomActionTimeoutEnabled&quot;:&quot;\u003cboolean\u003e&quot;,&quot;leadTimeInWeeks&quot;:&quot;\u003cinteger\u003e&quot;,&quot;months&quot;:[{&quot;name&quot;:&quot;OCTOBER&quot;},{&quot;name&quot;:&quot;JULY&quot;}],&quot;patchingMode&quot;:&quot;NONROLLING&quot;,&quot;preference&quot;:&quot;NO_PREFERENCE&quot;,&quot;weeksOfMonth&quot;:[&quot;\u003cinteger\u003e&quot;,&quot;\u003cinteger\u003e&quot;]},&quot;memorySizeInGBs&quot;:&quot;\u003cinteger\u003e&quot;,&quot;nextMaintenanceRunId&quot;:&quot;\u003cstring\u003e&quot;,&quot;nodeCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;nsgIds&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;pointInTimeDataDiskCloneTimestamp&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;recoStorageSizeInGB&quot;:&quot;\u003cinteger\u003e&quot;,&quot;scanDnsName&quot;:&quot;\u003cstring\u003e&quot;,&quot;scanDnsRecordId&quot;:&quot;\u003cstring\u003e&quot;,&quot;scanIpIds&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;sourceDbSystemId&quot;:&quot;\u003cstring\u003e&quot;,&quot;sparseDiskgroup&quot;:&quot;\u003cboolean\u003e&quot;,&quot;storageVolumePerformanceMode&quot;:&quot;BALANCED&quot;,&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;timeZone&quot;:&quot;\u003cstring\u003e&quot;,&quot;version&quot;:&quot;\u003cstring\u003e&quot;,&quot;vipIds&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;zoneId&quot;:&quot;\u003cstring\u003e&quot;},{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;compartmentId&quot;:&quot;\u003cstring\u003e&quot;,&quot;lifecycleState&quot;:&quot;TERMINATING&quot;,&quot;displayName&quot;:&quot;\u003cstring\u003e&quot;,&quot;availabilityDomain&quot;:&quot;\u003cstring\u003e&quot;,&quot;subnetId&quot;:&quot;\u003cstring\u003e&quot;,&quot;shape&quot;:&quot;\u003cstring\u003e&quot;,&quot;sshPublicKeys&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;cpuCoreCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;databaseEdition&quot;:&quot;ENTERPRISE_EDITION&quot;,&quot;hostname&quot;:&quot;\u003cstring\u003e&quot;,&quot;domain&quot;:&quot;\u003cstring\u003e&quot;,&quot;backupNetworkNsgIds&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;backupSubnetId&quot;:&quot;\u003cstring\u003e&quot;,&quot;clusterName&quot;:&quot;\u003cstring\u003e&quot;,&quot;dataCollectionOptions&quot;:{&quot;isDiagnosticsEventsEnabled&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isHealthMonitoringEnabled&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isIncidentLogsEnabled&quot;:&quot;\u003cboolean\u003e&quot;},&quot;dataStoragePercentage&quot;:&quot;\u003cinteger\u003e&quot;,&quot;dataStorageSizeInGBs&quot;:&quot;\u003cinteger\u003e&quot;,&quot;dbSystemOptions&quot;:{&quot;storageManagement&quot;:&quot;ASM&quot;},&quot;definedTags&quot;:{&quot;dolore_3e7&quot;:{&quot;qui_34_&quot;:{},&quot;id3&quot;:{},&quot;incididunt66&quot;:{}},&quot;nulla389&quot;:{&quot;qui5&quot;:{},&quot;pariatur_60&quot;:{},&quot;ad_99e&quot;:{}},&quot;do_76e&quot;:{&quot;culpa44&quot;:{},&quot;dolore_6&quot;:{},&quot;fugiat_e8&quot;:{}}},&quot;diskRedundancy&quot;:&quot;HIGH&quot;,&quot;faultDomains&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;freeformTags&quot;:{&quot;adipisicing_d&quot;:&quot;\u003cstring\u003e&quot;,&quot;adf&quot;:&quot;\u003cstring\u003e&quot;},&quot;kmsKeyId&quot;:&quot;\u003cstring\u003e&quot;,&quot;lastMaintenanceRunId&quot;:&quot;\u003cstring\u003e&quot;,&quot;lastPatchHistoryEntryId&quot;:&quot;\u003cstring\u003e&quot;,&quot;licenseModel&quot;:&quot;LICENSE_INCLUDED&quot;,&quot;lifecycleDetails&quot;:&quot;\u003cstring\u003e&quot;,&quot;listenerPort&quot;:&quot;\u003cinteger\u003e&quot;,&quot;maintenanceWindow&quot;:{&quot;customActionTimeoutInMins&quot;:&quot;\u003cinteger\u003e&quot;,&quot;daysOfWeek&quot;:[{&quot;name&quot;:&quot;THURSDAY&quot;},{&quot;name&quot;:&quot;SATURDAY&quot;}],&quot;hoursOfDay&quot;:[&quot;\u003cinteger\u003e&quot;,&quot;\u003cinteger\u003e&quot;],&quot;isCustomActionTimeoutEnabled&quot;:&quot;\u003cboolean\u003e&quot;,&quot;leadTimeInWeeks&quot;:&quot;\u003cinteger\u003e&quot;,&quot;months&quot;:[{&quot;name&quot;:&quot;MAY&quot;},{&quot;name&quot;:&quot;MARCH&quot;}],&quot;patchingMode&quot;:&quot;ROLLING&quot;,&quot;preference&quot;:&quot;NO_PREFERENCE&quot;,&quot;weeksOfMonth&quot;:[&quot;\u003cinteger\u003e&quot;,&quot;\u003cinteger\u003e&quot;]},&quot;memorySizeInGBs&quot;:&quot;\u003cinteger\u003e&quot;,&quot;nextMaintenanceRunId&quot;:&quot;\u003cstring\u003e&quot;,&quot;nodeCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;nsgIds&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;pointInTimeDataDiskCloneTimestamp&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;recoStorageSizeInGB&quot;:&quot;\u003cinteger\u003e&quot;,&quot;scanDnsName&quot;:&quot;\u003cstring\u003e&quot;,&quot;scanDnsRecordId&quot;:&quot;\u003cstring\u003e&quot;,&quot;scanIpIds&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;sourceDbSystemId&quot;:&quot;\u003cstring\u003e&quot;,&quot;sparseDiskgroup&quot;:&quot;\u003cboolean\u003e&quot;,&quot;storageVolumePerformanceMode&quot;:&quot;BALANCED&quot;,&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;timeZone&quot;:&quot;\u003cstring\u003e&quot;,&quot;version&quot;:&quot;\u003cstring\u003e&quot;,&quot;vipIds&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;zoneId&quot;:&quot;\u003cstring\u003e&quot;}]