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: |
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]$ |
[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]$ |
[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]$ |
[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]$ |
[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!
Comments
Post a Comment