{"id":852,"date":"2024-12-24T13:52:32","date_gmt":"2024-12-24T13:52:32","guid":{"rendered":"https:\/\/w3buddy.com\/?p=852"},"modified":"2026-01-15T13:15:58","modified_gmt":"2026-01-15T07:45:58","slug":"opatch-command-usage-for-oracle-patch-management","status":"publish","type":"post","link":"https:\/\/w3buddy.com\/blog\/opatch-command-usage-for-oracle-patch-management\/","title":{"rendered":"OPatch Command Usage for Oracle Patch Management"},"content":{"rendered":"\n

A collection of essential OPatch commands for managing Oracle patches, including listing inventory, applying\/rolling back patches, checking conflicts, and handling multiple inventory locations. This guide ensures efficient patch management for Oracle environments.<\/p>\n\n\n\n

Serial No.<\/strong><\/th>Action<\/strong><\/th>Command and Description<\/strong><\/th><\/tr><\/thead>
1<\/td>List inventory details of patch<\/td>$ORACLE_HOME\/OPatch\/opatch lsinventory<\/code>
List all patch inventory details applied to the Oracle home.<\/td><\/tr>
2<\/td>List patchsets applied<\/td>$ORACLE_HOME\/OPatch\/opatch lspatches<\/code>
List all patches currently applied to the Oracle home.<\/td><\/tr>
3<\/td>Find OPatch version<\/td>$ORACLE_HOME\/OPatch\/opatch version<\/code>
Find the version of OPatch installed in the Oracle home.<\/td><\/tr>
4<\/td>Find details of a particular patch<\/td>$ORACLE_HOME\/OPatch\/opatch query -all {PATCH_PATH}<\/code>
Query a specific patch’s details before applying.<\/td><\/tr>
<\/td><\/td>$ORACLE_HOME\/OPatch\/opatch query -all \/software\/PSUPATCH\/30089984<\/code>
Example to find details for a specific patch.<\/td><\/tr>
5<\/td>Apply a patch to RDBMS home<\/td>cd \/SOFTWARE\/PSUPATCH\/30089984<\/code>
$ORACLE_HOME\/OPatch\/opatch apply<\/code>
Apply a patch to the RDBMS home.<\/td><\/tr>
6<\/td>Rollback a patch from RDBMS home<\/td>$ORACLE_HOME\/OPatch\/opatch rollback -id [patch_id]<\/code>
Rollback a specific patch from the RDBMS home.<\/td><\/tr>
<\/td><\/td>$ORACLE_HOME\/OPatch\/opatch rollback -id 30089984<\/code>
Example rollback of a patch.<\/td><\/tr>
7<\/td>Apply one-off patch in Grid Home<\/td>root# $GI_HOME\/crs\/install\/rootcrs.sh -prepatch<\/code>
Apply one-off patch in the Grid Home.<\/td><\/tr>
<\/td><\/td>oracle$ cd \/SOFTWARE\/PSUPATCH\/30089984<\/code>
$GRID_HOME\/OPatch\/opatch apply<\/code>
Apply the patch in Grid Home.<\/td><\/tr>
<\/td><\/td>root# $GI_HOME\/crs\/install\/rootcrs.sh -postpatch<\/code>
Run the post-patch script.<\/td><\/tr>
8<\/td>Check conflict against ORACLE_HOME<\/td>cd 27734982<\/code>
[27734982]$ $ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -ph .\/<\/code>
Check for any conflicts with the Oracle Home.<\/td><\/tr>
9<\/td>Check whether active executables are running<\/td>cd 27734982<\/code>
[27734982]$ $ORACLE_HOME\/OPatch\/opatch prereq CheckActiveFilesAndExecutables -ph .\/<\/code>
Check if any active executables are running.<\/td><\/tr>
10<\/td>Opatch command using different inventory location<\/td>$ORACLE_HOME\/OPatch\/opatch lsinventory -invPtrLoc \/etc\/orainv\/orainventory<\/code>
List inventory details using a custom inventory location.<\/td><\/tr><\/tbody><\/table>
Table: Essential OPatch Commands for Oracle Patch Management<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"

A collection of essential OPatch commands for managing Oracle patches, including listing inventory, applying\/rolling back patches, checking conflicts, and handling multiple inventory locations. This guide ensures efficient patch management for Oracle environments. Serial No. Action Command and Description 1 List inventory details of patch $ORACLE_HOME\/OPatch\/opatch lsinventoryList all patch inventory details applied to the Oracle home. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"googlesitekit_rrm_CAowu461DA:productID":"","footnotes":""},"categories":[1225],"tags":[],"class_list":["post-852","post","type-post","status-publish","format-standard","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/852","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/comments?post=852"}],"version-history":[{"count":2,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/852\/revisions"}],"predecessor-version":[{"id":1537,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/852\/revisions\/1537"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/tags?post=852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}