04.12.06

又碰到ORA-7445 [SIGSEGV] [Address not mapped to object]

Posted in Oracle管理 at 10:13 pm by dosql

郁闷, 又碰到7445. 在Metalink也没找到直接相关的资料. 好在是在开发环境.

居然连”/ as sysdba”也连不进去, 在solaris里kill 掉一些进程才能进去. 由于是开发环境, 就shutdown immediate了. Startup 后发现很多sys的package都变成了invalid status. 用pl/sql developer编译了半个钟头才完.

我想可能是某个开发员把的哪个底层的object改了一下, 导致其他相关的package变成了invalid. 这种事问起来谁也不会说的, 要完全查清楚也不容易.

*** 2006-04-11 11:09:32.974

*** SESSION ID:(24.1073) 2006-04-11 11:09:32.973
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0×10, PC: [0×1022ff8a8, 00000001022FF8A8]

*** 2006-04-11 11:09:32.974
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [00000001022FF8A8] [SIGSEGV] [Address not mapped to object] [0×000000010] [] []
Current SQL statement for this session:
declare p varchar2(32767); begin p := DB_POLICIES_UTL.ACE_LOSS_PREDICATE_NROWS(:sn, :o n); :v1 := substr(p,1,4000); :v2 := substr(p,4001,4000); :v3 := substr(p,8001,4000); :v4 := substr(p,12001,4000); :v5 := substr(p,16001,4000); :v6 := substr(p,20001,4000); :v7 := substr(p,24001,4000); :v8 := substr(p,28001,4000); :v9 := substr(p,32001,767); :v10 := substr(p, 4000, 1); :v11 := substr(p,8000,1); :v12 := substr(p, 12000, 1); :v13 := substr(p,16000,1); :v14 := substr(p, 20000, 1); :v15 := substr(p,24000,1); :v16 := substr(p, 28000, 1); :v17 := substr(p,32000,1); end;——- Call Stack Trace——-
calling call entry argument values in hex
location type point (? means dubious value)——————————————————————————————————————ksedmp()+328 CALL ksedst() 00000000B ? 000000000 ?
000000000 ? 00000004A ?
FFFFFFFF7FFE9728 ?
103313838 ?
ssexhd()+676 CALL ksedmp() 00010373D ? 10373D000 ?
10373DF68 ? 103743000 ?
000102C00 ? 000000000 ?
sigacthandler()+44 PTR_CALL 0000000000000000 000103746 ?
FFFFFFFF7FFF07C0 ?
103746000 ? 103743120 ?
000000000 ? 103746078 ?
ptmak()+424 PTR_CALL 0000000000000000 00000000B ?
FFFFFFFF7FFF07C0 ?
FFFFFFFF7FFF04E0 ?
00000000B ? 000000003 ?
39BA510E0 ?
pdtidc()+4780 CALL ptmak() FFFFFFFF7FFF16C0 ?
000000000 ? 000000004 ?
000000002 ? 102F03A68 ?
000000001 ?
pdlifu()+620 CALL pdtidc() 000000001 ? 0000200B2 ?
FFFFFFFF7FFF0DF8 ?
102F03000 ? 000000000 ?
000102C00 ?
phpcmp()+1016 CALL phpcog() 000000000 ?
FFFFFFFF7CF5F400 ?
00000001D ? 000000011 ?
FFFFFFFF7FFF16C0 ?
39FC85358 ?
pcicog()+184 CALL phpcmp() FFFFFFFF7FFF16C0 ?
39FC85358 ? 000000000 ?
000000000 ? 000000004 ?
000000000 ?
kkxcog()+288 CALL pcicog() FFFFFFFF7FFF16C0 ?
39FC85358 ? 10373DCEC ?
00000A6E0 ? 000000001 ?
000000216 ?
opitca()+4776 CALL kkxcog() 39FC85358 ? 380023850 ?
000380000 ? 000103745 ?
103745000 ? 1037456AC ?
rpiswu2()+384 PTR_CALL 0000000000000000 00000001A ? 10373E1C8 ?
103740000 ?
FFFFFFFF7FFF1C20 ?
000103740 ? 39FC85358 ?
kkssbt()+2188 CALL rpiswu2() 3962D7B48 ? 00010373D ?
10373E190 ? 10373E1C8 ?
000000000 ? 1032D1000 ?
kksfbc()+9744 CALL kkssbt() 000000000 ? 000000000 ?
39BD0B090 ? 103745660 ?
39AF3AA78 ? 103745658 ?
opiexe()+1204 CALL kksfbc() 000000003 ? 000000000 ?
000000000 ? 39A0A9D98 ?
39BA2FDF0 ? 10373E1C8 ?

« Previous entries ·