ORA-27303

APPLIES TO

Operating System - Oracle Linux Server 7.9
Oracle Database - Enterprise Edition - version 11.2.0.4.0
Oracle Grid Infrastructure - version 11.2.0.4.0

SYMPTOMS

RAC node 1 instance connect " /as sysdba" fails.

~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Feb 7 18:13:52 2024
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

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 = 504 (asmadmin), current egid = 501 (oinsstall)

CAUSE

At the time of startup the background processes are having a gid, and since the gid of the $ORACLE_HOME/bin/oracle was changed, the new gid was not matching with the gid at startup.

SOLUTION

Change the gid of the $ORACLE_HOME/bin/oracle to the original value i.e. startup gid.

~]$ ls -l $ORACLE_HOME/bin/oracle
-rwsr-x--x 1 oracle asmadmin 239501536 Mar 16 2023 /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/oracle

~]# chmod 6751 $ORACLE_HOME/bin/oracle
~]$ ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle asmadmin 239501536 Mar 16 2023 /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/oracle