Apply ASM and Oracle Patch in Standalone Server

Apply ASM and Oracle Patch in Standalone Server 

This detailed guide walks you through applying ASM and Oracle patches in a standalone server environment, from downloading patches to verifying successful installation. 

📋 Table of Contents 

  1. Step 1: Download Required GRID and DB Patches
  2. Step 2: Validation of Database, ASM, Listener Services, Invalid Objects, and OPatch Inventory
  3. Step 3: Stop Database, ASM, and Listener Services
  4. Step 4: Upgrade OPatch Utility
  5. Step 5: Copy the Required Patch File
  6. Step 6: Run OPatch Conflict Check
  7. Step 7: Apply Patch Using opatchauto
  8. Step 8: Start Database and Run datapatch -verbose
  9. Step 9: Run utlrp.sql and Check Restricted Mode
  10. Step 10: Verify Object Valid State

Step 1: Download Required GRID and DB Patches 

Kindly check the shared folder if the patch is already downloaded. If not, download the required patch from ORACLE SUPPORT. 

Step 2: Validation of Database, ASM, Listener Services, Invalid Objects, and OPatch Inventory 

  1. Check Database, ASM, and Listener services
    2. Verify patch status using:
    ps -ef | grep pmon
    ps -ef | grep tns
    3. Check database invalid count in all containers and PDBs
    4. Run:
    ./opatch lsinv 

Step 3: Stop Database, ASM, and Listener Services 

  1. Check Database CDB and PDB restricted state, then shut down DB.
    2. Shutdown ASM services.
    3. Stop Listener service and verify status. 

Step 4: Upgrade OPatch Utility 

Upgrade OPatch in both Database and Grid users by replacing the OPatch folder with the latest version from Oracle Support.
Database User Steps:
– Backup OPatch folder
– Copy and unzip new OPatch
– Verify version
Grid User Steps:
– Backup OPatch folder
– Copy and unzip new OPatch
– Change permissions to grid:oinstall
– Verify version 

Step 5: Copy the Required Patch File 

Copy the patch file to root level, unzip, and set ownership to grid:oinstall.
Command:
chown -R grid:oinstall 9999999 

Step 6: Run OPatch Conflict Check 

Run conflict check in both Database and Grid user levels for all patches. 

Step 7: Apply Patch Using opatchauto 

Apply patch from root user level:
export ORACLE_HOME=/grid/app/19.3.0/ghome_1
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
opatchauto apply 9999999 

Step 8: Start Database and Run datapatch -verbose 

Run datapatch as database user:
./datapatch -verbose 

Step 9: Run utlrp.sql and Check Restricted Mode 

Run utlrp.sql in CDB and PDB multiple times, restart DB, and check restricted mode. 

Step 10: Verify Object Valid State 

Check for invalid objects in all databases. Compile if needed and restart DB. 

 

Recent Posts