In one of our EBS database we faced issue when connecting to SQLPLUS
Error message which was coming up was as below:
[oracle@dbserver bin]$ sqlplus apps/apps
Copyright (c) 1982, 2011, Oracle. All rights reserved.
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 = 11 (asmadmin), current egid =
17 (oinstall)
The error was found to be related to file permission on “oracle” binary and was corrected as below:
CORRECTION
[oracle@dbserver bin]$ ls -ltr oracle -rwxrwxrwx 1 oracle asmadmin 232514408 Mar 7 06:53 oracle [oracle@dbserver bin]$ chmod 6751 $ORACLE_HOME/bin/oracle [oracle@dbserver bin]$ ls -ltr oracle -rwsr-s--x 1 oracle asmadmin 232514408 Mar 7 06:53 oracle
TESTING
[oracle@dbserver bin]$ sqlplus apps/apps Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> exit
Latest posts by Brijesh Gogia (see all)
- Oracle Multitenant DB 4 : Parameters/SGA/PGA management in CDB-PDB - July 18, 2020
- Details of running concurrent requests in Oracle EBS - May 26, 2020
- Oracle Multitenant DB 3 : Data Dictionary Architecture in CDB-PDB - March 20, 2020