Shulou(Shulou.com)05/31 Report--

Editor to share with you what to do when the orcle 11g rac crs status is normal but the Node 2 database is not started. I believe most people don't know much about it, so share this article for your reference. I hope you will gain a lot after reading this article. Let's learn about it together.

Orcle 11g rac crs status is normal, Node 2 database is not started

After installing oracle11g R2 rac, view the database status on node 1:

[oracle@node1] $sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Wed May 17 18:56:34 2017Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionsSQL > SELECT inst_id, instance_number inst_no, instance_name inst_name, parallel, status, database_status db_status, active_state state, host_name host FROM gv$instance ORDER BY inst_id INST_ID INST_NO INST_NAME PAR STATUS DB_STATUS--STATE HOST-- -1 1 orcl1 YES OPEN ACTIVENORMAL node1SQL > SQL > quit# found no database information for node 2

View the database status on node 2:

[oracle@node2] $sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Wed May 17 18:57:48 2017Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL > SQL > SELECT inst_id, instance_number inst_no, instance_name inst_name, parallel, status, database_status db_status, active_state state, host_name host FROM gv$instance ORDER BY inst_id; SELECT inst_id, instance_number inst_no, instance_name inst_name, parallel, status, database_status db_status, active_state state, host_name host FROM gv$instance ORDER BY inst_id*ERROR at line 1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0SQL > quit

Show that the database is not available. Check the database process and find that the database process is not available:

[oracle@node2 ~] $ps-ef | grep ora_oracle 8718 8048 0 18:58 pts/0 00:00:00 grep-- color=auto ora_

View CRS status:

[grid@node2] $crs_stat-tName Type Target State Host-ora.DATA.dg ora....up.type ONLINE ONLINE node1 ora.... ER.lsnr ora....er.type ONLINE ONLINE node1 ora....N1.lsnr ora....er.type ONLINE ONLINE node1 ora.OCRVOTE.dg ora....up.type ONLINE ONLINE node1 ora.asm ora.asm.type ONLINE ONLINE node1 ora.cvu ora.cvu.type ONLINE ONLINE node1 ora.gsd ora.gsd.type OFFLINE OFFLINE Ora....network ora....rk.type ONLINE ONLINE node1 ora....SM1.asm application ONLINE ONLINE node1 ora....E1.lsnr application ONLINE ONLINE node1 ora.node1.gsd application OFFLINE OFFLINE ora.node1.ons application ONLINE ONLINE node1 ora.node1.vip ora....t1.type ONLINE ONLINE node1 ora.. .. SM2.asm application ONLINE ONLINE node2 ora....E2.lsnr application ONLINE ONLINE node2 ora.node2.gsd application OFFLINE OFFLINE ora.node2.ons application ONLINE ONLINE node2 ora.node2.vip ora....t1.type ONLINE ONLINE node2 ora.oc4j ora.oc4j.type ONLINE ONLINE node1 ora.ons ora.ons.type ONLINE ONLINE Node1 ora.orcl.db ora....se.type ONLINE ONLINE node1 ora.scan1.vip ora....ip.type ONLINE ONLINE node1 [grid@node2 ~] $crsctl status resNAME=ora.DATA.dgTYPE=ora.diskgroup.typeTARGET=ONLINE ONLINESTATE=ONLINE on node1, ONLINE on node2NAME=ora.LISTENER.lsnrTYPE=ora.listener.typeTARGET=ONLINE, ONLINESTATE=ONLINE on node1, ONLINE on node2NAME=ora.LISTENER_SCAN1.lsnrTYPE=ora.scan_listener.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.OCRVOTE.dgTYPE=ora.diskgroup.typeTARGET=ONLINE, ONLINESTATE=ONLINE on node1, ONLINE on node2NAME=ora.asmTYPE=ora.asm.typeTARGET=ONLINE, ONLINESTATE=INTERMEDIATE on node1, ONLINE on node2NAME=ora.cvuTYPE=ora.cvu.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.gsdTYPE=ora.gsd.typeTARGET=OFFLINE, OFFLINESTATE=OFFLINE, OFFLINENAME=ora.net1.networkTYPE=ora.network.typeTARGET=ONLINE, ONLINESTATE=ONLINE on node1 ONLINE on node2NAME=ora.node1.vipTYPE=ora.cluster_vip_net1.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.node2.vipTYPE=ora.cluster_vip_net1.typeTARGET=ONLINESTATE=ONLINE on node2NAME=ora.oc4jTYPE=ora.oc4j.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.onsTYPE=ora.ons.typeTARGET=ONLINE, ONLINESTATE=ONLINE on node1, ONLINE on node2NAME=ora.orcl.dbTYPE=ora.database.typeTARGET=ONLINE, ONLINESTATE=ONLINE on node1, OFFLINE-this shows that ora.orcl.db is OFFLINENAME=ora.scan1.vipTYPE=ora.scan_vip.typeTARGET=ONLINESTATE=ONLINE on node1 on node2

Manually start the database on node 2:

[grid@node2 ~] $srvctl start database-d orclPRCC-1014: orcl is already running PRCR-1004: resource ora.orcl.db is already running PRCR-1079: unable to start resource ora.orcl.dbCRS-5017: The resource action "ora.orcl.db start" encountered the following error: ORA-01078: failure in processing system parametersORA-01565: error in identifying file'+ DATA/orcl/spfileorcl.ora'ORA-17503: ksfdopn:2 Failed to open file + DATA/orcl/spfileorcl.oraORA-12547: TNS:lost contact. For details refer to "(: CLSN00107:)" in "/ u01/app/11.2.0/grid/log/node2/agent/crsd/oraagent_oracle/oraagent_oracle.log" .CRS-2674: Start of 'ora.orcl.db' on' node2' failedCRS-2528: Unable to place an instance of 'ora.orcl.db' as all possible servers are occupied by the resource

Solution:

It is thought that the attribute of $ORACLE_HOME/bin/oracle under the grid user was modified when Oracle 11gR2 RAC DBCA could not recognize the ASM disk group. At that time, the dbca could not access the created ASM disk group because of a permission problem. The error of viewing ORA-17503 seems to be a permission problem, and the problem is solved after modification in the same way.

[grid@node2 bin] $pwd/u01/app/11.2.0/grid/bin [grid@node2 bin] $ll oracle-rwxr-x--x 1 grid oinstall 209854149 May 16 15:36 oracle [grid@node2 bin] $chmod + s oracle [grid@node2 bin] $ll oracle-rwsr-s--x 1 grid oinstall 209854149 May 16 15:36 oracle

Then start the database:

[grid@node2 bin] $srvctl start database-d orcl# View crs status back to normal [grid@node2 ~] $crsctl status resNAME=ora.DATA.dgTYPE=ora.diskgroup.typeTARGET=ONLINE, ONLINESTATE=ONLINE on node1, ONLINE on node2NAME=ora.LISTENER.lsnrTYPE=ora.listener.typeTARGET=ONLINE, ONLINESTATE=ONLINE on node1, ONLINE on node2NAME=ora.LISTENER_SCAN1.lsnrTYPE=ora.scan_listener.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.OCRVOTE.dgTYPE=ora.diskgroup.typeTARGET=ONLINE, ONLINESTATE=ONLINE on node1, ONLINE on node2NAME=ora.asmTYPE=ora.asm.typeTARGET=ONLINE, ONLINESTATE=INTERMEDIATE on node1 ONLINE on node2NAME=ora.cvuTYPE=ora.cvu.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.gsdTYPE=ora.gsd.typeTARGET=OFFLINE, OFFLINESTATE=OFFLINE, OFFLINENAME=ora.net1.networkTYPE=ora.network.typeTARGET=ONLINE, ONLINESTATE=ONLINE on node1, ONLINE on node2NAME=ora.node1.vipTYPE=ora.cluster_vip_net1.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.node2.vipTYPE=ora.cluster_vip_net1.typeTARGET=ONLINESTATE=ONLINE on node2NAME=ora.oc4jTYPE=ora.oc4j.typeTARGET=ONLINESTATE=ONLINE on node1NAME=ora.onsTYPE=ora.ons.typeTARGET=ONLINE, ONLINESTATE=ONLINE on node1, ONLINE on node2NAME=ora.orcl.dbTYPE=ora.database.typeTARGET=ONLINE, ONLINESTATE=ONLINE on node1 ONLINE on node2NAME=ora.scan1.vipTYPE=ora.scan_vip.typeTARGET=ONLINESTATE=ONLINE on node1# View Database process [grid@node2 ~] $ps-ef | grep ora_oracle 9271 10 19:09? 00:00:00 ora_pmon_orcl2oracle 9273 10 19:09? 00:00:00 ora_psp0_orcl2oracle 9275 1 1 19:09? 00:00:06 ora_vktm_orcl2oracle 9279 10 19:09? 00:00:00 ora_gen0_orcl2oracle 9281 1 0 19:09? 00:00:00 ora_diag_orcl2oracle 9283 1 0 19:09? 00:00:00 ora_dbrm_orcl2oracle 9285 1 0 19:09? 00:00:00 ora_ping_orcl2oracle 9287 1 0 19:09? 00:00:00 ora_acms_orcl2oracle 9289 1 0 19:09? 00:00:00 ora_dia0_orcl2oracle 9291 1 0 19:09? 00:00:00 ora_lmon_orcl2oracle 9293 1 0 19:09? 00:00:01 ora_lmd0_orcl2oracle 9295 1 0 19:09? 00:00:01 ora_lms0_orcl2oracle 9299 1 0 19:09? 00:00:00 ora_rms0_orcl2oracle 9301 1 0 19:09? 00:00:00 ora_lmhb_orcl2oracle 9303 1 0 19:09? 00:00:00 ora_mman_orcl2oracle 9305 1 0 19:09? 00:00:00 ora_dbw0_orcl2oracle 9307 1 0 19:09? 00:00:00 ora_lgwr_orcl2oracle 9309 1 0 19:09? 00:00:00 ora_ckpt_orcl2oracle 9311 1 0 19:09? 00:00:00 ora_smon_orcl2oracle 9313 1 0 19:09? 00:00:00 ora_reco_orcl2oracle 9315 1 0 19:09? 00:00:00 ora_rbal_orcl2oracle 9317 1 0 19:09? 00:00:00 ora_asmb_orcl2oracle 9319 1 0 19:09? 00:00:00 ora_mmon_orcl2oracle 9323 1 0 19:09? 00:00:00 ora_mmnl_orcl2oracle 9325 1 0 19:09? 00:00:00 ora_d000_orcl2oracle 9327 1 0 19:09? 00:00:00 ora_mark_orcl2oracle 9329 1 0 19:09? 00:00:00 ora_s000_orcl2oracle 9335 1 0 19:09? 00:00:00 ora_lck0_orcl2oracle 9337 1 0 19:09? 00:00:00 ora_rsmn_orcl2oracle 9400 10 19:10? 00:00:00 ora_gtx0_orcl2oracle 9402 10 19:10? 00:00:00 ora_rcbg_orcl2oracle 9404 10 19:10? 00:00:00 ora_qmnc_orcl2oracle 9433 10 19:10? 00:00:00 ora_cjq0_orcl2oracle 9443 10 19:10? 00:00:00 ora_q000_orcl2oracle 9445 10 19:10? 00:00:00 ora_q001_orcl2oracle 9657 10 19:15? 00:00:00 ora_smco_orcl2oracle 9659 10 19:15? 00:00:00 ora_w000_orcl2oracle 9684 10 19:16? 00:00:00 ora_pz99_orcl2grid 9702 9501 0 19:17 pts/ 00:00:00 grep-- color=auto ora_ [grid@node2 ~] $crs_stat-tName Type Target State Host-ora.DATA.dg ora....up.type ONLINE ONLINE node1 ora....ER.lsnr ora....er.type ONLINE ONLINE node1 ora....N1.lsnr ora....er.type ONLINE ONLINE node1 ora.OCRVOTE.dg ora....up.type ONLINE ONLINE node1 ora.asm ora.asm.type ONLINE ONLINE node1 ora.cvu ora.cvu.type ONLINE ONLINE node1 ora.gsd Ora.gsd.type OFFLINE OFFLINE ora....network ora....rk.type ONLINE ONLINE node1 ora....SM1.asm application ONLINE ONLINE node1 ora....E1.lsnr application ONLINE ONLINE node1 ora.node1.gsd application OFFLINE OFFLINE ora.node1.ons application ONLINE ONLINE node1 ora.node1.vip ora....t1 .type ONLINE ONLINE node1 ora....SM2.asm application ONLINE ONLINE node2 ora....E2.lsnr application ONLINE ONLINE node2 ora.node2.gsd application OFFLINE OFFLINE ora.node2.ons application ONLINE ONLINE node2 ora.node2.vip ora....t1.type ONLINE ONLINE node2 ora.oc4j ora.oc4j.type ONLINE ONLINE node1 ora. Ons ora.ons.type ONLINE ONLINE node1 ora.orcl.db ora....se.type ONLINE ONLINE node1 ora.scan1.vip ora....ip.type ONLINE ONLINE node1

Check the database status again and return to normal:

[oracle@node2] $sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Wed May 17 19:40:37 2017Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionsSQL > SELECT inst_id, instance_number inst_no, instance_name inst_name, parallel, status, database_status db_status, active_state state, host_name host FROM gv$instance ORDER BY inst_id INST_ID INST_NO INST_NAME PAR STATUS DB_STATUS--STATE HOST-- -11 orcl1 YES OPEN ACTIVENORMAL node1 22 orcl2 YES OPEN ACTIVENORMAL node2SQL > these are all the contents of the article "what if the orcle 11g rac crs status is normal but the Node 2 database is not started" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.