Oracle Patching Process and Commands

Keeping Oracle database software up to date is crucial for maintaining system security, stability, and performance of the database. Below, we will see a structured approach to patching Oracle environments using OPatch, Oracle’s patching utility. Let’s break down the process and commands in detail.

Types of Oracle Patches

Patch Type	Description	Typical Use
One-Off Patch	Fixes a single issue	Urgent bug fix
PSU (Patch Set Update)	Security and bug fixes	Regular maintenance
RU (Release Update)	Security, bug, and functional fixes	Broader updates
RUR (Release Update Revision)	Smaller revision of RU	Minor improvements

 

Follow these steps for a smooth and safe patching experience in production environments:

1 .Check Current Version

SELECT * FROM v$version;

Confirms the current Oracle version before applying any patch

 

2. Plan & Take Backup

Use RMAN for database backup and copy the Oracle Home directory.

 

3. Pre-Patch Checks

Verify patch readiness, available space, and potential conflicts.

 

4. Stop Services 

Shutdown Database, Listener, and ASM if required to prevent conflicts.

 

5. Apply Patch

opatch apply

 

6. Run Datapatch

datapatch -verbose

Updates the database dictionary and applies SQL changes.

7. Start Services

Start the services, such as the database, listener, or ASM.

 

8. Verify Patch

opatch lsinventory

SELECT * FROM dba_registry_sqlpatch;