首页 > 技术文章 > ORACLE RAC补丁升级:ORA-27140: attach to post/wait facility failed

nianshaoyiguo 2020-07-04 15:04 原文

基本信息如下:

操作:oracle RAC for linux11g补丁升级 OJVM

补丁包:p30783890_112040_Linux-x86-64.zip

OJVM补丁:Patch 30805543 - Oracle JavaVM Component 11.2.0.4.200414 Database PSU

操作系统:Red Hat Enterprise Linux Server release 6.5 (Santiago)

 

操作步骤如下:

1、opatch apply后,补丁opatch success

2、sqlplus进入后执行任意select命令:

ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0

3、查看alert日志:

Errors in file /home/app/app/oracle/diag/rdbms/pc0app/pc0app1/trace/pc0app1_cjq0_86401.trc:

4、查看trc文件

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 = 5004 (asmadmin), current egid = 5001 (oinstall)

解决方案:

1、先回退,看补丁文档中README.html进行操作

2、回退后执行以下操作

在oracle用户下修改$ORACLE_HOME/bin/oracle权限
[oracle@dba_oracle1 dbhome_1]$ pwd
/u01/app/oracle/product/12.2.0/dbhome_1
[oracle@dba_oracle1 dbhome_1]$ cd bin
[oracle@dba_oracle1 bin]$ pwd
/u01/app/oracle/product/12.2.0/dbhome_1/bin
[oracle@dba_oracle1 bin]$ chown -R oracle:asmadmin oracle

修改后
-rwxr-x--x 1 oracle asmadmin 239626641 Mar 3 2017 oracle

在修改文件属性
[oracle@dba_oracle1 ~]$ chmod 6751 $ORACLE_HOME/bin/oracle

[oracle@dba_oracle1 bin]$ls -la oracle
-rwsr-s--x 1 oracle asmadmin 239626641 Mar 3 2020 oracle

 

推荐阅读