autonomous_virtual_machines

Creates, updates, deletes, gets or lists an autonomous_virtual_machines resource.

Overview

Name	autonomous_virtual_machines
Type	Resource
Id	oci.database.autonomous_virtual_machines

Fields

The following fields are returned by SELECT queries:

get

Autonomous Virtual Machine details.

Name	Datatype	Description
id	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the Autonomous Virtual Machine.
autonomousVmClusterId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the Autonomous VM Cluster associated with the Autonomous Virtual Machine.
clientIpAddress	string	Client IP Address.
cloudAutonomousVmClusterId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the Cloud Autonomous VM Cluster associated with the Autonomous Virtual Machine.
compartmentId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the compartment.
cpuCoreCount	integer	The number of CPU cores enabled on the Autonomous Virtual Machine.
dbNodeStorageSizeInGBs	integer	The allocated local node storage in GBs on the Autonomous Virtual Machine.
dbServerDisplayName	string	The display name of the dbServer associated with the Autonomous Virtual Machine.
dbServerId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the Db server associated with the Autonomous Virtual Machine.
definedTags	object	Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm).
freeformTags	object	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](/Content/General/Concepts/resourcetags.htm). Example: {"Department": "Finance"}
lifecycleState	string	The current state of the Autonomous Virtual Machine. (PROVISIONING, AVAILABLE, UPDATING, TERMINATING, TERMINATED, FAILED, MAINTENANCE_IN_PROGRESS)
memorySizeInGBs	integer	The allocated memory in GBs on the Autonomous Virtual Machine.
vmName	string	The name of the Autonomous Virtual Machine.

list

Details of the Autonomous Virtual Machine.<br />

Name	Datatype	Description
id	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the Autonomous Virtual Machine.
autonomousVmClusterId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the Autonomous VM Cluster associated with the Autonomous Virtual Machine.
clientIpAddress	string	Client IP Address.
cloudAutonomousVmClusterId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the Cloud Autonomous VM Cluster associated with the Autonomous Virtual Machine.
compartmentId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the compartment.
cpuCoreCount	integer	The number of CPU cores enabled on the Autonomous Virtual Machine.
dbNodeStorageSizeInGBs	integer	The allocated local node storage in GBs on the Autonomous Virtual Machine.
dbServerDisplayName	string	The display name of the dbServer associated with the Autonomous Virtual Machine.
dbServerId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the Db server associated with the Autonomous Virtual Machine.
definedTags	object	Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm).
freeformTags	object	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](/Content/General/Concepts/resourcetags.htm). Example: {"Department": "Finance"}
lifecycleState	string	The current state of the Autonomous Virtual Machine. (PROVISIONING, AVAILABLE, UPDATING, TERMINATING, TERMINATED, FAILED, MAINTENANCE_IN_PROGRESS)
memorySizeInGBs	integer	The allocated memory in GBs on the Autonomous Virtual Machine.
vmName	string	The name of the Autonomous Virtual Machine.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	autonomousVirtualMachineId, region	opc-request-id	Gets the details of specific Autonomous Virtual Machine.<br />
list	select	compartmentId, autonomousVmClusterId, region	limit, page, opc-request-id, lifecycleState	Lists the Autonomous Virtual Machines in the specified Autonomous VM Cluster and Compartment.<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.

Name	Datatype	Description
autonomousVirtualMachineId	string	The Autonomous Virtual machine [OCID](/Content/General/Concepts/identifiers.htm).
autonomousVmClusterId	string	The Autonomous Virtual machine [OCID](/Content/General/Concepts/identifiers.htm).
compartmentId	string	The compartment [OCID](/Content/General/Concepts/identifiers.htm).
region	string	OCI 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)
lifecycleState	string	A filter to return only resources that match the given lifecycle state exactly.
limit	integer	The maximum number of items to return per page.
opc-request-id	string	Unique identifier for the request.
page	string	The pagination token to continue listing from.

SELECT examples

get

Gets the details of specific Autonomous Virtual Machine.<br />

SELECT
id,
autonomousVmClusterId,
clientIpAddress,
cloudAutonomousVmClusterId,
compartmentId,
cpuCoreCount,
dbNodeStorageSizeInGBs,
dbServerDisplayName,
dbServerId,
definedTags,
freeformTags,
lifecycleState,
memorySizeInGBs,
vmName
FROM oci.database.autonomous_virtual_machines
WHERE autonomousVirtualMachineId = '{{ autonomousVirtualMachineId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
;

list

Lists the Autonomous Virtual Machines in the specified Autonomous VM Cluster and Compartment.<br />

SELECT
id,
autonomousVmClusterId,
clientIpAddress,
cloudAutonomousVmClusterId,
compartmentId,
cpuCoreCount,
dbNodeStorageSizeInGBs,
dbServerDisplayName,
dbServerId,
definedTags,
freeformTags,
lifecycleState,
memorySizeInGBs,
vmName
FROM oci.database.autonomous_virtual_machines
WHERE compartmentId = '{{ compartmentId }}' -- required
AND autonomousVmClusterId = '{{ autonomousVmClusterId }}' -- required
AND region = '{{ region }}' -- required
AND limit = '{{ limit }}'
AND page = '{{ page }}'
AND opc-request-id = '{{ opc-request-id }}'
AND lifecycleState = '{{ lifecycleState }}'
;