PSU Patching step by step on RAC

OPatch utility version 12.1.0.1.7 or later to apply this patch.

Grid Patch:----------------------------------------------------------------------------------------------------------------

From Oracle Home as oracle user:-
/o001/home/oracle/product/12.1.0/db_1/OPatch/opatch lsinventory -detail -oh /o001/home/oracle/product/12.1.0/db_1

From Grid Home as grid user:-
/o001/home/12.1.0/grid/OPatch/opatch lsinventory -detail -oh /o001/home/12.1.0/grid

As root user:-
/o001/home/12.1.0/grid/OPatch/opatchauto apply /o002/Oct_PSU_Patch/26635815 -analyze



export PATH=/o001/home/12.1.0/grid/OPatch:$PATH

opatchauto apply <UNZIPPED_PATCH_LOCATION>/27010872


Check Oracle permission
$ORACLE_HOME/lib/libsqlplus.so --- Should be 644


From both oracle and grid users:-
opatch lsinventory

col ACTION_TIME for a30
col BUNDLE_SERIES for a15
select ACTION_TIME,PATCH_ID,PATCH_UID,VERSION,ACTION,STATUS,BUNDLE_SERIES,BUNDLE_ID from dba_registry_sqlpatch;

###################################Amar Jadhav ######################


PSU and CPU April 2018 Patching 2 Node RAC Cluster.[Doc ID 2353306.1] 
--------------------------------
Database Version: 12.1.0.2.0


Patches


Patch 27475603: OJVM PATCH SET UPDATE 12.1.0.2.180417
Patch 27468957 GRID INFRASTRUCTURE PATCH SET UPDATE 12.1.0.2.180417

Steps Performed :  [Before patching activity]

We have check & save the current list of active process before performing this activity  on Node1,Node2

1. p -eaf|grep tns
2. ps -eaf|grep smon
3. crs_stat -t -v
4.crsctl status resource
5. crsctl check crs
6. crsctl check cluster -all
7. srvctl status asm

Brought down the edq from weblogic console (Edq 24). along with admin server.
Brought down the obiie from weblogic console (Obiee 23server) along with admin server. Need to down Opmnctl service also
Brough down the database


Steps 1: [node1, Node2 ]

Patch 27468957 GRID INFRASTRUCTURE PATCH SET UPDATE 12.1.0.2.180417

Unzip patch using grid user (Patch 26610308) ----Appyied patch using ROOT user.
reviewed the redme file
brought down the database using srvctl [complete shutdown]

OR

No need to bring down the database & cluster services.
Because from 12c onwords opatchauto utility will bring down the services automaticallly .
optach version must be latest on the grid home as well as oracle home
optachauto apply.

Step2: [ Node1 Node2]

Patch 23727148: ORACLE JAVAVM COMPONENT 12.1.0.2.160719 DATABASE PSU.[node1,node2]

1. unziped patch using grid user.
2. set the envornment variable as grid user.
3.$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
4.$ opatch apply
5. optach lsinventory



step 3:  [ Node1,Node2 ]

Patch 27475603: OJVM PATCH SET UPDATE 12.1.0.2.180417
2.Unzip patch using Oracle user.
3.check optach utility must have latest version
4.set the envornment variables
$ cd <PATCH_TOP_DIR>/26027162
$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
$opatch apply


Post Installation:
------------------

sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> alter system set cluster_database=false scope=spfile;

$ORACLE_HOME/bin/srvctl stop database -d <dbname>
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP UPGRADE
cd $ORACLE_HOME/Opatch
$./datapatch -verbose

sqlplus /nolog

sql> connect / as sysdba

sql> startup

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql


Step 4: [ Node1 , Node2 ]
-------

1. unzip Patch 25869659: WLS PATCH SET UPDATE 12.1.3.0.170718
2. set the ORACLE_HOME env vaiable to the directory whre you have installed ORACLE_WEBLOGIC Server.
2. brought down the database & application (edq,obiie) / stop all server (Adminserver and Managed server(s) )
3. veried opatch version . Must be latest
4.validate ora inventory
    $ opatch lsinventory -jre $ORACLE_HOME/jdk/jre
5.optach apply

   

#########################steps prepared#######################

For Grid patch :

You must use the OPatch utility version 12.1.0.1.7  or later .
For each Oracle RAC database home and the GI home that are being patched, run the following commands as the home owner to extract the OPatch utility.


Both GRID HOME and ORACLE HOME :(GH1,GH2,OH1,OH2)

   <ORACLE_HOME>/OPatch/opatch version
o/p-  The version output of the previous command should be 12.1.0.1.7 or later.

 Validation of Oracle Inventory:
 -------------------------------
  GI home and Each Oracle home
 
  <ORACLE_HOME>/OPatch/opatch lsinventory -detail -oh <ORACLE_HOME>

1.2.1.3 Download and Unzip the Patch:
--------------------------------------

Unzip the patch as grid home owner.

$ unzip p27468957_121020_<platform>.zip

1.2.2 One-off Patch Conflict Detection and Resolution:
-----------------------------------------------------
  a) The following commands check for conflicts in both the 12.1 GI home and the 12.1 DB homes.
 
   GRID_HOME/OPatch/opatchauto apply <UNZIPPED_PATCH_LOCATION>/27468957 -analyze
  
  
   b)opatchauto for GI(root)
     must be executed by an operating system (OS) user with root privileges, and it must be executed on each node in the cluster
   
     export PATH=$PATH:<GI_HOME>/OPatch
   
    <GI_HOME>/OPatch/opatchauto apply <UNZIPPED_PATCH_LOCATION>/27468957

Comments

Popular posts from this blog

All about DataInstaller & Hrglobal.drv in Oracle Applications R12

EBS Oracle Database 11.1.0.7 upgrade to 11.2.0.4 steps .