← 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