ORA-27303 during startup of a RAC database

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)

Leave a Reply

Your email address will not be published. Required fields are marked *