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