联系:手机/微信(+86 17813235971) QQ(107644445)
标题:8i升级到9i出现ORA-07445[pevm_MOVC_i()+18]
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
一个朋友数据库从8i升级到9i后,出现ORA-07445[pevm_MOVC_i()+18]错误
alert日志ORA-07445[pevm_MOVC_i()+18]
Mon Jul 16 12:21:54 2012 Errors in file /oracle/admin/ora8/udump/ora8_ora_8938.trc: ORA-07445: exception encountered: core dump [pevm_MOVC_i()+18] [SIGSEGV] [Address not mapped to object] [0x7] [] []
trace文件
--版本平台信息 Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production ORACLE_HOME = /oracle/product/9.2.0 System name: Linux Node name: localhost.localdomain Release: 2.6.18-194.el5PAE Version: #1 SMP Tue Mar 16 22:00:21 EDT 2010 Machine: i686 Instance name: ora8 Redo thread mounted by this instance: 1 Oracle process number: 15 Unix process pid: 8938, image: oracle@localhost.localdomain (TNS V1-V3) --trace信息 *** 2012-07-16 12:21:54.399 *** SESSION ID:(12.6) 2012-07-16 12:21:54.399 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x7, PC: [0x9bfac06, pevm_MOVC_i()+18] Registers: %eax: 0x00000000 %ebx: 0x00000025 %ecx: 0x00000000 %edx: 0xbf93bf50 %edi: 0x00000000 %esi: 0x002ff1d8 %esp: 0xbf93bc28 %ebp: 0xbf93bc60 %eip: 0x09bfac06 %efl: 0x00010296 pevm_MOVC_i()+6 (0x9bfabfa) mov %edi,0xffffffcc(%ebp) pevm_MOVC_i()+9 (0x9bfabfd) mov %esi,0xffffffd0(%ebp) pevm_MOVC_i()+12 (0x9bfac00) mov %ebx,0xffffffc8(%ebp) pevm_MOVC_i()+15 (0x9bfac03) mov 0x14(%ebp),%eax > pevm_MOVC_i()+18 (0x9bfac06) movb 0x7(%eax),%dl pevm_MOVC_i()+21 (0x9bfac09) mov $0x0,0xfffffff0(%ebp) pevm_MOVC_i()+28 (0x9bfac10) movb %dl,0xffffffe0(%ebp) pevm_MOVC_i()+31 (0x9bfac13) movb %dl,0xffffffe0(%ebp) pevm_MOVC_i()+34 (0x9bfac16) cmpb $0x1,%dl *** 2012-07-16 12:21:54.407 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [pevm_MOVC_i()+18] [SIGSEGV] [Address not mapped to object] [0x7] [] [] ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedmp()+269 call ksedst()+0 1 ? 0 ? 0 ? 1 ? 64252C31 ? 6666006C ? ssexhd()+1108 call ksedmp()+0 3 ? 0 ? 0 ? 0 ? 0 ? 0 ? pevm_MOVC_i()+18 signal ssexhd()+0 B ? BF93B8BC ? BF93B93C ? pfrrun()+8458 call pevm_MOVC_i()+0 2FF19C ? 16 ? BE14650 ? 0 ? pricar()+1277 call pfrrun()+0 2FF19C ? 1 ? BF93CCFC ? AD638A0 ? 2DFBAC ? 0 ? pricbr()+427 call pricar()+0 BF93DA88 ? BF93D084 ? 9BEAE0C ? 1 ? 0 ? 98C93728 ? prient2()+598 call pricbr()+0 BF93DA88 ? BF93D084 ? 0 ? prient()+1438 call prient2()+0 BF93DA88 ? BF93D084 ? 1 ? BF93E4E0 ? 0 ? kkxrpc()+347 call prient()+0 BF93DA88 ? AD638A0 ? BF93E534 ? 38 ? 1C8C997 ? 0 ? kporpc()+138 call kkxrpc()+0 4C ? F ? BF93E63C ? opiodr()+5238 call kjushutdown()+2671 4C ? F ? BF93E63C ? ttcpip()+2124 call opiodr()+0 4C ? F ? BF93E63C ? 0 ? Cannot find symbol in /lib/libc.so.6. opitsk()+1635 call ttcpip()+0 AD638A0 ? 4C ? BF93E63C ? 0 ? BF93EF14 ? BF93EF10 ? opiino()+602 call opitsk()+0 0 ? 0 ? AD638A0 ? BE01DE0 ? 103 ? 0 ? opiodr()+5238 call kjushutdown()+2671 3C ? 4 ? BF9402E0 ? opidrv()+517 call opiodr()+0 3C ? 4 ? BF9402E0 ? 0 ? sou2o()+25 call opidrv()+0 3C ? 4 ? BF9402E0 ? main()+182 call sou2o()+0 BF9402C4 ? 3C ? 4 ? BF9402E0 ? 0 ? 0 ? 00125E9C call main()+0 2 ? BF940384 ? BF940390 ? 88A810 ? 0 ? 1 ? ---------------------Binary Stack Dump --------------------- --进程信息 Process global information: process: 0x962ba0b8, call: 0x96342cd8, xact: (nil), curses: 0x962e4070, usrses: 0x962e4070 ---------------------------------------- SO: 0x962ba0b8, type: 2, owner: (nil), flag: INIT/-/-/0x00 (process) Oracle pid=15, calls cur/top: 0x96342cd8/0x96342cd8, flag: (0) - int error: 0, call error: 0, sess error: 0, txn error 0 (post info) last post received: 196 0 4 last post received-location: kslpsr last process to post me: 962b7828 1 6 last post sent: 0 0 15 last post sent-location: ksasnd last process posted by me: 962b7828 1 6 (latch info) wait_event=0 bits=0 Process Group: DEFAULT, pseudo proc: 0x962d9444 O/S info: user: oracle, term: UNKNOWN, ospid: 8938 OSD pid info: Unix process pid: 8938, image: oracle@localhost.localdomain (TNS V1-V3) ---------------------------------------- SO: 0x962e4070, type: 4, owner: 0x962ba0b8, flag: INIT/-/-/0x00 (session) trans: (nil), creator: 0x962ba0b8, flag: (8000041) USR/- BSY/-/-/-/-/- DID: 0001-000F-00000004, short-term DID: 0000-0000-00000000 txn branch: (nil) oct: 0, prv: 0, sql: (nil), psql: 0x98c3b858, user: 95/DDDD O/S info: user: mis, term: LANDERSVR3, ospid: 7904:3012, machine: XANDER\LANDERSVR3 program: c:\orant\bin\f50run32.exe c:\forms\bas9010.fmx application name: c:\orant\bin\f50run32.exe c:\forms\bas9010.fmx, hash value=0 last wait for 'db file sequential read' blocking sess=0x0 seq=1277 wait_time=11 file#=1, block#=21b, blocks=1
1.该用户程序是从8i升级到9i之后产生该错误
2.报错的访问程序是FORM 5
解决方案
查询MOS[ID 273411.1]发现是因为FORM 5和9i不兼容导致该错误,ORACLE未给出解决方案,言外之意,如果FORM不能升级,那就只能把ORACLE重新降级到8i.
温馨提示
在做oracle数据库升级前,需要实现进行评估,测试,如果是oracle相关软件和oracle数据库结合紧密,升级前最好需要和ORACLE技术人员确认是否兼容.
Error: ORA-07445 [Pevm_movc_i()+18] while running Forms application [ID 273411.1]