Class DbSystem
Inherited Members
Namespace: Oci.DatabaseService.Models
Assembly: OCI.DotNetSDK.Database.dll
Syntax
public class DbSystem
Properties
AvailabilityDomain
Declaration
[Required(ErrorMessage = "AvailabilityDomain is required.")]
[JsonProperty(PropertyName = "availabilityDomain")]
public string AvailabilityDomain { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The name of the availability domain that the DB system is located in. |
Remarks
Required
BackupNetworkNsgIds
Declaration
[JsonProperty(PropertyName = "backupNetworkNsgIds")]
public List<string> BackupNetworkNsgIds { get; set; }
Property Value
| Type | Description |
|---|---|
| List<string> | A list of the OCIDs 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. Applicable only to Exadata systems. |
BackupSubnetId
Declaration
[JsonProperty(PropertyName = "backupSubnetId")]
public string BackupSubnetId { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The OCID of the backup network subnet the DB system is associated with. Applicable only to Exadata DB systems.
|
ClusterName
Declaration
[JsonProperty(PropertyName = "clusterName")]
public string ClusterName { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The 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. |
ClusterPlacementGroupId
Declaration
[JsonProperty(PropertyName = "clusterPlacementGroupId")]
public string ClusterPlacementGroupId { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The OCID of the cluster placement group of the Exadata Infrastructure or Db System. |
CompartmentId
Declaration
[Required(ErrorMessage = "CompartmentId is required.")]
[JsonProperty(PropertyName = "compartmentId")]
public string CompartmentId { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The OCID of the compartment. |
Remarks
Required
ComputeCount
Declaration
[JsonProperty(PropertyName = "computeCount")]
public int? ComputeCount { get; set; }
Property Value
| Type | Description |
|---|---|
| int? | The number of compute servers for the DB system. |
ComputeModel
Declaration
[JsonProperty(PropertyName = "computeModel")]
[JsonConverter(typeof(ResponseEnumConverter))]
public DbSystem.ComputeModelEnum? ComputeModel { get; set; }
Property Value
| Type | Description |
|---|---|
| DbSystem.ComputeModelEnum? | The compute model for Base Database Service. This is required if using the |
CpuCoreCount
Declaration
[JsonProperty(PropertyName = "cpuCoreCount")]
public int? CpuCoreCount { get; set; }
Property Value
| Type | Description |
|---|---|
| int? | The number of CPU cores enabled on the DB system. |
DataCollectionOptions
Declaration
[JsonProperty(PropertyName = "dataCollectionOptions")]
public DataCollectionOptions DataCollectionOptions { get; set; }
Property Value
| Type | Description |
|---|---|
| DataCollectionOptions |
DataStoragePercentage
Declaration
[JsonProperty(PropertyName = "dataStoragePercentage")]
public int? DataStoragePercentage { get; set; }
Property Value
| Type | Description |
|---|---|
| int? | The 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. |
DataStorageSizeInGBs
Declaration
[JsonProperty(PropertyName = "dataStorageSizeInGBs")]
public int? DataStorageSizeInGBs { get; set; }
Property Value
| Type | Description |
|---|---|
| int? | The data storage size, in gigabytes, that is currently available to the DB system. Applies only for virtual machine DB systems. |
DatabaseEdition
Declaration
[Required(ErrorMessage = "DatabaseEdition is required.")]
[JsonProperty(PropertyName = "databaseEdition")]
[JsonConverter(typeof(ResponseEnumConverter))]
public DbSystem.DatabaseEditionEnum? DatabaseEdition { get; set; }
Property Value
| Type | Description |
|---|---|
| DbSystem.DatabaseEditionEnum? | The 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. |
Remarks
Required
DbSystemOptions
Declaration
[JsonProperty(PropertyName = "dbSystemOptions")]
public DbSystemOptions DbSystemOptions { get; set; }
Property Value
| Type | Description |
|---|---|
| DbSystemOptions |
DefinedTags
Declaration
[JsonProperty(PropertyName = "definedTags")]
public Dictionary<string, Dictionary<string, object>> DefinedTags { get; set; }
Property Value
| Type | Description |
|---|---|
| Dictionary<string, Dictionary<string, object>> | Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. |
DiskRedundancy
Declaration
[JsonProperty(PropertyName = "diskRedundancy")]
[JsonConverter(typeof(ResponseEnumConverter))]
public DbSystem.DiskRedundancyEnum? DiskRedundancy { get; set; }
Property Value
| Type | Description |
|---|---|
| DbSystem.DiskRedundancyEnum? | The type of redundancy configured for the DB system. NORMAL is 2-way redundancy. HIGH is 3-way redundancy. |
DisplayName
Declaration
[Required(ErrorMessage = "DisplayName is required.")]
[JsonProperty(PropertyName = "displayName")]
public string DisplayName { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The user-friendly name for the DB system. The name does not have to be unique. |
Remarks
Required
Domain
Declaration
[Required(ErrorMessage = "Domain is required.")]
[JsonProperty(PropertyName = "domain")]
public string Domain { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The domain name for the DB system. |
Remarks
Required
FaultDomains
Declaration
[JsonProperty(PropertyName = "faultDomains")]
public List<string> FaultDomains { get; set; }
Property Value
| Type | Description |
|---|---|
| List<string> | List of the Fault Domains in which this DB system is provisioned. |
FreeformTags
Declaration
[JsonProperty(PropertyName = "freeformTags")]
public Dictionary<string, string> FreeformTags { get; set; }
Property Value
| Type | Description |
|---|---|
| Dictionary<string, string> | Free-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.
|
GiSoftwareImageId
Declaration
[JsonProperty(PropertyName = "giSoftwareImageId")]
public string GiSoftwareImageId { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The OCID of a grid infrastructure software image. This is a database software image of the type |
Hostname
Declaration
[Required(ErrorMessage = "Hostname is required.")]
[JsonProperty(PropertyName = "hostname")]
public string Hostname { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The hostname for the DB system. |
Remarks
Required
Id
Declaration
[Required(ErrorMessage = "Id is required.")]
[JsonProperty(PropertyName = "id")]
public string Id { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The OCID of the DB system. |
Remarks
Required
IormConfigCache
Declaration
[JsonProperty(PropertyName = "iormConfigCache")]
public ExadataIormConfig IormConfigCache { get; set; }
Property Value
| Type | Description |
|---|---|
| ExadataIormConfig |
KmsKeyId
Declaration
[JsonProperty(PropertyName = "kmsKeyId")]
public string KmsKeyId { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations. |
LastMaintenanceRunId
Declaration
[JsonProperty(PropertyName = "lastMaintenanceRunId")]
public string LastMaintenanceRunId { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The OCID of the last maintenance run. |
LastPatchHistoryEntryId
Declaration
[JsonProperty(PropertyName = "lastPatchHistoryEntryId")]
public string LastPatchHistoryEntryId { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The OCID of the last patch history. This value is updated as soon as a patch operation starts. |
LicenseModel
Declaration
[JsonProperty(PropertyName = "licenseModel")]
[JsonConverter(typeof(ResponseEnumConverter))]
public DbSystem.LicenseModelEnum? LicenseModel { get; set; }
Property Value
| Type | Description |
|---|---|
| DbSystem.LicenseModelEnum? | The Oracle license model that applies to all the databases on the DB system. The default is LICENSE_INCLUDED. |
LifecycleDetails
Declaration
[JsonProperty(PropertyName = "lifecycleDetails")]
public string LifecycleDetails { get; set; }
Property Value
| Type | Description |
|---|---|
| string | Additional information about the current lifecycle state. |
LifecycleState
Declaration
[Required(ErrorMessage = "LifecycleState is required.")]
[JsonProperty(PropertyName = "lifecycleState")]
[JsonConverter(typeof(ResponseEnumConverter))]
public DbSystem.LifecycleStateEnum? LifecycleState { get; set; }
Property Value
| Type | Description |
|---|---|
| DbSystem.LifecycleStateEnum? | The current state of the DB system. |
Remarks
Required
ListenerPort
Declaration
[JsonProperty(PropertyName = "listenerPort")]
public int? ListenerPort { get; set; }
Property Value
| Type | Description |
|---|---|
| int? | The port number configured for the listener on the DB system. |
MaintenanceWindow
Declaration
[JsonProperty(PropertyName = "maintenanceWindow")]
public MaintenanceWindow MaintenanceWindow { get; set; }
Property Value
| Type | Description |
|---|---|
| MaintenanceWindow |
MemorySizeInGBs
Declaration
[JsonProperty(PropertyName = "memorySizeInGBs")]
public int? MemorySizeInGBs { get; set; }
Property Value
| Type | Description |
|---|---|
| int? | Memory allocated to the DB system, in gigabytes. |
NextMaintenanceRunId
Declaration
[JsonProperty(PropertyName = "nextMaintenanceRunId")]
public string NextMaintenanceRunId { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The OCID of the next maintenance run. |
NodeCount
Declaration
[JsonProperty(PropertyName = "nodeCount")]
public int? NodeCount { get; set; }
Property Value
| Type | Description |
|---|---|
| int? | The number of nodes in the DB system. For RAC DB systems, the value is greater than 1. |
NsgIds
Declaration
[JsonProperty(PropertyName = "nsgIds")]
public List<string> NsgIds { get; set; }
Property Value
| Type | Description |
|---|---|
| List<string> | The list of OCIDs 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. NsgIds restrictions:
|
OsVersion
Declaration
[JsonProperty(PropertyName = "osVersion")]
public string OsVersion { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The most recent OS Patch Version applied on the DB system. |
PointInTimeDataDiskCloneTimestamp
Declaration
[JsonProperty(PropertyName = "pointInTimeDataDiskCloneTimestamp")]
public DateTime? PointInTimeDataDiskCloneTimestamp { get; set; }
Property Value
| Type | Description |
|---|---|
| DateTime? | 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. |
RecoStorageSizeInGB
Declaration
[JsonProperty(PropertyName = "recoStorageSizeInGB")]
public int? RecoStorageSizeInGB { get; set; }
Property Value
| Type | Description |
|---|---|
| int? | The RECO/REDO storage size, in gigabytes, that is currently allocated to the DB system. Applies only for virtual machine DB systems. |
ScanDnsName
Declaration
[JsonProperty(PropertyName = "scanDnsName")]
public string ScanDnsName { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The FQDN of the DNS record for the SCAN IP addresses that are associated with the DB system. |
ScanDnsRecordId
Declaration
[JsonProperty(PropertyName = "scanDnsRecordId")]
public string ScanDnsRecordId { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The OCID of the DNS record for the SCAN IP addresses that are associated with the DB system. |
ScanIpIds
Declaration
[JsonProperty(PropertyName = "scanIpIds")]
public List<string> ScanIpIds { get; set; }
Property Value
| Type | Description |
|---|---|
| List<string> | The OCID 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.
|
ScanIpv6Ids
Declaration
[JsonProperty(PropertyName = "scanIpv6Ids")]
public List<string> ScanIpv6Ids { get; set; }
Property Value
| Type | Description |
|---|---|
| List<string> | The OCID 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.
|
SecurityAttributes
Declaration
[JsonProperty(PropertyName = "securityAttributes")]
public Dictionary<string, Dictionary<string, object>> SecurityAttributes { get; set; }
Property Value
| Type | Description |
|---|---|
| Dictionary<string, Dictionary<string, object>> | Security Attributes for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"Oracle-ZPR": {"MaxEgressCount": {"value": "42", "mode": "audit"}}} |
Shape
Declaration
[Required(ErrorMessage = "Shape is required.")]
[JsonProperty(PropertyName = "shape")]
public string Shape { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The shape of the DB system. The shape determines resources to allocate to the DB system.
|
Remarks
Required
SourceDbSystemId
Declaration
[JsonProperty(PropertyName = "sourceDbSystemId")]
public string SourceDbSystemId { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The OCID of the DB system. |
SparseDiskgroup
Declaration
[JsonProperty(PropertyName = "sparseDiskgroup")]
public bool? SparseDiskgroup { get; set; }
Property Value
| Type | Description |
|---|---|
| bool? | True, if Sparse Diskgroup is configured for Exadata dbsystem, False, if Sparse diskgroup was not configured. |
SshPublicKeys
Declaration
[Required(ErrorMessage = "SshPublicKeys is required.")]
[JsonProperty(PropertyName = "sshPublicKeys")]
public List<string> SshPublicKeys { get; set; }
Property Value
| Type | Description |
|---|---|
| List<string> | The public key portion of one or more key pairs used for SSH access to the DB system. |
Remarks
Required
StorageVolumePerformanceMode
Declaration
[JsonProperty(PropertyName = "storageVolumePerformanceMode")]
[JsonConverter(typeof(ResponseEnumConverter))]
public DbSystem.StorageVolumePerformanceModeEnum? StorageVolumePerformanceMode { get; set; }
Property Value
| Type | Description |
|---|---|
| DbSystem.StorageVolumePerformanceModeEnum? | The block storage volume performance level. Valid values are |
SubnetId
Declaration
[Required(ErrorMessage = "SubnetId is required.")]
[JsonProperty(PropertyName = "subnetId")]
public string SubnetId { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The OCID of the subnet the DB system is associated with.
|
Remarks
Required
SubscriptionId
Declaration
[JsonProperty(PropertyName = "subscriptionId")]
public string SubscriptionId { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The OCID of the subscription with which resource needs to be associated with. |
SystemTags
Declaration
[JsonProperty(PropertyName = "systemTags")]
public Dictionary<string, Dictionary<string, object>> SystemTags { get; set; }
Property Value
| Type | Description |
|---|---|
| Dictionary<string, Dictionary<string, object>> | System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. |
TimeCreated
Declaration
[JsonProperty(PropertyName = "timeCreated")]
public DateTime? TimeCreated { get; set; }
Property Value
| Type | Description |
|---|---|
| DateTime? | The date and time the DB system was created. |
TimeZone
Declaration
[JsonProperty(PropertyName = "timeZone")]
public string TimeZone { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The time zone of the DB system. For details, see DB System Time Zones. |
Version
Declaration
[JsonProperty(PropertyName = "version")]
public string Version { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The Oracle Database version of the DB system. |
VipIds
Declaration
[JsonProperty(PropertyName = "vipIds")]
public List<string> VipIds { get; set; }
Property Value
| Type | Description |
|---|---|
| List<string> | The OCID 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.
|
Vipv6Ids
Declaration
[JsonProperty(PropertyName = "vipv6Ids")]
public List<string> Vipv6Ids { get; set; }
Property Value
| Type | Description |
|---|---|
| List<string> | The OCID 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.
|
ZoneId
Declaration
[JsonProperty(PropertyName = "zoneId")]
public string ZoneId { get; set; }
Property Value
| Type | Description |
|---|---|
| string | The OCID of the zone the DB system is associated with. |