Patching & Upgrade
How to check applied patches in the database in Oracle
See which SQL patches were applied inside the database from DBA_REGISTRY_SQLPATCH, newest first, with a DBA_REGISTRY_HISTORY fallback for 11g.
How to apply a Release Update with OPatch in Oracle
Apply a Release Update to a single-instance Oracle Home with opatch apply, then finish with datapatch.
How to rolling patch a RAC cluster with opatchauto in Oracle
Patch a RAC cluster node by node with opatchauto to keep the database available, with a rollback command.
How to upgrade a database with AutoUpgrade in Oracle
Upgrade a database to a new major release with AutoUpgrade: run analyze first, then deploy, driven by a config file.
How to check for patch conflicts before applying in Oracle
Before applying a patch, check it for conflicts against the Oracle Home with opatch prereq CheckConflictAgainstOHWithDetail.
How to check the database version in Oracle
Confirm the exact Oracle release and component versions from V$VERSION and PRODUCT_COMPONENT_VERSION, with VERSION_FULL for the RU on 18c and later.
How to list applied patches with OPatch in Oracle
List the patches applied to an Oracle Home from the OS with opatch lsinventory and opatch lspatches.
How to check the timezone file version in Oracle
Check the DST timezone file version the database uses from V$TIMEZONE_FILE and DATABASE_PROPERTIES; patch bundles often ship newer files.
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.
How to query the OPatch inventory from SQL in Oracle
Read the OPatch inventory and datapatch status straight from SQL with DBMS_QOPATCH, without OS shell access.
How to apply SQL patches with datapatch in Oracle
Apply the SQL part of a Release Update with datapatch after the binary patch, then verify it registered in DBA_REGISTRY_SQLPATCH.
How to find and recompile invalid objects after patching in Oracle
Find invalid objects after a patch or upgrade from DBA_OBJECTS and recompile them with utlrp or UTL_RECOMP.