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

本文主要是介绍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

这篇关于oracle 19c RAC srvctl start database 启动数据库报错的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！