Modifying an RDS for Oracle tenant database - Amazon Relational Database Service

Modifying an RDS for Oracle tenant database

You can modify only the PDB name and the master user password of a tenant database in your CDB. Note the following requirements and limitations:

  • To modify the settings of a tenant database in your DB instance, the tenant database must exist.

  • You can't modify multiple tenant databases in a single operation. You can only modify one tenant database at a time.

  • You can't change the name of a tenant database to CDB$ROOT or PDB$SEED.

You can modify PDBs using the AWS Management Console, the AWS CLI, or the RDS API.

To modify the PDB name or master password of a tenant database

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the upper-right corner of the Amazon RDS console, choose the AWS Region in which you want to create the tenant database.

  3. In the navigation pane, choose Databases.

  4. Choose the tenant database whose database name or master user password you want to modify.

  5. Choose Modify.

  6. For Tenant database settings, do any of the following:

    • For Tenant database name, enter the new name of your new PDB.

    • For Tenant database master password, enter a new password.

  7. Choose Modify tenant.

To modify a tenant database using the AWS CLI, call the modify-tenant-database command with the following parameters:

  • --db-instance-identifier value

  • --tenant-db-name value

  • [--new-tenant-db-name value]

  • [--master-user-password value]

The following example renames tenant database pdb1 to pdb-hr on DB instance my-cdb-inst.

Example

For Linux, macOS, or Unix:

aws rds modify-tenant-database --region us-east-1 \
    --db-instance-identifier my-cdb-inst \
    --tenant-db-name pdb1 \
    --new-tenant-db-name pdb-hr

For Windows:

aws rds modify-tenant-database --region us-east-1 ^
    --db-instance-identifier my-cdb-inst ^
    --tenant-db-name pdb1 ^
    --new-tenant-db-name pdb-hr

This command produces output similar to the following. 

{
    "TenantDatabase" : {
        "DbiResourceId" : "db-abc123",
        "TenantDatabaseResourceId" : "tdb-bac567",
        "TenantDatabaseArn" : "arn:aws:rds:us-east-1:123456789012:db:my-cdb-inst:pdb1",
        "DBInstanceIdentifier" : "my-cdb-inst",
        "TenantDBName" : "pdb1",
        "Status" : "modifying",
        "MasterUsername" : "tenant-admin-user"
        "Port" : "6555",
        "CharacterSetName" : "UTF-16",
        "MaxAllocatedStorage" : "1000",
        "ParameterGroups": [
            {
                "ParameterGroupName": "pdb1-params",
                "ParameterApplyStatus": "in-sync"
            }
        ],
        "OptionGroupMemberships": [
            {
                "OptionGroupName": "pdb1-options",
                "Status": "in-sync"
            }
        ],
        "PendingModifiedValues": {
            "TenantDBName": "pdb-hr"
        }
    }
}