ORA-27124: Unable To Detach From Shared Memory Segment & IBM AIX RISC System/6000 Error: 22: Invalid

背景

操作系统 ：AIX 7
数据库 ： 11.2.0.4.0 未安装补丁

根据客户要求打补丁。但一直打不成功。提升如下：

故，回退。回退命令如下：

问题

回退后crs 启动正常，但无法将database拉起，手动尝试拉起，报错如下：

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 25 14:24:01 2022

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup    
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/prodrpt/spfileprodrpt.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/prodrpt/spfileprodrpt.ora
ORA-01034: ORACLE not available
ORA-27124: unable to detach from shared memory segment
IBM AIX RISC System/6000 Error: 22: Invalid argument
SQL> 

解决办法

通过查看mos
ORA-27124: Unable To Detach From Shared Memory Segment & IBM AIX RISC System/6000 Error: 22: Invalid Argument Error Reported. (Doc ID 1964312.1)

是由于oracle 命令权限发生变化导致。

分别使用grid和oracle用户查看oracle命令权限，正常权限为：

$ cd $ORACLE_HOME/bin
$ ls -rlt oracle
-rwsr-s--x    1 oracle   oinstall  309671310 Oct 25 14:47 oracle

实际上我的权限是：

$ cd $ORACLE_HOME/bin/
$ ls -l oracle
-rwxrwxr-x    1 grid     oinstall  272152615 Oct 23 16:31 oracle

权限修改命令：

$ chmod 6751 oracle
$ 
$ ls -l oracle
-rwsr-s--x    1 grid     oinstall  272152615 Oct 23 16:31 oracle

再次尝试启动数据库，成功！

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 25 15:44:18 2022

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 4.9973E+10 bytes
Fixed Size                  2257944 bytes
Variable Size            1.1274E+10 bytes
Database Buffers         3.8655E+10 bytes
Redo Buffers               42070016 bytes
Database mounted.
Database opened.