Environment
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)