PSU Patching on 12c RAC

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 (27468957) ----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.


step 2:  [ Node1,Node2 ]

Patch 27475603: OJVM PATCH SET UPDATE 12.1.0.2.180417
1.bring down database and listner before applying this patch
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

   

 GRID PATCH(as root user on both bode )

 step1: Bring down edq application
 Step2: export PATH=/db/app/12.1.0/grid_1/OPatch:$PATH
 Step3: As root user:-
        /db/app/12.1.0/grid_1/OPatch/opatchauto apply /dblogbackup1/APR18CPU/27468957 -analyze
step4: As root user
        /db/app/12.1.0/grid_1/OPatch/opatchauto apply /dblogbackup1/APR18CPU/27468957


Verify patch in sql:
------------------------


SET LINESIZE 400
COLUMN action_time FORMAT A20
    COLUMN action FORMAT A10
    COLUMN status FORMAT A10
    COLUMN description FORMAT A40
    COLUMN version FORMAT A10
    COLUMN bundle_series FORMAT A10

    SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,
           action,
           status,
           description,
           version,
           patch_id,
           bundle_series
    FROM   sys.dba_registry_sqlpatch
    ORDER by action_time;
#########################################################General steps ##########################################################################


Prerequsites :

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

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;