Tuesday 28 December 2021

ORA-27300: OS system dependent operation:invalid_egid failed with status: 1 ORA-27301: OS failure message: Operation not permitted

 

This document describes how to fix the below error. 

Issue: Unable to connect database with apps user and getting below error.


[oracle@server1 ~]$ sqlplus apps

SQL*Plus: Release 12.1.0.2.0 Production on Wed Dec 22 23:05:13 2021

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 = 1001 (dba), current egid
= 1006 (asmadmin)

 

Cause: 

Group permissions have been changed for the executable file "oracle" which is under $ORACLE_HOME/bin.

 

Solution: In my case oracle binaries belongs to "dba" group. Please change the  group according to your environment .

[oracle@server1 bin]$ hostname -i
192.168.1.110
[oracle@server1 bin]$
[oracle@server1 bin]$ pwd
/u01/app/oracle/product/19.3.0/dbhome_1/bin

[oracle@server1 bin]$ ls -ltr  oracle
-rwsr-s--x 1 oracle asmadmin 332956288 Dec  28 21:21 oracle
[oracle@server1 bin]$

After change the group for the file "oracle" which is under $ORACLE_HOME/bin

[oracle@server1 bin]$ ls -ltr  oracle
-rwsr-s--x 1 oracle dba 332956288 Dec  28 22:21 oracle
[oracle@server1 bin]$




Thanks for going through the post.............

No comments:

Post a Comment