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 19.6.0.0.0 and later
Information in this document applies to any platform.

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

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
Goal
Solution


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