How to Verify Oracle Database 19c Release Update Patching in CDB and PDB Environments

Verifying Oracle Database 19c Release Update (19.32) patching in Container Database (CDB) and Pluggable Database (PDB) environments is crucial for ensuring the database functions as intended. After applying a patch, it's important to verify that the SQL patches have been applied successfully and that the CDB and PDBs are running correctly. This guide demonstrates how to verify the patching process using Oracle OPatch, SQLPlus, Dictionary Views, and SQL commands.

To begin, log in to the database server with the appropriate Oracle Home and execute the command $ORACLE_HOME/OPatch/opatch lspatches. This will display a list of applied patches, including the ID (39472050) and description (Database Release Update: 19.32.0.0.260721) of the Oracle Database 19c Release Update (19.32) patch. Next, check the SQL patches by executing the command SELECT con_id, patch_id, action, status FROM cdb_registry_sqlpatch WHERE patch_id = 39472050 ORDER BY con_id; This will return a list of container IDs and patch statuses, confirming that the SQL patch was applied successfully to both the CDB root and the user PDB.

After verifying the SQL patches, check the current status of the PDBs using the command SHOW PDBS or SELECT con_id, name, open_mode. This will display the open mode of each PDB, ensuring that they are running correctly. It's important to note that having a SUCCESS status for the SQL patches doesn't guarantee that the patch was applied successfully; additional checks should be performed to ensure the database and PDBs are functioning as expected.