联系：手机/微信(+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技术人员确认是否兼容.