10 November, 2017

ORA-27300: OS system dependent operation:invalid_egid

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

No comments:

Post a Comment

Finding OPP Manager log for a concurrent request

=> Use below query to find the OPP manager log for a concurrent request.  SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.lo...