Username Of PDB Admin is Always PDBADMIN When PDB Created With DBCA In 19.6 Version (Doc ID 2643799.1)

Last updated on JULY 20, 2024

Applies to:

Goal

How to create desired PDB admin's username during PDB creation with DBCA ?

When create new PDB with DBCA, the username of PDB admin is always PDBADMIN no matter what is choose.
Example:
dbca -silent -createPluggableDatabase -sourceDB cdXXX -pdbName devXXX -createPDBFrom DEFAULT -pdbAdminUserName XXXX_ADMIN -pdbAdminPassword '******' -createUserTableSpace true

then "PDBADMIN" User gets created instead of "XXXX_ADMIN":

select username, created, con_id from cdb_users where (username like 'PDB%' or username like 'TEST%') and con_id in (select pdb_id from DBA_PDBS where PDB_NAME='TEST');

USERNAME  CREATED CON_ID
-------------------------------------------------------------------------------
PDBADMIN   24-FEB-20 3

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.