问题描述
实例无法打开:
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
查看数据库alert日志报错如下:
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
专家解答
后检查发现是bin/oracle文件属性被改,修改正确后恢复正常:
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
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。