Re: Exception signal 11

On Fri, 03 Mar 2006 01:39:45 -0800, News wrote:

> I'm running 10gr2 on aix 2.5 ML07. I got Exception signal: 11 in
> trace file (nothing in alert.log) during insertion into table and
> ORA-03113: end-of-file on communication channel.
>
> The max process per user is 2048 as recommended in installation doc. No
> hardware problems with disks .. no problem with swap.. Any idea ? is it
> a bug ?

$kill -l

 1    HUP Hangup                        33     33 Signal 33
 2    INT Interrupt                     34     34 Signal 34
 3   QUIT Quit                          35     35 Signal 35
 4    ILL Illegal instruction           36     36 Signal 36
 5   TRAP Trace trap                    37     37 Signal 37
 6   ABRT Abort                         38     38 Signal 38
 7    BUS Bus error                     39     39 Signal 39
 8    FPE Floating point exception      40     40 Signal 40
 9   KILL Killed                        41     41 Signal 41
10   USR1 User defined signal 1         42     42 Signal 42
11   SEGV Memory fault                  43     43 Signal 43
12   USR2 User defined signal 2         44     44 Signal 44
13   PIPE Broken pipe                   45     45 Signal 45
14   ALRM Alarm clock                   46     46 Signal 46
15   TERM Terminated                    47     47 Signal 47
16 STKFLT Stack fault                   48     48 Signal 48
17   CHLD Child exited                  49     49 Signal 49
18   CONT Continued                     50     50 Signal 50
19   STOP Stopped (signal)              51     51 Signal 51
20   TSTP Stopped                       52     52 Signal 52
21   TTIN Stopped (tty input)           53     53 Signal 53
22   TTOU Stopped (tty output)          54     54 Signal 54
23    URG Urgent I/O condition          55     55 Signal 55
24   XCPU CPU time limit exceeded       56     56 Signal 56
25   XFSZ File size limit exceeded      57     57 Signal 57
26 VTALRM Virtual timer expired         58     58 Signal 58
27   PROF Profiling timer expired       59     59 Signal 59
28  WINCH Window size change            60     60 Signal 60
29     IO I/O possible                  61     61 Signal 61
30    PWR Power-fail/Restart            62     62 Signal 62
31 UNUSED Unused                        63     63 Signal 63
32     32 Signal 32                     64     64 Signal 64

Signal 11 is segmentation violation. You shouldn't be violating your segmentation or your parole. Quite unrelated to that, I believe you might find something beginning with ORA-07445 in your alert log file. Did you check what's in your alert log file? You may also want to check whether someone has dumped core of the warp drive into CORE_DUMP_DEST (value of the parameter)

-- 
http://www.mgogala.com