Return
-
Title
No pluggable databases are listed in Oracle Pluggable Databases dashboard for Oracle 12c and higher -
Description
After registering a new container database, no pluggable databases are not showing up when using a common user in Oracle 12c and higher.
-
Cause
User ran a custom script with insufficient privileges.
The permissions script cycles through each pluggable database to ensure that each database can be queried.
-
Resolution
Ensure that a common user similar to the following- create user c##USERNAME identified by adminpwd container=all;
- grant connect,resource to c##USERNAME container=all;
Then run the permissions script provided with the Oracle cartridge.KB 4229296 describes how the permissions script can be obtained from the FMS.
NOTE: If the CREATE USER command included the username in double quotes then it will make the username case sensitive. All subsequent uses of the username must be in same case as when the username was created (i.e. c##username is different from C##USERNAME or c##USERNAME)
Also refer to KB 4376061 if only the CDB$ROOT is visible when monitoring Oracle pluggable databases -
Additional Information
There may be situations where a common user C##is created in the CDB but the common user does not show up in any PDB as it should. When querying CDB_USERS from the CDB, or querying DBA_USERS from the PDB, no rows for common user names are returned for any of the PDBs. This can be cause by unpublished Oracle bug 34014211 - COMMON USER CREATED IN 19C CDB BUT NOT CREATED IN PDB AND NO ERRORS. In this circumstance, try using a new unique (different) ID or consult Oracle metalink Doc ID 2867084.1