ORA-07445 in Alert.log



I made an export from Oracle 9i.
I imported the export into a Oracle 10g RC2 (other system).

Now I have following problem:

In a software I use appear an error. In Oracle Alert log are following
entries:

###############################
begin of the part from alert log
###############################

Current log# 3 seq# 1299 mem# 0: /oraflash/KLEI/redo03.log
Thu Aug 31 12:00:19 2006
Thread 1 cannot allocate new log, sequence 1300
Checkpoint not complete
Current log# 3 seq# 1299 mem# 0: /oraflash/KLEI/redo03.log
Thread 1 advanced to log sequence 1300
Current log# 1 seq# 1300 mem# 0: /oraflash/KLEI/redo01.log
Thu Aug 31 13:00:02 2006
Errors in file /pro/app/oracle/admin/KLEI/udump/klei_ora_16711.trc:
ORA-07445: Exception aufgetreten: CORE Dump [evaopn2()+209] [SIGSEGV]
[Address n
ot mapped to object] [0x0] [] []



###############################
end of the part from alert log
###############################

begin of /pro/app/oracle/admin/KLEI/udump/klei_ora_16711.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning and Data Mining options
ORACLE_HOME = /pro/app/oracle/product/10.2.0/db_2
System name: Linux
Node name: kkoradbs01
Release: 2.6.9-22.0.1.ELsmp
Version: #1 SMP Tue Oct 18 18:39:27 EDT 2005
Machine: i686
Instance name: KLEI
Redo thread mounted by this instance: 1
Oracle process number: 17
Unix process pid: 16711, image: oracleKLEI@kkoradbs01

*** 2006-08-31 13:00:02.634
*** ACTION NAME:( ) 2006-08-31 13:00:02.633
*** MODULE NAME:(wfbelpos) 2006-08-31 13:00:02.633
*** SERVICE NAME:(KLEI) 2006-08-31 13:00:02.633
*** SESSION ID:(151.14063) 2006-08-31 13:00:02.633
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object),
addr: 0x0, PC: [0x95171c3, evaopn2()+209]
Registers:
%eax: 0x00000838 %ebx: 0xb70dff20 %ecx: 0xb6ed6b18
%edx: 0x857ffa5c %edi: 0x09517165 %esi: 0x00000000
%esp: 0xbfff9f8c %ebp: 0xbfffa148 %eip: 0x095171c3
%efl: 0x00210246
evaopn2()+198 (0x95171b8) add $8,%esp
evaopn2()+201 (0x95171bb) mov 0xffffffd8(%ebp),%ebx
evaopn2()+204 (0x95171be) jmp 0x9517156
evaopn2()+206 (0x95171c0) mov 0x28(%edx),%esi
evaopn2()+209 (0x95171c3) mov (%esi),%edi
evaopn2()+211 (0x95171c5) movzw 0x4(%esi),%esi
evaopn2()+215 (0x95171c9) mov (%edi,%ecx),%edi
evaopn2()+218 (0x95171cc) mov %esi,0xfffffff0(%ebp)
evaopn2()+221 (0x95171cf) mov %edi,0xfffffff8(%ebp)
*** 2006-08-31 13:00:02.636
ksedmp: internal or fatal error
ORA-07445: Exception aufgetreten: CORE Dump [evaopn2()+209] [SIGSEGV]
[Address not mapped to object] [0x0] [] []
Current SQL statement for this session:
SELECT STPL_MWST , STPL_VNO , STPL_EKVK1 , STPL_PRAB , STPL_SUM ,
STPL_PLMI , STPL_MWS2 , STPL_EKVK2 , STPL_PRAB2 , STPL_SUM2
, STPL_PLMI2 , STPL_EKBAS , STPL_MINMAX , STPL_RUND , STPL_NO ,
STPL_ZEN , STPL_PBKZ , STPL_HERST FROM SPL WHERE STPL_NO =
:1 AND ( :1 IS NULL OR STPL_ZEN = :1 ) AND ( STPL_PBKZ = :1 OR
STPL_PBKZ = 0 ) AND ( STPL_HERST = :1 OR STPL_HERST
= 0 ) ORDER BY STPL_NO , STPL_ZEN , STPL_PBKZ DESC , STPL_HERST DESC
----- PL/SQL Call Stack -----
object line object
handle number name
0x946d477c 1763 package body UNITRADE.VK_PREIS
0x946d477c 2619 package body UNITRADE.VK_PREIS
0x945dba98 1 anonymous block
----- Call Stack Trace -----
calling call entry argument values in
hex
location type point (? means dubious
value)
-------------------- -------- --------------------
----------------------------
ksedst()+27 call ksedst1() 1 ? 1 ?
ksedmp()+557 call ksedst() 1 ? 8152A10 ?
B72FFEF0 ?
51D650 ? 10 ?
B74A2D38 ?
ssexhd()+863 call ksedmp() 3 ? 95171C3 ?
6F617665 ?
28326E70 ? 30322B29
? 39 ?
__pthread_sighandle call 00000000 B ? B7301C90 ?
B7301D10 ? 0 ?
r_rt()+92 0 ? 0 ?
evaopn2()+209 signal 00000000 B ? B7301C90 ?
B7301D10 ?
expepr()+146 call evaopn2() 857FFA5C ? 5 ?
857FFAF8 ? 0 ?
E2A ? 0 ?
evaiand()+38 call expepr() 857FFAA4 ? 85800320
? 0 ?
BFFFA188 ? 97FA31A ?
857FFAF8 ?
expeal()+22 call evaiand() 857FFAF8 ? BFFFA4D8
?
9EB75A2 ? 857FFAF8 ?
0 ? 0 ?
qertbFetchByRowID() call expeal() 857FFAF8 ? 0 ? 0 ? 1
?
+5710 9F39AEE8 ? 0 ?
opifch2()+5157 call 00000000 858002D8 ? A0DF740 ?
BFFFA730 ? 1 ?
opifch()+56 call opifch2() 89 ? 5 ? BFFFA9A0 ?
opipls()+7449 call opifch() 5 ? 2 ? BFFFABD8 ?
opiodr()+2347 call 00000000 66 ? 6 ? BFFFBD00 ?
rpidrus()+434 call opiodr() 66 ? 6 ? BFFFBD00 ?
8B ?
skgmstack()+210 call 00000000 BFFFB604 ? C6A667C ?
C6A667C ? BFFFB5E8 ?
BFFFBAEC ? BFFFB604
?
rpidru()+98 call skgmstack() BFFFB5E8 ? C6A6340 ?
F618 ?
970BE82 ? BFFFB604 ?
rpiswu2()+1061 call 00000000 BFFFBAEC ? BFFFBBA8
? 4 ? 4 ?
B713C64C ? B7130DD4
?
rpidrv()+1915 call rpiswu2() 9F39AEE8 ? 38 ?
BFFFBAB0 ?
2 ? BFFFBB28 ? 38 ?
BFFFBAB0 ? 0 ?
970C13C ?
970C218 ? BFFFBAEC ?
38 ?
psddr0()+456 call rpidrv() 8B ? 66 ? BFFFBD00 ?
38 ?
psdnal()+310 call psddr0() 8B ? 66 ? BFFFBD00 ?
30 ?
B7040B98 ? 946D477C
?
pevm_BFTCHC()+678 call 00000000 BFFFC3F0 ? BFFFC4EC
?
C6ADD80 ? B7040B98 ?
946D477C ? 4 ?
pfrinstr_FTCHC()+14 call pevm_BFTCHC() B7163C74 ? B6F9F6AC
? 0 ?
1
pfrrun_no_tool()+45 call 00000000 B7163C74 ? 8555C238
?
B7163CB0 ?
pfrrun()+1381 call pfrrun_no_tool() B7163C74 ? 859CCB1C
?
B7163CB0 ?
plsql_run()+1416 call pfrrun() B7163C74 ? C6ADD80 ?
BFFFC3F0 ? 0 ? 0 ?
B714EB08 ?
peicnt()+525 call plsql_run() B7163C74 ? 1 ? 0 ?
kkxexe()+481 call peicnt() BFFFC3F0 ? B7163C74
?
C6A6580 ? 0 ?
BFFFC4EC ? 0 ?
opiexe()+9215 call kkxexe() B70BA030 ? 10A12A ?
0 ?
58647DC0 ? 403A4 ? 0
?
opiodr()+2347 call 00000000 4 ? 4 ? BFFFECD4 ?
ttcpip()+4227 call 00000000 4 ? 4 ? BFFFECD4 ?
12B ?
C70D6E6 ? 11 ?
opitsk()+1991 call ttcpip() C6ADD80 ? 4 ?
BFFFECD4 ? 0 ?
BFFFE1B4 ? BFFFEDF8
?
opiino()+1387 call opitsk() 0 ? 0 ?
opiodr()+2347 call 00000000 3C ? 4 ? BFFFF8C0 ?
opidrv()+915 call opiodr() 3C ? 4 ? BFFFF8C0 ?
0 ?
sou2o()+113 call opidrv() 3C ? 4 ? BFFFF8C0 ?
opimai_real()+212 call sou2o() BFFFF8A4 ? 3C ? 4 ?
BFFFF8C0 ?
main()+111 call opimai_real() 2 ? BFFFF8F0 ?
__libc_start_main() call 00000000 2 ? BFFFF974 ?
BFFFF980 ?
+161 51CFD4 ? 2 ? 8286EF8
?

--------------------- Binary Stack Dump ---------------------

========== FRAME [1] (ksedst()+27 -> ksedst1()) ==========
Dump of memory from 0xB72FFE4C to 0xB72FFE5C
B72FFE40 B72FFE5C [\./.]
B72FFE50 082B5AFD 00000001 00000001 [.Z+.........]
========== FRAME [2] (ksedmp()+557 -> ksedst()) ==========
Dump of memory from 0xB72FFE5C to 0xB72FFFB4
B72FFE50 B72FFFB4 [../.]
B72FFE60 082B46CB 00000001 08152A10 B72FFEF0 [.F+......*..../.]
B72FFE70 0051D650 00000010 B74A2D38 00000001 [P.Q.....8-J.....]
B72FFE80 00000000 00000001 00000000 00000000 [................]
B72FFE90 00000003 0051D650 0C6A667C 00000004 [....P.Q.|fj.....]
B72FFEA0 B72FFEF0 00000000 00000000 B72FFEC4 [../.........../.]
B72FFEB0 B72FFF30 B73BBCD6 00000003 B72FFEC4 [0./...;......./.]
B72FFEC0 B72FFF44 00000815 00000000 00000000 [D./.............]
B72FFED0 00133DE3 000081A0 00000001 000001F4 [.=..............]
B72FFEE0 000001F6 00000000 00000000 00000000 [................]
B72FFEF0 0002307D 00000000 00001000 00000128 [}0..........(...]
B72FFF00 00000000 44F6C116 00000000 44731BC6 [.......D......sD]
B72FFF10 00000000 4486EDC5 00000000 00133DE3 [.......D.....=..]
B72FFF20 00000000 0C669358 B7301C90 9F2E4630 [....X.f...0.0F..]
B72FFF30 B72FFFB0 0AC3B915 00000003 9F2E4648 [../.........HF..]
B72FFF40 B72FFF44 00000815 00000000 00000000 [D./.............]
B72FFF50 00000000 00000000 00000000 00000000 [................]
B72FFF60 000001F6 00000000 00000000 B7300000 [..............0.]
B72FFF70 0002307D 00001000 00000128 44F6C116 [}0......(......D]
B72FFF80 00000000 44731BC6 00000001 00000001 [......sD........]
B72FFF90 00000001 00000000 00000000 00000001 [................]
B72FFFA0 00000000 0BE0A1CC B7301C90 B7301D24 [..........0.$.0.]
B72FFFB0 B7301C2C [,.0.]
========== FRAME [3] (ssexhd()+863 -> ksedmp()) ==========
Dump of memory from 0xB72FFFB4 to 0xB73003B4
B72FFFB0 B7301C2C 094933D7 00000003 [,.0..3I.....]
B72FFFC0 095171C3 6F617665 28326E70 30322B29 [.qQ.evaopn2()+20]
B72FFFD0 00000039 00000000 00000000 00000000 [9...............]
B72FFFE0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
B7300010 00000000 00000001 00000000 00000000 [................]
B7300020 00000000 00001000 00000000 00000000 [................]
B7300030 00000000 00000000 00000000 00000000 [................]
Repeat 55 times
B73003B0 00000000 [....]
========== FRAME [4] (__pthread_sighandler_rt()+92 -> 00000000)
==========
Dump of memory from 0xB7301C2C to 0xB7301C7C
B7301C20 B7301C7C [|.0.]
B7301C30 B743923C 0000000B B7301C90 B7301D10 [<.C.......0...0.]
B7301C40 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
B7301C70 B70DFF20 00000000 09517165 [ .......eqQ.]
========== FRAME [5] (evaopn2()+209 -> 00000000) ==========
%eax 00000838 %ebx B70DFF20 %ecx B6ED6B18 %edx 857FFA5C
%edi 09517165 %esi 00000000 %esp BFFF9F8C %ebp BFFFA148
%eip 095171C3
Dump of memory from 0xB7301C7C to 0xB730207C
B7301C70 BFFFA148 [H...]
B7301C80 B732C890 0000000B B7301C90 B7301D10 [..2.......0...0.]
B7301C90 0000000B 00000000 00000001 00000000 [................]
B7301CA0 00000000 00000000 00000000 00000000 [................]
Repeat 6 times
B7301D10 00000000 00000000 B7202000 00000000 [......... .....]
B7301D20 00100000 00000033 00000000 0000007B [....3.......{...]
B7301D30 C02D007B 09517165 00000000 BFFFA148 [{.-.eqQ.....H...]
B7301D40 BFFF9F8C B70DFF20 857FFA5C B6ED6B18 [.... ...\....k..]
B7301D50 00000838 0000000E 00000004 095171C3 [8............qQ.]
B7301D60 00000073 00210246 BFFF9F8C 0000007B [s...F.!.....{...]
B7301D70 B7301D84 80000000 00000000 80000000 [..0.............]
B7301D80 00000000 FFFF027F FFFF0030 FFFFFFFF [........0.......]
B7301D90 09EB5FD8 01C90073 BFFFA39C 0000007B [._..s.......{...]
B7301DA0 00000000 00000000 00000000 00000000 [................]
B7301DB0 00000000 00000000 00000000 70000000 [...............p]
B7301DC0 5AE3788D 40008015 00000000 80000000 [.x.Z...@........]
B7301DD0 00004000 00000000 00000000 00000000 [.@..............]
B7301DE0 80000000 88004005 AD688DC7 3FF7ADA9 [.....@....h....?]
B7301DF0 00000030 0030027F 01C90000 09EB5FD8 [0.....0......_..]
B7301E00 00000073 BFFFA39C 0000007B 00009FC0 [s.......{.......]
B7301E10 0000FFFF 00000000 00000000 00000000 [................]
B7301E20 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
B7301E40 00000000 788D7000 80155AE3 00004000 [.....p.x.Z...@..]
B7301E50 00000000 00000000 80000000 00004000 [.............@..]
B7301E60 00000000 00000000 00000000 00000000 [................]
B7301E70 00000000 00000000 80000000 00004005 [.............@..]
B7301E80 00000000 8DC78800 ADA9AD68 00003FF7 [........h....?..]
B7301E90 00000000 00000000 00000000 00000000 [................]
Repeat 21 times
B7301FF0 00000000 0000ADB8 0080CD00 00000000 [................]
B7302000 00000000 00000000 00000000 00000000 [................]
Repeat 6 times
B7302070 00000000 00000000 00000000 [............]
========== FRAME [6] (expepr()+146 -> evaopn2()) ==========
Dump of memory from 0xBFFFA148 to 0xBFFFA168



the complete file is 3 MByte


thx for help

.



Relevant Pages

  • Re: ORA-07445 in Alert.log
    ... I imported the export into a Oracle 10g RC2. ... Dump of memory from 0xB72FFE4C to 0xB72FFE5C ... Repeat 55 times ...
    (comp.databases.oracle.server)
  • [Full-disclosure] Oracle TNS Listener DoS and/or remote memory inspection
    ... Oracle TNS Listener DoS and/or remote memory inspection ... The TNS Listener can be crashed by an attacker causing a Denial of Service; ... Oracle was alerted to this flaw on the 22nd of June 2006. ... The views expressed in this email do not necessarily reflect NGS policy. ...
    (Full-Disclosure)
  • Oracle TNS Listener DoS and/or remote memory inspection
    ... Oracle TNS Listener DoS and/or remote memory inspection ... The TNS Listener can be crashed by an attacker causing a Denial of Service; ... Oracle was alerted to this flaw on the 22nd of June 2006. ... The views expressed in this email do not necessarily reflect NGS policy. ...
    (Bugtraq)
  • Re: Oracle 9.2.0.6 Memory leak
    ... Client applications received some ORA-4030 errors. ... Most of the memory was consumed by Oracle client and background ... this bug. ...
    (comp.databases.oracle.server)
  • Re: strange memory leak
    ... server that is going to host a new JDE EnterpriseOne implementation. ... So far, oracle & JDE are installed, and users are able to log in, ... the machine shipped with 8GB memory, ... When paging space fills up, it means that the system sends out ...
    (comp.unix.aix)