美文网首页
Oracle Rac CRS 无法启动的解决办法 CRS-456

Oracle Rac CRS 无法启动的解决办法 CRS-456

作者: 神力无敌_61b6 | 来源:发表于2017-04-19 22:07 被阅读0次

    客户Rac环境由第三方公司安装,安装完了后一直也没注意,今天才发现,节点1压根就没在集群内

    [grid@db2 ~]$ crs_stat -t
    Name           Type           Target    State     Host        
    ------------------------------------------------------------
    ora.DATA.dg    ora....up.type ONLINE    ONLINE    db2         
    ora....ER.lsnr ora....er.type ONLINE    ONLINE    db2         
    ora....N1.lsnr ora....er.type ONLINE    OFFLINE               
    ora...._CRS.dg ora....up.type ONLINE    ONLINE    db2         
    ora.asm        ora.asm.type   ONLINE    ONLINE    db2         
    ora.crjdb.db   ora....se.type ONLINE    ONLINE    db2         
    ora.cvu        ora.cvu.type   ONLINE    ONLINE    db2         
    ora.db.db      ora....se.type ONLINE    ONLINE    db2         
    ora.db1.vip    ora....t1.type ONLINE    OFFLINE               
    ora....SM2.asm application    ONLINE    ONLINE    db2         
    ora....B2.lsnr application    ONLINE    ONLINE    db2         
    ora.db2.gsd    application    OFFLINE   OFFLINE               
    ora.db2.ons    application    ONLINE    ONLINE    db2         
    ora.db2.vip    ora....t1.type ONLINE    ONLINE    db2         
    ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
    ora....network ora....rk.type ONLINE    ONLINE    db2         
    ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    db2         
    ora.ons        ora.ons.type   ONLINE    ONLINE    db2         
    ora.scan1.vip  ora....ip.type ONLINE    OFFLINE    
    

    由此看来db1根本就没在集群内
    因此去db1查看状态,发现crs确实未启动

    [grid@db2 ~]$ crs_stat -t
    CRS-0184: Cannot communicate with the CRS daemon.
    

    启动crs,发现启动失败

    [grid@db2 ~]$  crsctl start crs
    CRS-4563: Insufficient user privileges.
    
    CRS-4000: Command Start failed, or completed with errors.
    [grid@db2 ~]$ crsctl check css
    CRS-4639: Could not contact Oracle High Availability Services
    CRS-4000: Command Check failed, or completed with errors.
    

    后来查看日志发现对log下面db2没有权限,此时才发现了问题,节点1的hostname竟然和节点二一样

    [grid@db2 ~]$ hostname
    db2
    

    更改hostname后,crs一样启动不来

    后来网上查询尝试重新配置crs,使用root权限

    [root@db1 ~]# cd /home/u01/grid/11.2.0/crs/install/
    [root@db1 install]#  ./roothas.pl -deconfig -force -verbose
    Using configuration parameter file: ./crsconfig_params
    CRS-4535: Cannot communicate with Cluster Ready Services
    CRS-4000: Command Stop failed, or completed with errors.
    CRS-4535: Cannot communicate with Cluster Ready Services
    CRS-4000: Command Delete failed, or completed with errors.
    CRS-4133: Oracle High Availability Services has been stopped.
    Successfully deconfigured Oracle Restart stack
    
    

    执行root.sh

    [root@db1 ~]# cd /home/u01/grid/11.2.0/
    [root@db1 11.2.0]# ./root.sh 
    Performing root user operation for Oracle 11g 
    
    The following environment variables are set as:
        ORACLE_OWNER= grid
        ORACLE_HOME=  /home/u01/grid/11.2.0
    
    Enter the full pathname of the local bin directory: [/usr/local/bin]: 
    The contents of "dbhome" have not changed. No need to overwrite.
    The contents of "oraenv" have not changed. No need to overwrite.
    The contents of "coraenv" have not changed. No need to overwrite.
    
    Entries will be added to the /etc/oratab file as needed by
    Database Configuration Assistant when a database is created
    Finished running generic part of root script.
    Now product-specific root actions will be performed.
    Using configuration parameter file: /home/u01/grid/11.2.0/crs/install/crsconfig_params
    User ignored Prerequisites during installation
    Installing Trace File Analyzer
    OLR initialization - successful
    Adding Clusterware entries to upstart
    CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node db2, number 2, and is terminating
    An active cluster was found during exclusive startup, restarting to join the cluster
    PRKO-2190 : VIP exists for node db1, VIP name db1-vip
    Configure Oracle Grid Infrastructure for a Cluster ... succeeded
    
    

    此时查看crs状态

    [root@db1 11.2.0]# su -  grid 
    [grid@db1 ~]$ crs_stat -t
    Name           Type           Target    State     Host        
    ------------------------------------------------------------
    ora.DATA.dg    ora....up.type ONLINE    ONLINE    db1         
    ora....ER.lsnr ora....er.type ONLINE    ONLINE    db1         
    ora....N1.lsnr ora....er.type ONLINE    ONLINE    db1         
    ora...._CRS.dg ora....up.type ONLINE    ONLINE    db1         
    ora.asm        ora.asm.type   ONLINE    ONLINE    db1         
    ora.crjdb.db   ora....se.type ONLINE    ONLINE    db1         
    ora.cvu        ora.cvu.type   ONLINE    ONLINE    db2         
    ora.db.db      ora....se.type ONLINE    ONLINE    db1         
    ora....SM1.asm application    ONLINE    ONLINE    db1         
    ora....B1.lsnr application    ONLINE    ONLINE    db1         
    ora.db1.gsd    application    OFFLINE   OFFLINE               
    ora.db1.ons    application    ONLINE    ONLINE    db1         
    ora.db1.vip    ora....t1.type ONLINE    ONLINE    db1         
    ora....SM2.asm application    ONLINE    ONLINE    db2         
    ora....B2.lsnr application    ONLINE    ONLINE    db2         
    ora.db2.gsd    application    OFFLINE   OFFLINE               
    ora.db2.ons    application    ONLINE    ONLINE    db2         
    ora.db2.vip    ora....t1.type ONLINE    ONLINE    db2         
    ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
    ora....network ora....rk.type ONLINE    ONLINE    db1         
    ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    db2         
    ora.ons        ora.ons.type   ONLINE    ONLINE    db1         
    ora.scan1.vip  ora....ip.type ONLINE    ONLINE    db1    
    

    搞定

    相关文章

      网友评论

          本文标题:Oracle Rac CRS 无法启动的解决办法 CRS-456

          本文链接:https://www.haomeiwen.com/subject/lhzhzttx.html