odb / Client / list_db_servers

list_db_servers

odb.Client.list_db_servers(**kwargs)

Returns information about the database servers that belong to the specified Exadata infrastructure.

See also: AWS API Documentation

Request Syntax

response = client.list_db_servers(
    cloudExadataInfrastructureId='string',
    maxResults=123,
    nextToken='string'
)
Parameters:

  • cloudExadataInfrastructureId (string) –

    [REQUIRED]

    The unique identifier of the Oracle Exadata infrastructure.

  • maxResults (integer) –

    The maximum number of items to return for this request. To get the next page of items, make another request with the token returned in the output.

    Default: 10

  • nextToken (string) – The token returned from a previous paginated request. Pagination continues from the end of the items returned by the previous request.

Return type:

dict

Returns:

Response Syntax

{
    'nextToken': 'string',
    'dbServers': [
        {
            'dbServerId': 'string',
            'status': 'AVAILABLE'|'FAILED'|'PROVISIONING'|'TERMINATED'|'TERMINATING'|'UPDATING'|'MAINTENANCE_IN_PROGRESS',
            'statusReason': 'string',
            'cpuCoreCount': 123,
            'dbNodeStorageSizeInGBs': 123,
            'dbServerPatchingDetails': {
                'estimatedPatchDuration': 123,
                'patchingStatus': 'COMPLETE'|'FAILED'|'MAINTENANCE_IN_PROGRESS'|'SCHEDULED',
                'timePatchingEnded': 'string',
                'timePatchingStarted': 'string'
            },
            'displayName': 'string',
            'exadataInfrastructureId': 'string',
            'ocid': 'string',
            'ociResourceAnchorName': 'string',
            'maxCpuCount': 123,
            'maxDbNodeStorageInGBs': 123,
            'maxMemoryInGBs': 123,
            'memorySizeInGBs': 123,
            'shape': 'string',
            'createdAt': datetime(2015, 1, 1),
            'vmClusterIds': [
                'string',
            ],
            'computeModel': 'ECPU'|'OCPU',
            'autonomousVmClusterIds': [
                'string',
            ],
            'autonomousVirtualMachineIds': [
                'string',
            ]
        },
    ]
}

Response Structure

  • (dict) –

    • nextToken (string) –

      The token to include in another request to get the next page of items. This value is null when there are no more items to return.

    • dbServers (list) –

      The list of database servers along with their properties.

      • (dict) –

        Information about a database server.

        • dbServerId (string) –

          The unique identifier of the database server.

        • status (string) –

          The current status of the database server.

        • statusReason (string) –

          Additional information about the status of the database server.

        • cpuCoreCount (integer) –

          The number of CPU cores enabled on the database server.

        • dbNodeStorageSizeInGBs (integer) –

          The amount of local node storage, in gigabytes (GB), that’s allocated on the database server.

        • dbServerPatchingDetails (dict) –

          The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

          • estimatedPatchDuration (integer) –

            Estimated time, in minutes, to patch one database server.

          • patchingStatus (string) –

            The status of the patching operation. Possible values are SCHEDULED, MAINTENANCE_IN_PROGRESS, FAILED, and COMPLETE.

          • timePatchingEnded (string) –

            The time when the patching operation ended.

          • timePatchingStarted (string) –

            The time when the patching operation started.

        • displayName (string) –

          The user-friendly name of the database server. The name doesn’t need to be unique.

        • exadataInfrastructureId (string) –

          The ID of the Exadata infrastructure that hosts the database server.

        • ocid (string) –

          The OCID of the database server.

        • ociResourceAnchorName (string) –

          The name of the OCI resource anchor for the database server.

        • maxCpuCount (integer) –

          The total number of CPU cores available on the database server.

        • maxDbNodeStorageInGBs (integer) –

          The total amount of local node storage, in gigabytes (GB), that’s available on the database server.

        • maxMemoryInGBs (integer) –

          The total amount of memory, in gigabytes (GB), that’s available on the database server.

        • memorySizeInGBs (integer) –

          The amount of memory, in gigabytes (GB), that’s allocated on the database server.

        • shape (string) –

          The hardware system model of the Exadata infrastructure that the database server is hosted on. The shape determines the amount of CPU, storage, and memory resources available.

        • createdAt (datetime) –

          The date and time when the database server was created.

        • vmClusterIds (list) –

          The IDs of the VM clusters that are associated with the database server.

          • (string) –

        • computeModel (string) –

          The OCI model compute model used when you create or clone an instance: ECPU or OCPU. An ECPU is an abstracted measure of compute resources. ECPUs are based on the number of cores elastically allocated from a pool of compute and storage servers. An OCPU is a legacy physical measure of compute resources. OCPUs are based on the physical core of a processor with hyper-threading enabled.

        • autonomousVmClusterIds (list) –

          A list of identifiers for the Autonomous VM clusters.

          • (string) –

        • autonomousVirtualMachineIds (list) –

          A list of unique identifiers for the Autonomous VMs.

          • (string) –

Exceptions