ORA-27140 ORA-27300 ORA-27301 ORA-27302 And ORA-27303 In Trace File

刘泽宇

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.


参照官方文档 ID：453959.1