oracle报ora-07445

cisco3640

请问是什么原因？如何解决？
alert.log的内容如下：
Mon Oct 11 15:15:38 2010
Thread 1 advanced to log sequence 71654
  Current log# 3 seq# 71654 mem# 0: /oradata/boss/log3.ora
Mon Oct 11 15:32:50 2010
Thread 1 advanced to log sequence 71655
  Current log# 1 seq# 71655 mem# 0: /oradata/boss/log1.ora
Mon Oct 11 15:51:19 2010
Thread 1 advanced to log sequence 71656
  Current log# 2 seq# 71656 mem# 0: /oradata/boss/log2.ora
Mon Oct 11 16:01:39 2010
Errors in file /oracle/admin/boss/udump/boss_ora_302.trc:
ORA-07445: exception encountered: core dump [kgiopn()+172] [SIGSEGV] [Address not mapped to object] [0x4000800000010] [] []
Mon Oct 11 16:01:39 2010
Errors in file /oracle/admin/boss/udump/boss_ora_304.trc:
ORA-07445: exception encountered: core dump [kgiopn()+172] [SIGSEGV] [Address not mapped to object] [0x4000800000010] [] []


查看第一个trc文件，内容如下：
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/oracle10g/10gdb
System name:    SunOS
Node name:      db1
Release:        5.10
Version:        Generic_118833-36
Machine:        sun4u
Instance name: boss
Redo thread mounted by this instance: 1
Oracle process number: 32
Unix process pid: 302, image: oracleboss@db1

*** 2010-10-11 16:01:39.975
*** SERVICE NAMEboss) 2010-10-11 16:01:39.971
*** SESSION ID82.3743 2010-10-11 16:01:39.971
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x4000800000010, PC: [0x103c8e84c, kgiopn()+172]
*** 2010-10-11 16:01:39.980
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kgiopn()+172] [SIGSEGV] [Address not mapped to object] [0x4000800000010] [] []
Current SQL statement for this session:
begin       :ret :=bill_003.accountbas(:packettime,:acctsessionid, :nasipaddr,:nasporttype, :acctstatustype,            :username,:callingid,
:calledid,:framedipaddr,:inputoctets,           utputoctets,:inputgigawords,utputgigawords,:acctsessiontime,:acctdelaytime,         :acct
terminatecause,:mdsip,:nasidentifier,:nasport,:nasportid,:class);end;
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x4000800000030, PC: [0x104820478, pfrtra()+88]
*** 2010-10-11 16:01:40.129
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [pfrtra()+88] [SIGSEGV] [Address not mapped to object] [0x4000800000030] [] []
ORA-07445: exception encountered: core dump [kgiopn()+172] [SIGSEGV] [Address not mapped to object] [0x4000800000010] [] []
ksedmp: obtaining current SQL failed earlier. not retrying
----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------


……由于论坛限制，trc文件下面内容省略

请问这是什么原因造成的？
Current SQL statement for this session:
begin       :ret :=bill_003.accountbas(:packettime,:acctsessionid, :nasipaddr,:nasporttype, :acctstatustype,            :username,:callingid,
:calledid,:framedipaddr,:inputoctets,           utputoctets,:inputgigawords,utputgigawords,:acctsessiontime,:acctdelaytime,         :acct
terminatecause,:mdsip,:nasidentifier,:nasport,:nasportid,:class);end;是否在执行存储过程时造成的。
为啥能够自动恢复了，如何解决此问题？
谢谢！

duolanshizhe

恩   这个问题必然是存储过程引起

可能触发了oracle的内部bug

建议对这个存储过程进行改造测试

renxiao2003

楼主把发生错误的存储过程帖出来看看。

cisco3640

这个实例不是我建的，呵呵，是一个packages，我没有密码。
据说已经被修改而且也重新编译了。
谢谢！