How to apply SQL patches with datapatch in Oracle

Apply the SQL part of a Release Update to the database with datapatch, then verify it registered.

This modifies the data dictionary by applying SQL patches. Run it after the binary patch is in place, with the database open, following the patch readme.

# Database must be open; run from the patched Oracle Home
cd $ORACLE_HOME/OPatch
./datapatch -verbose

-- Verify (read-only): the patch should show SUCCESS
SELECT patch_id, action, status, action_time
FROM   dba_registry_sqlpatch
ORDER  BY action_time DESC;