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$ROOTorPDB$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
Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/
. -
In the upper-right corner of the Amazon RDS console, choose the AWS Region in which you want to create the tenant database.
-
In the navigation pane, choose Databases.
-
Choose the tenant database whose database name or master user password you want to modify.
-
Choose Modify.
-
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.
-
-
Choose Modify tenant.
To modify a tenant database using the AWS CLI, call the modify-tenant-database command with the following parameters:
-
--db-instance-identifiervalue -
--tenant-db-namevalue -
[--new-tenant-db-namevalue] -
[--master-user-passwordvalue]
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 --regionus-east-1\ --db-instance-identifiermy-cdb-inst\ --tenant-db-namepdb1\ --new-tenant-db-namepdb-hr
For Windows:
aws rds modify-tenant-database --regionus-east-1^ --db-instance-identifiermy-cdb-inst^ --tenant-db-namepdb1^ --new-tenant-db-namepdb-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"
}
}
}