In this article I will explain how to install/upgrade OPatch utility in grid_home and oracle_home in a RAC infrastructure.

Opatch utility is used while applying patches to the database. Every readme file (that comes with patch), mention the recommended opatch version. If your existing opatch version is lower than the recommended version then, Opatch need to be updated.

Here we will upgrade Opatch on both GRID_HOME and DB_HOME in a 2 node RAC setup.

 

 

How to check your existing opatch version:

 

cd $GRID_HOME/OPatch
/gridapp/app/oracle/product/grid12c/OPatch# ./opatch version
OPatch Version: 12.2.0.1.14
 
OPatch succeeded.

cd $ORACLE_HOME/OPatch
/oracle/app/oracle/product/12.1.0.2/dbhome_1/OPatch#./opatch version
OPatch Version: 12.2.0.1.14
 
OPatch succeeded.



Lets proceed with install/upgrade OPatch.

1. Download latest opatch utility

LINK -  > Oracle OPatch link - 6880880

 

 

select required release and platform for download.

 

2. Copy the file to both the database nodes:

 

cd /dumparea
ls -ltr p6880880_122001_Solaris.zip

3. Upgrade OPatch on GRID_HOME( as root user)

----Backup existing OPatch ( as root user)

root#cd $GRID_HOME
root#pwd
/gridapp/app/oracle/product/grid12c

root#cp OPatch OPatch_old

--- copy the latest opatch file to GRID_HOME and unzip 
root#cp /dumparea/p6880880_122001_Solaris.zip /gridapp/app/oracle/product/grid12c/

root# cd /gridapp/app/oracle/product/grid12c/
root# unzip p6880880_122001_Solaris.zip

-- provide permission to grid owner( this is very important)

root# chown -R oracle:oinstall OPatch
root#chmod -R 755 OPatch

-- Check the OPatch version
root#./opatch version
OPatch Version: 12.2.0.1.21

GRID_HOME OPatch has been upgraded. Lets proceed with DB_HOME

4. Upgrade OPatch in DB_HOME

oracle$cd $ORACLE_HOME

oracle$pwd
/oracle/app/oracle/product/12.1.0.2/dbhome_1

oracle$cp OPatch OPatch_old

--- copy the latest opatch file to DB_HOME and unzip
oracle$cp /dumparea/p6880880_122001_Solaris.zip /oracle/app/oracle/product/12.1.0.2/dbhome_1

oracle$ cd /oracle/app/oracle/product/12.1.0.2/dbhome_1
oracle$ unzip p6880880_122001_Solaris.zip

-- Check the OPatch version
oracle$./opatch version
OPatch Version: 12.2.0.1.21

Now DB_HOME opatch version has been upgrade on the node 1:

THESE SAME OPATCH UPGRADE NEED TO BE FOLLOWED ON OTHER NODES IN THE GRID ALSO.

gridOPATCHpatchingRAC ORACLE RAC


Related Topics

How to move spfile from file system to ASM in RAC
How to Downgrade oracle 19C Grid to 12C GRID
How to recreate MGMT database in ORACLE 12C GRID
How to flashback a RAC database
Steps for changing public hostname for a standalone grid infrastructure
Apply database proactive bundle patch in RAC using manual process
How to install OPatch in ORACLE RAC
Upgrade grid infrastructure to 19C oracle
How to deinstall/cleanup standalone grid infrastructure

You May Also Like

Steps for upgrading weblogic 12.1.2 to 12.1.3
Find the active transactions in oracle database
How to drop a database in postgres
Generate custom report from OEM cloud control
Install oracle enterprise manager cloud control 12c
How to enable flash recovery area in oracle database
Useful TFACTL commands
Clone a database using dbca command in oracle 19c -New feature
Oracle database Security Assessment Tool
Setting up Table replication in oracle goldengate

From This Website

How to enable flash recovery area in oracle database
Ansible script to run script on remote server and fetch the output
How to find cpu and memory information of oracle database server
Lock account automatically with INACTIVE_ACCOUNT_TIME
DEFERRED_SEGMENT_CREATION parameter in oracle
ERROR: permission denied for schema in postgres
how to use DBMS_PRIVILEGE_CAPTURE to capture privs in oracle 12c
How to move AUD$ table to another tablespace using DBMS_AUDIT_MGMT
How to install postgres database on mac os/linux
How to add a tempfile in primary database in dataguard