标题: ORA-27140 ORA-27300 ORA-27301 ORA-27302 And ORA-27303 In Trace File [打印本页] 作者: 刘泽宇 时间: 2021-1-31 13:07 标题: ORA-27140 ORA-27300 ORA-27301 ORA-27302 And ORA-27303 In Trace File 本帖最后由 刘泽宇 于 2021-1-31 16:55 编辑
Connect " /as sysdba" is showing connected but failing when performing any query.
sysdba连接数据库却无法执行任何查询操作，同时查看告警日志中出现了ORA-27140 ORA-27300 ORA-27301 ORA-27302 ORA-27303报错
$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Aug 8 19:34:19 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected.
SQL> select * from v$instance;
select * from v$instance
*
ERROR at line 1:
ORA-01012: not logged on
Died during process startup with error 27140 (seq=805)
OPIRIP: Uncaught error 27140. Error stack:
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: Not owner
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 202 (?), current egid = 101 (dba)
oracle@xxx0: ABC : /opt/oracle/ABC/bdump
造成这个问题的原因是：
At the time of startup the background processes are having a gid, and since the gid of the
$ORACLE_HOME/bin/oracle was changed, the new gid was not matching with the gid at startup.
处理方法为：Change the gid of the $ORACLE_HOME/bin/oracle to the original value i.e. startup gid.