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]
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
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
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_jit_enabled boolean TRUE
SQL> alter system set JAVA_JIT_ENABLED=FALSE scope=both;
System altered.
System altered.
SQL> show parameter JAVA_JIT_ENABLED
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_jit_enabled boolean FALSE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_jit_enabled boolean FALSE
SQL> alter session set container=EBSPROD;
Session altered.
Session altered.
SQL> show parameter JAVA_JIT_ENABLED
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_jit_enabled boolean TRUE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_jit_enabled boolean TRUE
SQL> alter system set JAVA_JIT_ENABLED=FALSE scope=both;
System altered.
System altered.
SQL> show parameter JAVA_JIT_ENABLED
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_jit_enabled boolean FALSE
SQL>
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_jit_enabled boolean FALSE
SQL>
(if required) restart database (shut immediate/startup)
Thanks
Thanks
0 Comments