Sunday 14 April 2019

End of day not completing // DBMS_RESULT_CACHE is showing disabled in one of the RAC node


Issue :DBMS_RESULT_CACHE is showing disabled in one of the RAC node

On weekend (Saturday ) , We have performed the switch over activity.As part of the switch over activity ,We need to bring down the NODE 2 and perform the switch over action plan.
After successful switch over EOD has been trigger which is fetcting the old data from the system and EOD never completing.We have raised SEV 1 SR with ORACLE to get immediate help on this and below is the response.





Node 1
++++
oracle@icctsd-prd-01:~$ sqlplus "/as sysdba"

SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 17 16:45:16 2018

Copyright (c) 1982, 2014, Oracle. All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> SELECT DBMS_RESULT_CACHE.status FROM dual;

STATUS
--------------------------------------------------------------------------------
DISABLED

SQL>


Node 2
+++++
oracle@icctsd-prd-02:~$ sqlplus "/as sysdba"

SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 17 14:49:47 2018

Copyright (c) 1982, 2014, Oracle. All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> SELECT DBMS_RESULT_CACHE.status FROM dual;

STATUS
--------------------------------------------------------------------------------
ENABLED




solution : Just bounce the database and check the status of result cache.

No comments:

Post a Comment