oracle 19c RAC srvctl start database 启动数据库报错

 

oracle 19c RAC srvctl start database 启动数据库报错：

 

[oracle@ora19c-rac1 ~]$srvctl start database -d orcl
PRCR-1079 : Failed to start resource ora.orcl.db
CRS-5017: The resource action "ora.orcl.db start" encountered the following error:
ORA-00443: background process "LMD1" did not start
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/ora19c-rac1/crs/trace/crsd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.orcl.db' on 'ora19c-rac1' failed
CRS-2632: There are no more servers to try to place resource 'ora.orcl.db' on that would satisfy its placement policy
CRS-5017: The resource action "ora.orcl.db start" encountered the following error:
ORA-00443: background process "RBAL" did not start
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/ora19c-rac2/crs/trace/crsd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.orcl.db' on 'ora19c-rac2' failed

 

数据库alert日志报错：

Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_psp0_42613.trc:
ORA-27300: OS system dependent operation:fork failed with status: 11
ORA-27301: OS failure message: Resource temporarily unavailable
ORA-27302: failure occurred at: skgpspawn5
2022-02-07T11:14:36.655060+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_lms1_42683_42689.trc (incident=64023):
ORA-00800: soft external error, arguments: [Set Priority Failed], [LMS1], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_64023/orcl1_lms1_42683_42689_i64023.trc
2022-02-07T11:14:36.655931+08:00
Error attempting to elevate LMS1's priority: no further priority changes will be attempted for this process
LMS1 started with pid=25, OS id=42683_42689
2022-02-07T11:14:36.698538+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_lms0_42681_42688.trc (incident=64024):
ORA-00800: soft external error, arguments: [Set Priority Failed], [LMS0], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_64024/orcl1_lms0_42681_42688_i64024.trc
2022-02-07T11:14:36.699149+08:00

Error attempting to elevate LMS0's priority: no further priority changes will be attempted for this process
LMS0 started with pid=23, OS id=42681_42688
2022-02-07T11:14:37.625682+08:00
Process RMS0 died, see its trace file
USER (ospid: 42454): terminating the instance due to ORA error 443

 

此处有2点问题：

1：ORA-27300: OS system dependent operation:fork failed with status: 11

2：ORA-00800: soft external error, arguments: [Set Priority Failed], [LMS0], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

 

问题1 根因：

DefaultTasksMax was set to default value(512).
systemd limited maximum number of tasks that may be created on the node.
This setting will also affect maxpid value on the OS.

 

解决办法：

vi /etc/systemd/system.conf

修改 DefaultTasksMax 值 为 infinity  （默认512，修改不限制）

重启操作系统

 

问题2根因：

Bug 28831618 : FAILED TO ELEVATE VKTM'S PRIORITY IN AIX WITH EVENT 10795 SET

解决办法：

cd $ORACLE_HOME/bin （oracle db home）root用户修改

chown root oradism

chmod u+s oradism