Skip to Content
Last modified by Nefedenkova Viktoria on 2021/08/20 18:48
Show last authors
1 ^^[[Информационные материалы проекта UNA>>http://xwiki.una.md/bin/view/UNA/WebHome]] (% class="separator" %)»(%%) [[Регламенты Unisim-Soft>>http://xwiki.una.md/bin/view/UNA/Reglament_docs]] (% class="separator" %)»(%%) [[IT>>http://xwiki.una.md/bin/view/UNA/IT]]^^
2
3 I have a coredmp where all thread stack look normal but one stack shows like this. Can any one tell me possible reason for this? i can see exit is being called from oracle libs, is this issue of oracle? Can any one guide me when this can happen?
4
5 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
6 {{{ Thread 3 (process 26454):
7 #0 0x00002b803ceb54a8 in exit () from /lib64/libc.so.6
8 #1 0x00002b803bbe93f5 in skgdbgcra () from /home/oracle/product/11g/lib/libclntsh.so.11.1
9 #2 0x00002b803be9cdec in kpeDbgCrash () from /home/oracle/product/11g/lib/libclntsh.so.11.1
10 #3 0x00002b803be9c627 in kpeDbgSignalHandler () from /home/oracle/product/11g/lib/libclntsh.so.11.1
11 #4 0x00002b803bbe64b1 in skgesig_sigactionHandler () from /home/oracle/product/11g/lib/libclntsh.so.11.1
12 #5 <signal handler called>
13
14 > Program terminated with signal 6, Aborted.}}}
15
16 Looks like it's an issue on oracle 11g.
17
18 1. Starting from Oracle 11g Diagnostic Repositories are turned on by default. Automatic Diagnostic Repository (ADR) Parameters such as DIAG_SIGHANDLER_ENABLED, DIAG_ADR_ENABLED, DIAG_DDE_ENABLED are mostly set at SQLNET.ORA.
19
20 Having DIAG_SIGHANDLER_ENABLED will force all diagnostics to be written such as alert logs, trace files, application dumps and that becomes a overload and sometimes the Application stumbles.
21
22 To turn off the signal handler and re-enable standard Operating System failure processing, place the following parameter setting in your client side or server side sqlnet.ora file under $ORACLE_HOME/network/admin directory.
23
24 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
25 DIAG_ADR_ENABLED=OFF
26 DIAG_SIGHANDLER_ENABLED=FALSE
27 DIAG_DDE_ENABLED=FALSE
28
29 By default this parameter is set to true.
30
31 After making any such changes to ADR ie., turning off DIAG_SIGHANDLER_ENABLED, DIAG_ADR_ENABLED, DIAG_DDE_ENABLED, it is recommended to restart the Application after making the setting in sqlnet.ora.
32
33 (% start="3" %)
34 1. Turning off ADR parameters should cause no impact either to your Application or Database.