ORA-07445: exception encountered , CDUMP consuming lots of space in less time in 19c PDB/CDB with EBS 12.1.3:

CDUMP consuming lots of space in less time in 19c PDB/CDB with EBS 12.1.3:

As per alert log, below details observed:

++++++++++++
 Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x18] [PC:0x1186F6114, ioc_access_IU()+84] [flags: 0x0, count: 1]

Errors in file PROD_mz00_28282.trc  (incident=590939) (PDBNAME=CDB$ROOT):

ORA-07445: exception encountered: core dump [ioc_access_IU()+84] [SIGSEGV] [ADDR:0x18] [PC:0x1186F6114] [Address not mapped to object] []
+++++++++++++

In my case, I applied below workaround and issue got fixed.


SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 EBSPROD                        READ WRITE NO

SQL> show parameter JAVA_JIT_ENABLED
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
java_jit_enabled                     boolean     TRUE

SQL> alter system set JAVA_JIT_ENABLED=FALSE scope=both;
System altered.

SQL> show parameter JAVA_JIT_ENABLED
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
java_jit_enabled                     boolean     FALSE

SQL> alter session set container=EBSPROD;
Session altered.

SQL> show parameter JAVA_JIT_ENABLED
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
java_jit_enabled                     boolean     TRUE

SQL> alter system set JAVA_JIT_ENABLED=FALSE scope=both;
System altered.

SQL> show parameter JAVA_JIT_ENABLED
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
java_jit_enabled                     boolean     FALSE
SQL>


(if required) restart database (shut immediate/startup)

Thanks

Post a Comment

0 Comments