ora-03113 通信通道的文件结束

luaiping 2008-12-04 10:23:39
客户端访问报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: dbsanp

Redo thread mounted by this instance: 1

Oracle process number: 24

Windows 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)
...全文
839 9 打赏 收藏 转发到动态 举报
写回复
用AI写文章
9 条回复
切换为时间正序
请发表友善的回复…
发表回复
vc555 2008-12-04
  • 打赏
  • 举报
回复
insert into UT_RPT_STATISTICREPORTDATA@SANPDBLINK(Reportid,Sourceid,val,rrow,cow) values (:Reportid,:Sourceid,:val,:rrow,:cow)
这个语句有什么问题吗?是该语句每次执行的时候出错?
luaiping 2008-12-04
  • 打赏
  • 举报
回复
Thu Dec 04 12:18:28 2008
Errors in file e:\oracle\product\10.2.0\admin\dbsanp\bdump\dbsanp_s005_2288.trc:
ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kksfbc+12153] [PC:0x832B49] [ADDR:0x28] [UNABLE_TO_READ] []

Thu Dec 04 12:18:47 2008
Thread 1 cannot allocate new log, sequence 362732
Checkpoint not complete
Current log# 1 seq# 362731 mem# 0: +DATABASEASM/dbsanp/onlinelog/group_1.258.664736071
Current log# 1 seq# 362731 mem# 1: +DATABASEASM/dbsanp/onlinelog/group_1.259.664736073
Thu Dec 04 12:18:47 2008
found dead shared server 'S000', pid = (15, 20)
found dead shared server 'S001', pid = (19, 10)
found dead shared server 'S002', pid = (21, 18)
found dead shared server 'S003', pid = (22, 17)
found dead shared server 'S004', pid = (23, 17)
found dead shared server 'S005', pid = (24, 18)
found dead shared server 'S008', pid = (31, 7)
PMON failed to delete process, see PMON trace file
PMON deletion of process succeeded
Thu Dec 04 12:18:57 2008
Thread 1 advanced to log sequence 362732
Current log# 2 seq# 362732 mem# 0: +DATABASEASM/dbsanp/onlinelog/group_2.260.664736075
Current log# 2 seq# 362732 mem# 1: +DATABASEASM/dbsanp/onlinelog/group_2.261.664736077
Thu Dec 04 12:18:57 2008
Errors in file e:\oracle\product\10.2.0\admin\dbsanp\bdump\dbsanp_s000_3136.trc:
ORA-00600: 内部错误代码, 参数: [kksfbc-reparse-infinite-loop], [0x7B32518], [], [], [], [], [], []

Thu Dec 04 12:18:57 2008
Errors in file e:\oracle\product\10.2.0\admin\dbsanp\bdump\dbsanp_s001_2540.trc:
ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kksfbc+12153] [PC:0x832B49] [ADDR:0x28] [UNABLE_TO_READ] []
luaiping 2008-12-04
  • 打赏
  • 举报
回复
alert.log
Thu Dec 04 11:59:24 2008
Errors in file e:\oracle\product\10.2.0\admin\dbsanp\bdump\dbsanp_s009_3176.trc:
ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kksfbc+12153] [PC:0x832B49] [ADDR:0x28] [UNABLE_TO_READ] []

Thu Dec 04 11:59:25 2008
Thread 1 cannot allocate new log, sequence 362675
Thu Dec 04 11:59:25 2008
found dead shared server 'S000', pid = (15, 46)
found dead shared server 'S002', pid = (20, 22)
found dead shared server 'S003', pid = (21, 55)
found dead shared server 'S004', pid = (22, 53)
found dead shared server 'S005', pid = (23, 51)
found dead shared server 'S006', pid = (24, 49)
found dead shared server 'S007', pid = (25, 47)
found dead shared server 'S017', pid = (33, 19)
Checkpoint not complete
Thu Dec 04 11:59:26 2008
Current log# 1 seq# 362674 mem# 0: +DATABASEASM/dbsanp/onlinelog/group_1.258.664736071
Current log# 1 seq# 362674 mem# 1: +DATABASEASM/dbsanp/onlinelog/group_1.259.664736073
Thu Dec 04 11:59:27 2008
found dead shared server 'S009', pid = (32, 17)
Thu Dec 04 11:59:28 2008
Thread 1 advanced to log sequence 362675
Current log# 2 seq# 362675 mem# 0: +DATABASEASM/dbsanp/onlinelog/group_2.260.664736075
Current log# 2 seq# 362675 mem# 1: +DATABASEASM/dbsanp/onlinelog/group_2.261.664736077
Thu Dec 04 11:59:29 2008
Errors in file e:\oracle\product\10.2.0\admin\dbsanp\bdump\dbsanp_s002_3180.trc:
ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kksfbc+12153] [PC:0x832B49] [ADDR:0x28] [UNABLE_TO_READ] []
sleepzzzzz 2008-12-04
  • 打赏
  • 举报
回复
可能与idle_time或者connect_time的设置有关系.



[Quote=引用楼主 luaiping 的帖子:]
客户端访问报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…
[/Quote]
范佩西_11 2008-12-04
  • 打赏
  • 举报
回复
改300或500,再大些。先show 再改
范佩西_11 2008-12-04
  • 打赏
  • 举报
回复
哈哈。我遇到过的。是process值太小了。修改processes值就可以了。
默认的processes值是150你改大些。
可以show parameter processes
alter system set processes=200 scope=spfile;

shutdown immediate
startup
luaiping 2008-12-04
  • 打赏
  • 举报
回复
防火墙没有问题
hebo2005 2008-12-04
  • 打赏
  • 举报
回复
是不是防火墙的关系,我就遇到过装了卡巴,每过段时候就断了,查了下,把反黑客关了就行了
Andy__Huang 2008-12-04
  • 打赏
  • 举报
回复
你首先要保证网络没有问题,然后再检查程序代码的问题

3,492

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 高级技术相关讨论专区
社区管理员
  • 高级技术社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧