详细报错信息如下:
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/taxidb/spfiletaxidb.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/taxidb/spfiletaxidb.ora
ORA-01031: insufficient privileges
查了下当前oracle的身份信息
[root@rac1 ~]# id oracle
uid=502(oracle) gid=501(oinstall) 缁501(oinstall),502(dba)
[root@rac1 ~]# id grid
uid=501(grid) gid=501(oinstall) 缁501(oinstall),502(dba),504(asmadmin),506(asmdba),507(asmoper)
正常节点oracle用户属性:
[root@rac1 etc]# id oracle
uid=500(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),506(asmdba)
[root@rac1 etc]# id grid
uid=501(grid) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),504(asmadmin),505(asmoper),506(asmdba)
执行如下:主要增加asmdba组
[root@rac1 ~]# usermod -g oinstall -G dba,asmdba oracle
[root@rac1 ~]# id oracle
uid=502(oracle) gid=501(oinstall) 缁501(oinstall),502(dba),506(asmdba)
SQL> startup
ORACLE instance started.
Total System Global Area 6597406720 bytes
Fixed Size 2240784 bytes
Variable Size 4932505328 bytes
Database Buffers 1644167168 bytes
Redo Buffers 18493440 bytes
Database mounted.
Database opened.