暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

数据库无法连接ASM ORA-15055: unable to connect to ASM instance

原创 章芋文 2015-02-13
1880
实例无法打开:
[code]SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/jfcsdb/spfilejfcsdb.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/jfcsdb/spfilejfcsdb.ora
ORA-12547: TNS:lost contact[/code]

查看数据库alert日志报错如下:
[code]TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/export/home/oracle/app/11.2/grid/bin/oracle)(ARGV0=oracle+ASM_o000_jfcsdb)(ENVS='ORACLE
_HOME=/export/home/oracle/app/11.2/grid,ORACLE_SID=+ASM')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
Mon May 19 14:24:08 2014
WARNING: ASM communication error: op 33 state 0x40 (12547)
ERROR: slave communication error with ASM
ERROR: paging ASM fault extent map failed gn=1 fn=297 extet=62
KCF: read, write or open error, block=0xfb0 online=1
file=22 '+DATA/jfcsdb/datafile/data01.297.846953041'
error=15055 txt: ''
Errors in file /export/home/oracle/app/oracle/diag/rdbms/jfcsdb/jfcsdb/trace/jfcsdb_dbw1_5783.trc:
ORA-12547: TNS:lost contact
Errors in file /export/home/oracle/app/oracle/diag/rdbms/jfcsdb/jfcsdb/trace/jfcsdb_dbw1_5783.trc:
ORA-63999: data file suffered media failure
ORA-01114: IO error writing block to file 22 (block # 4016)
ORA-01110: data file 22: '+DATA/jfcsdb/datafile/data01.297.846953041'
ORA-15055: unable to connect to ASM instance
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact
DBW1 (ospid: 5783): terminating the instance due to error 63999
Mon May 19 14:24:08 2014
System state dump requested by (instance=1, osid=5783 (DBW1)), summary=[abnormal instance termination].
System State dumped to trace file /export/home/oracle/app/oracle/diag/rdbms/jfcsdb/jfcsdb/trace/jfcsdb_diag_5773.trc[/code]
后检查发现是bin/oracle文件属性被改,修改正确后恢复正常:
[code]oracle@jyjfcsdb:~/app/oracle/diag/rdbms/jfcsdb/jfcsdb/trace$ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle dba 246508176 May 5 10:19 /export/home/oracle/app/oracle/product/11.2.0/db/bin/oracle

grid@jyjfcsdb:/export/home/oracle/app/grid/diag/asm/+asm/+ASM/trace$ls -l $ORACLE_HOME/bin/oracle
-rwxr-x--x 1 grid dba 218248392 May 5 09:50 /export/home/oracle/app/11.2/grid/bin/oracle
grid@jyjfcsdb:/export/home/oracle/app/grid/diag/asm/+asm/+ASM/trace$chmod 6751 $ORACLE_HOME/bin/oracle
grid@jyjfcsdb:/export/home/oracle/app/grid/diag/asm/+asm/+ASM/trace$ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 grid dba 218248392 May 5 09:50 /export/home/oracle/app/11.2/grid/bin/oracle[/code]
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论