AskDBA.org Forum » Recent Posts

AskDBA.org Forum » Recent Posts http://www.forum.askdba.org/ AskDBA.org Forum » Recent Posts en Sat, 13 Mar 2010 16:59:09 +0000 Mahesh.G on "DR rebuild- Data restore issue" http://www.forum.askdba.org/topic/dr-rebuild-data-restore-issue#post-138 Fri, 12 Mar 2010 12:24:10 +0000 Mahesh.G 138@http://www.forum.askdba.org/ Hi, I still see the same errors even after taking control file and datafiles backup at a time. In alert log i found below error which is causing this issue. Please help me in understanding the issue and best solution for the problem. alert log shows the below errors.. Fri Mar 12 06:25:56 2010 The input backup piece /backup/ora_backup/gll88kta_9_1 is in compressed format. Error validating file dummy (5) in piece /backup/ora_backup/gll88kta_9_1: missing header Error validating file dummy (15) in piece /backup/ora_backup/gll88kta_9_1: missing header Error validating file dummy (14) in piece /backup/ora_backup/gll88kta_9_1: missing header Error validating file dummy (27) in piece /backup/ora_backup/gll88kta_9_1: missing header Error validating file dummy (10) in piece /backup/ora_backup/gll88kta_9_1: missing header Error validating file dummy (12) in piece /backup/ora_backup/gll88kta_9_1: missing header Mahesh.G Mahesh.G on "DR rebuild- Data restore issue" http://www.forum.askdba.org/topic/dr-rebuild-data-restore-issue#post-137 Thu, 11 Mar 2010 12:44:40 +0000 Mahesh.G 137@http://www.forum.askdba.org/ Sorry for the delay in replying.. Yes. Yesterday we identified by using list backup command that backuppieces are expiered status. Then i realized that control file (standby) has been backed after backup is taken. So i believe there is mismatch there. I already taken standby control file backup and database backup at once and copying in DR location. I will keep you posted once i am done. Thanks, Saurabh Sood on "DR rebuild- Data restore issue" http://www.forum.askdba.org/topic/dr-rebuild-data-restore-issue#post-136 Thu, 11 Mar 2010 06:47:31 +0000 Saurabh Sood 136@http://www.forum.askdba.org/ Have you taken the backup of archivelogs when you issued the rman backup? If not, then switch the logfile and make backup of archivelogs with your datafile backups, and try the restore again. The backup script should look like: backup format '/u01/PROD/df_t%t_s%s_p%p' database; sql 'alter system archive log current'; backup format '/u01/PROD/al_t%t_s%s_p%p' archivelog all; sunkkuma on "DR rebuild- Data restore issue" http://www.forum.askdba.org/topic/dr-rebuild-data-restore-issue#post-135 Thu, 11 Mar 2010 06:44:53 +0000 sunkkuma 135@http://www.forum.askdba.org/ you can also use " list backup by datafile <datafile_no> " to check if there are any backups available for a datafile Amit Bansal on "DB and Listener availability monitoring script" http://www.forum.askdba.org/topic/db-and-listener-availability-script#post-134 Thu, 11 Mar 2010 06:13:39 +0000 Amit Bansal 134@http://www.forum.askdba.org/ Hi, Find below a simple script to monitor db and listener. It uses utl_mail procedure to connect to a mailserver db and send a mail in case of failure. You can also use mailx function to send mail. I have hard-coded password , but you can also use Oracle wallet to store password. Refer to my blog post <a href="http://askdba.org/weblog/2009/09/using-oracle-wallet-to-execute-shell-scriptcron-without-hard-coded-oracle-database-password/"> here </a> for details You need to pass ORACLE_SID as parameter. So to schedule a cron to check every 10 mins, you need to specify like below <pre> 00,10,20,30,40,50 * * * * sh /home/oracle/monitor/db_check.sh orcl </pre> Find below the script. Any suggestions/improvements are welcome <pre> ################################################################### ## Check Database Availability ################################################################### ##########Env Variables ############# export DBA_MAIL1='amit.bansal@askdba.org' export DBA_MAIL2='saurabh.sood@askdba.org' export ORACLE_HOME=/oracle/ora_db export TNS_ADMIN=$ORACLE_HOME/network/admin export BASE_DIR=/home/oracle/monitor export ORACLE_SID=$1 export LOG_FILE=$BASE_DIR/$ORACLE_SID.log export PATH=$ORACLE_HOME/bin:$PATH export machinename=<code>hostname</code> ################################### cd $BASE_DIR echo "<code>date</code> " > $LOG_FILE echo "Oracle Database(s) Status <code>hostname</code> :\n" >> $LOG_FILE db_cnt=<code>ps -ef|grep pmon|grep $ORACLE_SID|wc -l</code> if [ $db_cnt -gt 0 ]; then echo "$ORACLE_SID is Up" >> $LOG_FILE else echo "$ORACLE_SID is Down" >> $LOG_FILE $ORACLE_HOME/bin/sqlplus -s "system@maildb/oracle123" <<EOF >> $LOG_FILE alter session SET smtp_out_server = 'mailserv:100'; BEGIN UTL_MAIL.send( sender => 'webmaster@askdba.org' ,recipients => '${DBA_MAIL1}' ,cc => '${DBA_MAIL2}' ,subject => '${ORACLE_SID} is down on ${machinename}' ,message => '${ORACLE_SID} is Down on ${machinename}' ,mime_type => 'text/plain; charset=us-ascii' ,priority => 3); END; / exit EOF fi lsn_cnt=<code>ps -ef|grep tnslsnr|grep oracle|grep -v grep|wc -l</code> if [ $lsn_cnt -gt 0 ]; then echo "Listener is up" >>$LOG_FILE else echo "Listener is down" >>$LOG_FILE $ORACLE_HOME/bin/sqlplus -s "system@maildb/oracle123" <<EOF >> $LOG_FILE alter session SET smtp_out_server = 'mailserv:100'; BEGIN UTL_MAIL.send( sender => 'webmaster@askdba.org' ,recipients => '${DBA_MAIL1}' ,cc => '${DBA_MAIL2}' ,subject => 'Listener is down on ${machinename}' ,message => 'Listener is Down on ${machinename}' ,mime_type => 'text; charset=us-ascii' ,priority => 3); END; / exit EOF fi </pre> animesh on "DR rebuild- Data restore issue" http://www.forum.askdba.org/topic/dr-rebuild-data-restore-issue#post-133 Thu, 11 Mar 2010 06:02:52 +0000 animesh 133@http://www.forum.askdba.org/ Can you please provide step by step process you have followed. The error suggest that the datafile 27 and 28 is not there in the backup piece. ++ crosscheck backup Check the below link for complete steps for standby setup. <a href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ps.htm#i67520" rel="nofollow">http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ps.htm#i67520</a> Animesh upratap on "OS Memory issue" http://www.forum.askdba.org/topic/os-memory-issue#post-132 Thu, 11 Mar 2010 05:36:22 +0000 upratap 132@http://www.forum.askdba.org/ Check the memory usage, as seen from oracle. Check if any process is consuming high memory. then we can check what that session is doing. col name format a30 select sid,name,value from v$statname n,v$sesstat s where n.STATISTIC# = s.STATISTIC# and name like 'session%memory%' order by 3 asc; One thing regarding the inactive sessions is, it is better to set IDLE_TIME in PROFILE or set up DCD(Dead Connection Detection) if it is the problem of client being disconnected and sessions still there.. This helps in cleanup of such sessions.. -Pratap Mahesh.G on "DR rebuild- Data restore issue" http://www.forum.askdba.org/topic/dr-rebuild-data-restore-issue#post-131 Wed, 10 Mar 2010 11:27:43 +0000 Mahesh.G 131@http://www.forum.askdba.org/ Hi Experts, While doing DR rebuild ( physical standby ), after restoring standby controlfile in DR location, i am getting below error while restoring database. I took backup through RMAN ( hotbackup ) from primary database. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 03/10/2010 11:58:32 RMAN-06026: some targets not found - aborting restore RMAN-06023: no backup or copy of datafile 28 found to restore RMAN-06023: no backup or copy of datafile 27 found to restore I tried the below options :- 1. Duplicate command :- while using duplicate command also i got the same error 2. " catalog backuppiece " of all backup pieces copied from primary database. 3. I used restore with set until time option also but no luck. In all cases i got same error. How can i restore primary database backup in DR ? Pls help. Mahesh Amit Bansal on "Convert from 2 node RAC to single instance database" http://www.forum.askdba.org/topic/convert-from-2-node-rac-to-single-instance-database#post-130 Thu, 25 Feb 2010 05:35:13 +0000 Amit Bansal 130@http://www.forum.askdba.org/ Hi Tsswamy, I have not done this kind of migration. I believe that starting a database with non-rac binary and removing the cluster* parameters should allow you to do same. I would recommend you to contact My Oracle Support for exact steps to do same. Amit Bansal on "OS Memory issue" http://www.forum.askdba.org/topic/os-memory-issue#post-129 Thu, 25 Feb 2010 05:27:18 +0000 Amit Bansal 129@http://www.forum.askdba.org/ Hi, As per your statement, you are observing memory statistics from TOP command. Please note that TOP output contains component of shared+private memory, so you cannot rely on that figure ( to confirm if you add memory for all processes it will exceed the total memory on system). There are some Metalink/MOS docs regarding same. You can use pmap (solaris and linux) or svmon to know the exact memory usage of process. I would suggest digging into Statspack/AWR report to find the bottleneck. w.r.t to a process consuming high CPU, check if it is a Background process. You can look at program column in V$process select s.sid,p.spid,s.username "SUSER",p.username "PUSER",s.osuser,p.program,s.status from v$session s ,v$process p where s.paddr=p.addr tsswamy on "Convert from 2 node RAC to single instance database" http://www.forum.askdba.org/topic/convert-from-2-node-rac-to-single-instance-database#post-128 Wed, 24 Feb 2010 20:09:17 +0000 tsswamy 128@http://www.forum.askdba.org/ We have several databases that were set up in RAC on 2 nodes with ASM and now we want to remove SOME of those databases from RAC and have them set up as single instance databases. Can you please provide step by step procedure to convert from a 2 node RAC environment in windows to a single instance database. I am looking for the steps involved to remove the entries from clusterware as well. Thanks wesguez on "OS Memory issue" http://www.forum.askdba.org/topic/os-memory-issue#post-127 Mon, 22 Feb 2010 19:44:02 +0000 wesguez 127@http://www.forum.askdba.org/ I am having a issue of OS memory crunch.The sever has 16Gb RAM, and hosts 2 db.The total sga+pga combined is ~10.5GB.For one of the database, i see in TOP command, RES column values like 1100M,1245M , though these sessions are inactive and the logon_time is of 9th Feb.The sessions are also having open_cursor.Can this is a bottleneck?Can snipping these sessions be useful? How to find why the cursor is still open for a session.I have a session with a logon date on 29-JAN-2010, which is INACTIVE and has 1 open_cursor.This session is having the maximum cpu usage,though inactive.How do i go ahead for analyzing it. waiting for your response. Amit Bansal on "Linux:Capturing Top Output in text file" http://www.forum.askdba.org/topic/linuxcapturing-top-output-in-text-file#post-126 Mon, 15 Feb 2010 11:51:49 +0000 Amit Bansal 126@http://www.forum.askdba.org/ Came across this link for capturing Top output in text file <a href="http://magazine.redhat.com/2008/04/16/tips-and-tricks-how-do-i-capture-the-output-of-top-to-a-file/" rel="nofollow">http://magazine.redhat.com/2008/04/16/tips-and-tricks-how-do-i-capture-the-output-of-top-to-a-file/</a> I found following command to be very useful. top -b -n5 -d5 It captures top output 5 times and wait 5 seconds between each output. Amit Bansal on "Database Hang" http://www.forum.askdba.org/topic/database-hang#post-125 Wed, 27 Jan 2010 11:39:12 +0000 Amit Bansal 125@http://www.forum.askdba.org/ I assume you are using windows server. But don't have sufficient information to help. Are you facing database hang or slow database? If it is hang then there could be some blocking session. If it's a slow database, it could be query issue or sth else. -Amit rtskrajan on "Database Hang" http://www.forum.askdba.org/topic/database-hang#post-124 Tue, 26 Jan 2010 11:14:23 +0000 rtskrajan 124@http://www.forum.askdba.org/ Hi experts, My server ram is 12GB. i installed 10r2 and implemented /3GB also. Eventhough my database is giving problem. Could you please give some valuable advice. Thanks. Saurabh Sood on "Database shutdown hangs." http://www.forum.askdba.org/topic/database-shutdown-hangs#post-123 Wed, 20 Jan 2010 14:42:21 +0000 Saurabh Sood 123@http://www.forum.askdba.org/ Hi Pratheep, Processes with status "D" cannot be killed at all. They are in "D" status because they are sleeping and waiting for a resource like "Kernel lock" etc. which they will never get. If you are seeing these ospid in v$process they will not allow "shutdown immediate" or "shutdown abort". The only way to remove such processes is to "reboot" server. These processes cannot be traced down. Check If you can apply Dead Connection detection (DCD) to avoid such situations in future. Cheers!!! pratheep on "Database shutdown hangs." http://www.forum.askdba.org/topic/database-shutdown-hangs#post-122 Wed, 20 Jan 2010 04:25:12 +0000 pratheep 122@http://www.forum.askdba.org/ Hi, One of my production database shutdown process hangs every planned shutdown. (Both shutdown immediate and abort options). Database version & OS : 10.2.0.4 on SuSe Linux 10 SP2, All the latest patches, cpus installed. Some of the active database server process are preventing the database from shutdown. I tried to kill the process from OS root user also. But the process are not closing. When I check ps command the process are in 'D' state (uninterruptable sleep). For the particular pid, strace command also stuck. As I verified in v$session before shutdown immediate there is no active sessions or jobs in database. But above mentioned "D" state pid's are exist in v$process. Please suggest me, how to find the history of the process.? like when it is hanged/which session id/which sql statement caused that..? Thank you all, Pratheep Amit Bansal on "What is the process/steps to start up a database in a RAC" http://www.forum.askdba.org/topic/what-is-the-processsteps-to-start-up-a-database-in-a-rac#post-121 Thu, 14 Jan 2010 01:50:00 +0000 Amit Bansal 121@http://www.forum.askdba.org/ Hi, Sorry for late reply. Didn't get time to reply earlier. In case of RAC database (10.2) you need to perform following steps 1)Start CRS (as root) #crsctl start crs Actually if you have enabled automatic startup of resources and configured asm-instance dependency correctly, then it will start all resources automatically. Otherwise go to below steps 2)Start Nodeapps $srvctl start nodeapps -n <noden> 3)Start ASM instance srvctl start asm -n <noden> Repeat steps on other node. You can use srvctl command from any node 4) Now start cluster database $srvctl start database -d <dbname> You can also start a single instance using following command srvctl start instance -d <db_name> -i <inst_name> jammoral on "What is the process/steps to start up a database in a RAC" http://www.forum.askdba.org/topic/what-is-the-processsteps-to-start-up-a-database-in-a-rac#post-120 Tue, 12 Jan 2010 14:51:42 +0000 jammoral 120@http://www.forum.askdba.org/ what steps are followed to startup an Oracle instance setup as part cluster. I understand powerpath 1st to allow access to the san, then CRSD ... not sure what is next!! Amit Bansal on "SYSASM not granted to sys." http://www.forum.askdba.org/topic/sysasm-not-granted-to-sys#post-119 Tue, 12 Jan 2010 06:25:34 +0000 Amit Bansal 119@http://www.forum.askdba.org/ As per upgrade guide, you had to add a user to password file before upgrading ASM instance. <a href="http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/upgrade.htm#BABEJBFD" rel="nofollow">http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/upgrade.htm#BABEJBFD</a> Did you try recreating password file for ASM?Use orapwd to do same. If it still doesn't work, then would recommend you to raise SR. nhameed on "SYSASM not granted to sys." http://www.forum.askdba.org/topic/sysasm-not-granted-to-sys#post-118 Sat, 09 Jan 2010 10:22:15 +0000 nhameed 118@http://www.forum.askdba.org/ I have upgraded 10 RAC database to 11g rac, now I cannot connect to ASM instance, in v$pwfile_users, sys dont have SYSASM privilege. How can I manually grant this privilege to SYS user. deepika.dhamija@gmail.com on "ASM Volumes and DiskGroups" http://www.forum.askdba.org/topic/asm-volumes-and-diskgroups#post-117 Wed, 30 Dec 2009 04:19:40 +0000 deepika.dhamija@gmail.com 117@http://www.forum.askdba.org/ Thanks Amit for your reply. I am working for a company that makes protection software and we are planning to extend it to support RAC. Yes, we do realize that RAC Databases are complex and we therefore are also getting in touch with a DBA. These were some of the preliminary doubts that I had. Thanks anyways for your response. Amit Bansal on "ASM Volumes and DiskGroups" http://www.forum.askdba.org/topic/asm-volumes-and-diskgroups#post-116 Wed, 30 Dec 2009 01:59:45 +0000 Amit Bansal 116@http://www.forum.askdba.org/ 1. There is no asm command to find the devices part of particular diskgroup. You can use the query to find the diskgroup devices. 2. Yes, you can have multiple diskgroups 3. No, you can allocate only one diskgroup to FRA. 4. Yes, you can have multiple databases using same diskgroup 5. I cant answer this. You need to read Database Concepts and Admin guide. 6. No. Can't be done. Deepika , I think it would be better to get a DBA for managing your site as RAC DB's are much complex then single instance databases on filesystem. deepika.dhamija@gmail.com on "ASM Volumes and DiskGroups" http://www.forum.askdba.org/topic/asm-volumes-and-diskgroups#post-115 Mon, 28 Dec 2009 08:57:41 +0000 deepika.dhamija@gmail.com 115@http://www.forum.askdba.org/ Hi, I have a 2Node Oracle RAC Setup(10gR2). ASM Volumes were configured for 2 disk groups as follows, during the installation: /dev/sdb2 : VOL1 /dev/sdb3 : VOL2 /dev/sdb4 : VOL3 ORCL_DATA1 : VOL1 & VOL2 FLASH_RECOVERY_AREA : VOL3 I have some basic doubts about ASM and Database Groups. 1) I run the foll commands to know/query the ASM Volumes and devices # /etc/init.d/oracleasm querydisk /dev/sdb2 # /etc/init.d/oracleasm listdisks # ls -al /dev/oracleasm/disks/ Can I also get the 'Disk Group' information in a similar manner from ASM? eg: What are the disk group names and what vol's/devices form the diskgroup. Currently I am run the below query to get this information select d.name, e.name from v$asm_diskgroup d, v$asm_disk e where d.group_number=e.group_number; 2) Can my database have multiple data groups? eg: ORCL_DATA1 (VOL1 & VOL2) and ORCL_DATA2 (VOL3 & VOL4) 3) Can multiple datagroups share the same Flash Recovery Area? eg: ORCL_DATA1 & ORCL_DATA2 have the same Flash Recovery Area (FLASH_RECOVERY_AREA (VOL5 & VOL6) 4) Can disk groups span across databases? 5) When I create/alter tables, and if I have two data groups (ORCL_DATA1 & ORCL_DATA2) in the database, do I know where the information is being written or can I provide this information somewhere? 6) If my database contains multiple disk groups, and incase I wish to rollback the database to a previous good instant of time, can I just rollback some disk groups in the database or 'ALL' the diskgroups will have to be rolledback to maintain consistency. I am working on RAC as a user and not very clear on the underlying aspects of databases etc. Some of the questions above may sound flimsy. Any advise/suggestion is appreciated. Thanks deepika.dhamija@gmail.com on "Executing SQL from Shell Script" http://www.forum.askdba.org/topic/executing-sql-from-shell-script#post-114 Thu, 24 Dec 2009 10:50:40 +0000 deepika.dhamija@gmail.com 114@http://www.forum.askdba.org/ Thanks Amit. I was able to execute the SQL using the command sqlplus <username>/<password>@<orcl_sid> Amit Bansal on "Executing SQL from Shell Script" http://www.forum.askdba.org/topic/executing-sql-from-shell-script#post-113 Thu, 24 Dec 2009 06:59:48 +0000 Amit Bansal 113@http://www.forum.askdba.org/ Deepika, Please find response below 1) Your first script has mistake. Should be like export ORACLE_SID=+ASM1 sqlplus / as sysdba <<EOF select name, path from v$asm_disk; exit EOF 2) node_list=<code>olsnodes</code> node1=<code>echo $node_list|awk '{print $1}'</code> node2=<code>echo $node_list|awk '{print $2}'</code> echo "Node 1 is " $node1 echo "Node 2 is " $node2 Hope this helps deepika.dhamija@gmail.com on "Executing SQL from Shell Script" http://www.forum.askdba.org/topic/executing-sql-from-shell-script#post-112 Wed, 23 Dec 2009 07:25:14 +0000 deepika.dhamija@gmail.com 112@http://www.forum.askdba.org/ Hi, I have a two node RAC Cluster Setup (10R2) and I want to execute sql queries from a shell script, to be run as root. I have the foll test.sh script #! /bin/bash echo "In BASH" sqlplus / <<+ENDOFSQL+ select name, path from v$asm_disk; exit +ENDOFSQL+ echo "Back to Bash" exit and I get the foll O/P In BASH SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 23 07:25:32 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12546: TNS:permission denied Enter user-name: SP2-0306: Invalid option. Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] where <logon> ::= <username>[/<password>][@<connect_identifier>] | / Enter user-name: Enter password: ERROR: ORA-12546: TNS:permission denied SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus Back to Bash What permissions should for this? 2) Also I need to know the node names of the nodes that form the clustre. I add the foll lines to my script NODE_NAMES=<code>olsnodes</code> echo $NODE_NAMES ad I get O/P linux-1 linux-2 Is it possible to store these space separated node names in diff variables that can then be used. (the number of nodes are variable) Any suggestion/advise is appreciated. Thanks deepika.dhamija@gmail.com on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-111 Wed, 09 Dec 2009 12:29:40 +0000 deepika.dhamija@gmail.com 111@http://www.forum.askdba.org/ Amit, I am finally able to achieve what I intended to do. Many Thanks to you for your valuable suggestions. Amit Bansal on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-110 Wed, 09 Dec 2009 09:30:43 +0000 Amit Bansal 110@http://www.forum.askdba.org/ Hi, >>Actually I have an application that runs on every node on the cluster and creates the devices /dev/multipath/sd* Can't understand this statement. Anyways if you use udev, you can set permissions in rules file /etc/udev/rules.d/50-udev.rules I think your sysadmin can help you with that. -Amit deepika.dhamija@gmail.com on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-109 Wed, 09 Dec 2009 09:03:19 +0000 deepika.dhamija@gmail.com 109@http://www.forum.askdba.org/ Hi Amit, 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. On Node 1 [oracle@linux1 ~]$ uname -a Linux linux1 2.6.9-78.0.13.ELsmp #1 SMP Wed Jan 7 17:52:47 EST 2009 i686 i686 i386 GNU/Linux Does this much information answer your questions? Amit Bansal on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-108 Wed, 09 Dec 2009 07:58:21 +0000 Amit Bansal 108@http://www.forum.askdba.org/ Deepika, How have you configured multipathing? Are you using udev and device mapper? Also let me know your linux release details. -Amit deepika.dhamija@gmail.com on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-107 Wed, 09 Dec 2009 07:10:39 +0000 deepika.dhamija@gmail.com 107@http://www.forum.askdba.org/ Thanks Amit for the prompt reply. I had ORACLE_SID SET to orcl1 and orcl2 on both the nodes respectively. On node1, I did the above steps, and I luckily was able to connect to Oracle. It did not say 'connected to idle instance'. The O/P of the query on Node1 (ORACLE_SID=+ASM1) is NAME PATH MOUNT_S HEADER_STATUS ORCL:VOL1 CLOSED UNKNOWN ORCL:VOL1 CLOSED UNKNOWN ORCL:VOL1 CLOSED UNKNOWN The O/P of the query on Node2 (ORACLE_SID=orcl2) is NAME PATH MOUNT_S HEADER_STATUS VOL1 ORCL:VOL1 OPENED UNKNOWN VOL2 ORCL:VOL2 OPENED UNKNOWN VOL3 ORCL:VOL3 OPENED UNKNOWN Does that mean that the multipath disks have not been picked up by asm at all. What about the permissions. I ran the foll commands (for sdb2, sdb3, sdb4) on Node1 # chown -R oracle:dba /dev/multipath/sdb2 # chmod -R 775 /dev/multipath/sdb2 # /etc/init.d/oracleasm scandisks # /etc/init.d/oracleasm listdisks VOL1 VOL2 VOL3 How do these permissions remain intact after a reboot to the node? Amit Bansal on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-106 Wed, 09 Dec 2009 06:54:50 +0000 Amit Bansal 106@http://www.forum.askdba.org/ Hi, Try logging into ASM instance and query V$ASM_DISK i.e export ORACLE_SID=+ASM1 sqlplus "/ as sysdba" select name,path,mount_status,header_status from V$ASM_DISK; with regards to naming convention, I think naming convention should follow /dev/[a-z]* naming convention instead of /dev/multipath/[a-z]* 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. I think best way would be to actually first query V$ASM_DISK output. deepika.dhamija@gmail.com on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-105 Wed, 09 Dec 2009 06:33:44 +0000 deepika.dhamija@gmail.com 105@http://www.forum.askdba.org/ Hi Amit, Yes, I am following the above URL. On Node1: [root@linux1 ~]# /etc/init.d/oracleasm listdisks VOL1 VOL2 VOL3 [root@linux1 ~]# /etc/init.d/oracleasm querydisk /dev/multipath/sdb2 Device "/dev/multipath/sdb2" is marked an ASM disk with the label "VOL1" [root@linux1 ~]# /etc/init.d/oracleasm querydisk /dev/sdb2 Device "/dev/sdb2" is marked an ASM disk with the label "VOL1" The O/P is same for sdb3 and sdb4 (both multipath & single path devices) Is this what you mean when you say if disks are visible on node1? [oracle@linux1 ~]$ srvctl status asm -n linux1 ASM instance +ASM1 is running on node linux1. [oracle@linux1 ~]$ srvctl status instance -d orcl -i orcl1 Instance orcl1 is not running on node linux1 [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'. [oracle@linux1 ~]$ I am unable to start the instance orcl1 on node1. Also what is the significance of naming multipath devices in a particular way? Amit Bansal on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-104 Tue, 08 Dec 2009 13:32:15 +0000 Amit Bansal 104@http://www.forum.askdba.org/ Hi Deepika, I believe you are following below article available on Oracle website <a href="http://www.oracle.com/technology/tech/linux/asmlib/multipath.html" rel="nofollow">http://www.oracle.com/technology/tech/linux/asmlib/multipath.html</a> 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. Secondly name multipath device as multipatha,multibathc instead of /multipath/sdb1 etc