Forum Replies Created
-
Posts
-
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.
Thanks Amit.
I was able to execute the SQL using the command
sqlplus <username>/<password>@<orcl_sid>
Amit,
I am finally able to achieve what I intended to do.
Many Thanks to you for your valuable suggestions.
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?
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?
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?
