Table of Contents
Environment
- Oracle Restart 11.2.0.4
Error and related File permissions
SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATA/ORS4/spfileors4.ora' ORA-17503: ksfdopn:2 Failed to open file +DATA/ORS4/spfileors4.ora ORA-27140: attach to post/wait facility failed ORA-27300: OS system dependent operation:invalid_egid failed with status: 1 ORA-27301: OS failure message: Operation not permitted ORA-27302: failure occurred at: skgpwinit6 ORA-27303: additional information: startup egid = 54321 (oinstall), current egid = 504 (asmadmin) [oracle2@orars4 trace]$ ls $ORACLE_HOME/bin/oracle /u01/app/oracle/product/11204/ors/bin/oracle [oracle2@orars4 trace]$ ls -l $ORACLE_HOME/bin/oracle -rwsr-s--x. 1 oracle2 asmadmin 239626683 Oct 20 11:50 /u01/app/oracle/product/11204/ors/bin/oracle Stop the resoucre and change ownership [root@orars4 Desktop]# srvctl stop database -d ors4 [oracle2@orars4 trace]$ chown oracle2:oinstall $ORACLE_HOME/bin/oracle [oracle2@orars4 trace]$ ls -l $ORACLE_HOME/bin/oracle -rwxr-x--x. 1 oracle2 oinstall 239626683 Oct 20 11:50 /u01/app/oracle/product/11204/ors/bin/oracle [oracle2@orars4 trace]$ ls -l /dev/asm* brw-rw----. 1 oracle2 oinstall 8, 17 Oct 21 07:34 /dev/asm_data_10g_disk1 brw-rw----. 1 oracle2 oinstall 8, 33 Oct 21 07:34 /dev/asm_test_1g_disk1 Manually start the db with sqlplus --> worked --> After CRS reboot the group was change back to asmadmin Try to change ora.ors4.db resoure [root@orars4 dbs]# crsctl status resource ora.ors4.db -f .. ACL=owner:oracle2:rwx,pgrp:asmdba:r-x,other::r--,group:oinstall:r-x,user:oracle2:rwx Change the primary group [root@orars4 dbs]# crsctl setperm resource ora.ors4.db -g oinstall [root@orars4 dbs]# crsctl getperm resource ora.ors4.db Name: ora.ors4.db owner:oracle2:rwx,pgrp:oinstall:r-x,other::r--,group:oinstall:r-x,user:oracle2:rwx --> Did not work after GRID restart the executable still switch group ownership to asmadmnin
Modify config.c in $ORACLE_HOME/rdbms/lib and relink
#define SS_DBA_GRP "asmdba" #define SS_OPER_GRP "asmoper" #define SS_ASM_GRP "asmadmin" Change config.c to #define SS_DBA_GRP "dba" #define SS_OPER_GRP "oper" #define SS_ASM_GRP "oinstall" Shutdown CRS stack and relink # crsctl stop has [oracle2@orars4 grid]$ ls -ld $ORACLE_HOME drwxr-x---. 67 oracle2 oinstall 4096 Oct 19 11:25 /u01/app/11204/grid [oracle2@orars4 grid]$ cd $ORACLE_HOME/rdbms/lib [oracle2@orars4 lib]$ $ORACLE_HOME/bin/relink all .. As root, execute: # $GRID_HOME/crs/install/roothas.pl -patch Run the setasmgidwrap command as in Note.1084186.1. This will change the group membership of 'oracle' binary in DB home to new sysasm group. [oracle2@orars4 lib]$ cd $GRID_HOME/bin /' [oracle2@orars4 bin]$ ./setasmgidwrap o=/u01/app/oracle/product/11204/ors/bin/oracle [oracle2@orars4 bin]$ ls -l /u01/app/oracle/product/11204/ors/bin/oracle -rwxr-s--x. 1 oracle2 oinstall 239626683 Oct 20 11:50 /u01/app/oracle/product/11204/ors/bin/oracle
Reference
- How to change ownership and group memberships of Grid home in 11.2 Standalone (Doc ID 1171674.1)