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