ITPub博客

首页 > 数据库 > Oracle > ORA-7445(ptmax)错误

ORA-7445(ptmax)错误

原创 Oracle 作者:yangtingkun 时间:2013-07-02 23:49:37 0 删除 编辑

一个9.2.0.8上的bug

[@more@]

虽然12c已经发布,但是仍然有部分客户的核心数据库还跑在9i环境上,有碰到了一个9208上的bug

Thu May 16 14:18:48 2013
Errors in file /oracle/oracle/admin/orcl/udump/orcl_ora_11922.trc:
ORA-07445:
出现异常: 核心转储 [00000001023A0F08] [SIGSEGV] [Address not mapped to object] [0x000000010] [] []
Thu May 16 14:19:49 2013
Errors in file /oracle/oracle/admin/orcl/udump/orcl_ora_12389.trc:
ORA-07445:
出现异常: 核心转储 [00000001023A0F08] [SIGSEGV] [Address not mapped to object] [0x000000010] [] []

详细TRACE信息:

*** SESSION ID:(1298.47235) 2013-05-16 14:18:48.666
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x10, PC: [0x1023a0f08, 00000001023A0F08]
*** 2013-05-16 14:18:48.669
ksedmp: internal or fatal error
ORA-07445:
出现异常: 核心转储 [00000001023A0F08] [SIGSEGV] [Address not mapped to object] [0x000000010] [] []
Current SQL statement for this session:
begin
-- Call the procedure
z_r_res_pk.g_num;
end;
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+328 CALL ksedst() 00000000B ? 000000000 ?
000000000 ? 1033CF6C8 ?
00000003E ?
FFFFFFFF7FFF1188 ?
ssexhd()+676 CALL ksedmp() 00010380C ? 10380C000 ?
10380C718 ? 103811000 ?
000102C00 ? 000000000 ?
__sighndlr()+12 PTR_CALL 0000000000000000 000103814 ?
FFFFFFFF7FFF8400 ?
103814000 ? 1038118E8 ?
000000000 ? 103814908 ?
call_user_handler() CALL __sighndlr() 00000000B ?
+992 FFFFFFFF7FFF8400 ?
FFFFFFFF7FFF8120 ?
10023F860 ? 000000000 ?
00000000A ?
sigacthandler()+104 CALL call_user_handler() FFFFFFFF7DB00200 ?
FFFFFFFF7DB00200 ?
FFFFFFFF7FFF8120 ?
00000000C ? 000000000 ?
000000000 ?
ptmak()+424 PTR_CALL 0000000000000000 000000000 ?
FFFFFFFF7FFF8400 ?
FFFFFFFF7FFF8120 ?
FFFFFFFF7DB00200 ?
000000000 ?
FFFFFFFF7DB3E000 ?
pdtidc()+4716 CALL ptmak() FFFFFFFF7FFF9300 ?
000000000 ? 000000004 ?
000000002 ? 000000000 ?
FFFFFFFF7CE61800 ?
pdlifu()+620 CALL pdtidc() 000000000 ? 00002000C ?
000000001 ? 000000001 ?
102FBB000 ? 000102C00 ?
phpcmp()+1016 CALL phpcog() 000000000 ?
FFFFFFFF7CE5C150 ?
00000000C ? 000000011 ?
FFFFFFFF7FFF9300 ?
F988B6748 ?
pcicog()+184 CALL phpcmp() FFFFFFFF7FFF9300 ?
F988B6748 ? 000000000 ?
000000004 ? 000000004 ?
000000000 ?
kkxcog()+288 CALL pcicog() FFFFFFFF7FFF9300 ?
F988B6748 ? 10380C49C ?
00000AB90 ? 000000001 ?
000000225 ?
opitca()+4796 CALL kkxcog() F988B6748 ? 3800231C0 ?
000380000 ? 000103813 ?
103813000 ? 103813F34 ?
rpiswu2()+384 PTR_CALL 0000000000000000 FFFFFFFF7FFF9A60 ?
000000001 ? 00000000A ?
000000001 ? 00000001A ?
F988B6748 ?
kkslod()+5196 CALL rpiswu2() F46434118 ? 00010380C ?
10380C940 ? 10380C978 ?
000000000 ? 10338B000 ?
kglobld()+696 PTR_CALL 0000000000000000 000000000 ?
FFFFFFFF7CE64658 ?
000000000 ? 10380C978 ?
F98D09B58 ? FD7970EF0 ?
kglobpn()+1284 CALL kglobld() 000000001 ? 000000000 ?
F98ECBA88 ? 10380CAB8 ?
000000001 ? F988B6748 ?
kglpim()+236 CALL kglobpn() 000000001 ? F922092E8 ?
000000001 ? 10390E848 ?
10390EA08 ? 10380DA10 ?
kglpin()+764 CALL kglpim() 0000000FF ? 10380CAB8 ?
102DC74E8 ? 010010000 ?
F988B6748 ? F922092E8 ?
kksfbc()+6956 CALL kglpin() 000010000 ?
FFFFFFFF7FFFB278 ?
F9100F9C8 ? 000000000 ?
FFFFFFFF7FFFAE28 ?
FFFFFFFF7FFFA950 ?
kkspsc0()+988 CALL kksfbc() 000004000 ? 000004000 ?
000103800 ? 000000000 ?
000004000 ? 000000000 ?
opiosq0()+936 CALL kkspsc0() FFFFFFFF7CE60400 ?
000000024 ? 102FA3B10 ?
000000003 ? 000000004 ?
FFFFFFFF7FFFC5D0 ?
kpooprx()+204 CALL opiosq0() 10104C000 ? 10380EC78 ?
000000042 ?
FFFFFFFF7FFFCC90 ?
10380EA84 ? 000000016 ?
kpoal8()+528 CALL kpooprx() FFFFFFFF7FFFEC2C ?
FFFFFFFF7FFFCC90 ?
000000042 ? 103814B90 ?
000000000 ? 000000024 ?
opiodr()+1720 PTR_CALL 0000000000000000 10380E000 ? 000000000 ?
FFFFFFFF7FFFEC28 ?
000000024 ? 000000000 ?
000000000 ?
ttcpip()+1564 PTR_CALL 0000000000000000 000102DD9 ? 00010380C ?
103814B98 ? 10380CAB8 ?
10380EFF8 ?
FFFFFFFF7FFFC5D0 ?
opitsk()+1156 CALL ttcpip() 103814B90 ? 000000001 ?
FFFFFFFF7FFFEC28 ?
000000014 ?
FFFFFFFF7FFFD718 ?
FFFFFFFF7FFFD714 ?
opiino()+1504 CALL opitsk() 000000000 ? 103814B20 ?
000000000 ? 000000000 ?
102E484C8 ? 10380EFE0 ?
opiodr()+1720 PTR_CALL 0000000000000000 000000000 ? 000000000 ?
000000000 ?
FFFFFFFF7FFFFAA0 ?
000000001 ? 000000001 ?
opidrv()+764 CALL opiodr() 000102DD9 ? 00010380C ?
103814B98 ? 10380CAB8 ?
10380EFF8 ?
FFFFFFFF7FFFF5C0 ?
sou2o()+16 CALL opidrv() 00010380C ? 000000004 ?
10380CAB8 ? 00000003C ?
10380CAB8 ? 10380C718 ?
main()+184 CALL sou2o() FFFFFFFF7FFFFAC0 ?
00000003C ? 000000004 ?
FFFFFFFF7FFFFAA0 ?
00003B000 ? 00003B030 ?
_start()+380 CALL main() 000000002 ?
FFFFFFFF7FFFFC08 ?
FFFFFFFF7FFFFC20 ?
000000000 ?
FFFFFFFF7E100100 ?
FFFFFFFF7DB00200 ?

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

进一步检查TRACE,发现当前程序为DEVELOPER在进行DEBUG操作:

PROCESS STATE
-------------
Process global information:
process: f474d5360, call: f95814378, xact: 0, curses: f46434118, usrses: f46434118
----------------------------------------
SO: f474d5360, type: 2, owner: 0, flag: INIT/-/-/0x00
(process) Oracle pid=848, calls cur/top: f95814378/f95814378, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 0
last post received-location: No post
last process to post me: none
last post sent: 0 0 0
last post sent-location: No post
last process posted by me: none
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: f443c8d50
O/S info: user: oracle, term: UNKNOWN, ospid: 11922
OSD pid info: Unix process pid: 11922, image: oracle@ysun7 (TNS V1-V3)
----------------------------------------
SO: f46434118, type: 4, owner: f474d5360, flag: INIT/-/-/0x00
(session) trans: 0, creator: f474d5360, flag: (41) USR/- BSY/-/-/-/-/-
DID: 0001-0350-00106A26, short-term DID: 0000-0000-00000000
txn branch: 0
oct: 47, prv: 0, sql: f98ecb960, psql: fdcc324f8, user: 65/GZMPCMIS
O/S info: user: Administrator, term: S-E-SERVE, ospid: 5944:4000, machine: WORKGROUPS-E-SERVE
program: plsqldev.exe
application name: PL/SQL Developer, hash value=1190136663
action name: Test Window - Script for procedu, hash value=3367543201
last wait for 'SQL*Net message from client' blocking sess=0x0 seq=34 wait_time=8952
driver id=54435000, #bytes=1, =0
temporary object counter: 0
----------------------------------------
SO: f922092e8, type: 52, owner: f46434118, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=f922092e8 handle=f988b6748 mode=X lock=f9100f9c8
user=f46434118 session=f46434118 count=0 mask=00ff savepoint=195 flags=[00]
----------------------------------------
.
.
.
SO: f6a2eaba8, type: 51, owner: f46434118, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=f6a2eaba8 handle=f8dbc9320 mode=N
call pin=faf005300 session pin=0
htl=f6a2eac18[fa6f5b618,fa6f5b618] htb=fa6f5b618
user=f46434118 session=f46434118 count=1 flags=[00] savepoint=186
LIBRARY OBJECT HANDLE: handle=f8dbc9320
name=SYS.DBMS_DEBUG
hash=2c51e752 timestamp=10-04-2010 00:55:36
namespace=BODY/TYBD flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0011-0011 lock=N pin=S latch#=21
lwt=f8dbc9350[f8dbc9350,f8dbc9350] ltm=f8dbc9360[f8dbc9360,f8dbc9360]
pwt=f8dbc9380[f8dbc9380,f8dbc9380] ptm=f8dbc9410[f8dbc9410,f8dbc9410]
ref=f8dbc9330[f8dbc9330, f8dbc9330] lnd=f8dbc9428[f8dbc9428,f8dbc9428]
LIBRARY OBJECT: object=fb741e720
type=PKBD flags=EXS/LOC[0005] pflags=/SWR [08] status=VALD load=0
DEPENDENCIES: count=10 size=16
ACCESSES: count=9 size=16
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 f94627a40 fb741e8c8 I/P/A 0 NONE
4 fb741e840 fb0c81e68 I/P/A 1 NONE
----------------------------------------
SO: f85863c38, type: 51, owner: f46434118, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=f85863c38 handle=fcbfb58d0 mode=N
call pin=f83bafa18 session pin=0
htl=f85863ca8[fa6f5b608,fa6f5b608] htb=fa6f5b608
user=f46434118 session=f46434118 count=1 flags=[00] savepoint=186
LIBRARY OBJECT HANDLE: handle=fcbfb58d0
name=SYS.DBMS_DEBUG
hash=2c51e751 timestamp=10-04-2010 00:55:32
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0215-0215 lock=N pin=S latch#=22
lwt=fcbfb5900[fcbfb5900,fcbfb5900] ltm=fcbfb5910[fcbfb5910,fcbfb5910]
pwt=fcbfb5930[fcbfb5930,fcbfb5930] ptm=fcbfb59c0[fcbfb59c0,fcbfb59c0]
ref=fcbfb58e0[fcbfb58e0, fcbfb58e0] lnd=fcbfb59d8[fa81f4ca0,f9a3a9ef0]
LIBRARY OBJECT: object=fb62f8710
type=PCKG flags=EXS/LOC[0005] pflags= [00] status=VALD load=0
DEPENDENCIES: count=2 size=16
ACCESSES: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 fafa8d3f8 fb62f88b8 I/P/A 0 NONE
2 fb62f8830 fb68a95f8 I/-/A 0 NONE
4 fb6f38c50 fd2b7d280 I/P/A 1 NONE
9 fb6f38ba0 fb6a0f450 I/-/A 0 NONE
----------------------------------------

根据MOS文档ORA-07445 [ptmak()+107] During PL/SQL Debug [ID 726611.1],这个问题应该是DEBUG模式下编译对象导致的。

虽然BUG的信息是10.2上的,但是不排除9.2.0.8上存在相同的问题,不要使用PL/SQLDEBUG功能,或者禁止过程的DEBUG选项,可以避免这个错误的产生。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/4227/viewspace-1060657/,如需转载,请注明出处,否则将追究法律责任。

上一篇: OLAP用户手册
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10437381