MCP Tools Reference: oracledatabase.googleapis.com

Tool: list_exadata_infrastructures

List Exadata Infrastructures in a Google Cloud project in the given location.

The following code sample shows how to use curl to call the list_exadata_infrastructures MCP tool.

Curl Request 
curl --location 'https://oracledatabase.googleapis.com/mcp' \
--header 'content-type: application/json' \
--header 'accept: application/json, text/event-stream' \
--data '{
  "method": "tools/call",
  "params": {
    "name": "list_exadata_infrastructures",
    "arguments": {
      // Provide these details according to the MCP tool specification.
    }
  },
  "jsonrpc": "2.0",
  "id": 1
}'

Input Schema

The request for CloudExadataInfrastructures.List.

ListCloudExadataInfrastructuresRequest

JSON representation 
{
  "parent": string,
  "pageSize": integer,
  "pageToken": string,
  "filter": string,
  "orderBy": string
}
Fields
parent

string

Required. The parent value for CloudExadataInfrastructure in the following format: projects/{project}/locations/{location}.
pageSize

integer

Optional. The maximum number of items to return. If unspecified, at most 50 Exadata infrastructures will be returned. The maximum value is 1000; values above 1000 will be coerced to 1000.
pageToken

string

Optional. A token identifying a page of results the server should return.
filter

string

Optional. An expression for filtering the results of the request.
orderBy

string

Optional. An expression for ordering the results of the request.

Output Schema

The response for CloudExadataInfrastructures.list.

ListCloudExadataInfrastructuresResponse

JSON representation 
{
  "cloudExadataInfrastructures": [
    {
      object (CloudExadataInfrastructure)
    }
  ],
  "nextPageToken": string,
  "unreachable": [
    string
  ]
}
Fields
cloudExadataInfrastructures[]

object (CloudExadataInfrastructure)

The list of Exadata Infrastructures.
nextPageToken

string

A token for fetching next page of response.
unreachable[]

string

Unreachable locations when listing resources across all locations using wildcard location '-'.

CloudExadataInfrastructure

JSON representation 
{
  "name": string,
  "displayName": string,
  "gcpOracleZone": string,
  "entitlementId": string,
  "properties": {
    object (CloudExadataInfrastructureProperties)
  },
  "labels": {
    string: string,
    ...
  },
  "createTime": string
}
Fields
name

string

Identifier. The name of the Exadata Infrastructure resource with the format: projects/{project}/locations/{region}/cloudExadataInfrastructures/{cloud_exadata_infrastructure}
displayName

string

Optional. Immutable. User friendly name for this resource.
gcpOracleZone

string

Optional. Immutable. The GCP Oracle zone where Oracle Exadata Infrastructure is hosted. Example: us-east4-b-r2. If not specified, the system will pick a zone based on availability.
entitlementId

string

Output only. Entitlement ID of the private offer against which this infrastructure resource is provisioned.
properties

object (CloudExadataInfrastructureProperties)

Optional. Immutable. Various properties of the infra.
labels

map (key: string, value: string)

Optional. Labels or tags associated with the resource.

An object containing a list of "key": value pairs. Example: { "name": "wrench", "mass": "1.3kg", "count": "3" }.
createTime

string (Timestamp format)

Output only. The date and time that the Exadata Infrastructure was created.

Uses RFC 3339, where generated output will always be Z-normalized and use 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: "2014-10-02T15:01:23Z", "2014-10-02T15:01:23.045123456Z" or "2014-10-02T15:01:23+05:30".

CloudExadataInfrastructureProperties

JSON representation 
{
  "ocid": string,
  "computeCount": integer,
  "storageCount": integer,
  "totalStorageSizeGb": integer,
  "availableStorageSizeGb": integer,
  "maintenanceWindow": {
    object (MaintenanceWindow)
  },
  "state": enum (State),
  "shape": string,
  "ociUrl": string,
  "cpuCount": integer,
  "maxCpuCount": integer,
  "memorySizeGb": integer,
  "maxMemoryGb": integer,
  "dbNodeStorageSizeGb": integer,
  "maxDbNodeStorageSizeGb": integer,
  "dataStorageSizeTb": number,
  "maxDataStorageTb": number,
  "activatedStorageCount": integer,
  "additionalStorageCount": integer,
  "dbServerVersion": string,
  "storageServerVersion": string,
  "nextMaintenanceRunId": string,
  "nextMaintenanceRunTime": string,
  "nextSecurityMaintenanceRunTime": string,
  "customerContacts": [
    {
      object (CustomerContact)
    }
  ],
  "monthlyStorageServerVersion": string,
  "monthlyDbServerVersion": string,
  "computeModel": enum (ComputeModel),
  "databaseServerType": string,
  "storageServerType": string,
  "exascaleConfig": {
    object (ExascaleConfig)
  }
}
Fields
ocid

string

Output only. OCID of created infra. https://docs.oracle.com/en-us/iaas/Content/General/Concepts/identifiers.htm#Oracle
computeCount

integer

Optional. The number of compute servers for the Exadata Infrastructure.
storageCount

integer

Optional. The number of Cloud Exadata storage servers for the Exadata Infrastructure.
totalStorageSizeGb

integer

Optional. The total storage allocated to the Exadata Infrastructure resource, in gigabytes (GB).
availableStorageSizeGb

integer

Output only. The available storage can be allocated to the Exadata Infrastructure resource, in gigabytes (GB).
maintenanceWindow

object (MaintenanceWindow)

Optional. Maintenance window for repair.
state

enum (State)

Output only. The current lifecycle state of the Exadata Infrastructure.
shape

string

Required. The shape of the Exadata Infrastructure. The shape determines the amount of CPU, storage, and memory resources allocated to the instance.
ociUrl

string

Output only. Deep link to the OCI console to view this resource.
cpuCount

integer

Output only. The number of enabled CPU cores.
maxCpuCount

integer

Output only. The total number of CPU cores available.
memorySizeGb

integer

Output only. The memory allocated in GBs.
maxMemoryGb

integer

Output only. The total memory available in GBs.
dbNodeStorageSizeGb

integer

Output only. The local node storage allocated in GBs.
maxDbNodeStorageSizeGb

integer

Output only. The total local node storage available in GBs.
dataStorageSizeTb

number

Output only. Size, in terabytes, of the DATA disk group.
maxDataStorageTb

number

Output only. The total available DATA disk group size.
activatedStorageCount

integer

Output only. The requested number of additional storage servers activated for the Exadata Infrastructure.
additionalStorageCount

integer

Output only. The requested number of additional storage servers for the Exadata Infrastructure.
dbServerVersion

string

Output only. The software version of the database servers (dom0) in the Exadata Infrastructure.
storageServerVersion

string

Output only. The software version of the storage servers (cells) in the Exadata Infrastructure.
nextMaintenanceRunId

string

Output only. The OCID of the next maintenance run.
nextMaintenanceRunTime

string (Timestamp format)

Output only. The time when the next maintenance run will occur.

Uses RFC 3339, where generated output will always be Z-normalized and use 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: "2014-10-02T15:01:23Z", "2014-10-02T15:01:23.045123456Z" or "2014-10-02T15:01:23+05:30".
nextSecurityMaintenanceRunTime

string (Timestamp format)

Output only. The time when the next security maintenance run will occur.

Uses RFC 3339, where generated output will always be Z-normalized and use 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: "2014-10-02T15:01:23Z", "2014-10-02T15:01:23.045123456Z" or "2014-10-02T15:01:23+05:30".
customerContacts[]

object (CustomerContact)

Optional. The list of customer contacts.
monthlyStorageServerVersion

string

Output only. The monthly software version of the storage servers (cells) in the Exadata Infrastructure. Example: 20.1.15
monthlyDbServerVersion

string

Output only. The monthly software version of the database servers (dom0) in the Exadata Infrastructure. Example: 20.1.15
computeModel

enum (ComputeModel)

Output only. The compute model of the Exadata Infrastructure.
databaseServerType

string

Optional. The database server type of the Exadata Infrastructure.
storageServerType

string

Optional. The storage server type of the Exadata Infrastructure.
exascaleConfig

object (ExascaleConfig)

Output only. The Exascale configuration for the Exadata Infrastructure.

MaintenanceWindow

JSON representation 
{
  "preference": enum (MaintenanceWindowPreference),
  "months": [
    enum (Month)
  ],
  "weeksOfMonth": [
    integer
  ],
  "daysOfWeek": [
    enum (DayOfWeek)
  ],
  "hoursOfDay": [
    integer
  ],
  "leadTimeWeek": integer,
  "patchingMode": enum (PatchingMode),
  "customActionTimeoutMins": integer,
  "isCustomActionTimeoutEnabled": boolean
}
Fields
preference

enum (MaintenanceWindowPreference)

Optional. The maintenance window scheduling preference.
months[]

enum (Month)

Optional. Months during the year when maintenance should be performed.
weeksOfMonth[]

integer

Optional. Weeks during the month when maintenance should be performed. Weeks start on the 1st, 8th, 15th, and 22nd days of the month, and have a duration of 7 days. Weeks start and end based on calendar dates, not days of the week.
daysOfWeek[]

enum (DayOfWeek)

Optional. Days during the week when maintenance should be performed.
hoursOfDay[]

integer

Optional. The window of hours during the day when maintenance should be performed. The window is a 4 hour slot. Valid values are: 0 - represents time slot 0:00 - 3:59 UTC 4 - represents time slot 4:00 - 7:59 UTC 8 - represents time slot 8:00 - 11:59 UTC 12 - represents time slot 12:00 - 15:59 UTC 16 - represents time slot 16:00 - 19:59 UTC 20 - represents time slot 20:00 - 23:59 UTC
leadTimeWeek

integer

Optional. Lead time window allows user to set a lead time to prepare for a down time. The lead time is in weeks and valid value is between 1 to 4.
patchingMode

enum (PatchingMode)

Optional. Cloud CloudExadataInfrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.
customActionTimeoutMins

integer

Optional. Determines the amount of time the system will wait before the start of each database server patching operation. Custom action timeout is in minutes and valid value is between 15 to 120 (inclusive).
isCustomActionTimeoutEnabled

boolean

Optional. If true, enables the configuration of a custom action timeout (waiting period) between database server patching operations.

Timestamp

JSON representation 
{
  "seconds": string,
  "nanos": integer
}
Fields
seconds

string (int64 format)

Represents seconds of UTC time since Unix epoch 1970-01-01T00:00:00Z. Must be between -62135596800 and 253402300799 inclusive (which corresponds to 0001-01-01T00:00:00Z to 9999-12-31T23:59:59Z).
nanos

integer

Non-negative fractions of a second at nanosecond resolution. This field is the nanosecond portion of the duration, not an alternative to seconds. Negative second values with fractions must still have non-negative nanos values that count forward in time. Must be between 0 and 999,999,999 inclusive.

CustomerContact

JSON representation 
{
  "email": string
}
Fields
email

string

Required. The email address used by Oracle to send notifications regarding databases and infrastructure.

ExascaleConfig

JSON representation 
{
  "totalStorageSizeGb": integer,
  "availableStorageSizeGb": integer,
  "totalVmStorageSizeGb": integer,
  "availableVmStorageSizeGb": integer
}
Fields
totalStorageSizeGb

integer

Output only. Total storage size needed for Exascale in GBs.
availableStorageSizeGb

integer

Output only. Available storage size for Exascale in GBs.
totalVmStorageSizeGb

integer

Output only. Storage size needed for VM storage on Exascale in GBs.
availableVmStorageSizeGb

integer

Output only. Available storage size for VM storage on Exascale in GBs.

LabelsEntry

JSON representation 
{
  "key": string,
  "value": string
}
Fields
key

string
value

string

MaintenanceWindowPreference

Maintenance window preference.

Enums
MAINTENANCE_WINDOW_PREFERENCE_UNSPECIFIED Default unspecified value.
CUSTOM_PREFERENCE Custom preference.
NO_PREFERENCE No preference.

Month

Represents a month in the Gregorian calendar.

Enums
MONTH_UNSPECIFIED The unspecified month.
JANUARY The month of January.
FEBRUARY The month of February.
MARCH The month of March.
APRIL The month of April.
MAY The month of May.
JUNE The month of June.
JULY The month of July.
AUGUST The month of August.
SEPTEMBER The month of September.
OCTOBER The month of October.
NOVEMBER The month of November.
DECEMBER The month of December.

DayOfWeek

Represents a day of the week.

Enums
DAY_OF_WEEK_UNSPECIFIED The day of the week is unspecified.
MONDAY Monday
TUESDAY Tuesday
WEDNESDAY Wednesday
THURSDAY Thursday
FRIDAY Friday
SATURDAY Saturday
SUNDAY Sunday

PatchingMode

Patching mode.

Enums
PATCHING_MODE_UNSPECIFIED Default unspecified value.
ROLLING Updates the Cloud Exadata database server hosts in a rolling fashion.
NON_ROLLING The non-rolling maintenance method first updates your storage servers at the same time, then your database servers at the same time.

State

The various lifecycle states of the Exadata Infrastructure.

Enums
STATE_UNSPECIFIED Default unspecified value.
PROVISIONING The Exadata Infrastructure is being provisioned.
AVAILABLE The Exadata Infrastructure is available for use.
UPDATING The Exadata Infrastructure is being updated.
TERMINATING The Exadata Infrastructure is being terminated.
TERMINATED The Exadata Infrastructure is terminated.
FAILED The Exadata Infrastructure is in failed state.
MAINTENANCE_IN_PROGRESS The Exadata Infrastructure is in maintenance.

ComputeModel

The compute model of the Exadata Infrastructure, VM Cluster and Autonomous Database.

Enums
COMPUTE_MODEL_UNSPECIFIED Unspecified compute model.
COMPUTE_MODEL_ECPU Abstract measure of compute resources. ECPUs are based on the number of cores elastically allocated from a pool of compute and storage servers.
COMPUTE_MODEL_OCPU Physical measure of compute resources. OCPUs are based on the physical core of a processor.

Tool Annotations

Tool annotations are sent to MCP clients to describe the basic risk of a given tool. Most clients treat these hints as untrusted, but they can be used to decide when a confirmation prompt might be sent to a user.

Along with the title string, the following boolean hints are defined as follows:

  • readOnlyHint: If true, the tool doesn't modify its environment. Default: false.
  • destructiveHint: If true, then the tool can perform destructive actions. If false, then the tool can only perform additive actions. Default: true.
  • idempotentHint: If true, then calling the tool repeatedly with the same arguments will have no additional effect on its environment. Default: false.
  • openWorldHint: If true, then the tool can interact with an 'open world' of external entities. If false, then the tool can only interact with internal entities. For example, a web search tool would be open world, while a memory tool would not be open world.

Destructive Hint: ❌ | Idempotent Hint: ❌ | Read Only Hint: ✅ | Open World Hint: ❌