No pluggable databases are listed in Oracle Pluggable Databases dashboard for Oracle 12c and higher (4310978)

Tchater maintenant avec le support

Obtenir une aide instantanée
Terminer l’enregistrement

Se connecter

Demander les tarifs

Contacter le service des ventes

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

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.
Résolution
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
Informations supplémentaires

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

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Demander un article de la base de connaissances

Contenu recommandé

Produit(s) :: Foglight Cloud
Hosted; Foglight
7.1.0, 6.3.0, 6.1.0, 6.0.0, 5.9.8, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2; Foglight for Databases
7.1.0, 6.3.0, 6.1.0, 6.0.0, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2

Sujet(s) :: Troubleshooting

Historique de l’article :: Créé le : 7/17/2020
Dernière mise à jour le : 6/14/2024

Rechercher tous les articles

Veuillez sélectionner votre produit

Afin de mieux répondre à vos besoins, précisez l'objet du tchat:

Solutions recommandées pour votre problème

No pluggable databases are listed in Oracle Pluggable Databases dashboard for Oracle 12c and higher (4310978)

Titre

Description

Cause

Résolution

Informations supplémentaires

Leave a Comment