本帖最后由 cisco3640 于 2010-10-12 10:14 编辑
请问是什么原因？如何解决？
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 NAME:(boss) 2010-10-11 16:01:39.971
*** SESSION ID:(82.37438) 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, :outputoctets,:inputgigawords,:outputgigawords,: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, :outputoctets,:inputgigawords,:outputgigawords,:acctsessiontime,:acctdelaytime, :acct
terminatecause,:mdsip,:nasidentifier,:nasport,:nasportid,:class);end;是否在执行存储过程时造成的。
为啥能够自动恢复了，如何解决此问题？
谢谢！
|
