oracle noob wrote:
> 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_at_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
>
See Note 310099.1 in Metalink for tons of information on this error. If
that note does not help, then open a SR with Support as others have
suggested.
HTH,
Brian
--
===================================================================
Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net
Remove the "nospam." from the email address to email me.
"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
Received on Thu Aug 31 2006 - 10:38:34 CDT
