ListDbHomes

GET {{baseUrl}}/dbHomes?compartmentId=<string>&dbSystemId=<string>&vmClusterId=<string>&backupId=<string>&dbVersion=NONE&limit=10&page=<string>&sortBy=TIMECREATED&sortOrder=ASC&lifecycleState=<string>&displayName=<string>

Lists the Database Homes in the specified DB system and compartment. A Database Home is a directory where Oracle Database software is installed.

Request Params

KeyDatatypeRequiredDescription
compartmentIdstring(Required) The compartment OCID.
dbSystemIdstringThe DB system OCID. If provided, filters the results to the set of database versions which are supported for the DB system.
vmClusterIdstringThe OCID of the VM cluster.
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.
dbVersionstringA filter to return only DB Homes that match the specified dbVersion.
limitnumberThe maximum number of items to return per page.
pagestringThe pagination token to continue listing from.
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.
sortOrderstringThe sort order to use, either ascending (ASC) or descending (DESC).
lifecycleStatestringA filter to return only resources that match the given lifecycle state exactly.
displayNamestringA 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;TERMINATED&quot;,&quot;displayName&quot;:&quot;\u003cstring\u003e&quot;,&quot;dbVersion&quot;:&quot;\u003cstring\u003e&quot;,&quot;dbHomeLocation&quot;:&quot;\u003cstring\u003e&quot;,&quot;databaseSoftwareImageId&quot;:&quot;\u003cstring\u003e&quot;,&quot;dbSystemId&quot;:&quot;\u003cstring\u003e&quot;,&quot;definedTags&quot;:{&quot;anim72&quot;:{&quot;autea&quot;:{},&quot;suntb3&quot;:{},&quot;doloref1&quot;:{}},&quot;adipisicing_e&quot;:{&quot;ex9&quot;:{},&quot;ametf&quot;:{},&quot;officia71a&quot;:{}},&quot;nostrud21&quot;:{&quot;Duis__b&quot;:{}}},&quot;freeformTags&quot;:{&quot;laboris86&quot;:&quot;\u003cstring\u003e&quot;,&quot;amet__d6&quot;:&quot;\u003cstring\u003e&quot;},&quot;kmsKeyId&quot;:&quot;\u003cstring\u003e&quot;,&quot;lastPatchHistoryEntryId&quot;:&quot;\u003cstring\u003e&quot;,&quot;lifecycleDetails&quot;:&quot;\u003cstring\u003e&quot;,&quot;oneOffPatches&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;vmClusterId&quot;:&quot;\u003cstring\u003e&quot;},{&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;dbVersion&quot;:&quot;\u003cstring\u003e&quot;,&quot;dbHomeLocation&quot;:&quot;\u003cstring\u003e&quot;,&quot;databaseSoftwareImageId&quot;:&quot;\u003cstring\u003e&quot;,&quot;dbSystemId&quot;:&quot;\u003cstring\u003e&quot;,&quot;definedTags&quot;:{&quot;adipisicing4&quot;:{&quot;nulla_1_&quot;:{},&quot;dolore18&quot;:{}}},&quot;freeformTags&quot;:{&quot;laboref&quot;:&quot;\u003cstring\u003e&quot;,&quot;qui_7c1&quot;:&quot;\u003cstring\u003e&quot;,&quot;laboris_683&quot;:&quot;\u003cstring\u003e&quot;,&quot;culpa5&quot;:&quot;\u003cstring\u003e&quot;,&quot;ipsum_d8&quot;:&quot;\u003cstring\u003e&quot;},&quot;kmsKeyId&quot;:&quot;\u003cstring\u003e&quot;,&quot;lastPatchHistoryEntryId&quot;:&quot;\u003cstring\u003e&quot;,&quot;lifecycleDetails&quot;:&quot;\u003cstring\u003e&quot;,&quot;oneOffPatches&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;vmClusterId&quot;:&quot;\u003cstring\u003e&quot;}]