Cluster status is showing In Rolling Patching mode in Oracle 12.1.0.2 RAC after applying April PSU

Jul 3, 2016 12:51AM

Hi All,

I am facing issue after applying April PSU 2016 patches on my PROD database.Please check and advise.

Cluster status is showing In Rolling Patching mode in Oracle 12.1.0.2 RAC after applying April PSU patches in PROD database.

SQL> SELECT SYS_CONTEXT('SYS_CLUSTER_PROPERTIES', 'CLUSTER_STATE') FROM DUAL;

SYS_CONTEXT('SYS_CLUSTER_PROPERTIES','CLUSTER_STATE')

--------------------------------------------------------------------------------

In Rolling Patch

SQL> SELECT SYS_CONTEXT('SYS_CLUSTER_PROPERTIES', 'CURRENT_PATCHLVL') FROM DUAL;

SYS_CONTEXT('SYS_CLUSTER_PROPERTIES','CURRENT_PATCHLVL')

--------------------------------------------------------------------------------

0

SQL>

SQL> select * from V$PATCHES;

PATCH_ID CON_ID

---------- ----------

19769480 0

20299023 0

20831110 0

21359755 0

21436941 0

21948354 0

22291127 0

22502518 0

22502555 0

9 rows selected.

[ chssdbr13t:/opt/oracle/Srinivas-Kasarla ]

ORACLE u659785@+ASM2$ asmcmd

Database - RAC/Scalability (MOSC)