<?xml version="1.0" encoding="UTF-8"?><!-- generator="bbPress" -->

<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
>

<channel>
<title>AskDBA.org Forum &#187; Forum: Automatic Storage Management - Recent Posts</title>
<link>http://www.forum.askdba.org/</link>
<description>Forum for Oracle DBA&#039;s</description>
<language>en</language>
<pubDate>Sun, 12 Feb 2012 09:53:36 +0000</pubDate>

<item>
<title>Amit Bansal on "register standby database in recovery catalog."</title>
<link>http://www.forum.askdba.org/topic/register-standby-database-in-recovery-catalog#post-188</link>
<pubDate>Sun, 17 Oct 2010 04:15:52 +0000</pubDate>
<dc:creator>Amit Bansal</dc:creator>
<guid isPermaLink="false">188@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Daniesh,&#60;/p&#62;
&#60;p&#62;Apologies, didnt read the question properly. I have not seen any configuration using different catalog for primary and standby (there could be but I havent seen it). Moreover purpose of using rman at standby site is to reduce workload on primary so that in case of failure you can restore the backup. In case of failure, you would need to connect to this very catalog. Anyways I think you can register first primary database at catalog and then take standy backups.&#60;br /&#62;
Checked docs (&#60;a href=&#34;http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmcatdb.htm#CIHECCEF&#34; rel=&#34;nofollow&#34;&#62;http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmcatdb.htm#CIHECCEF&#60;/a&#62;) and they mention that registration can only be done at primary database.&#60;/p&#62;
&#60;p&#62;-Amit
&#60;/p&#62;</description>
</item>
<item>
<title>daniesh on "register standby database in recovery catalog."</title>
<link>http://www.forum.askdba.org/topic/register-standby-database-in-recovery-catalog#post-187</link>
<pubDate>Thu, 14 Oct 2010 19:46:48 +0000</pubDate>
<dc:creator>daniesh</dc:creator>
<guid isPermaLink="false">187@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Hi,&#60;/p&#62;
&#60;p&#62;Yes i know that.&#60;br /&#62;
I guess this works when both the primary and secondary database register in the same catalog.&#60;/p&#62;
&#60;p&#62;I have already mentioned that in my question the one you are referring if both the database are in the same catalog then the standby database will automatically get registered in the catalog database if the catalog database is different then i dont think that standby database will automatically get registered in database.&#60;/p&#62;
&#60;p&#62;Your assistance is much appreciated in this regards,&#60;/p&#62;
&#60;p&#62;Thanks
&#60;/p&#62;</description>
</item>
<item>
<title>Saurabh Sood on "register standby database in recovery catalog."</title>
<link>http://www.forum.askdba.org/topic/register-standby-database-in-recovery-catalog#post-186</link>
<pubDate>Thu, 14 Oct 2010 07:58:35 +0000</pubDate>
<dc:creator>Saurabh Sood</dc:creator>
<guid isPermaLink="false">186@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;You can check the following OTN discussion for this:&#60;/p&#62;
&#60;p&#62;&#60;a href=&#34;http://forums.oracle.com/forums/thread.jspa?threadID=536520&#34; rel=&#34;nofollow&#34;&#62;http://forums.oracle.com/forums/thread.jspa?threadID=536520&#60;/a&#62;
&#60;/p&#62;</description>
</item>
<item>
<title>Amit Bansal on "register standby database in recovery catalog."</title>
<link>http://www.forum.askdba.org/topic/register-standby-database-in-recovery-catalog#post-185</link>
<pubDate>Wed, 13 Oct 2010 13:20:55 +0000</pubDate>
<dc:creator>Amit Bansal</dc:creator>
<guid isPermaLink="false">185@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Daniesh,&#60;/p&#62;
&#60;p&#62;You are not required to register standby database in recovery catalog. Oracle will understand that this is standby database (even though they share same dbid)&#60;/p&#62;
&#60;p&#62;Hope this helps
&#60;/p&#62;</description>
</item>
<item>
<title>daniesh on "register standby database in recovery catalog."</title>
<link>http://www.forum.askdba.org/topic/register-standby-database-in-recovery-catalog#post-184</link>
<pubDate>Thu, 07 Oct 2010 17:27:36 +0000</pubDate>
<dc:creator>daniesh</dc:creator>
<guid isPermaLink="false">184@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Hi,&#60;/p&#62;
&#60;p&#62;Can we register the standby database in recovery catalog.&#60;br /&#62;
I know that if the catalog database is same for both the standby and primary then both will have same dbid and we can use unique dbid.&#60;br /&#62;
However in our case, Catalog is different for primary and standby whenever i try to register the standby database. I am getting the below error.&#60;/p&#62;
&#60;p&#62;RMAN&#38;gt; register database;&#60;/p&#62;
&#60;p&#62;RMAN-00571: ===========================================================&#60;br /&#62;
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============&#60;br /&#62;
RMAN-00571: ===========================================================&#60;br /&#62;
RMAN-03002: failure of register command at 10/07/2010 18:26:04&#60;br /&#62;
RMAN-08040: full resync skipped, control file is not current or backup&#60;/p&#62;
&#60;p&#62;Can you please let me know your view on this?&#60;/p&#62;
&#60;p&#62;Thanks in advance.
&#60;/p&#62;</description>
</item>
<item>
<title>taraldesai on "ASM DiskGroup"</title>
<link>http://www.forum.askdba.org/topic/asm-diskgroup#post-182</link>
<pubDate>Wed, 15 Sep 2010 15:09:36 +0000</pubDate>
<dc:creator>taraldesai</dc:creator>
<guid isPermaLink="false">182@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Sorry for late reply I was on vacation. Thanks Amit for information.
&#60;/p&#62;</description>
</item>
<item>
<title>Amit Bansal on "ASM DiskGroup"</title>
<link>http://www.forum.askdba.org/topic/asm-diskgroup#post-180</link>
<pubDate>Mon, 30 Aug 2010 04:57:44 +0000</pubDate>
<dc:creator>Amit Bansal</dc:creator>
<guid isPermaLink="false">180@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Taral,&#60;/p&#62;
&#60;p&#62;When you don't define failgroup while creating normal redundancy diskgroup, oracle would automatically create diskgroup for you. Run following query to identify this&#60;/p&#62;
&#60;p&#62;select name,path,failgroup,header_status from V$ASM_DISKGROUP;
&#60;/p&#62;</description>
</item>
<item>
<title>taraldesai on "ASM DiskGroup"</title>
<link>http://www.forum.askdba.org/topic/asm-diskgroup#post-179</link>
<pubDate>Sun, 29 Aug 2010 18:52:22 +0000</pubDate>
<dc:creator>taraldesai</dc:creator>
<guid isPermaLink="false">179@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Hi Amit/Saurabh,&#60;/p&#62;
&#60;p&#62;I have question regarding adding diskgroup. Let's say if we add any diskgroup with normal redundancy without using failgroup it will create diskgroup. So, how redundancy is maintained. Where would it write block image on same disk.
&#60;/p&#62;</description>
</item>
<item>
<title>Amit Bansal on "What are the pre-requisites of ASM on AIX 6.1?"</title>
<link>http://www.forum.askdba.org/topic/what-are-the-pre-requisites-of-asm-on-aix-61#post-165</link>
<pubDate>Thu, 24 Jun 2010 06:56:00 +0000</pubDate>
<dc:creator>Amit Bansal</dc:creator>
<guid isPermaLink="false">165@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Hi Bhatia,&#60;/p&#62;
&#60;p&#62;I do not think that there are separate pre-requisites for ASM . You need to ensure that you apply all packages mentioned in OS pre-requisite for oracle installation. Also check for MOS (Metalink) to ensure that your version is certified to run on AIX 6.1&#60;/p&#62;
&#60;p&#62;Cheers&#60;br /&#62;
Amit
&#60;/p&#62;</description>
</item>
<item>
<title>bhatia.ish@gmail.com on "What are the pre-requisites of ASM on AIX 6.1?"</title>
<link>http://www.forum.askdba.org/topic/what-are-the-pre-requisites-of-asm-on-aix-61#post-164</link>
<pubDate>Tue, 22 Jun 2010 11:29:28 +0000</pubDate>
<dc:creator>bhatia.ish@gmail.com</dc:creator>
<guid isPermaLink="false">164@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Hi,&#60;/p&#62;
&#60;p&#62;What are the pre-requisites of ASM on AIX 6.1?&#60;/p&#62;
&#60;p&#62;Regards,&#60;br /&#62;
Bhatia
&#60;/p&#62;</description>
</item>
<item>
<title>Anonymous on "PKRS-1009 failed to start ASM instance"</title>
<link>http://www.forum.askdba.org/topic/pkrs-1009-failed-to-start-asm-instance#post-156</link>
<pubDate>Wed, 02 Jun 2010 08:12:10 +0000</pubDate>
<dc:creator>Anonymous</dc:creator>
<guid isPermaLink="false">156@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Permissions on init+ASM2.ora is right.I am only facing this problem when i was starting ASM through srvctl command otherwise it's working fine.&#60;/p&#62;
&#60;p&#62;Please note this point.
&#60;/p&#62;</description>
</item>
<item>
<title>deepika.dhamija@gmail.com on "ASM and Multipathing"</title>
<link>http://www.forum.askdba.org/topic/asm-and-multipathing#post-111</link>
<pubDate>Wed, 09 Dec 2009 12:29:40 +0000</pubDate>
<dc:creator>deepika.dhamija@gmail.com</dc:creator>
<guid isPermaLink="false">111@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Amit,&#60;/p&#62;
&#60;p&#62;I am finally able to achieve what I intended to do.&#60;/p&#62;
&#60;p&#62;Many Thanks to you for your valuable suggestions.
&#60;/p&#62;</description>
</item>
<item>
<title>Amit Bansal on "ASM and Multipathing"</title>
<link>http://www.forum.askdba.org/topic/asm-and-multipathing#post-110</link>
<pubDate>Wed, 09 Dec 2009 09:30:43 +0000</pubDate>
<dc:creator>Amit Bansal</dc:creator>
<guid isPermaLink="false">110@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Hi,&#60;/p&#62;
&#60;p&#62;&#38;gt;&#38;gt;Actually I have an application that runs on every node on the cluster and creates the devices /dev/multipath/sd*&#60;/p&#62;
&#60;p&#62;Can't understand this statement.&#60;br /&#62;
Anyways if you use udev, you can set permissions in rules file&#60;/p&#62;
&#60;p&#62;/etc/udev/rules.d/50-udev.rules&#60;/p&#62;
&#60;p&#62;I think your sysadmin can help you with that.&#60;/p&#62;
&#60;p&#62;-Amit
&#60;/p&#62;</description>
</item>
<item>
<title>deepika.dhamija@gmail.com on "ASM and Multipathing"</title>
<link>http://www.forum.askdba.org/topic/asm-and-multipathing#post-109</link>
<pubDate>Wed, 09 Dec 2009 09:03:19 +0000</pubDate>
<dc:creator>deepika.dhamija@gmail.com</dc:creator>
<guid isPermaLink="false">109@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Hi Amit,&#60;/p&#62;
&#60;p&#62;Actually I have an application that runs on every node on the cluster and creates the devices /dev/multipath/sd*. I am new to this entire setup, but I can tell you that it uses udev.&#60;br /&#62;
On Node 1&#60;br /&#62;
[oracle@linux1 ~]$ uname -a&#60;br /&#62;
Linux linux1 2.6.9-78.0.13.ELsmp #1 SMP Wed Jan 7 17:52:47 EST 2009 i686 i686 i386 GNU/Linux&#60;/p&#62;
&#60;p&#62;Does this much information answer your questions?
&#60;/p&#62;</description>
</item>
<item>
<title>Amit Bansal on "ASM and Multipathing"</title>
<link>http://www.forum.askdba.org/topic/asm-and-multipathing#post-108</link>
<pubDate>Wed, 09 Dec 2009 07:58:21 +0000</pubDate>
<dc:creator>Amit Bansal</dc:creator>
<guid isPermaLink="false">108@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Deepika,&#60;/p&#62;
&#60;p&#62;How have you configured multipathing? Are you using udev and device mapper?&#60;br /&#62;
Also let me know your linux release details.&#60;/p&#62;
&#60;p&#62;-Amit
&#60;/p&#62;</description>
</item>
<item>
<title>deepika.dhamija@gmail.com on "ASM and Multipathing"</title>
<link>http://www.forum.askdba.org/topic/asm-and-multipathing#post-107</link>
<pubDate>Wed, 09 Dec 2009 07:10:39 +0000</pubDate>
<dc:creator>deepika.dhamija@gmail.com</dc:creator>
<guid isPermaLink="false">107@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Thanks Amit for the prompt reply.&#60;/p&#62;
&#60;p&#62;I had ORACLE_SID SET to orcl1 and orcl2 on both the nodes respectively.&#60;/p&#62;
&#60;p&#62;On node1, I did the above steps, and I luckily was able to connect to Oracle. It did not say 'connected to idle instance'.&#60;/p&#62;
&#60;p&#62;The O/P of the query on Node1 (ORACLE_SID=+ASM1) is&#60;br /&#62;
NAME	PATH		MOUNT_S		HEADER_STATUS&#60;br /&#62;
	ORCL:VOL1	CLOSED		UNKNOWN&#60;br /&#62;
	ORCL:VOL1	CLOSED		UNKNOWN&#60;br /&#62;
	ORCL:VOL1	CLOSED		UNKNOWN&#60;/p&#62;
&#60;p&#62;The O/P of the query on Node2 (ORACLE_SID=orcl2) is&#60;br /&#62;
NAME	PATH		MOUNT_S		HEADER_STATUS&#60;br /&#62;
VOL1	ORCL:VOL1	OPENED		UNKNOWN&#60;br /&#62;
VOL2	ORCL:VOL2	OPENED		UNKNOWN&#60;br /&#62;
VOL3	ORCL:VOL3	OPENED		UNKNOWN&#60;/p&#62;
&#60;p&#62;Does that mean that the multipath disks have not been picked up by asm at all.&#60;br /&#62;
What about the permissions. I ran the foll commands (for sdb2, sdb3, sdb4) on Node1&#60;br /&#62;
# chown -R oracle:dba /dev/multipath/sdb2&#60;br /&#62;
# chmod -R 775 /dev/multipath/sdb2&#60;/p&#62;
&#60;p&#62;# /etc/init.d/oracleasm scandisks&#60;br /&#62;
# /etc/init.d/oracleasm listdisks&#60;br /&#62;
VOL1&#60;br /&#62;
VOL2&#60;br /&#62;
VOL3&#60;/p&#62;
&#60;p&#62;How do these permissions remain intact after a reboot to the node?
&#60;/p&#62;</description>
</item>
<item>
<title>Amit Bansal on "ASM and Multipathing"</title>
<link>http://www.forum.askdba.org/topic/asm-and-multipathing#post-106</link>
<pubDate>Wed, 09 Dec 2009 06:54:50 +0000</pubDate>
<dc:creator>Amit Bansal</dc:creator>
<guid isPermaLink="false">106@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Hi,&#60;/p&#62;
&#60;p&#62;Try logging into ASM instance and query V$ASM_DISK i.e&#60;/p&#62;
&#60;p&#62;export ORACLE_SID=+ASM1&#60;br /&#62;
sqlplus &#34;/ as sysdba&#34;&#60;br /&#62;
select name,path,mount_status,header_status from V$ASM_DISK;&#60;/p&#62;
&#60;p&#62;with regards to naming convention, I think naming convention should follow /dev/[a-z]* naming convention instead of /dev/multipath/[a-z]*&#60;br /&#62;
It could be this or it could be that as the name of multipath device is also ending with sdb2,sdb3 and we are also excluding the disk ending with sdb2,sdb3. I am not too sure on this.&#60;/p&#62;
&#60;p&#62;I think best way would be to actually first query V$ASM_DISK output.
&#60;/p&#62;</description>
</item>
<item>
<title>deepika.dhamija@gmail.com on "ASM and Multipathing"</title>
<link>http://www.forum.askdba.org/topic/asm-and-multipathing#post-105</link>
<pubDate>Wed, 09 Dec 2009 06:33:44 +0000</pubDate>
<dc:creator>deepika.dhamija@gmail.com</dc:creator>
<guid isPermaLink="false">105@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Hi Amit,&#60;/p&#62;
&#60;p&#62;Yes, I am following the above URL.&#60;/p&#62;
&#60;p&#62;On Node1:&#60;br /&#62;
[root@linux1 ~]# /etc/init.d/oracleasm listdisks&#60;br /&#62;
VOL1&#60;br /&#62;
VOL2&#60;br /&#62;
VOL3&#60;br /&#62;
[root@linux1 ~]# /etc/init.d/oracleasm querydisk /dev/multipath/sdb2&#60;br /&#62;
Device &#34;/dev/multipath/sdb2&#34; is marked an ASM disk with the label &#34;VOL1&#34;&#60;br /&#62;
[root@linux1 ~]# /etc/init.d/oracleasm querydisk /dev/sdb2&#60;br /&#62;
Device &#34;/dev/sdb2&#34; is marked an ASM disk with the label &#34;VOL1&#34;&#60;/p&#62;
&#60;p&#62;The O/P is same for sdb3 and sdb4 (both multipath &#38;amp; single path devices)&#60;br /&#62;
Is this what you mean when you say if disks are visible on node1?&#60;/p&#62;
&#60;p&#62;[oracle@linux1 ~]$ srvctl status asm -n linux1&#60;br /&#62;
ASM instance +ASM1 is running on node linux1.&#60;br /&#62;
[oracle@linux1 ~]$ srvctl status instance -d orcl -i orcl1&#60;br /&#62;
Instance orcl1 is not running on node linux1&#60;br /&#62;
[oracle@linux1 ~]$ srvctl start instance -d orcl -i orcl1&#60;br /&#62;
PRKP-1001 : Error starting instance orcl1 on node linux1&#60;br /&#62;
CRS-0215: Could not start resource 'ora.orcl.orcl1.inst'.&#60;br /&#62;
[oracle@linux1 ~]$&#60;/p&#62;
&#60;p&#62;I am unable to start the instance orcl1 on node1.&#60;/p&#62;
&#60;p&#62;Also what is the significance of naming multipath devices in a particular way?
&#60;/p&#62;</description>
</item>
<item>
<title>Amit Bansal on "ASM and Multipathing"</title>
<link>http://www.forum.askdba.org/topic/asm-and-multipathing#post-104</link>
<pubDate>Tue, 08 Dec 2009 13:32:15 +0000</pubDate>
<dc:creator>Amit Bansal</dc:creator>
<guid isPermaLink="false">104@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Hi Deepika,&#60;/p&#62;
&#60;p&#62;I believe you are following below article available on Oracle website&#60;/p&#62;
&#60;p&#62;&#60;a href=&#34;http://www.oracle.com/technology/tech/linux/asmlib/multipath.html&#34; rel=&#34;nofollow&#34;&#62;http://www.oracle.com/technology/tech/linux/asmlib/multipath.html&#60;/a&#62;&#60;/p&#62;
&#60;p&#62;First I believe that you should check ASM instance and see if you are able to see the disks on Node 1. From above output it looks that you connected to node 1 DB instance and not asm instance. This can also be seen from crs_stat output which shows that asm instance is up on node 1.&#60;br /&#62;
Secondly name multipath device as multipatha,multibathc instead of /multipath/sdb1 etc
&#60;/p&#62;</description>
</item>
<item>
<title>deepika.dhamija@gmail.com on "ASM and Multipathing"</title>
<link>http://www.forum.askdba.org/topic/asm-and-multipathing#post-103</link>
<pubDate>Tue, 08 Dec 2009 09:37:34 +0000</pubDate>
<dc:creator>deepika.dhamija@gmail.com</dc:creator>
<guid isPermaLink="false">103@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Hi&#60;/p&#62;
&#60;p&#62;I have a 2node RAC Setup 10gR2.&#60;/p&#62;
&#60;p&#62;I have three ASM Volumes configured, out of devices sdb2, sdb3, sdb4&#60;br /&#62;
/etc/init.d/oracleasm createdisk VOL1 /dev/sdb2&#60;br /&#62;
/etc/init.d/oracleasm createdisk VOL2 /dev/sdb3&#60;br /&#62;
/etc/init.d/oracleasm createdisk VOL3 /dev/sdb4.&#60;br /&#62;
where VOL1 &#38;amp; VOL2 belong to the Disk Group ORCL_DATA1 and Vol3 to the group FLASH_RECOVERY_AREA.&#60;/p&#62;
&#60;p&#62;I want to use the multipath disks namely /dev/multipath/sdb2, /dev/multipath/sdb3 and /dev/multipath/sdb4 for asm volumes.&#60;br /&#62;
I created the multipath disks on node1 and edited the file /etc/sysconfig/oracleasm and set ORACLEASM_SCANORDER=&#34;multipath&#34; and&#60;br /&#62;
ORACLEASM_SCANEXCLUDE=&#34;sdb2 sdb3 sdb4&#34;.&#60;/p&#62;
&#60;p&#62;After a Reboot, the crs_stat shows&#60;br /&#62;
On Node1&#60;/p&#62;
&#60;p&#62;--------------------------------------------------------------------------------&#60;br /&#62;
Name Type Target State Host&#60;/p&#62;
&#60;p&#62;--------------------------------------------------------------------------------&#60;br /&#62;
ora....SM1.asm application ONLINE ONLINE linux1&#60;br /&#62;
ora....X1.lsnr application ONLINE ONLINE linux1&#60;br /&#62;
ora.linux1.gsd application ONLINE ONLINE linux1&#60;br /&#62;
ora.linux1.ons application ONLINE ONLINE linux1&#60;br /&#62;
ora.linux1.vip application ONLINE ONLINE linux1&#60;br /&#62;
ora....SM2.asm application ONLINE ONLINE linux2&#60;br /&#62;
ora....X2.lsnr application ONLINE ONLINE linux2&#60;br /&#62;
ora.linux2.gsd application ONLINE ONLINE linux2&#60;br /&#62;
ora.linux2.ons application ONLINE ONLINE linux2&#60;br /&#62;
ora.linux2.vip application ONLINE ONLINE linux2&#60;br /&#62;
ora.orcl.db application ONLINE ONLINE linux1&#60;br /&#62;
ora....l1.inst application ONLINE OFFLINE&#60;br /&#62;
ora....l2.inst application ONLINE ONLINE linux2&#60;br /&#62;
ora....test.cs application ONLINE ONLINE linux2&#60;br /&#62;
ora....cl1.srv application ONLINE OFFLINE&#60;br /&#62;
ora....cl2.srv application ONLINE ONLINE linux2&#60;/p&#62;
&#60;p&#62;oracle@linux1 ~$ sqlplus &#34;/ as sysdba&#34;&#60;/p&#62;
&#60;p&#62;SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 8 12:04:53 2009&#60;/p&#62;
&#60;p&#62;Copyright (c) 1982, 2005, Oracle. All rights reserved.&#60;/p&#62;
&#60;p&#62;Connected to an idle instance.&#60;/p&#62;
&#60;p&#62;SQL&#38;gt; select name, path from v$asm_disk;&#60;br /&#62;
select name, path from v$asm_disk&#60;br /&#62;
*&#60;br /&#62;
ERROR at line 1:&#60;br /&#62;
ORA-01034: ORACLE not available&#60;/p&#62;
&#60;p&#62;I try to start the instance manually,&#60;br /&#62;
oracle@linux1 ~$ srvctl start instance -d orcl -i orcl1&#60;br /&#62;
PRKP-1001 : Error starting instance orcl1 on node linux1&#60;br /&#62;
CRS-0215: Could not start resource 'ora.orcl.orcl1.inst'.&#60;/p&#62;
&#60;p&#62;Also from sql&#60;br /&#62;
SQL&#38;gt; startup&#60;br /&#62;
ORA-01078: failure in processing system parameters&#60;br /&#62;
ORA-01565: error in identifying file '+ORCL_DATA1/orcl/spfileorcl.ora'&#60;br /&#62;
ORA-17503: ksfdopn:2 Failed to open file +ORCL_DATA1/orcl/spfileorcl.ora&#60;br /&#62;
ORA-15077: could not locate ASM instance serving a required diskgroup&#60;/p&#62;
&#60;p&#62;On Node2&#60;/p&#62;
&#60;p&#62;--------------------------------------------------------------------------------&#60;br /&#62;
oracle@linux2 ~$ sqlplus &#34;/ as sysdba&#34;&#60;/p&#62;
&#60;p&#62;SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 8 11:56:13 2009&#60;/p&#62;
&#60;p&#62;Copyright (c) 1982, 2005, Oracle. All rights reserved.&#60;/p&#62;
&#60;p&#62;Connected to:&#60;br /&#62;
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production&#60;br /&#62;
With the Partitioning, Real Application Clusters, OLAP and Data Mining options&#60;/p&#62;
&#60;p&#62;SQL&#38;gt; select name, path from v$asm_disk;&#60;/p&#62;
&#60;p&#62;NAME&#60;/p&#62;
&#60;p&#62;--------------------------------------------------------------------------------&#60;br /&#62;
PATH&#60;/p&#62;
&#60;p&#62;--------------------------------------------------------------------------------&#60;br /&#62;
VOL1&#60;br /&#62;
ORCL:VOL1&#60;/p&#62;
&#60;p&#62;VOL2&#60;br /&#62;
ORCL:VOL2&#60;/p&#62;
&#60;p&#62;VOL3&#60;br /&#62;
ORCL:VOL3&#60;/p&#62;
&#60;p&#62;Plz note, that I have the multipath devices only on one node currently.&#60;/p&#62;
&#60;p&#62;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.&#60;br /&#62;
And the causes/solutions to the errors.
&#60;/p&#62;</description>
</item>
<item>
<title>Saurabh Sood on "PKRS-1009 failed to start ASM instance"</title>
<link>http://www.forum.askdba.org/topic/pkrs-1009-failed-to-start-asm-instance#post-101</link>
<pubDate>Wed, 21 Oct 2009 03:41:29 +0000</pubDate>
<dc:creator>Saurabh Sood</dc:creator>
<guid isPermaLink="false">101@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;1. For errors &#34;FAILED TO START ASM INSTANCE&#34;:&#60;/p&#62;
&#60;p&#62;Check your sqlnet.ora file, if there is any line like: SQLNET.AUTHENTICATION_SERVICES=(NTS)&#60;/p&#62;
&#60;p&#62;Remove this line and try again.&#60;/p&#62;
&#60;p&#62;2. For vip not getting started &#34;CRS-1006: No more members to consider&#34;:&#60;/p&#62;
&#60;p&#62;It is very difficult error to sort out. You have to set tracing to know the exact reason for this.&#60;br /&#62;
I had this issue one time and eventually I had to recreate the entire system. But you can try to Remove the VIP resource and add it again and see what happens. Also what is the output of :&#60;br /&#62;
$srvctl config nodeapps -n &#38;lt;nodename&#38;gt; -a -g -s -l &#60;/p&#62;
&#60;p&#62;Regards:&#60;br /&#62;
Saurabh Sood
&#60;/p&#62;</description>
</item>
<item>
<title>daniesh on "PKRS-1009 failed to start ASM instance"</title>
<link>http://www.forum.askdba.org/topic/pkrs-1009-failed-to-start-asm-instance#post-100</link>
<pubDate>Wed, 14 Oct 2009 19:50:15 +0000</pubDate>
<dc:creator>daniesh</dc:creator>
<guid isPermaLink="false">100@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Hi,&#60;/p&#62;
&#60;p&#62;I have already installed CRS and Oracle s/w and i want to install ASM&#60;br /&#62;
however when i try to install asm using DBCA.,&#60;/p&#62;
&#60;p&#62;I am getting error.&#60;/p&#62;
&#60;p&#62;please help me on this.&#60;/p&#62;
&#60;p&#62;Thanks,
&#60;/p&#62;</description>
</item>
<item>
<title>daniesh on "PKRS-1009 failed to start ASM instance"</title>
<link>http://www.forum.askdba.org/topic/pkrs-1009-failed-to-start-asm-instance#post-99</link>
<pubDate>Tue, 13 Oct 2009 20:05:20 +0000</pubDate>
<dc:creator>daniesh</dc:creator>
<guid isPermaLink="false">99@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Hi ,&#60;br /&#62;
thanks for the reply.&#60;/p&#62;
&#60;p&#62;yes ORACLE and ASM  home are same&#60;br /&#62;
please see the output below.&#60;br /&#62;
[oracle@rac2 bin]$./crs_stat -t&#60;br /&#62;
Name          Type          Target   State     Host&#60;br /&#62;
--------------------------------------------------------------&#60;br /&#62;
ora...SM1.asm application   ONLINE   OFFLINE&#60;br /&#62;
ora...C1.lsnr application   ONLINE   OFFLINE&#60;br /&#62;
ora.rac1.gsd  application   ONLINE   ONLINE    rac1&#60;br /&#62;
ora.rac1.ons  application   ONLINE   ONLINE    rac1&#60;br /&#62;
ora.rac1.vip  application   ONLINE   OFFLINE&#60;br /&#62;
ora...SM2.asm application   ONLINE   OFFLINE&#60;br /&#62;
ora...C2.lsnr application   ONLINE   OFFLINE&#60;br /&#62;
ora.rac2.gsd  application   ONLINE   ONLINE    rac2&#60;br /&#62;
ora.rac2.ons  application   ONLINE   ONLINE    rac2&#60;br /&#62;
ora.rac2.vip  application   ONLINE   OFFLINE     &#60;/p&#62;
&#60;p&#62;you can see from the above o/p that vip is not up.&#60;br /&#62;
when i try to stop and start it up.&#60;br /&#62;
[oracle@rac1 bin ]#./crs_stop -f ora.rac1.vip&#60;br /&#62;
Target set to OFFLINE for 'ora.rac1.LISTENER_RAC1.lsnr'&#60;br /&#62;
Target set to OFFLINE for 'ora.rac1.ASM1.asm'&#60;br /&#62;
Target set to OFFLINE for 'ora.rac11.vip'&#60;/p&#62;
&#60;p&#62;[oracle@rac1 bin ]#./crs_start -f ora.rac1.vip&#60;br /&#62;
Attempting to start 'ora.rac1.vip' on member 'rac1'&#60;br /&#62;
start of 'ora.rac1.vip' on member 'rac1' failed.&#60;br /&#62;
Attempting to start 'ora.rac1.vip' on member on 'rac2'&#60;br /&#62;
start of 'ora.rac1.vip' on member 'rac2' failed.&#60;br /&#62;
CRS-1006: No more members to consider&#60;/p&#62;
&#60;p&#62;CRS-0215: Could not start resource 'ora.rac1.vip'.&#60;/p&#62;
&#60;p&#62;could you please help me on this?
&#60;/p&#62;</description>
</item>
<item>
<title>Saurabh Sood on "PKRS-1009 failed to start ASM instance"</title>
<link>http://www.forum.askdba.org/topic/pkrs-1009-failed-to-start-asm-instance#post-98</link>
<pubDate>Tue, 13 Oct 2009 06:33:30 +0000</pubDate>
<dc:creator>Saurabh Sood</dc:creator>
<guid isPermaLink="false">98@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;What do you mean by installing ASM??&#60;br /&#62;
Are you trying to start ASM instance and getting these errors?&#60;br /&#62;
What is the command that you are using?&#60;br /&#62;
Is ASM and Oracle home are same?&#60;/p&#62;
&#60;p&#62;Check the &#34;STATE&#34; of ASM resource using &#34;$ crs_stat -t&#34;&#60;br /&#62;
If it is UNKNOWN then use &#34;crs_stop -f &#38;lt;resource_name&#38;gt;&#34; to stop the resource and then try to start again.&#60;/p&#62;
&#60;p&#62;- Saurabh Sood
&#60;/p&#62;</description>
</item>
<item>
<title>daniesh on "PKRS-1009 failed to start ASM instance"</title>
<link>http://www.forum.askdba.org/topic/pkrs-1009-failed-to-start-asm-instance#post-97</link>
<pubDate>Mon, 12 Oct 2009 06:01:09 +0000</pubDate>
<dc:creator>daniesh</dc:creator>
<guid isPermaLink="false">97@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Hi ,&#60;br /&#62;
I have installed RAC on AS-4 platform. cluster and database s/w is installed successfully however when i try to install ASM i am getting an following error.&#60;br /&#62;
PKRS-1009 : failed to start ASM instance.&#60;br /&#62;
CRS-1005: failed to get required resources.&#60;br /&#62;
CRS:0223: node 1 has placement erro.&#60;/p&#62;
&#60;p&#62;could you please help me on this?&#60;/p&#62;
&#60;p&#62;Thanks,
&#60;/p&#62;</description>
</item>
<item>
<title>Amit Bansal on "asmcmd register"</title>
<link>http://www.forum.askdba.org/topic/asmcmd-register#post-96</link>
<pubDate>Thu, 01 Oct 2009 10:26:02 +0000</pubDate>
<dc:creator>Amit Bansal</dc:creator>
<guid isPermaLink="false">96@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Daniel,&#60;/p&#62;
&#60;p&#62;Please find below response to your questions..&#60;/p&#62;
&#60;p&#62;1)In RAC all instances will show same data from asmcmd. To use asmcmd, you need to export ORACLE_SID to +ASM4 by logging on 4th instance.&#60;/p&#62;
&#60;p&#62;2)When you create database using DBCA, oracle automatically add's database to the OCR. In case you wish to add instance, then use DBCA instance management option to add instance which will also register the database. In case you created db/added instance manually, then you need to use srvctl command for same&#60;/p&#62;
&#60;p&#62;Refer srvctl reference guide for more details&#60;/p&#62;
&#60;p&#62;&#60;a href=&#34;http://download.oracle.com/docs/cd/B19306_01/rac.102/b14197/srvctladmin.htm&#34; rel=&#34;nofollow&#34;&#62;http://download.oracle.com/docs/cd/B19306_01/rac.102/b14197/srvctladmin.htm&#60;/a&#62;
&#60;/p&#62;</description>
</item>
<item>
<title>daniesh on "asmcmd register"</title>
<link>http://www.forum.askdba.org/topic/asmcmd-register#post-95</link>
<pubDate>Mon, 28 Sep 2009 09:42:00 +0000</pubDate>
<dc:creator>daniesh</dc:creator>
<guid isPermaLink="false">95@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Hi,&#60;br /&#62;
sorry for the 2nd question in the above post.&#60;/p&#62;
&#60;p&#62;how can we register multiple database in a RAC?&#60;/p&#62;
&#60;p&#62;Thanks.
&#60;/p&#62;</description>
</item>
<item>
<title>daniesh on "asmcmd register"</title>
<link>http://www.forum.askdba.org/topic/asmcmd-register#post-94</link>
<pubDate>Mon, 28 Sep 2009 09:37:03 +0000</pubDate>
<dc:creator>daniesh</dc:creator>
<guid isPermaLink="false">94@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;HI,&#60;br /&#62;
Thanks for the reply.&#60;br /&#62;
suppose i have 4 instance rac database.&#60;br /&#62;
i want to see the information about 4th instance.&#60;br /&#62;
how i will do using ASMCMD command?&#60;/p&#62;
&#60;p&#62;About the above question,&#60;br /&#62;
How do we register database in RAC?&#60;br /&#62;
suppose i have 3 instance , now i want to register 4th instance.&#60;br /&#62;
how i will achieve that?&#60;/p&#62;
&#60;p&#62;Thanks
&#60;/p&#62;</description>
</item>
<item>
<title>Amit Bansal on "asmcmd register"</title>
<link>http://www.forum.askdba.org/topic/asmcmd-register#post-91</link>
<pubDate>Tue, 22 Sep 2009 10:21:03 +0000</pubDate>
<dc:creator>Amit Bansal</dc:creator>
<guid isPermaLink="false">91@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Daniesh,&#60;/p&#62;
&#60;p&#62;asmcmd is a utility and we do not need to register ASM instance to it. To use asmcmd you need to set ORACLE_HOME and ORACLE_SID variable.&#60;/p&#62;
&#60;p&#62;-Amit
&#60;/p&#62;</description>
</item>
<item>
<title>daniesh on "asmcmd register"</title>
<link>http://www.forum.askdba.org/topic/asmcmd-register#post-90</link>
<pubDate>Mon, 21 Sep 2009 13:56:02 +0000</pubDate>
<dc:creator>daniesh</dc:creator>
<guid isPermaLink="false">90@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Hi, &#60;/p&#62;
&#60;p&#62;Is there anyway to register a database using asmcmd command?
&#60;/p&#62;</description>
</item>
<item>
<title>lata on "asm tool"</title>
<link>http://www.forum.askdba.org/topic/asm-tool#post-35</link>
<pubDate>Thu, 20 Nov 2008 07:44:37 +0000</pubDate>
<dc:creator>lata</dc:creator>
<guid isPermaLink="false">35@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;what is asm tool and how to use it
&#60;/p&#62;</description>
</item>
<item>
<title>Saurabh Sood on "error while addign a disk to asm diskgroup"</title>
<link>http://www.forum.askdba.org/topic/error-while-addign-a-disk-to-asm-diskgroup#post-19</link>
<pubDate>Fri, 12 Sep 2008 16:18:31 +0000</pubDate>
<dc:creator>Saurabh Sood</dc:creator>
<guid isPermaLink="false">19@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Anu,&#60;/p&#62;
&#60;p&#62;1. Does the disk appear under v$asm_disk?&#60;br /&#62;
You can check it as:&#60;/p&#62;
&#60;p&#62;select group_number, name, path from v$asm_disk;&#60;/p&#62;
&#60;p&#62;2. Is this a new LUN created?&#60;/p&#62;
&#60;p&#62;3. Have you used  asmtoolg to delete any existing lun ?&#60;br /&#62;
If asmtoolg was used to delete any existing lun then it is mandatory to bounce the ASM instance and then try to add a lun from scratch.&#60;/p&#62;
&#60;p&#62;-Saurabh Sood
&#60;/p&#62;</description>
</item>
<item>
<title>anu.kmth on "error while addign a disk to asm diskgroup"</title>
<link>http://www.forum.askdba.org/topic/error-while-addign-a-disk-to-asm-diskgroup#post-18</link>
<pubDate>Fri, 12 Sep 2008 15:20:03 +0000</pubDate>
<dc:creator>anu.kmth</dc:creator>
<guid isPermaLink="false">18@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;1. asmtool is listing the disks as shown below.&#60;br /&#62;
--------------------------------------------------------------------&#60;br /&#62;
C:\oracle\product\10.2.0\db_1\BIN\BIN&#38;gt;asmtool -list&#60;br /&#62;
NTFS                             \Device\Harddisk0\Partition1            25595M&#60;br /&#62;
NTFS                             \Device\Harddisk1\Partition1            35998M&#60;br /&#62;
NTFS                             \Device\Harddisk1\Partition2            33994M&#60;br /&#62;
NTFS                             \Device\Harddisk2\Partition1            34994M&#60;br /&#62;
NTFS                             \Device\Harddisk3\Partition1            34946M&#60;br /&#62;
ORCLDISKASM0                     \Device\Harddisk4\Partition1             1011M&#60;br /&#62;
ORCLDISKASM2                     \Device\Harddisk5\Partition1             1011M&#60;br /&#62;
NTFS                             \Device\Harddisk7\Partition1             5122M&#60;br /&#62;
ORCLDISKASM0                     \Device\Harddisk9\Partition1             1004M&#60;br /&#62;
ORCLDISKASM1                     \Device\Harddisk10\Partition1            1004M&#60;br /&#62;
ORCLDISKASM3                     \Device\Harddisk10\Partition2            1004M&#60;br /&#62;
ORCLDISKASM0                     \Device\Harddisk10\Partition3            1004M&#60;br /&#62;
ORCLDISKASM1040                  \Device\Harddisk10\Partition4            1004M&#60;/p&#62;
&#60;p&#62;2. When tried to add ORCLDISKASM1040 to existing ASm disk group following error is seen&#60;br /&#62;
-----------------------------------------------------------&#60;/p&#62;
&#60;p&#62;SQL&#38;gt; ALTER DISKGROUP disk_group_1 ADD DISK '\\.\ORCLDISKASM1040';&#60;br /&#62;
ALTER DISKGROUP disk_group_1 ADD DISK '\\.\ORCLDISKASM1040'&#60;br /&#62;
*&#60;br /&#62;
ERROR at line 1:&#60;br /&#62;
ORA-15032: not all alterations performed&#60;br /&#62;
ORA-15031: disk specification '\\.\ORCLDISKASM1040' matches no disks&#60;/p&#62;
&#60;p&#62;Please help/suggest on how to fix this....................................
&#60;/p&#62;</description>
</item>
<item>
<title>Amit Bansal on "ASM not starting up after system reboot"</title>
<link>http://www.forum.askdba.org/topic/asm-not-starting-up-after-system-reboot#post-15</link>
<pubDate>Fri, 29 Aug 2008 07:21:04 +0000</pubDate>
<dc:creator>Amit Bansal</dc:creator>
<guid isPermaLink="false">15@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Cool!! Do update ASM alert log entry also in case issue does not resolve..
&#60;/p&#62;</description>
</item>
<item>
<title>Amit Bansal on "ASM not starting up after system reboot"</title>
<link>http://www.forum.askdba.org/topic/asm-not-starting-up-after-system-reboot#post-14</link>
<pubDate>Fri, 29 Aug 2008 07:14:36 +0000</pubDate>
<dc:creator>Amit Bansal</dc:creator>
<guid isPermaLink="false">14@http://www.forum.askdba.org/</guid>
<description>&#60;p&#62;Cool!! Do update ASM alert log entry also in case issue does not resolve..
&#60;/p&#62;</description>
</item>

</channel>
</rss>

