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

 

上一篇:ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected DG开启MRP失败


下一篇:CHANGING HOSTNAMES IN ORACLE RAC