My Oracle Support Banner

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

Last updated on MARCH 13, 2020

Applies to:

Oracle Database Configuration Assistant - Version and later
Information in this document applies to any platform.


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.
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');

PDBADMIN   24-FEB-20 3



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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