In this article , we will provide steps for rolling back a patch in non-rac standalone database.

PATCH TO BE ROLLED BACK – 27105253 – Database Jan 2018 Release Update (DB RU) 12.2.0.1.180116

 

1. Check the existence of patch in oracle home inventory.

2. Shutdown services running from oracle_home(database , listener)

3. Rollback the patch.

$ORACLE_HOME/OPatch/opatch rollback -id 27105253

4. Now start the database:

5. Now run the post rollback script.

cd $ORACLE_HOME/OPatch

./datapatch -verbose

6. Check the registry table for the status:

Rollback is successful.:)