This guide provides a high-quality, step-by-step procedure for executing the opatchauto utility to apply Oracle Grid Infrastructure (GI) and Database Release Update 36182763 (July 2024) in Non-Rolling mode.
Note: You requested "72030". Assuming this is a typo for the Release Update 36182763, which corresponds to version 19.24.0.0.240716. If you are applying a different specific patch, replace the patch number where appropriate, but the syntax remains the same. opatchauto72030 execute in nonrolling mode high quality
OPatchauto Session:
Session id: 12345
Patch location: /stage/72030
Mode: nonrolling
Analysis: passed
Apply: successful on all nodes
OPatchauto completed successfully.
If a critical issue arises after patching, rollback is straightforward in non-rolling mode: Note: You requested "72030"
$GRID_HOME/OPatch/opatchauto rollback /stage/72030/72030 \
-nonrolling \
-logdir /var/log/opatchauto
This will revert the binary changes and restart the stack. Note: SQL downgrade is not automatic; use datapatch -rollback if needed. 3. Validate Databases
SELECT PATCH_ID
SELECT PATCH_ID, VERSION, STATUS FROM DBA_REGISTRY_SQLPATCH;