客户端访问报ora-03113 通信通道的文件结束,这时connect 服务器端正常,网络应该没问题数据库差不多每隔15分钟就会出这样的警告
Dump file e:\oracle\product\10.2.0\admin\dbsanp\bdump\dbsanp_s003_3940.trc
Wed Nov 05 08:47:06 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 16 - type 586, 8 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:13524M/16379M, Ph+PgF:15631M/17841M, VA:100M/2047M
Instance name: dbsanpRedo thread mounted by this instance: 1Oracle process number: 24Windows thread id: 3940, image: ORACLE.EXE (S003)
*** ACTION NAME:() 2008-11-05 08:47:06.108
*** MODULE NAME:(ReportStaticisticService.exe) 2008-11-05 08:47:06.108
*** SERVICE NAME:(DBSANP) 2008-11-05 08:47:06.108
*** CLIENT ID:() 2008-11-05 08:47:06.108
*** SESSION ID:(694.3686) 2008-11-05 08:47:06.108
*** 2008-11-05 08:47:06.108
ksedmp: internal or fatal error
ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x832B49] [ADDR:0x28] [UNABLE_TO_READ] []
Current SQL statement for this session:
insert into UT_RPT_STATISTICREPORTDATA@SANPDBLINK(Reportid,Sourceid,val,rrow,cow) values (:Reportid,:Sourceid,:val,:rrow,:cow)
Dump file e:\oracle\product\10.2.0\admin\dbsanp\bdump\dbsanp_s003_3940.trc
Wed Nov 05 08:47:06 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 16 - type 586, 8 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:13524M/16379M, Ph+PgF:15631M/17841M, VA:100M/2047M
Instance name: dbsanpRedo thread mounted by this instance: 1Oracle process number: 24Windows thread id: 3940, image: ORACLE.EXE (S003)
*** ACTION NAME:() 2008-11-05 08:47:06.108
*** MODULE NAME:(ReportStaticisticService.exe) 2008-11-05 08:47:06.108
*** SERVICE NAME:(DBSANP) 2008-11-05 08:47:06.108
*** CLIENT ID:() 2008-11-05 08:47:06.108
*** SESSION ID:(694.3686) 2008-11-05 08:47:06.108
*** 2008-11-05 08:47:06.108
ksedmp: internal or fatal error
ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x832B49] [ADDR:0x28] [UNABLE_TO_READ] []
Current SQL statement for this session:
insert into UT_RPT_STATISTICREPORTDATA@SANPDBLINK(Reportid,Sourceid,val,rrow,cow) values (:Reportid,:Sourceid,:val,:rrow,:cow)
解决方案 »
- 查看表空间?
- java程序去调用oracle的存储过程时出错
- 请教个oralce问题,知道的,不知道的进来看看
- 返回结果怎么按in排序
- 大家帮我看看这个sql语句怎么写啊?
- 一个是oracle数据库,一个是sysbase数据库,想要互想访问交换数据,有修改数据的可能,怎么办了?
- 请问怎样用Toad显示SQL的执行过程,急~~~~ 请求大家帮忙!
- 触发器能否触发一个存储过程
- 转换成MS SQL的数据库
- 初学者的问题,请高手指点!建库出错!
- 本地和远程关闭实例后,sqlplus在客户端怎样远程启动linux下Oracle 10.2的服务端数据库实例?怎样写一个启动批处理文件?
- 请问下ORACLE 10G 中orcl如何创建用户和密码还有表空间
请参考:
http://topic.csdn.net/u/20081208/22/79d5d1a8-0603-4ecc-8b07-060ee2181c38.html
// *Cause: The connection between Client and Server process was broken.
// *Action: There was a communication error that requires further investigation.
// First, check for network problems and review the SQL*Net setup.
// Also, look in the alert.log file for any errors. Finally, test to
// see whether the server process is dead and whether a trace file
// was generated at failure time.
ORA-12012: error on auto execute of job 404
ORA-02053: transaction 10.2.1691589 committed, some remote DBs may be in-doubt
ORA-02068: following severe error from ERP_PROD
ORA-03135: connection lost contact
ORA-06512: at "SAJET.XXSFC_SSTS_AUTO_TRANSFER", line 110
ORA-06512: at line 1Thu Dec 08 14:41:09 2011
Errors in file t:\oracle\bdump\bhpsfcdb_j000_5260.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kpnfch+224] [PC:0xF986B4] [ADDR:0x84] [UNABLE_TO_READ] []请楼主指点。
2查看一下故障时间的后台日志
3网络 是否断开过
4如果是linux下的服务,可能要查看一下系统是否报错。