Only CDB$ROOT is visible when monitoring Oracle pluggable databases
说明
Only CDB$ROOT is visible when monitoring Oracle pluggable databases
原因
By default in Oracle unless it is specified otherwise, new common users are created set with container_data=current so that containers queries only return the local data pertaining to the application PDBs.
(NOTE: This issue typically occurs when the permissions script was run manually in which the &&USER_NAME was manually replaced in the script but one of the replacements was missed.)
解决办法
Modify the foglight Oracle agent user to set the container_data to all so that the query returns both the shared data in the application root and the local data pertaining to the application PDB.
As a SYSTEM or SYSDBA user in SQL on the host, run the following command alter user C##USERNAME set container_data=all container=current;
Deactivate and reactivate the Oracle agent or Oracle RAC agents for the host.
Return to the Pluggable databases dashboard and wait a moment for the additional PDB databases to display.
