Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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.