关于ORA-07445问题请教
刚才发错地方了。不好意思！！
Errors in file /
/udump/_ora_20599.trc:
ORA-07445: exception encountered: core dump [FFFFFFFF7DD3C14C] [SIGSEGV] [Address not mapped to object] [0xFFFF

trc文件部分内容
more /udump/_ora_20599.trc
/udump/_ora_20599.trc
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
ORACLE_HOME =
System name: SunOS
Node name:
Release: 5.8
Version: Generic_108528-29
Machine: sun4u
Instance name:
Redo thread mounted by this instance: 1
Oracle process number: 398
Unix process pid: 20599, image: oracle@f4800a-a (TNS V1-V3)

*** 2006-04-20 08:51:25.250
*** SESSION ID179.44633) 2006-04-20 08:51:25.196
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0xffffffff7d080000, PC: [0xffffff
ff7dd3c14c, FFFFFFFF7DD3C14C]
*** 2006-04-20 08:51:25.253
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [FFFFFFFF7DD3C14C] [SIGSEGV] [Address not mapped to object] [0xFFFF
FFFF7D080000] [] []
Current SQL statement for this session:
select
T4.OFFICIALNAME,
T3.EADATE,
t2.certqty,
t1.Certissuedate,
t1.acceptdate,
t2.enddate
from
tb_reg_payerbasicinfo t1 ,
(select regcode,certqty,enddate from tb_reg_payercertinfo where reservelcopyflag =:"SYS_B_0" and
cancelflag <> :"SYS_B_1" ) t2,
(select regcode,EADATE from Tb_Reg_BookInfo where filecode in(:"SYS_B_2",:"SYS_B_3",:"SYS_B_4
",:"SYS_B_5",:"SYS_B_6",:"SYS_B_7",:"SYS_B_8" ) t3,
tc_pub_fficialspec t4
where
t1.regcode=t2.regcode and
t1.regcode=t3.regcode and
t1.insertstaffcode=t4.officialcode AND
t1.taxregcode=:"SYS_B_9"
----- Call Stack Trace -----
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ssd_sparc64_plt_adjust: failed to adjust PLT entry
inst1 [0x01000000] inst2 [0x30ba0ef3] inst3 [0x01000000] inst4 [0x01000000]
inst5 [0x01000000] inst6 [0x01000000] inst7 [0x01000000] inst8 [0x01000000]
ssd_sparc64_plt_adjust: failed to adjust PLT entry
inst1 [0x01000000] inst2 [0x30bb4c90] inst3 [0x01000000] inst4 [0x01000000]
inst5 [0x01000000] inst6 [0x01000000] inst7 [0x01000000] inst8 [0x01000000]
Cannot find symbol in /usr/lib/64/libsocket.so.1.
ksedmp()+376 CALL ksedst()+0 000000000 ? 1032BFC08 ?
1032BFC60 ? 1032BFC50 ?
1032BF000 ? 00000000A ?
ssexhd()+604 CALL ksedmp()+0 0001032BF ? 1032BF000 ?
000103400 ? 0001036E6 ?
1036E6000 ? 1036E6FDC ?
sigacthandler()+44 PTR_CALL 0000000000000000 1036E9000 ?
FFFFFFFF7FFF5380 ?
000000000 ? 000000001 ?
1036E6FE0 ? 00000000B ?
strlen()+124 PTR_CALL 0000000000000000 00000000B ?
FFFFFFFF7FFF5380 ?
FFFFFFFF7FFF50A0 ?
00000000B ? 081010100 ?
081010100 ?
_doprnt()+7300 FRM_LESS _fini()+1116320 000000008 ?
-------

谁知道是什么原因？
sql语句也是非常简单的。一般也就出来一条记录,前台执行速度是非常快！但是在应用程序中老报这个错误！望帮助！

[oracle@svr1 oracle]$ oerr ora 7445
07445, 00000, "exception encountered: core dump [%s] [%s] [%s] [%s] [%s] [%s]"
// *Cause: An OS exception occurred which should result in the creation of a
//         core file.  This is an internal error.
// *Action: Contact your customer support representative.

你是否在dml执行的时候对unique执行过rebuild?

没有做过rebuild。

from metalink :
Truncate the idl_ tables, then run the catalog.sql and catproc.sql scripts to recreate the SYS/SYSTEM objects including STANDARD.  Then rebuild the database:

1. Take a backup of the database
2. Log into sqlplus as SYS and do the following:


SQL> truncate table idl_ub1$;
SQL> truncate table idl_char$;
SQL> truncate table idl_ub2$;
SQL> truncate table idl_sb4$;
SQL> alter system flush shared_pool;
SQL> @?/rdbms/admin/catalog
SQL> @?/rdbms/admin/catproc
SQL> @?/rdbms/admin/utlrp


3. Drop and create the java system followed by reload of user classes
4. Rebuild the database since truncating the idl_.. tables is not supported


the ORA-7445 [hshuid()+512] [SIGSEGV] [Address not mapped to object] [24] [] [] with arguments matches Bug 2602266

晕。是生产机呀。不会这么严重吧！！要运行这个脚本！
而且你查的错误和我的好像还是有区别的：
ORA-07445: exception encountered: core dump [FFFFFFFF7DD3C14C] [SIGSEGV] [Address not mapped to object] [0xFFFF
FFFF7D080000] [] []
还有你刚才查的那个地址能否告诉以下？谢谢！

你的是solaris吧.  9205?

see bug:2624702

cursor_sharing=force?

QUOTE:

---

最初由 zflying2000 发布
晕。是生产机呀。不会这么严重吧！！要运行这个脚本！
而且你查的错误和我的好像还是有区别的：
ORA-07445: exception encountered: core dump [FFFFFFFF7DD3C14C] [SIGSEGV] [Address not mapped to object] [0xFFFF
FFFF7D080000] [] []
还有你刚才查的那个地址能否告诉以下？谢谢！

---

Very sorry, I have forgotten,But you oneself may consult metalink too  !