rac 实例1 无法启动 ORA-17503：can open spfile，ORA-27123：unable to attach to shared memory segment



重新启动节点1实例的实例报错：

srvctl startinstance -d oraprddb -i oraprddb1 -o nomount

 

oradb01:/home/oracle$srvctlstart instance -d oraprddb -i oraprddb1 -o nomount

PRCR-1013 :Failed to start resource ora.oraprddb.db

PRCR-1064 :Failed to start resource ora.oraprddb.db on node oradb01

CRS-5017: Theresource action "ora.oraprddb.db start" encountered the followingerror:

ORA-01078:failure in processing system parameters

ORA-01565: errorin identifying file '+DATA/oraprddb/spfileoraprddb.ora'

ORA-17503:ksfdopn:2 Failed to open file +DATA/oraprddb/spfileoraprddb.ora

ORA-01034:ORACLE not available

ORA-27123:unable to attach to shared memory segment

IBM AIX RISCSystem/6000 Error: 13: Permission denied

 

分析是grid 用户 $ORACLE_HOME/bin/oracle文件权限由问题：

原权限：

-rwxrwxr-x    1 grid    oinstall  264671006 Mar 222013  oracle

修改权限：

Chmod  6755 oracle

-rwsr-sr-x    1 grid    oinstall  264671006 Mar 222013  /u01/11.2.0/grid/bin/oracle

 

重新启动rac 节点1 的实例成功

srvctl startinstance -d oraprddb -i oraprddb1

检查节点1 的状态：

SQL> selectopen_mode from v$database;

 

OPEN_MODE

------------------------------------------------------------

READ WRITE