• 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

  • 相关阅读:
    谈一谈网站防盗链
    SEO优化步骤
    hls协议(最清晰的讲解)
    https比http到底那里安全?
    常见的php攻击(6种攻击详解)
    36)django-jsonp跨域
    35)django-验证码
    34)django-上传文件,图片预览功能实现
    33)django-原生ajax,伪ajax
    32)django-modelform
  • 原文地址:https://www.cnblogs.com/sky2088/p/15867783.html
Copyright © 2020-2023  润新知