AskDBA.org Forum » Tag: multipathing

AskDBA.org Forum » Tag: multipathing - Recent Topics http://www.forum.askdba.org/ Forum for Oracle DBA's en Sat, 11 Feb 2012 13:22:56 +0000 deepika.dhamija@gmail.com on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-103 Tue, 08 Dec 2009 09:37:34 +0000 deepika.dhamija@gmail.com 103@http://www.forum.askdba.org/ Hi I have a 2node RAC Setup 10gR2. I have three ASM Volumes configured, out of devices sdb2, sdb3, sdb4 /etc/init.d/oracleasm createdisk VOL1 /dev/sdb2 /etc/init.d/oracleasm createdisk VOL2 /dev/sdb3 /etc/init.d/oracleasm createdisk VOL3 /dev/sdb4. where VOL1 & VOL2 belong to the Disk Group ORCL_DATA1 and Vol3 to the group FLASH_RECOVERY_AREA. I want to use the multipath disks namely /dev/multipath/sdb2, /dev/multipath/sdb3 and /dev/multipath/sdb4 for asm volumes. I created the multipath disks on node1 and edited the file /etc/sysconfig/oracleasm and set ORACLEASM_SCANORDER="multipath" and ORACLEASM_SCANEXCLUDE="sdb2 sdb3 sdb4". After a Reboot, the crs_stat shows On Node1 -------------------------------------------------------------------------------- Name Type Target State Host -------------------------------------------------------------------------------- ora....SM1.asm application ONLINE ONLINE linux1 ora....X1.lsnr application ONLINE ONLINE linux1 ora.linux1.gsd application ONLINE ONLINE linux1 ora.linux1.ons application ONLINE ONLINE linux1 ora.linux1.vip application ONLINE ONLINE linux1 ora....SM2.asm application ONLINE ONLINE linux2 ora....X2.lsnr application ONLINE ONLINE linux2 ora.linux2.gsd application ONLINE ONLINE linux2 ora.linux2.ons application ONLINE ONLINE linux2 ora.linux2.vip application ONLINE ONLINE linux2 ora.orcl.db application ONLINE ONLINE linux1 ora....l1.inst application ONLINE OFFLINE ora....l2.inst application ONLINE ONLINE linux2 ora....test.cs application ONLINE ONLINE linux2 ora....cl1.srv application ONLINE OFFLINE ora....cl2.srv application ONLINE ONLINE linux2 oracle@linux1 ~$ sqlplus "/ as sysdba" SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 8 12:04:53 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> select name, path from v$asm_disk; select name, path from v$asm_disk * ERROR at line 1: ORA-01034: ORACLE not available I try to start the instance manually, oracle@linux1 ~$ srvctl start instance -d orcl -i orcl1 PRKP-1001 : Error starting instance orcl1 on node linux1 CRS-0215: Could not start resource 'ora.orcl.orcl1.inst'. Also from sql SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+ORCL_DATA1/orcl/spfileorcl.ora' ORA-17503: ksfdopn:2 Failed to open file +ORCL_DATA1/orcl/spfileorcl.ora ORA-15077: could not locate ASM instance serving a required diskgroup On Node2 -------------------------------------------------------------------------------- oracle@linux2 ~$ sqlplus "/ as sysdba" SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 8 11:56:13 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options SQL> select name, path from v$asm_disk; NAME -------------------------------------------------------------------------------- PATH -------------------------------------------------------------------------------- VOL1 ORCL:VOL1 VOL2 ORCL:VOL2 VOL3 ORCL:VOL3 Plz note, that I have the multipath devices only on one node currently. I am new to the multipathing concept. Plz advise, on what (above) steps are wrong and what additional things are to be taken care of. And the causes/solutions to the errors.