暂无图片
分享
NIU
2019-08-16
单机oracle数据库修改服务器的ip地址导致数据库报错ora—03113

报错信息如下:

ORA-03113: end-of-file on communication channel

Process ID: 6473

Session ID: 32 Serial number: 22731




alert.log

2019-08-10T01:40:31.917221+08:00

ARC2 started with pid=36, OS id=6590 

ARC0: Archival started

ARC1: Archival started

ARC2: Archival started

2019-08-10T01:40:31.932703+08:00

ARC0: Becoming a 'no FAL' ARCH

ARC0: Becoming the 'no SRL' ARCH

2019-08-10T01:40:31.941942+08:00

ARC3 started with pid=37, OS id=6592 

2019-08-10T01:40:31.952898+08:00

ARC3: Archival started

ARCH: STARTING ARCH PROCESSES COMPLETE

2019-08-10T01:40:32.013479+08:00

Unable to create archive log file '/arch/1_6_1015789651.dbf'

2019-08-10T01:40:32.013740+08:00

Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc1_6588.trc:

ORA-19504: failed to create file "/arch/1_6_1015789651.dbf"

ORA-27040: file create error, unable to create file

Linux-x86_64 Error: 13: Permission denied

Additional information: 1

ARC1: Error 19504 Creating archive log file to '/arch/1_6_1015789651.dbf'

krsd_check_stuck_arch: stuck archiver: insufficient local LADs

krsd_check_stuck_arch: stuck archiver condition declared

2019-08-10T01:40:32.025579+08:00

TT00: Gap Manager starting (PID:6594)

2019-08-10T01:45:32.043112+08:00

krsd_check_stuck_arch: stuck archiver condition cleared

2019-08-10T01:45:33.244718+08:00

Unable to create archive log file '/arch/1_5_1015789651.dbf'

2019-08-10T01:45:33.245277+08:00

Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc3_6592.trc:

ORA-19504: failed to create file "/arch/1_5_1015789651.dbf"

ORA-27040: file create error, unable to create file

Linux-x86_64 Error: 13: Permission denied

Additional information: 1

ARC3: Error 19504 Creating archive log file to '/arch/1_5_1015789651.dbf'

krsd_check_stuck_arch: stuck archiver: insufficient local LADs

krsd_check_stuck_arch: stuck archiver condition declared


收藏
分享
4条回答
默认
最新
章芋文

修改单实例IP地址建议重启下数据库,监听里面的配置是否正常,/tec/hosts是否正确。

暂无图片 评论
暂无图片 有用 0
刘贵宾

看日志,像是权限原因,你看看归档目录以及里面的文件的属主和权限是否正确。

暂无图片 评论
暂无图片 有用 0
NIU

setup  修改完主机的ip忘记修改 /etc/hosts  文件的内容就启动数据库  导致报错 ,后来自己想起来了 。修改了etc/hosts  把归档关闭了  现在恢复正常 。

暂无图片 评论
暂无图片 有用 0
NIU
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏