10 Replies Latest reply: Nov 20, 2012 3:42 AM by Flake RSS

    Cluster Database not starting up. Permission error.

    Flake
      Hi all,

      I recently installed 2 node Oracle 11g RAC on RHEL5. While creating Clustered Database, database creation on second node (racnode2) failed. So, I connected */ as sysdba* on the node and executed startup only to get this error message:
      SQL> startup
      ORA-01078: failure in processing system parameters
      ORA-01565: error in identifying file '+RACDB_DATA/RACDB/spfileRACDB.ora'
      ORA-17503: ksfdopn:2 Failed to open file +RACDB_DATA/RACDB/spfileRACDB.ora
      ORA-01034: ORACLE not available
      ORA-27123: unable to attach to shared memory segment
      Linux Error: 13: Permission denied
      Additional information: 196612
      Additional information: 10
      SQL>
      But, *'+RACDB_DATA/RACDB/spfileRACDB.ora'* is present. I strongly believe it is a permission issue that ORACLE owned processes are not able to access disks owned by GRID user. I checked the permission of disks:
      [oracle@racnode2 ~]$ cd /dev/oracleasm/disks
      [oracle@racnode2 disks]$ ls -l
      total 0
      brw-rw---- 1 grid asmadmin 8, 65 Nov 19 19:15 CRSVOL1
      brw-rw---- 1 grid asmadmin 8, 49 Nov 19 19:15 DATAVOL1
      brw-rw---- 1 grid asmadmin 8, 81 Nov 19 19:15 FRAVOL1
      [oracle@racnode2 disks]$
      And also, ORACLE user has asmdba among other privileges.
      [oracle@racnode2 disks]$ id
      uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1201(asmdba),1300(dba),1301(oper) context=user_u:system_r:unconfined_t
      Can someone shed light on what is happening? I am willing to furnish further data. Any help is highly appreciated.

      Thanks,
      ...