小编给大家分享一下orcle 11g rac crs状态正常但节点2数据库未启动怎么办，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！

安装完oracle11g R2 rac后，在节点1上查看数据库状态：

[oracle@node1~]$sqlplus/assysdbaSQL*Plus:Release11.2.0.4.0ProductiononWedMay1718:56:342017Copyright(c)1982,2013,Oracle.Allrightsreserved.Connectedto:OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptionsSQL>SELECTinst_id,instance_numberinst_no,instance_nameinst_name,parallel,status,database_statusdb_status,active_statestate,host_namehostFROMgv$instanceORDERBYinst_id;INST_IDINST_NOINST_NAMEPARSTATUSDB_STATUS--------------------------------------------------------------------STATEHOST-------------------------------------------------------------------------11orcl1YESOPENACTIVENORMALnode1SQL>SQL>quit#发现没有节点2的数据库信息

在节点2上查看数据库状态:

[oracle@node2~]$sqlplus/assysdbaSQL*Plus:Release11.2.0.4.0ProductiononWedMay1718:57:482017Copyright(c)1982,2013,Oracle.Allrightsreserved.Connectedtoanidleinstance.SQL>SQL>SELECTinst_id,instance_numberinst_no,instance_nameinst_name,parallel,status,database_statusdb_status,active_statestate,host_namehostFROMgv$instanceORDERBYinst_id;SELECTinst_id,instance_numberinst_no,instance_nameinst_name,parallel,status,database_statusdb_status,active_statestate,host_namehostFROMgv$instanceORDERBYinst_id*ERRORatline1:ORA-01034:ORACLEnotavailableProcessID:0SessionID:0Serialnumber:0SQL>quit

显示数据库不可用,查看数据库进程,发现数据库进程不在：

[oracle@node2~]$ps-ef|grepora_oracle87188048018:58pts/000:00:00grep--color=autoora_

查看CRS状态：

[grid@node2~]$crs_stat-tNameTypeTargetStateHost------------------------------------------------------------ora.DATA.dgora....up.typeONLINEONLINEnode1ora....ER.lsnrora....er.typeONLINEONLINEnode1ora....N1.lsnrora....er.typeONLINEONLINEnode1ora.OCRVOTE.dgora....up.typeONLINEONLINEnode1ora.asmora.asm.typeONLINEONLINEnode1ora.cvuora.cvu.typeONLINEONLINEnode1ora.gsdora.gsd.typeOFFLINEOFFLINEora....networkora....rk.typeONLINEONLINEnode1ora....SM1.asmapplicationONLINEONLINEnode1ora....E1.lsnrapplicationONLINEONLINEnode1ora.node1.gsdapplicationOFFLINEOFFLINEora.node1.onsapplicationONLINEONLINEnode1ora.node1.vipora....t1.typeONLINEONLINEnode1ora....SM2.asmapplicationONLINEONLINEnode2ora....E2.lsnrapplicationONLINEONLINEnode2ora.node2.gsdapplicationOFFLINEOFFLINEora.node2.onsapplicationONLINEONLINEnode2ora.node2.vipora....t1.typeONLINEONLINEnode2ora.oc4jora.oc4j.typeONLINEONLINEnode1ora.onsora.ons.typeONLINEONLINEnode1ora.orcl.dbora....se.typeONLINEONLINEnode1ora.scan1.vipora....ip.typeONLINEONLINEnode1[grid@node2~]$crsctlstatusresNAME=ora.DATA.dgTYPE=ora.diskgroup.typeTARGET=ONLINE,ONLINESTATE=ONLINEonnode1,ONLINEonnode2NAME=ora.LISTENER.lsnrTYPE=ora.listener.typeTARGET=ONLINE,ONLINESTATE=ONLINEonnode1,ONLINEonnode2NAME=ora.LISTENER_SCAN1.lsnrTYPE=ora.scan_listener.typeTARGET=ONLINESTATE=ONLINEonnode1NAME=ora.OCRVOTE.dgTYPE=ora.diskgroup.typeTARGET=ONLINE,ONLINESTATE=ONLINEonnode1,ONLINEonnode2NAME=ora.asmTYPE=ora.asm.typeTARGET=ONLINE,ONLINESTATE=INTERMEDIATEonnode1,ONLINEonnode2NAME=ora.cvuTYPE=ora.cvu.typeTARGET=ONLINESTATE=ONLINEonnode1NAME=ora.gsdTYPE=ora.gsd.typeTARGET=OFFLINE,OFFLINESTATE=OFFLINE,OFFLINENAME=ora.net1.networkTYPE=ora.network.typeTARGET=ONLINE,ONLINESTATE=ONLINEonnode1,ONLINEonnode2NAME=ora.node1.vipTYPE=ora.cluster_vip_net1.typeTARGET=ONLINESTATE=ONLINEonnode1NAME=ora.node2.vipTYPE=ora.cluster_vip_net1.typeTARGET=ONLINESTATE=ONLINEonnode2NAME=ora.oc4jTYPE=ora.oc4j.typeTARGET=ONLINESTATE=ONLINEonnode1NAME=ora.onsTYPE=ora.ons.typeTARGET=ONLINE,ONLINESTATE=ONLINEonnode1,ONLINEonnode2NAME=ora.orcl.dbTYPE=ora.database.typeTARGET=ONLINE,ONLINESTATE=ONLINEonnode1,OFFLINE----这里显示ora.orcl.db在node2上为OFFLINENAME=ora.scan1.vipTYPE=ora.scan_vip.typeTARGET=ONLINESTATE=ONLINEonnode1

在节点2手动启动数据库：

[grid@node2~]$srvctlstartdatabase-dorclPRCC-1014:orcl已在运行PRCR-1004:资源ora.orcl.db已在运行PRCR-1079:无法启动资源ora.orcl.dbCRS-5017:Theresourceaction"ora.orcl.dbstart"encounteredthefollowingerror:ORA-01078:failureinprocessingsystemparametersORA-01565:errorinidentifyingfile'+DATA/orcl/spfileorcl.ora'ORA-17503:ksfdopn:2Failedtoopenfile+DATA/orcl/spfileorcl.oraORA-12547:TNS:lostcontact.Fordetailsreferto"(:CLSN00107:)"in"/u01/app/11.2.0/grid/log/node2/agent/crsd/oraagent_oracle/oraagent_oracle.log".CRS-2674:Startof'ora.orcl.db'on'node2'failedCRS-2528:Unabletoplaceaninstanceof'ora.orcl.db'asallpossibleserversareoccupiedbytheresource

解决办法：

联想到Oracle 11gR2 RAC DBCA无法识别ASM磁盘组时曾修改过grid用户下$ORACLE_HOME/bin/oracle的属性，当时是因为权限问题导致dbca无法访问创建好的ASM磁盘组，查看ORA-17503错误貌似是权限的问题，按照相同的方法修改后问题解决。

[grid@node2bin]$pwd/u01/app/11.2.0/grid/bin[grid@node2bin]$lloracle-rwxr-x--x1gridoinstall2098541495月1615:36oracle[grid@node2bin]$chmod+soracle[grid@node2bin]$lloracle-rwsr-s--x1gridoinstall2098541495月1615:36oracle

然后启动数据库：

[grid@node2bin]$srvctlstartdatabase-dorcl#查看crs状态恢复正常[grid@node2~]$crsctlstatusresNAME=ora.DATA.dgTYPE=ora.diskgroup.typeTARGET=ONLINE,ONLINESTATE=ONLINEonnode1,ONLINEonnode2NAME=ora.LISTENER.lsnrTYPE=ora.listener.typeTARGET=ONLINE,ONLINESTATE=ONLINEonnode1,ONLINEonnode2NAME=ora.LISTENER_SCAN1.lsnrTYPE=ora.scan_listener.typeTARGET=ONLINESTATE=ONLINEonnode1NAME=ora.OCRVOTE.dgTYPE=ora.diskgroup.typeTARGET=ONLINE,ONLINESTATE=ONLINEonnode1,ONLINEonnode2NAME=ora.asmTYPE=ora.asm.typeTARGET=ONLINE,ONLINESTATE=INTERMEDIATEonnode1,ONLINEonnode2NAME=ora.cvuTYPE=ora.cvu.typeTARGET=ONLINESTATE=ONLINEonnode1NAME=ora.gsdTYPE=ora.gsd.typeTARGET=OFFLINE,OFFLINESTATE=OFFLINE,OFFLINENAME=ora.net1.networkTYPE=ora.network.typeTARGET=ONLINE,ONLINESTATE=ONLINEonnode1,ONLINEonnode2NAME=ora.node1.vipTYPE=ora.cluster_vip_net1.typeTARGET=ONLINESTATE=ONLINEonnode1NAME=ora.node2.vipTYPE=ora.cluster_vip_net1.typeTARGET=ONLINESTATE=ONLINEonnode2NAME=ora.oc4jTYPE=ora.oc4j.typeTARGET=ONLINESTATE=ONLINEonnode1NAME=ora.onsTYPE=ora.ons.typeTARGET=ONLINE,ONLINESTATE=ONLINEonnode1,ONLINEonnode2NAME=ora.orcl.dbTYPE=ora.database.typeTARGET=ONLINE,ONLINESTATE=ONLINEonnode1,ONLINEonnode2NAME=ora.scan1.vipTYPE=ora.scan_vip.typeTARGET=ONLINESTATE=ONLINEonnode1#查看数据库进程[grid@node2~]$ps-ef|grepora_oracle92711019:09?00:00:00ora_pmon_orcl2oracle92731019:09?00:00:00ora_psp0_orcl2oracle92751119:09?00:00:06ora_vktm_orcl2oracle92791019:09?00:00:00ora_gen0_orcl2oracle92811019:09?00:00:00ora_diag_orcl2oracle92831019:09?00:00:00ora_dbrm_orcl2oracle92851019:09?00:00:00ora_ping_orcl2oracle92871019:09?00:00:00ora_acms_orcl2oracle92891019:09?00:00:00ora_dia0_orcl2oracle92911019:09?00:00:00ora_lmon_orcl2oracle92931019:09?00:00:01ora_lmd0_orcl2oracle92951019:09?00:00:01ora_lms0_orcl2oracle92991019:09?00:00:00ora_rms0_orcl2oracle93011019:09?00:00:00ora_lmhb_orcl2oracle93031019:09?00:00:00ora_mman_orcl2oracle93051019:09?00:00:00ora_dbw0_orcl2oracle93071019:09?00:00:00ora_lgwr_orcl2oracle93091019:09?00:00:00ora_ckpt_orcl2oracle93111019:09?00:00:00ora_smon_orcl2oracle93131019:09?00:00:00ora_reco_orcl2oracle93151019:09?00:00:00ora_rbal_orcl2oracle93171019:09?00:00:00ora_asmb_orcl2oracle93191019:09?00:00:00ora_mmon_orcl2oracle93231019:09?00:00:00ora_mmnl_orcl2oracle93251019:09?00:00:00ora_d000_orcl2oracle93271019:09?00:00:00ora_mark_orcl2oracle93291019:09?00:00:00ora_s000_orcl2oracle93351019:09?00:00:00ora_lck0_orcl2oracle93371019:09?00:00:00ora_rsmn_orcl2oracle94001019:10?00:00:00ora_gtx0_orcl2oracle94021019:10?00:00:00ora_rcbg_orcl2oracle94041019:10?00:00:00ora_qmnc_orcl2oracle94331019:10?00:00:00ora_cjq0_orcl2oracle94431019:10?00:00:00ora_q000_orcl2oracle94451019:10?00:00:00ora_q001_orcl2oracle96571019:15?00:00:00ora_smco_orcl2oracle96591019:15?00:00:00ora_w000_orcl2oracle96841019:16?00:00:00ora_pz99_orcl2grid97029501019:17pts/100:00:00grep--color=autoora_[grid@node2~]$crs_stat-tNameTypeTargetStateHost------------------------------------------------------------ora.DATA.dgora....up.typeONLINEONLINEnode1ora....ER.lsnrora....er.typeONLINEONLINEnode1ora....N1.lsnrora....er.typeONLINEONLINEnode1ora.OCRVOTE.dgora....up.typeONLINEONLINEnode1ora.asmora.asm.typeONLINEONLINEnode1ora.cvuora.cvu.typeONLINEONLINEnode1ora.gsdora.gsd.typeOFFLINEOFFLINEora....networkora....rk.typeONLINEONLINEnode1ora....SM1.asmapplicationONLINEONLINEnode1ora....E1.lsnrapplicationONLINEONLINEnode1ora.node1.gsdapplicationOFFLINEOFFLINEora.node1.onsapplicationONLINEONLINEnode1ora.node1.vipora....t1.typeONLINEONLINEnode1ora....SM2.asmapplicationONLINEONLINEnode2ora....E2.lsnrapplicationONLINEONLINEnode2ora.node2.gsdapplicationOFFLINEOFFLINEora.node2.onsapplicationONLINEONLINEnode2ora.node2.vipora....t1.typeONLINEONLINEnode2ora.oc4jora.oc4j.typeONLINEONLINEnode1ora.onsora.ons.typeONLINEONLINEnode1ora.orcl.dbora....se.typeONLINEONLINEnode1ora.scan1.vipora....ip.typeONLINEONLINEnode1

再次检查数据库状态，恢复正常：

[oracle@node2~]$sqlplus/assysdbaSQL*Plus:Release11.2.0.4.0ProductiononWedMay1719:40:372017Copyright(c)1982,2013,Oracle.Allrightsreserved.Connectedto:OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptionsSQL>SELECTinst_id,instance_numberinst_no,instance_nameinst_name,parallel,status,database_statusdb_status,active_statestate,host_namehostFROMgv$instanceORDERBYinst_id;INST_IDINST_NOINST_NAMEPARSTATUSDB_STATUS--------------------------------------------------------------------STATEHOST-------------------------------------------------------------------------11orcl1YESOPENACTIVENORMALnode122orcl2YESOPENACTIVENORMALnode2SQL>

以上是“orcle 11g rac crs状态正常但节点2数据库未启动怎么办”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注亿速云行业资讯频道！