Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle 9i on Red Hat 9 crash with SIGSEGV periodicaly.

Oracle 9i on Red Hat 9 crash with SIGSEGV periodicaly.

From: Pavel Lokhmakov <pavel_at_krasinfo.ru>
Date: 11 Apr 2004 21:25:12 -0700
Message-ID: <263e0b56.0404112025.77a942e1@posting.google.com>


Hi.

Every half hour in database INSERT one record as:

INSERT INTO askue.telemetry_counters (tc_time, tc_ti, tc_p, tc_tele) VALUES (TO_DATE('2004-04-12, 02:30:00 AM','RRRR-MM-DD, HH:MI:SS AM'), 1, 0, 73)

And one time in month Oracle crash with SIGSEGV.

First incident.

Fri Mar 19 07:40:49 2004
Errors in file /opt/oracle/admin/askue/udump/askue_ora_13032.trc: ORA-07445: exception encountered: core dump [kgldafr()+33] [SIGSEGV] [Address not mapped to object] [0x8000008] [] [] Fri Mar 19 07:40:53 2004
Errors in file /opt/oracle/admin/askue/bdump/askue_pmon_3514.trc: ORA-07445: exception encountered: core dump [kgldafr()+33] [SIGSEGV] [Address not mapped to object] [0x8000008] [] [] Fri Mar 19 07:41:20 2004
LGWR: terminating instance due to error 472 Instance terminated by LGWR, pid = 3518

/opt/oracle/admin/askue/udump/askue_ora_13032.trc Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /opt/oracle/product/9.2.0

System name:	Linux
Node name:	askue
Release:	2.4.20-8
Version:	#1 Thu Mar 13 17:54:28 EST 2003
Machine:	i686

Instance name: ASKUE
Redo thread mounted by this instance: 1
Oracle process number: 17
Unix process pid: 13032, image: oracle_at_askue (TNS V1-V3)

/opt/oracle/admin/askue/bdump/askue_pmon_3514.trc Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /opt/oracle/product/9.2.0

System name:	Linux
Node name:	askue
Release:	2.4.20-8
Version:	#1 Thu Mar 13 17:54:28 EST 2003
Machine:	i686

Instance name: ASKUE
Redo thread mounted by this instance: 1
Oracle process number: 2
Unix process pid: 3514, image: oracle_at_askue (PMON)
--

Second incident.

-- Part of alert_ASKUE.log

Mon Apr 12 02:40:03 2004
Errors in file /opt/oracle/admin/askue/udump/askue_ora_20128.trc:
ORA-07445: exception encountered: core dump [kglhdde()+144] [SIGSEGV]
[Address not mapped to object] [0x8000008] [] []
Mon Apr 12 02:40:07 2004
Errors in file /opt/oracle/admin/askue/bdump/askue_pmon_5771.trc:
ORA-07445: exception encountered: core dump [kglhdde()+144] [SIGSEGV]
[Address not mapped to object] [0x8000008] [] []
Mon Apr 12 02:40:56 2004
CKPT: terminating instance due to error 472
Instance terminated by CKPT, pid = 5777

-- Part of askue_ora_20128.trc (1 273 243 bytes)

/opt/oracle/admin/askue/udump/askue_ora_20128.trc
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /opt/oracle/product/9.2.0
System name:	Linux
Node name:	askue
Release:	2.4.20-8
Version:	#1 Thu Mar 13 17:54:28 EST 2003
Machine:	i686
Instance name: ASKUE
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 20128, image: oracle_at_askue (TNS V1-V3)

*** SESSION ID:(9.29464) 2004-04-12 02:40:02.769
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to
object), addr: 0x8000008, PC: [0x9609de0, kglhdde()+144]
Registers:

%eax: 0x08000000 %ebx: 0x0ab941ac %ecx: 0x00000000
%edx: 0x0ab111a0 %edi: 0x53f66bec %esi: 0x00000001
%esp: 0xbfff8d70 %ebp: 0xbfff8d88 %eip: 0x09609de0
%efl: 0x00010202
kglhdde()+131 (0x9609dd3) jmp 0x9609dfc kglhdde()+133 (0x9609dd5) test %esi,%esi kglhdde()+135 (0x9609dd7) je 0x9609df0 kglhdde()+137 (0x9609dd9) lea 0x0(%esi),%esi > kglhdde()+144 (0x9609de0) movb 0x8(%eax),%dl kglhdde()+147 (0x9609de3) orb %dl,0xffffffff(%ebp) kglhdde()+150 (0x9609de6) add $12,%eax kglhdde()+153 (0x9609de9) dec %esi kglhdde()+154 (0x9609dea) jnz 0x9609de0 *** 2004-04-12 02:40:02.999 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [kglhdde()+144] [SIGSEGV] [Address not mapped to object] [0x8000008] [] [] No current SQL statement being executed. -- Part of askue_ora_pmon_5771.trc (816 284 bytes) /opt/oracle/admin/askue/bdump/askue_pmon_5771.trc Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production ORACLE_HOME = /opt/oracle/product/9.2.0 System name: Linux Node name: askue Release: 2.4.20-8 Version: #1 Thu Mar 13 17:54:28 EST 2003 Machine: i686 Instance name: ASKUE Redo thread mounted by this instance: 1 Oracle process number: 2 Unix process pid: 5771, image: oracle_at_askue (PMON) *** 2004-04-12 02:40:07.007 *** SESSION ID:(1.1) 2004-04-12 02:40:06.865 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x8000008, PC: [0x9609de0, kglhdde()+144] Registers:
%eax: 0x08000000 %ebx: 0x0ab941ac %ecx: 0x00000000
%edx: 0x0ab111a0 %edi: 0x53f66bec %esi: 0x00000001
%esp: 0xbfffcfc0 %ebp: 0xbfffcfd8 %eip: 0x09609de0
%efl: 0x00010202
kglhdde()+131 (0x9609dd3) jmp 0x9609dfc kglhdde()+133 (0x9609dd5) test %esi,%esi kglhdde()+135 (0x9609dd7) je 0x9609df0 kglhdde()+137 (0x9609dd9) lea 0x0(%esi),%esi > kglhdde()+144 (0x9609de0) movb 0x8(%eax),%dl kglhdde()+147 (0x9609de3) orb %dl,0xffffffff(%ebp) kglhdde()+150 (0x9609de6) add $12,%eax kglhdde()+153 (0x9609de9) dec %esi kglhdde()+154 (0x9609dea) jnz 0x9609de0 *** 2004-04-12 02:40:07.038 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [kglhdde()+144] [SIGSEGV] [Address not mapped to object] [0x8000008] [] []
Received on Sun Apr 11 2004 - 23:25:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US