[[email protected]]

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.

[[email protected]]

Thanks Amit.

I was able to execute the SQL using the command

sqlplus <username>/<password>@<orcl_sid>

[[email protected]]

Amit,

I am finally able to achieve what I intended to do.

Many Thanks to you for your valuable suggestions.

[[email protected]]

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?

[[email protected]]

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?

[[email protected]]

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?

[Author]

Posts