[oracle@rac2 ~]sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat Apr 1 15:51:24 2017
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL>startup

ORA-01078:failure in processing system parameters

ORA-01565:error in identifying file '+DATA/orcl/spfileorcl.ora'

ORA-17503: kfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora

ORA-01034:ORACLE not available

ORA-27123:unable to attach to shared memory segment

Linux-x86_64 Error:13:Permission denied

Additional information: 26

Additional information: 196613

 

 

grid用户下,查看磁盘组状态正常

SQL>select name,state from http://www.buy-trusted-tablets.com v$asm_diskgroup;

NAME                                   STATE

———————————–   ————————

DATA                                    MOUNTED

OCRVT                                 MOUNTED

 

查看grid用户下oracle权限

[grid@rac2 ~]$cd $ORACLE_HOME/bin

[grid@rac2 bin]$ls -la oracle

-rwxr-x–x 1 grid oinstall 209914519 Mar 28 16:16 oracle

 

发现权限错误,正确的权限应该是-rwsr-s–x-

[grid@rac2 bin]$ chmod 6751 oracle

 

SQL>select instance_name,status from gv$instane;

INSTANCE_NAME         STATUS

——————————    ——————

orcl2                                 OPEN

orcl1                                 OPEN

节点2实例启动

 

造成这种问题的可能:

 

1、是人为修改该文件的权限,

2、还有就是apply patch失败,apply patch的过程会有修改该文件权限为-rwxr-xr-x的动作,在apply patch完成后再修改回来,但是如果apply patch失败,就会导致该文件权限一直是错误的状态,需要手动修改回来。

 

 

 

 




Related posts

coded by nessus
分享:  DeliciousGReader鲜果豆瓣CSDN网摘
Trackback

no comment untill now

Add your comment now

无觅相关文章插件