Check the conflicts before installing Patch in Oracle Database

Following is the steps which will provide the detail of conflict which need to resolve before apply the patch:

  1. Download the latest patch which you want to apply on your Oracle Home.

2. Unzip the downloaded patch and go to the directory in shell or command prompt of which you want to check conflict.

cd C:\patch\patch_25463157\25463157 

3. Run the command with patch number you want to apply in that patch directory.

--- go to the unzip directory location and run the command with patch number:
C:\patch_25463157>opatch prereq CheckConflictAgainstOHWithDetail -ph 25463157 

OR

-- Go to the directory of patch number location and use . as current patch:
C:\patch_25463157\25463157>opatch prereq CheckConflictAgainstOHWithDetail -ph .

4. Example shows conflict or no conflict found in patching as shown in images:

No Conflict found
Conflict found

5. If we found the conflict, then we need to rollback the conflict patch first before applying the new patch.

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply