Sunday, October 16, 2016

ORA-27303: additional information: startup egid = 54322 (dba), current egid = 54321 (oinstall)

 My database is Oracle12c and two node RAC database.  I have standby database with two node  RAC.

I  was getting the  below error during the business hours.  We were not to able  connect the database. Oracle stopped taking new connections. But existing  connections were fine and it did not impact the transactions.

[oracle@usbenhost1 ~]$ sqlplus gthangavelu

SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 14 15:22:15 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Enter password:
ERROR:
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 = 54322 (dba), current egid = 54321 (oinstall)


Enter user-name:


I was able to connect the standby database.  Then i have done some oracle metalink search and found that this is related to $ORACLE_HOME/bin/oracle   file permission issue.

Looked at the standby database $ORACLE_HOME/bin/oracle file privilege. It was different than the primary database. I came to conclusion that, $ORACLE_HOME/bin/oracle file permission  is the root cause for this connectivity issue.

Primary database  First node Privileges :
[oracle@usbenhost1 bin]$ pwd
/u01/app/oracle/product/12.1.0.2/db_1/bin
[oracle@usbenhost1 bin]$ ls -ltr oracle
-rwxr-x--x. 1 oracle oinstall 323762228 Dec 28  2014 oracle
[oracle@usbenhost1 bin]$

 Primary database   Second   node  Privileges :
[oracle@usbenhost2 bin]$ pwd
/u01/app/oracle/product/12.1.0.2/db_1/bin
[oracle@usbenhost2 bin]$ ls -ltr oracle
-rwxr-x--x. 1 oracle oinstall 323762228 Dec 28  2014 oracle
[oracle@usbenhost2 bin]$

Secondary database  First node Privileges :
[oracle@usbenhost3 bin]$ pwd
/u01/app/oracle/product/12.1.0.2/db_1/bin
[oracle@usbenhost3 bin]$ ls -ltr oracle
-rwsr-s--x. 1 oracle dba 323762276 Feb 23  2015 oracle
[oracle@usbenhost3 bin]$

Secondary database  Second  node Privileges :
[oracle@usbenhost4 bin]$ pwd
/u01/app/oracle/product/12.1.0.2/db_1/bin
[oracle@usbenhost4 bin]$ ls -ltr oracle
-rwsr-s--x. 1 oracle dba 323762276 Feb 23  2015 oracle
[oracle@usbenhost4 bin]$


I changed the privilege as below in both primary nodes and able to connect the  database.

[oracle@usbenhost1 bin]$ pwd
/u01/app/oracle/product/12.1.0.2/db_1/bin
[oracle@usbenhost1 bin]$ ls -ltr oracle
-rwxr-x--x. 1 oracle dba 323762228 Dec 28  2014 oracle
[oracle@usbenhost1 bin]$ chmod 6751 oracle
[oracle@usbenhost1 1in]$ ls -ltr oracle
-rwsr-s--x. 1 oracle dba 323762276 Feb 23  2015 oracle
[oracle@usbenhost1 bin]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 14 17:24:33 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL>


[oracle@usbenhost2 bin]$ pwd
/u01/app/oracle/product/12.1.0.2/db_1/bin
[oracle@usbenhost2 bin]$ ls -ltr oracle
-rwxr-x--x. 1 oracle dba 323762228 Dec 28  2014 oracle
[oracle@usbenhost2 bin]$ chmod 6751 oracle
[oracle@usbenhost2 bin]$ ls -ltr oracle
-rwsr-s--x. 1 oracle dba 323762228 Dec 28  2014 oracle
[oracle@usbenhost2 bin]$ sqlplus  / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 14 17:23:23 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL>

Issue resolved now!

This issue could happen when $GI_HOME/bin/oracle   privilege is  changed same as above.  But my case,  i had an issue with $ORACLE_HOME/bin/oracle privilege.

Hope this post is helpful!