We have CENTOS 5.5 on DELL server and several ORACLE databases on version 10.2.0.4 and 11.1.0.7. Recently I found following messages popup on /var/log/messages:


Jul 26 16:28:03 ORA6 kernel: oracle[29286]: segfault at fffffffffffffff0 rip 0000000007d54183 rsp 00007fffff6c3080 error 4
Jul 26 16:28:07 ORA6 kernel: oracle[29300]: segfault at fffffffffffffff0 rip 0000000007d54183 rsp 00007fff47838560 error 4
Jul 26 16:28:11 ORA6 kernel: oracle[29309]: segfault at fffffffffffffff0 rip 0000000007d54183 rsp 00007fffda1a3ee0 error 4
Jul 26 16:28:15 ORA6 kernel: oracle[29322]: segfault at fffffffffffffff0 rip 0000000007d54183 rsp 00007fff97087220 error 4
Jul 26 16:28:19 ORA6 kernel: oracle[29337]: segfault at fffffffffffffff0 rip 0000000007d54183 rsp 00007fffb3647280 error 4

I can not find and trace file or core dump file on O.S. and ORACLE databases. I also check hardware log and NO memory or disks error.

Any ideal?




_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos

contact your oracle support.

Eero,
rhce

2010/7/27, mcclnx mcc <mcclnx@yahoo.com.tw>:
> We have CENTOS 5.5 on DELL server and several ORACLE databases on version
> 10.2.0.4 and 11.1.0.7. Recently I found following messages popup on
> /var/log/messages:
>
>
> Jul 26 16:28:03 ORA6 kernel: oracle[29286]: segfault at fffffffffffffff0 rip
> 0000000007d54183 rsp 00007fffff6c3080 error 4
> Jul 26 16:28:07 ORA6 kernel: oracle[29300]: segfault at fffffffffffffff0 rip
> 0000000007d54183 rsp 00007fff47838560 error 4
> Jul 26 16:28:11 ORA6 kernel: oracle[29309]: segfault at fffffffffffffff0 rip
> 0000000007d54183 rsp 00007fffda1a3ee0 error 4
> Jul 26 16:28:15 ORA6 kernel: oracle[29322]: segfault at fffffffffffffff0 rip
> 0000000007d54183 rsp 00007fff97087220 error 4
> Jul 26 16:28:19 ORA6 kernel: oracle[29337]: segfault at fffffffffffffff0 rip
> 0000000007d54183 rsp 00007fffb3647280 error 4
>
> I can not find and trace file or core dump file on O.S. and ORACLE
> databases. I also check hardware log and NO memory or disks error.
>
> Any ideal?
>
>
>
>
> _______________________________________________
> CentOS mailing list
> CentOS@centos.org
> http://lists.centos.org/mailman/listinfo/centos
>
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos

mcclnx mcc wrote:
> We have CENTOS 5.5 on DELL server and several ORACLE databases on version
> 10.2.0.4 and 11.1.0.7. Recently I found following messages popup on
> /var/log/messages:
>
>
> Jul 26 16:28:03 ORA6 kernel: oracle[29286]: segfault at fffffffffffffff0
> rip 0000000007d54183 rsp 00007fffff6c3080 error 4
> Jul 26 16:28:07 ORA6 kernel: oracle[29300]: segfault at fffffffffffffff0
> rip 0000000007d54183 rsp 00007fff47838560 error 4
> Jul 26 16:28:11 ORA6 kernel: oracle[29309]: segfault at fffffffffffffff0
> rip 0000000007d54183 rsp 00007fffda1a3ee0 error 4
> Jul 26 16:28:15 ORA6 kernel: oracle[29322]: segfault at fffffffffffffff0
> rip 0000000007d54183 rsp 00007fff97087220 error 4
> Jul 26 16:28:19 ORA6 kernel: oracle[29337]: segfault at fffffffffffffff0
> rip 0000000007d54183 rsp 00007fffb3647280 error 4
>
> I can not find and trace file or core dump file on O.S. and ORACLE
> databases. I also check hardware log and NO memory or disks error.
>
> Any ideal?

Well, Oracle's not ideal <g>, but first question: did you just do an
upgrade to CentOS? If so, what kernel are you running?

You might check with Oracle, and see if it's a know bug.

mark

_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos

On Tuesday 27 July 2010, mcclnx mcc wrote:
> We have CENTOS 5.5 on DELL server and several ORACLE databases on version
> 10.2.0.4 and 11.1.0.7. Recently I found following messages popup on
> /var/log/messages:
>
>
> Jul 26 16:28:03 ORA6 kernel: oracle[29286]: segfault at ...
>
> I can not find and trace file or core dump file on O.S. and ORACLE
> databases. I also check hardware log and NO memory or disks error.
>
> Any ideal?

The OS noted that a process "oracle" with pid 29286 crashed (segmentation
fault). Not much more can be learned from only this. Can be an application
bug or pretty near anything else (segfault is essentially memory corruption,
but most commonly due to code bugs).

Turn to application level logs after ruling out hardware (which you seem to
have done).

/Peter
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos

From: mcclnx mcc <mcclnx@yahoo.com.tw>

> We have CENTOS 5.5 on DELL server and several ORACLE databases on version
>10.2.0.4 and 11.1.0.7. Recently I found following messages popup on
>/var/log/messages:
> Jul 26 16:28:03 ORA6 kernel: oracle[29286]: segfault at fffffffffffffff0 rip
>0000000007d54183 rsp 00007fffff6c3080 error 4
> Jul 26 16:28:07 ORA6 kernel: oracle[29300]: segfault at fffffffffffffff0 rip
>0000000007d54183 rsp 00007fff47838560 error 4
> Jul 26 16:28:11 ORA6 kernel: oracle[29309]: segfault at fffffffffffffff0 rip
>0000000007d54183 rsp 00007fffda1a3ee0 error 4
> Jul 26 16:28:15 ORA6 kernel: oracle[29322]: segfault at fffffffffffffff0 rip
>0000000007d54183 rsp 00007fff97087220 error 4
> Jul 26 16:28:19 ORA6 kernel: oracle[29337]: segfault at fffffffffffffff0 rip
>0000000007d54183 rsp 00007fffb3647280 error 4
> I can not find and trace file or core dump file on O.S. and ORACLE databases.
>I also check hardware log and NO memory or disks error.

Maybe try ulimit as the user to see the max size of core dumps?
ulimit -a
Althought I am not sure it would be a blocking parameter...

JD



_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos

On Jul 27, 2010, at 11:11 AM, mcclnx mcc <mcclnx@yahoo.com.tw> wrote:

> We have CENTOS 5.5 on DELL server and several ORACLE databases on version 10.2.0.4 and 11.1.0.7. Recently I found following messages popup on /var/log/messages:
>
>
> Jul 26 16:28:03 ORA6 kernel: oracle[29286]: segfault at fffffffffffffff0 rip 0000000007d54183 rsp 00007fffff6c3080 error 4
> Jul 26 16:28:07 ORA6 kernel: oracle[29300]: segfault at fffffffffffffff0 rip 0000000007d54183 rsp 00007fff47838560 error 4
> Jul 26 16:28:11 ORA6 kernel: oracle[29309]: segfault at fffffffffffffff0 rip 0000000007d54183 rsp 00007fffda1a3ee0 error 4
> Jul 26 16:28:15 ORA6 kernel: oracle[29322]: segfault at fffffffffffffff0 rip 0000000007d54183 rsp 00007fff97087220 error 4
> Jul 26 16:28:19 ORA6 kernel: oracle[29337]: segfault at fffffffffffffff0 rip 0000000007d54183 rsp 00007fffb3647280 error 4
>
> I can not find and trace file or core dump file on O.S. and ORACLE databases. I also check hardware log and NO memory or disks error.
>
> Any ideal?

Use the Oracle installation guides and check your ulimits and shared memory configuration.

If that doesn't fix it, call Oracle support.

-Ross

_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos