Skip to main content

db_systems

Creates, updates, deletes, gets or lists a db_systems resource.

Overview​

Namedb_systems
TypeResource
Idoci.database.db_systems

Fields​

The following fields are returned by SELECT queries:

The DB system information was retrieved.

NameDatatypeDescription
idstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the DB system.
availabilityDomainstringThe name of the availability domain that the DB system is located in.
backupNetworkNsgIdsarrayA list of the [OCIDs](/Content/General/Concepts/identifiers.htm) of the network security groups (NSGs) that the backup network of this DB system belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see [Security Rules](/Content/Network/Concepts/securityrules.htm). Applicable only to Exadata systems.
backupSubnetIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the backup network subnet the DB system is associated with. Applicable only to Exadata DB systems. Subnet Restriction: See the subnet restrictions information for subnetId.
clusterNamestringThe cluster name for Exadata and 2-node RAC virtual machine DB systems. The cluster name must begin with an alphabetic character, and may contain hyphens (-). Underscores (_) are not permitted. The cluster name can be no longer than 11 characters and is not case sensitive.
compartmentIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the compartment.
computeCountinteger (int32)The number of compute servers for the DB system.
computeModelstringThe compute model for Base Database Service. This is required if using the computeCount parameter. If using cpuCoreCount then it is an error to specify computeModel to a non-null value. The ECPU compute model is the recommended model, and the OCPU compute model is legacy. (ECPU, OCPU)
cpuCoreCountintegerThe number of CPU cores enabled on the DB system.
dataCollectionOptionsobjectIndicates user preferences for the various diagnostic collection options for the VM cluster/Cloud VM cluster/VMBM DBCS.
dataStoragePercentageintegerThe percentage assigned to DATA storage (user data and database files). The remaining percentage is assigned to RECO storage (database redo logs, archive logs, and recovery manager backups). Accepted values are 40 and 80. The default is 80 percent assigned to DATA storage. Not applicable for virtual machine DB systems.
dataStorageSizeInGBsintegerThe data storage size, in gigabytes, that is currently available to the DB system. Applies only for virtual machine DB systems.
databaseEditionstringThe Oracle Database Edition that applies to all the databases on the DB system. Exadata DB systems and 2-node RAC DB systems require ENTERPRISE_EDITION_EXTREME_PERFORMANCE. (STANDARD_EDITION, ENTERPRISE_EDITION, ENTERPRISE_EDITION_HIGH_PERFORMANCE, ENTERPRISE_EDITION_EXTREME_PERFORMANCE, ENTERPRISE_EDITION_DEVELOPER)
dbSystemOptionsobjectThe DB system options.
definedTagsobjectDefined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm).
diskRedundancystringThe type of redundancy configured for the DB system. NORMAL is 2-way redundancy. HIGH is 3-way redundancy. (HIGH, NORMAL)
displayNamestringThe user-friendly name for the DB system. The name does not have to be unique.
domainstringThe domain name for the DB system.
faultDomainsarrayList of the Fault Domains in which this DB system is provisioned.
freeformTagsobjectFree-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm). Example: {"Department": "Finance"}
giSoftwareImageIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) of a grid infrastructure software image. This is a database software image of the type GRID_IMAGE.
hostnamestringThe hostname for the DB system.
iormConfigCacheobjectThe IORM settings of the Exadata DB system.
kmsKeyIdstringThe OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.
lastMaintenanceRunIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the last maintenance run.
lastPatchHistoryEntryIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the last patch history. This value is updated as soon as a patch operation starts.
licenseModelstringThe Oracle license model that applies to all the databases on the DB system. The default is LICENSE_INCLUDED. (LICENSE_INCLUDED, BRING_YOUR_OWN_LICENSE)
lifecycleDetailsstringAdditional information about the current lifecycle state.
lifecycleStatestringThe current state of the DB system. (PROVISIONING, AVAILABLE, UPDATING, TERMINATING, TERMINATED, FAILED, MIGRATED, MAINTENANCE_IN_PROGRESS, NEEDS_ATTENTION, UPGRADING)
listenerPortintegerThe port number configured for the listener on the DB system.
maintenanceWindowobjectThe scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.
memorySizeInGBsintegerMemory allocated to the DB system, in gigabytes. (x-default-description: null)
nextMaintenanceRunIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the next maintenance run.
nodeCountintegerThe number of nodes in the DB system. For RAC DB systems, the value is greater than 1.
nsgIdsarrayThe list of [OCIDs](/Content/General/Concepts/identifiers.htm) for the network security groups (NSGs) to which this resource belongs. Setting this to an empty list removes all resources from all NSGs. For more information about NSGs, see [Security Rules](/Content/Network/Concepts/securityrules.htm).
pointInTimeDataDiskCloneTimestampstring (date-time)The point in time for a cloned database system when the data disks were cloned from the source database system, as described in [RFC 3339](https:​//tools.ietf.org/rfc/rfc3339).
recoStorageSizeInGBintegerThe RECO/REDO storage size, in gigabytes, that is currently allocated to the DB system. Applies only for virtual machine DB systems.
scanDnsNamestringThe FQDN of the DNS record for the SCAN IP addresses that are associated with the DB system.
scanDnsRecordIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the DNS record for the SCAN IP addresses that are associated with the DB system.
scanIpIdsarrayThe [OCID](/Content/General/Concepts/identifiers.htm) of the Single Client Access Name (SCAN) IPv4 addresses associated with the DB system. SCAN IPv4 addresses are typically used for load balancing and are not assigned to any interface. Oracle Clusterware directs the requests to the appropriate nodes in the cluster. Note: For a single-node DB system, this list is empty.
scanIpv6IdsarrayThe [OCID](/Content/General/Concepts/identifiers.htm) of the Single Client Access Name (SCAN) IPv6 addresses associated with the DB system. SCAN IPv6 addresses are typically used for load balancing and are not assigned to any interface. Oracle Clusterware directs the requests to the appropriate nodes in the cluster. Note: For a single-node DB system, this list is empty.
securityAttributesobjectSecurity Attributes for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/iaas/Content/General/Concepts/resourcetags.htm). Example: {"Oracle-ZPR": {"MaxEgressCount": {"value": "42", "mode": "audit"}}}
shapestringThe shape of the DB system. The shape determines resources to allocate to the DB system. - For virtual machine shapes, the number of CPU cores and memory - For bare metal and Exadata shapes, the number of CPU cores, storage, and memory
sourceDbSystemIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the DB system.
sparseDiskgroupbooleanTrue, if Sparse Diskgroup is configured for Exadata dbsystem, False, if Sparse diskgroup was not configured.
sshPublicKeysarrayThe public key portion of one or more key pairs used for SSH access to the DB system.
storageVolumePerformanceModestringThe block storage volume performance level. Valid values are BALANCED and HIGH_PERFORMANCE. See [Block Volume Performance](/Content/Block/Concepts/blockvolumeperformance.htm) for more information. (BALANCED, HIGH_PERFORMANCE) (default: BALANCED)
subnetIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the subnet the DB system is associated with. Subnet Restrictions: - For bare metal DB systems and for single node virtual machine DB systems, do not use a subnet that overlaps with 192.168.16.16/28. - For Exadata and virtual machine 2-node RAC DB systems, do not use a subnet that overlaps with 192.168.128.0/20. These subnets are used by the Oracle Clusterware private interconnect on the database instance. Specifying an overlapping subnet will cause the private interconnect to malfunction. This restriction applies to both the client subnet and backup subnet.
systemTagsobjectSystem tags for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm).
timeCreatedstring (date-time)The date and time the DB system was created.
timeZonestringThe time zone of the DB system. For details, see [DB System Time Zones](/Content/Database/References/timezones.htm).
versionstringThe Oracle Database version of the DB system.
vipIdsarrayThe [OCID](/Content/General/Concepts/identifiers.htm) of the virtual IPv4 (VIP) addresses associated with the DB system. The Cluster Ready Services (CRS) creates and maintains one VIPv4 address for each node in the DB system to enable failover. If one node fails, the VIPv4 is reassigned to another active node in the cluster. Note: For a single-node DB system, this list is empty.
vipv6IdsarrayThe [OCID](/Content/General/Concepts/identifiers.htm) of the virtual IPv6 (VIP) addresses associated with the DB system. The Cluster Ready Services (CRS) creates and maintains one VIP IpV6 address for each node in the DB system to enable failover. If one node fails, the VIP is reassigned to another active node in the cluster. Note: For a single-node DB system, this list is empty.
zoneIdstringThe OCID of the zone the DB system is associated with.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectdbSystemId, regionGets information about the specified DB system.<br /><br />Note: Deprecated for Exadata Cloud Service systems. Use the [new resource model APIs](/iaas/Content/Database/Concepts/exaflexsystem.htm#exaflexsystem_topic-resource_model) instead.<br /><br />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](/iaas/Content/Database/Concepts/exaflexsystem_topic-resource_model_conversion.htm) for details on converting existing Exadata DB systems to the new resource model.<br />
listselectcompartmentId, regionlimit, page, backupId, sortBy, sortOrder, lifecycleState, availabilityDomain, displayNameLists 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.<br /><br />Note: Deprecated for Exadata Cloud Service systems. Use the [new resource model APIs](/iaas/Content/Database/Concepts/exaflexsystem.htm#exaflexsystem_topic-resource_model) instead.<br /><br />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](/iaas/Content/Database/Concepts/exaflexsystem_topic-resource_model_conversion.htm) for details on converting existing Exadata DB systems to the new resource model.<br />
launchinsertregion, compartmentId, availabilityDomain, subnetId, shape, sshPublicKeys, hostnameopc-retry-tokenCreates a new DB system in the specified compartment and availability domain. The Oracle<br />Database edition that you specify applies to all the databases on that DB system. The selected edition cannot be changed.<br /><br />An initial database is created on the DB system based on the request parameters you provide and some default<br />options. For detailed information about default options, see [Bare metal and virtual machine DB system default options.](/Content/Database/Tasks/creatingDBsystem.htm#Default)<br /><br />Note: Deprecated for Exadata Cloud Service systems. Use the [new resource model APIs](/iaas/Content/Database/Concepts/exaflexsystem.htm#exaflexsystem_topic-resource_model) instead.<br /><br />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](/iaas/Content/Database/Concepts/exaflexsystem_topic-resource_model_conversion.htm) for details on converting existing Exadata DB systems to the new resource model.<br /><br />Use the [CreateCloudExadataInfrastructure](#/en/database/latest/CloudExadataInfrastructure/CreateCloudExadataInfrastructure/) and [CreateCloudVmCluster](#/en/database/latest/CloudVmCluster/CreateCloudVmCluster/) APIs to provision a new Exadata Cloud Service instance.<br />
updateupdatedbSystemId, regionif-matchUpdates the properties of the specified DB system.<br /><br />Note: Deprecated for Exadata Cloud Service systems. Use the [new resource model APIs](/iaas/Content/Database/Concepts/exaflexsystem.htm#exaflexsystem_topic-resource_model) instead.<br /><br />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](/iaas/Content/Database/Concepts/exaflexsystem_topic-resource_model_conversion.htm) for details on converting existing Exadata DB systems to the new resource model.<br />
terminatedeletedbSystemId, regionif-matchTerminates a DB system and permanently deletes it and any databases running on it, and any storage volumes attached to it. The database data is local to the DB system and will be lost when the system is terminated. Oracle recommends that you back up any data in the DB system prior to terminating it.<br /><br />Note: Deprecated for Exadata Cloud Service systems. Use the [new resource model APIs](/iaas/Content/Database/Concepts/exaflexsystem.htm#exaflexsystem_topic-resource_model) instead.<br /><br />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](/iaas/Content/Database/Concepts/exaflexsystem_topic-resource_model_conversion.htm) for details on converting existing Exadata DB systems to the new resource model.<br />
change_compartmentexecdbSystemId, region, compartmentIdopc-retry-token, opc-request-id, if-matchMoves the DB system and its dependent resources to the specified compartment.<br />For more information about moving DB systems, see<br />[Moving Database Resources to a Different Compartment](/Content/Database/Concepts/databaseoverview.htm#moveRes).<br />
migrate_exadata_db_system_resource_modelexecdbSystemId, regionopc-request-id, if-match, opc-retry-tokenMigrates the Exadata DB system to the new [Exadata resource model](/iaas/Content/Database/Concepts/exaflexsystem.htm#exaflexsystem_topic-resource_model).<br />All related resources will be migrated.<br />
execute_db_system_os_patchexecdbSystemId, region, actionopc-retry-token, opc-request-id, if-matchExecute an operating system (OS) patch action on a DB system. Returns 202 and a work request. Some updates may require a reboot.<br />
upgrade_db_systemexecdbSystemId, region, actionif-match, opc-request-id, opc-retry-tokenUpgrades the operating system and grid infrastructure of the DB system.<br />

Parameters​

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
compartmentIdstringThe compartment [OCID](/Content/General/Concepts/identifiers.htm).
dbSystemIdstringThe DB system [OCID](/Content/General/Concepts/identifiers.htm).
regionstringOCI region identifier (e.g. us-ashburn-1, ap-sydney-1); resolves from OCI_REGION when not supplied in the query. (default: us-ashburn-1, x-stackQL-envVar: OCI_REGION)
availabilityDomainstringA filter to return only resources that match the given availability domain exactly.
backupIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) 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.
displayNamestringA filter to return only resources that match the entire display name given. The match is not case sensitive.
if-matchstringFor optimistic concurrency control. In the PUT or DELETE call for a resource, set the if-match parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value.
lifecycleStatestringA filter to return only resources that match the given lifecycle state exactly.
limitintegerThe maximum number of items to return per page.
opc-request-idstringUnique identifier for the request.
opc-retry-tokenstringA token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations (for example, if a resource has been deleted and purged from the system, then a retry of the original creation request may be rejected).
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. Note: If you do not include the availability domain filter, the resources are grouped by availability domain, then sorted.
sortOrderstringThe sort order to use, either ascending (ASC) or descending (DESC).

SELECT examples​

Gets information about the specified DB system.<br /><br />Note: Deprecated for Exadata Cloud Service systems. Use the [new resource model APIs](/iaas/Content/Database/Concepts/exaflexsystem.htm#exaflexsystem_topic-resource_model) instead.<br /><br />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](/iaas/Content/Database/Concepts/exaflexsystem_topic-resource_model_conversion.htm) for details on converting existing Exadata DB systems to the new resource model.<br />

SELECT
id,
availabilityDomain,
backupNetworkNsgIds,
backupSubnetId,
clusterName,
compartmentId,
computeCount,
computeModel,
cpuCoreCount,
dataCollectionOptions,
dataStoragePercentage,
dataStorageSizeInGBs,
databaseEdition,
dbSystemOptions,
definedTags,
diskRedundancy,
displayName,
domain,
faultDomains,
freeformTags,
giSoftwareImageId,
hostname,
iormConfigCache,
kmsKeyId,
lastMaintenanceRunId,
lastPatchHistoryEntryId,
licenseModel,
lifecycleDetails,
lifecycleState,
listenerPort,
maintenanceWindow,
memorySizeInGBs,
nextMaintenanceRunId,
nodeCount,
nsgIds,
pointInTimeDataDiskCloneTimestamp,
recoStorageSizeInGB,
scanDnsName,
scanDnsRecordId,
scanIpIds,
scanIpv6Ids,
securityAttributes,
shape,
sourceDbSystemId,
sparseDiskgroup,
sshPublicKeys,
storageVolumePerformanceMode,
subnetId,
systemTags,
timeCreated,
timeZone,
version,
vipIds,
vipv6Ids,
zoneId
FROM oci.database.db_systems
WHERE dbSystemId = '{{ dbSystemId }}' -- required
AND region = '{{ region }}' -- required
;

INSERT examples​

Creates a new DB system in the specified compartment and availability domain. The Oracle<br />Database edition that you specify applies to all the databases on that DB system. The selected edition cannot be changed.<br /><br />An initial database is created on the DB system based on the request parameters you provide and some default<br />options. For detailed information about default options, see [Bare metal and virtual machine DB system default options.](/Content/Database/Tasks/creatingDBsystem.htm#Default)<br /><br />Note: Deprecated for Exadata Cloud Service systems. Use the [new resource model APIs](/iaas/Content/Database/Concepts/exaflexsystem.htm#exaflexsystem_topic-resource_model) instead.<br /><br />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](/iaas/Content/Database/Concepts/exaflexsystem_topic-resource_model_conversion.htm) for details on converting existing Exadata DB systems to the new resource model.<br /><br />Use the [CreateCloudExadataInfrastructure](#/en/database/latest/CloudExadataInfrastructure/CreateCloudExadataInfrastructure/) and [CreateCloudVmCluster](#/en/database/latest/CloudVmCluster/CreateCloudVmCluster/) APIs to provision a new Exadata Cloud Service instance.<br />

INSERT INTO oci.database.db_systems (
availabilityDomain,
backupNetworkNsgIds,
backupSubnetId,
clusterName,
compartmentId,
computeCount,
computeModel,
cpuCoreCount,
dataCollectionOptions,
dataStoragePercentage,
dbSystemOptions,
definedTags,
displayName,
domain,
faultDomains,
freeformTags,
hostname,
initialDataStorageSizeInGB,
kmsKeyId,
kmsKeyVersionId,
nodeCount,
nsgIds,
privateIp,
privateIpV6,
securityAttributes,
shape,
source,
sparseDiskgroup,
sshPublicKeys,
storageVolumePerformanceMode,
subnetId,
timeZone,
region,
opc-retry-token
)
SELECT 
'{{ availabilityDomain }}' /* required */,
'{{ backupNetworkNsgIds }}',
'{{ backupSubnetId }}',
'{{ clusterName }}',
'{{ compartmentId }}' /* required */,
{{ computeCount }},
'{{ computeModel }}',
{{ cpuCoreCount }},
'{{ dataCollectionOptions }}',
{{ dataStoragePercentage }},
'{{ dbSystemOptions }}',
'{{ definedTags }}',
'{{ displayName }}',
'{{ domain }}',
'{{ faultDomains }}',
'{{ freeformTags }}',
'{{ hostname }}' /* required */,
{{ initialDataStorageSizeInGB }},
'{{ kmsKeyId }}',
'{{ kmsKeyVersionId }}',
{{ nodeCount }},
'{{ nsgIds }}',
'{{ privateIp }}',
'{{ privateIpV6 }}',
'{{ securityAttributes }}',
'{{ shape }}' /* required */,
'{{ source }}',
{{ sparseDiskgroup }},
'{{ sshPublicKeys }}' /* required */,
'{{ storageVolumePerformanceMode }}',
'{{ subnetId }}' /* required */,
'{{ timeZone }}',
'{{ region }}',
'{{ opc-retry-token }}'
RETURNING
id,
availabilityDomain,
backupNetworkNsgIds,
backupSubnetId,
clusterName,
compartmentId,
computeCount,
computeModel,
cpuCoreCount,
dataCollectionOptions,
dataStoragePercentage,
dataStorageSizeInGBs,
databaseEdition,
dbSystemOptions,
definedTags,
diskRedundancy,
displayName,
domain,
faultDomains,
freeformTags,
giSoftwareImageId,
hostname,
iormConfigCache,
kmsKeyId,
lastMaintenanceRunId,
lastPatchHistoryEntryId,
licenseModel,
lifecycleDetails,
lifecycleState,
listenerPort,
maintenanceWindow,
memorySizeInGBs,
nextMaintenanceRunId,
nodeCount,
nsgIds,
pointInTimeDataDiskCloneTimestamp,
recoStorageSizeInGB,
scanDnsName,
scanDnsRecordId,
scanIpIds,
scanIpv6Ids,
securityAttributes,
shape,
sourceDbSystemId,
sparseDiskgroup,
sshPublicKeys,
storageVolumePerformanceMode,
subnetId,
systemTags,
timeCreated,
timeZone,
version,
vipIds,
vipv6Ids,
zoneId
;

UPDATE examples​

Updates the properties of the specified DB system.<br /><br />Note: Deprecated for Exadata Cloud Service systems. Use the [new resource model APIs](/iaas/Content/Database/Concepts/exaflexsystem.htm#exaflexsystem_topic-resource_model) instead.<br /><br />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](/iaas/Content/Database/Concepts/exaflexsystem_topic-resource_model_conversion.htm) for details on converting existing Exadata DB systems to the new resource model.<br />

UPDATE oci.database.db_systems
SET 
backupNetworkNsgIds = '{{ backupNetworkNsgIds }}',
computeCount = {{ computeCount }},
computeModel = '{{ computeModel }}',
cpuCoreCount = {{ cpuCoreCount }},
dataCollectionOptions = '{{ dataCollectionOptions }}',
dataStorageSizeInGBs = {{ dataStorageSizeInGBs }},
definedTags = '{{ definedTags }}',
freeformTags = '{{ freeformTags }}',
licenseModel = '{{ licenseModel }}',
maintenanceWindowDetails = '{{ maintenanceWindowDetails }}',
nsgIds = '{{ nsgIds }}',
securityAttributes = '{{ securityAttributes }}',
shape = '{{ shape }}',
sshPublicKeys = '{{ sshPublicKeys }}',
version = '{{ version }}'
WHERE 
dbSystemId = '{{ dbSystemId }}' --required
AND region = '{{ region }}' --required
AND if-match = '{{ if-match}}'
RETURNING
id,
availabilityDomain,
backupNetworkNsgIds,
backupSubnetId,
clusterName,
compartmentId,
computeCount,
computeModel,
cpuCoreCount,
dataCollectionOptions,
dataStoragePercentage,
dataStorageSizeInGBs,
databaseEdition,
dbSystemOptions,
definedTags,
diskRedundancy,
displayName,
domain,
faultDomains,
freeformTags,
giSoftwareImageId,
hostname,
iormConfigCache,
kmsKeyId,
lastMaintenanceRunId,
lastPatchHistoryEntryId,
licenseModel,
lifecycleDetails,
lifecycleState,
listenerPort,
maintenanceWindow,
memorySizeInGBs,
nextMaintenanceRunId,
nodeCount,
nsgIds,
pointInTimeDataDiskCloneTimestamp,
recoStorageSizeInGB,
scanDnsName,
scanDnsRecordId,
scanIpIds,
scanIpv6Ids,
securityAttributes,
shape,
sourceDbSystemId,
sparseDiskgroup,
sshPublicKeys,
storageVolumePerformanceMode,
subnetId,
systemTags,
timeCreated,
timeZone,
version,
vipIds,
vipv6Ids,
zoneId;

DELETE examples​

Terminates a DB system and permanently deletes it and any databases running on it, and any storage volumes attached to it. The database data is local to the DB system and will be lost when the system is terminated. Oracle recommends that you back up any data in the DB system prior to terminating it.<br /><br />Note: Deprecated for Exadata Cloud Service systems. Use the [new resource model APIs](/iaas/Content/Database/Concepts/exaflexsystem.htm#exaflexsystem_topic-resource_model) instead.<br /><br />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](/iaas/Content/Database/Concepts/exaflexsystem_topic-resource_model_conversion.htm) for details on converting existing Exadata DB systems to the new resource model.<br />

DELETE FROM oci.database.db_systems
WHERE dbSystemId = '{{ dbSystemId }}' --required
AND region = '{{ region }}' --required
AND if-match = '{{ if-match }}'
;

Lifecycle Methods​

Moves the DB system and its dependent resources to the specified compartment.<br />For more information about moving DB systems, see<br />[Moving Database Resources to a Different Compartment](/Content/Database/Concepts/databaseoverview.htm#moveRes).<br />

EXEC oci.database.db_systems.change_compartment 
@dbSystemId='{{ dbSystemId }}' --required, 
@region='{{ region }}' --required, 
@opc-retry-token='{{ opc-retry-token }}', 
@opc-request-id='{{ opc-request-id }}', 
@if-match='{{ if-match }}' 
@@json=
'{
"compartmentId": "{{ compartmentId }}"
}'
;