Rollback an Oracle CPU patch deployed in Oracle Standard Edition

Products

• Data Loss Prevention
• Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

How to rollback or uninstall an Oracle CPU patch in the Oracle Standard Edition.
Users of Oracle Enterprise will need to work with their DBA to rollback or uninstall the CPU.

Resolution

When you download the CPU patch, it includes a docs folder containing a readme file with all the instructions necessary for uninstalling the patch. The basic command to perform the rollback will resemble:

opatch rollback -id <ID>

A]. Rollback Instructions
1. Check Rollback Command Syntax
Before proceeding with the rollback, you can confirm the syntax and options for the opatch rollback command by using the -help flag:

$ opatch rollback -help

2. Perform the Rollback
-id <ID>: Specify the reference ID of the patch to be rolled back.
-connectString <List of connect strings>: Connect strings for the Oracle database.
-delay <value>: Specify a delay value.
-init <parameters for the init script in escaped double quotes> [-opatch_init_end]: Parameters for the init script.
-invPtrLoc <Path to oraInst.loc>: Path to the oraInst.loc file.
-jre <LOC>: Location of the Java Runtime Environment (JRE).
-local: Perform the rollback on the local system.
-local_node <Local node name>: Specify the local node name.
-no_relink: Skip relinking.
-oh <ORACLE_HOME>: Path to the Oracle Home directory.
-ph <Patch Location>: Location of the patch.
-post <parameters for the post script in escaped double quotes>[ -opatch_post_end]: Parameters for the post script.
-pre <parameters for the pre script in escaped double quotes> [-opatch_pre_end]: Parameters for the pre script.
-property_file <path to property file>: Path to a property file.
-ptlConnect <portal connect string>: Portal connect string.
-ptlPassword <portal password>: Portal password.
-ptlSchema <portal schema>: Portal schema.
-remote_nodes <List of remote nodes (node1,node2)>: List of remote nodes for rollback.
-retry <value>: Specify a retry value.
-runSql: Run SQL scripts.
-silent: Perform the rollback silently.
-sqlScript <path of the SQL file>: Path to the SQL script file.
-verbose: Verbose output for the rollback process.

Example: $ opatch rollback -id 12345 -oh /path/to/ORACLE_HOME -local -verbose

Notes:
- Replace <ID> with the actual reference ID of the patch to be rolled back.
- Modify other options as needed based on your system configuration.
- Ensure you have the necessary permissions and backups before proceeding with the rollback.