---
title: "POST /v1/{+parent}/dbSystems"
method: POST
path: "/v1/{+parent}/dbSystems"
tags: ["projects"]
---

# POST /v1/{+parent}/dbSystems

`POST /v1/{+parent}/dbSystems`

Creates a new DbSystem in a given project and location.

## Path parameters

- `parent` string, required

## Query parameters

- `dbSystemId` string
- `requestId` string

## Request body

- DbSystem — Details of the DbSystem (BaseDB) resource. https://docs.oracle.com/en-us/iaas/api/#/en/database/20160918/DbSystem/
  - `createTime` string, google-datetime — Output only. The date and time that the DbSystem was created.
  - `odbNetwork` string — Optional. The name of the OdbNetwork associated with the DbSystem. Format: projects/{project}/locations/{location}/odbNetworks/{odb_network} It is optional but if specified, this should match the parent ODBNetwork of the OdbSubnet.
  - `name` string — Identifier. The name of the DbSystem resource in the following format: projects/{project}/locations/{region}/dbSystems/{db_system}
  - `labels` object — Optional. The labels or tags associated with the DbSystem.
  - `entitlementId` string — Output only. The ID of the subscription entitlement associated with the DbSystem
  - `properties` DbSystemProperties — The properties of a DbSystem.
    - `computeCount` integer — Required. The number of CPU cores to enable for the DbSystem.
    - `sshPublicKeys` string[] — Required. SSH public keys to be stored with the DbSystem.
    - `ocid` string — Output only. OCID of the DbSystem.
    - `hostnamePrefix` string — Optional. Prefix for DB System host names.
    - `initialDataStorageSizeGb` integer — Required. The initial data storage size in GB.
    - `domain` string — Optional. The host domain name of the DbSystem.
    - `privateIp` string — Optional. The private IP address of the DbSystem.
    - `computeModel` 'COMPUTE_MODEL_UNSPECIFIED' | 'ECPU' | 'OCPU' — Optional. The compute model of the DbSystem.
    - `recoStorageSizeGb` integer — Optional. The reco/redo storage size in GB.
    - `lifecycleState` 'DB_SYSTEM_LIFECYCLE_STATE_UNSPECIFIED' | 'PROVISIONING' | 'AVAILABLE' | 'UPDATING' | 'TERMINATING' | 'TERMINATED' | 'FAILED' | 'MIGRATED' | 'MAINTENANCE_IN_PROGRESS' | 'NEEDS_ATTENTION' | 'UPGRADING' — Output only. State of the DbSystem.
    - `dataCollectionOptions` DataCollectionOptionsDbSystem — Data collection options for DbSystem.
      - `isDiagnosticsEventsEnabled` boolean — Optional. Indicates whether to enable data collection for diagnostics.
      - `isIncidentLogsEnabled` boolean — Optional. Indicates whether to enable incident logs and trace collection.
    - `dataStorageSizeGb` integer — Optional. The data storage size in GB that is currently available to DbSystems.
    - `dbSystemOptions` DbSystemOptions — Details of the DbSystem Options.
      - `storageManagement` 'STORAGE_MANAGEMENT_UNSPECIFIED' | 'ASM' | 'LVM' — Optional. The storage option used in DB system.
    - `timeZone` TimeZone — Represents a time zone from the [IANA Time Zone Database](https://www.iana.org/time-zones).
      - `id` string — IANA Time Zone Database time zone. For example "America/New_York".
      - `version` string — Optional. IANA Time Zone Database version number. For example "2019a".
    - `dbHome` DbHome — Details of the Database Home resource.
      - `database` Database — Details of the Database resource. https://docs.oracle.com/en-us/iaas/api/#/en/database/20160918/Database/
        - `databaseId` string — Optional. The database ID of the Database.
        - `tdeWalletPassword` string — Optional. The TDE wallet password for the database. Note: Only one of `tde_wallet_password_secret_version` or `tde_wallet_password` can be populated.
        - `dbUniqueName` string — Optional. The DB_UNIQUE_NAME of the Oracle Database being backed up.
        - `pluggableDatabaseName` string — Optional. The pluggable database associated with the Database. The name must begin with an alphabetic character and can contain a maximum of thirty alphanumeric characters.
        - `opsInsightsStatus` 'OPERATIONS_INSIGHTS_STATUS_UNSPECIFIED' | 'ENABLING' | 'ENABLED' | 'DISABLING' | 'NOT_ENABLED' | 'FAILED_ENABLING' | 'FAILED_DISABLING' — Output only. The Status of Operations Insights for this Database.
        - `pluggableDatabaseId` string — Optional. The ID of the pluggable database associated with the Database. The ID must be unique within the project and location.
        - `createTime` string, google-datetime — Output only. The date and time that the Database was created.
        - `dbName` string — Optional. The database name. The name must begin with an alphabetic character and can contain a maximum of eight alphanumeric characters. Special characters are not permitted.
        - `adminPassword` string — Optional. The password for the default ADMIN user. Note: Only one of `admin_password_secret_version` or `admin_password` can be populated.
        - `tdeWalletPasswordSecretVersion` string — Optional. The resource name of a secret version in Secret Manager which contains the TDE wallet password for the database. Format: projects/{project}/secrets/{secret}/versions/{version}. Note: Only one of `tde_wallet_password_secret_version` or `tde_wallet_password` can be populated.
        - `characterSet` string — Optional. The character set for the database. The default is AL32UTF8.
        - `dbHomeName` string — Optional. The name of the DbHome resource associated with the Database.
        - `adminPasswordSecretVersion` string — Optional. The resource name of a secret version in Secret Manager which contains the database admin user's password. Format: projects/{project}/secrets/{secret}/versions/{version}. Note: Only one of `admin_password_secret_version` or `admin_password` can be populated.
        - `gcpOracleZone` string — Output only. The GCP Oracle zone where the Database is created.
        - `ncharacterSet` string — Optional. The national character set for the database. The default is AL16UTF16.
        - `ociUrl` string — Output only. HTTPS link to OCI resources exposed to Customer via UI Interface.
        - `properties` DatabaseProperties — The properties of a Database.
          - `state` 'DATABASE_LIFECYCLE_STATE_UNSPECIFIED' | 'PROVISIONING' | 'AVAILABLE' | 'UPDATING' | 'BACKUP_IN_PROGRESS' | 'UPGRADING' | 'CONVERTING' | 'TERMINATING' | 'TERMINATED' | 'RESTORE_FAILED' | 'FAILED' — Output only. State of the Database.
          - `dbVersion` string — Required. The Oracle Database version.
          - `databaseManagementConfig` DatabaseManagementConfig — The configuration of the Database Management service.
            - `managementType` 'MANAGEMENT_TYPE_UNSPECIFIED' | 'BASIC' | 'ADVANCED' — Output only. The Database Management type.
            - `managementState` 'MANAGEMENT_STATE_UNSPECIFIED' | 'ENABLING' | 'ENABLED' | 'DISABLING' | 'DISABLED' | 'UPDATING' | 'FAILED_ENABLING' | 'FAILED_DISABLING' | 'FAILED_UPDATING' — Output only. The status of the Database Management service.
          - `dbBackupConfig` DbBackupConfig — Backup Options for the Database.
            - `autoBackupEnabled` boolean — Optional. If set to true, enables automatic backups on the database.
            - `autoFullBackupDay` 'DAY_OF_WEEK_UNSPECIFIED' | 'MONDAY' | 'TUESDAY' | 'WEDNESDAY' | 'THURSDAY' | 'FRIDAY' | 'SATURDAY' | 'SUNDAY' — Optional. The day of the week on which the full backup should be performed on the database. If no value is provided, it will default to Sunday.
            - `autoFullBackupWindow` 'BACKUP_WINDOW_UNSPECIFIED' | 'SLOT_ONE' | 'SLOT_TWO' | 'SLOT_THREE' | 'SLOT_FOUR' | 'SLOT_FIVE' | 'SLOT_SIX' | 'SLOT_SEVEN' | 'SLOT_EIGHT' | 'SLOT_NINE' | 'SLOT_TEN' | 'SLOT_ELEVEN' | 'SLOT_TWELVE' — Optional. The window in which the full backup should be performed on the database. If no value is provided, the default is anytime.
            - `backupDestinationDetails` BackupDestinationDetails[] — Optional. Details of the database backup destinations.
              - …
            - `backupDeletionPolicy` 'BACKUP_DELETION_POLICY_UNSPECIFIED' | 'DELETE_IMMEDIATELY' | 'DELETE_AFTER_RETENTION_PERIOD' — Optional. This defines when the backups will be deleted after Database termination.
            - `retentionPeriodDays` integer — Optional. The number of days an automatic backup is retained before being automatically deleted. This value determines the earliest point in time to which a database can be restored. Min: 1, Max: 60.
            - `autoIncrementalBackupWindow` 'BACKUP_WINDOW_UNSPECIFIED' | 'SLOT_ONE' | 'SLOT_TWO' | 'SLOT_THREE' | 'SLOT_FOUR' | 'SLOT_FIVE' | 'SLOT_SIX' | 'SLOT_SEVEN' | 'SLOT_EIGHT' | 'SLOT_NINE' | 'SLOT_TEN' | 'SLOT_ELEVEN' | 'SLOT_TWELVE' — Optional. The window in which the incremental backup should be performed on the database. If no value is provided, the default is anytime except the auto full backup day.
        - `name` string — Identifier. The name of the Database resource in the following format: projects/{project}/locations/{region}/databases/{database}
      - `displayName` string — Optional. The display name for the Database Home. The name does not have to be unique within your project.
      - `isUnifiedAuditingEnabled` boolean — Optional. Whether unified auditing is enabled for the Database Home.
      - `dbVersion` string — Required. A valid Oracle Database version. For a list of supported versions, use the ListDbVersions operation.
    - `memorySizeGb` integer — Optional. The memory size in GB.
    - `databaseEdition` 'DB_SYSTEM_DATABASE_EDITION_UNSPECIFIED' | 'STANDARD_EDITION' | 'ENTERPRISE_EDITION' | 'ENTERPRISE_EDITION_HIGH_PERFORMANCE' — Required. The database edition of the DbSystem.
    - `licenseModel` 'LICENSE_MODEL_UNSPECIFIED' | 'LICENSE_INCLUDED' | 'BRING_YOUR_OWN_LICENSE' — Required. The license model of the DbSystem.
    - `nodeCount` integer — Optional. The number of nodes in the DbSystem.
    - `shape` string — Required. Shape of DB System.
    - `hostname` string — Output only. The hostname of the DbSystem.
  - `odbSubnet` string — Required. The name of the OdbSubnet associated with the DbSystem for IP allocation. Format: projects/{project}/locations/{location}/odbNetworks/{odb_network}/odbSubnets/{odb_subnet}
  - `gcpOracleZone` string — Optional. The GCP Oracle zone where Oracle DbSystem is hosted. Example: us-east4-b-r2. If not specified, the system will pick a zone based on availability.
  - `displayName` string — Required. The display name for the System db. The name does not have to be unique within your project.
  - `ociUrl` string — Output only. HTTPS link to OCI resources exposed to Customer via UI Interface.

## Response `200`

Successful response

---

[API](https://skmtc.net/google/apis/oracledatabase.md) · [All operations](https://skmtc.net/google/apis/oracledatabase/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/google/oracledatabase/versions/120ce7891e09/schema)