Skip to main content

vm_cluster_networks

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

Overview​

Namevm_cluster_networks
TypeResource
Idoci.database.vm_cluster_networks

Fields​

The following fields are returned by SELECT queries:

The specified Exadata Cloud@Customer VM cluster network.

NameDatatypeDescription
idstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the VM cluster network.
compartmentIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the compartment.
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).
displayNamestringThe user-friendly name for the VM cluster network. The name does not need to be unique.
dnsarrayThe list of DNS server IP addresses. Maximum of 3 allowed.
drScansarrayThe SCAN details for DR network
exadataInfrastructureIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the Exadata infrastructure.
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"}
lifecycleDetailsstringAdditional information about the current lifecycle state.
lifecycleStatestringThe current state of the VM cluster network. CREATING - The resource is being created REQUIRES_VALIDATION - The resource is created and may not be usable until it is validated. VALIDATING - The resource is being validated and not available to use. VALIDATED - The resource is validated and is available for consumption by VM cluster. VALIDATION_FAILED - The resource validation has failed and might require user input to be corrected. UPDATING - The resource is being updated and not available to use. ALLOCATED - The resource is is currently being used by VM cluster. TERMINATING - The resource is being deleted and not available to use. TERMINATED - The resource is deleted and unavailable. FAILED - The resource is in a failed state due to validation or other errors. NEEDS_ATTENTION - The resource is in needs attention state as some of it's child nodes are not validated and unusable by VM cluster. (CREATING, REQUIRES_VALIDATION, VALIDATING, VALIDATED, VALIDATION_FAILED, UPDATING, ALLOCATED, TERMINATING, TERMINATED, FAILED, NEEDS_ATTENTION)
ntparrayThe list of NTP server IP addresses. Maximum of 3 allowed.
scansarrayThe SCAN details.
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 when the VM cluster network was created.
vmClusterIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the associated VM Cluster.
vmNetworksarrayDetails of the client and backup networks.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectexadataInfrastructureId, vmClusterNetworkId, regionopc-request-idGets information about the specified VM cluster network. Applies to Exadata Cloud@Customer instances only.<br />To get information about a cloud VM cluster in an Exadata Cloud Service instance, use the [GetCloudVmCluster ](#/en/database/latest/CloudVmCluster/GetCloudVmCluster) operation.<br />
listselectexadataInfrastructureId, compartmentId, regionlimit, page, sortBy, sortOrder, lifecycleState, displayName, opc-request-idGets a list of the VM cluster networks in the specified compartment. Applies to Exadata Cloud@Customer instances only.<br />
createinsertexadataInfrastructureId, region, compartmentId, displayName, scans, vmNetworksopc-retry-token, opc-request-idCreates the VM cluster network. Applies to Exadata Cloud@Customer instances only.<br />To create a cloud VM cluster in an Exadata Cloud Service instance, use the [CreateCloudVmCluster ](#/en/database/latest/CloudVmCluster/CreateCloudVmCluster) operation.<br />
updateupdateexadataInfrastructureId, vmClusterNetworkId, regionif-match, opc-request-idUpdates the specified VM cluster network. Applies to Exadata Cloud@Customer instances only.<br />To update a cloud VM cluster in an Exadata Cloud Service instance, use the [UpdateCloudVmCluster ](#/en/database/latest/CloudVmCluster/UpdateCloudVmCluster) operation.<br />
deletedeleteexadataInfrastructureId, vmClusterNetworkId, regionif-match, opc-request-idDeletes the specified VM cluster network. Applies to Exadata Cloud@Customer instances only.<br />To delete a cloud VM cluster in an Exadata Cloud Service instance, use the [DeleteCloudVmCluster ](#/en/database/latest/CloudVmCluster/DeleteCloudVmCluster) operation.<br />
generate_recommended_vm_cluster_networkexecexadataInfrastructureId, region, compartmentId, displayName, networksopc-request-id, opc-retry-tokenGenerates a recommended Cloud@Customer VM cluster network configuration.<br />
download_vm_cluster_network_config_fileexecexadataInfrastructureId, vmClusterNetworkId, regionopc-request-id, opc-retry-tokenDownloads the configuration file for the specified VM cluster network. Applies to Exadata Cloud@Customer instances only.<br />
resize_vm_cluster_networkexecexadataInfrastructureId, vmClusterNetworkId, region, vmNetworks, actionopc-request-id, opc-retry-token, if-matchAdds or removes Db server network nodes to extend or shrink the existing VM cluster network. Applies to Exadata<br />Cloud@Customer instances only.<br />
validate_vm_cluster_networkexecexadataInfrastructureId, vmClusterNetworkId, regionopc-request-id, opc-retry-tokenValidates the specified VM cluster network. Applies to Exadata Cloud@Customer instances only.<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).
exadataInfrastructureIdstringThe Exadata infrastructure [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)
vmClusterNetworkIdstringThe VM cluster network [OCID](/Content/General/Concepts/identifiers.htm).
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.
sortOrderstringThe sort order to use, either ascending (ASC) or descending (DESC).

SELECT examples​

Gets information about the specified VM cluster network. Applies to Exadata Cloud@Customer instances only.<br />To get information about a cloud VM cluster in an Exadata Cloud Service instance, use the [GetCloudVmCluster ](#/en/database/latest/CloudVmCluster/GetCloudVmCluster) operation.<br />

SELECT
id,
compartmentId,
definedTags,
displayName,
dns,
drScans,
exadataInfrastructureId,
freeformTags,
lifecycleDetails,
lifecycleState,
ntp,
scans,
systemTags,
timeCreated,
vmClusterId,
vmNetworks
FROM oci.database.vm_cluster_networks
WHERE exadataInfrastructureId = '{{ exadataInfrastructureId }}' -- required
AND vmClusterNetworkId = '{{ vmClusterNetworkId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
;

INSERT examples​

Creates the VM cluster network. Applies to Exadata Cloud@Customer instances only.<br />To create a cloud VM cluster in an Exadata Cloud Service instance, use the [CreateCloudVmCluster ](#/en/database/latest/CloudVmCluster/CreateCloudVmCluster) operation.<br />

INSERT INTO oci.database.vm_cluster_networks (
compartmentId,
definedTags,
displayName,
dns,
drScans,
freeformTags,
ntp,
scans,
vmNetworks,
exadataInfrastructureId,
region,
opc-retry-token,
opc-request-id
)
SELECT
'{{ compartmentId }}' /* required */,
'{{ definedTags }}',
'{{ displayName }}' /* required */,
'{{ dns }}',
'{{ drScans }}',
'{{ freeformTags }}',
'{{ ntp }}',
'{{ scans }}' /* required */,
'{{ vmNetworks }}' /* required */,
'{{ exadataInfrastructureId }}',
'{{ region }}',
'{{ opc-retry-token }}',
'{{ opc-request-id }}'
RETURNING
id,
compartmentId,
definedTags,
displayName,
dns,
drScans,
exadataInfrastructureId,
freeformTags,
lifecycleDetails,
lifecycleState,
ntp,
scans,
systemTags,
timeCreated,
vmClusterId,
vmNetworks
;

UPDATE examples​

Updates the specified VM cluster network. Applies to Exadata Cloud@Customer instances only.<br />To update a cloud VM cluster in an Exadata Cloud Service instance, use the [UpdateCloudVmCluster ](#/en/database/latest/CloudVmCluster/UpdateCloudVmCluster) operation.<br />

UPDATE oci.database.vm_cluster_networks
SET
definedTags = '{{ definedTags }}',
dns = '{{ dns }}',
drScans = '{{ drScans }}',
freeformTags = '{{ freeformTags }}',
ntp = '{{ ntp }}',
scans = '{{ scans }}',
vmNetworks = '{{ vmNetworks }}'
WHERE
exadataInfrastructureId = '{{ exadataInfrastructureId }}' --required
AND vmClusterNetworkId = '{{ vmClusterNetworkId }}' --required
AND region = '{{ region }}' --required
AND if-match = '{{ if-match}}'
AND opc-request-id = '{{ opc-request-id}}'
RETURNING
id,
compartmentId,
definedTags,
displayName,
dns,
drScans,
exadataInfrastructureId,
freeformTags,
lifecycleDetails,
lifecycleState,
ntp,
scans,
systemTags,
timeCreated,
vmClusterId,
vmNetworks;

DELETE examples​

Deletes the specified VM cluster network. Applies to Exadata Cloud@Customer instances only.<br />To delete a cloud VM cluster in an Exadata Cloud Service instance, use the [DeleteCloudVmCluster ](#/en/database/latest/CloudVmCluster/DeleteCloudVmCluster) operation.<br />

DELETE FROM oci.database.vm_cluster_networks
WHERE exadataInfrastructureId = '{{ exadataInfrastructureId }}' --required
AND vmClusterNetworkId = '{{ vmClusterNetworkId }}' --required
AND region = '{{ region }}' --required
AND if-match = '{{ if-match }}'
AND opc-request-id = '{{ opc-request-id }}'
;

Lifecycle Methods​

Generates a recommended Cloud@Customer VM cluster network configuration.<br />

EXEC oci.database.vm_cluster_networks.generate_recommended_vm_cluster_network
@exadataInfrastructureId='{{ exadataInfrastructureId }}' --required,
@region='{{ region }}' --required,
@opc-request-id='{{ opc-request-id }}',
@opc-retry-token='{{ opc-retry-token }}'
@@json=
'{
"compartmentId": "{{ compartmentId }}",
"dbServers": "{{ dbServers }}",
"definedTags": "{{ definedTags }}",
"displayName": "{{ displayName }}",
"dns": "{{ dns }}",
"drScanListenerPortTcp": {{ drScanListenerPortTcp }},
"freeformTags": "{{ freeformTags }}",
"networks": "{{ networks }}",
"ntp": "{{ ntp }}"
}'
;