db_nodes

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

Overview

Name	db_nodes
Type	Resource
Id	azure_isv.oracle.db_nodes

Fields

The following fields are returned by SELECT queries:

get

Azure operation completed successfully.

Name	Datatype	Description
properties	object	The resource-specific properties for this resource.

list_by_cloud_vm_cluster

Azure operation completed successfully.

Name	Datatype	Description
properties	object	The resource-specific properties for this resource.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	subscriptionId, resourceGroupName, cloudvmclustername, dbnodeocid		Get a DbNode
list_by_cloud_vm_cluster	select	subscriptionId, resourceGroupName, cloudvmclustername		List DbNode resources by CloudVmCluster
action	exec	subscriptionId, resourceGroupName, cloudvmclustername, dbnodeocid, action		VM actions on DbNode of VM Cluster by the provided filter

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
cloudvmclustername	string	CloudVmCluster name
dbnodeocid	string	DbNode OCID.
resourceGroupName	string	The name of the resource group. The name is case insensitive.
subscriptionId	string (uuid)	The ID of the target subscription. The value must be an UUID.

SELECT examples

get

Get a DbNode

SELECT
properties
FROM azure_isv.oracle.db_nodes
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND cloudvmclustername = '{{ cloudvmclustername }}' -- required
AND dbnodeocid = '{{ dbnodeocid }}' -- required
;

list_by_cloud_vm_cluster

List DbNode resources by CloudVmCluster

SELECT
properties
FROM azure_isv.oracle.db_nodes
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND cloudvmclustername = '{{ cloudvmclustername }}' -- required
;

Lifecycle Methods

action

VM actions on DbNode of VM Cluster by the provided filter

EXEC azure_isv.oracle.db_nodes.action 
@subscriptionId='{{ subscriptionId }}' --required, 
@resourceGroupName='{{ resourceGroupName }}' --required, 
@cloudvmclustername='{{ cloudvmclustername }}' --required, 
@dbnodeocid='{{ dbnodeocid }}' --required 
@@json=
'{
"action": "{{ action }}"
}'
;