Friday, December 1, 2017

DAC 11.1.1.6.4 intermittent Crash




It has been notice DAC 11.1.1.6.4 Server crash intermittently and it need to be restarted.  Crash is following.




# A fatal error has been detected by the Java Runtime Environment:


# # SIGSEGV (0xb) at pc=0x00007fcf752b21b0, pid=112882, tid=140528723429696
# # JRE version: Java(TM) SE Runtime Environment (7.0_80-b15) (build 1.7.0_80-b15)
# Java VM: Java HotSpot(TM) 64-Bit Server VM (24.80-b11 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# V [libjvm.so+0x6541b0] jni_GetLongArrayRegion+0xd0
# # Failed to write core dump. Core dumps have been disabled. To enable core dumping, try "ulimit -c unlimited" before starting Java again
# # An error report file with more information is saved as: # /oraclebi/DAC11G/dac/hs_err_pid112882.log
# # If you would like to submit a bug report, please visit:
# http://bugreport.java.com/bugreport/crash.jsp
# ORA-24550: signal received: [si_signo=6] [si_errno=0] [si_code=-6] [si_int=0] [si_ptr=(nil)] [si_addr=0x4e220001b8f2] kpedbg_dmp_stack()+362




Reference:


 


ORA-24550 Signal Received Error From Client Based Application (Doc ID 1284564.1)


 


CAUSE


 


Diagnosability features which are turned on by default on Oracle 11g Release 2 causes the problem.


Parameters are:


DIAG_ADR_ENABLED


DIAG_SIGHANDLER_ENABLED


DIAG_DDE_ENABLED


 


SOLUTION


 


1. Such errors can occur if the "Diagnosability" features are 'ON'.


To turn off the OCI signal handler and re-enable standard Operating System failure processing, place the following parameter setting in sqlnet.ora:


DIAG_SIGHANDLER_ENABLED=FALSE


By default this parameter is set to true.


If you want to see the old behavior you can simply turn off the feature by placing the following parameter setting in your client side sqlnet.ora file under $ORACLE_HOME/network/admin directory.


2. In addition, please turn off other Diagnostics parameters as well by placing the following entries in the client side or server sqlnet.ora file. i.e., from where the application is run.


DIAG_ADR_ENABLED=OFF


DIAG_SIGHANDLER_ENABLED=FALSE


DIAG_DDE_ENABLED=FALSE


 


Note:


Changes to client side SQLNET.ORA requires only application restart.


Where as changes to SQLNET.ORA on Database side requires only restart of the listener.


 

No comments: