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

来源：互联网发布：智能手环数据接口编辑：程序博客网时间：2024/05/17 00:50

重新启动节点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

0 0