Skip to main content

db_nodes

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

Overview

Namedb_nodes
TypeResource
Idgoogle.oracledatabase.db_nodes

Fields

The following fields are returned by SELECT queries:

Successful response

NameDatatypeDescription
namestringIdentifier. The name of the database node resource in the following format: projects/{project}/locations/{location}/cloudVmClusters/{cloud_vm_cluster}/dbNodes/{db_node}
propertiesobjectOptional. Various properties of the database node. (id: DbNodeProperties)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectprojectsId, locationsId, cloudVmClustersIdpageSize, pageTokenLists the database nodes of a VM Cluster.

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
cloudVmClustersIdstring
locationsIdstring
projectsIdstring
pageSizeinteger (int32)
pageTokenstring

SELECT examples

Lists the database nodes of a VM Cluster.

SELECT
name,
properties
FROM google.oracledatabase.db_nodes
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND cloudVmClustersId = '{{ cloudVmClustersId }}' -- required
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}';