← Patching & Upgrade
Oracle · Patching & Upgrade
How to check database component status after patching in Oracle
After a patch or upgrade, confirm every database component is VALID and at the expected version from DBA_REGISTRY.
Tested on11g12c18c19c21c23ai26ai
After a patch or upgrade, confirm every database component is VALID and at the expected version.
SELECT comp_id, comp_name, version, status
FROM dba_registry
ORDER BY comp_id;PatchingUpgradeDBA_REGISTRY