基本信息如下:
操作: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