Advertisement

06.16.2008 at 08:31PM PDT, ID: 23490279
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.0

Oracle RAC ASM setup on a shared Netapp SAN partition in RHES

Asked by sunhux in Oracle Database, Linux Setup, Storage Technology

Tags: , ,

Hi,

We have 3 RHES servers (V4.6) - the DBA would like Oracle RAC ASM on all 3 servers
access a common NetApp SAN raw disk partition.

We found that /dev/mapper/mpath1 on  server 1  is /dev/mapper/mpath0  on  server 2
& yet a different device name on the 3rd server.  Good thing is /dev/mapper/mpathx
stays permanently linked to the same disk partition each time the RHES servers are
rebooted.  If we use /dev/mpath/pathx, it changes each time servers are rebooted,
ie on server 1, after a reboot, the value in  /dev/mpath/pathx  will need to be changed
so as to access back the same disk partition but if we used /dev/mapper/pathx, it's
stays the same after reboots.

The DBA has set up Oracle RAC clustering (using sort of ASM tool - I'm not sure as
I'm no DBA but Unix Admin).  She's sure that on all the servers, she has used the
same SAN disk partition & is able to create the database successfully.  So on all
the servers,  ORACLE_SID=+ASM2  & when she went into each of the servers to
do a "select" to retrieve data, only on server1 it returns data while on the other
servers, nothing was returned.

I'm not sure how the DBA ensure she's accessing the same partition - is there anyway
I can verify this other than
" formatting (using fdisk) on each of the server the disk partition
to a  character device, mount the formatted character device to a mount point on each
server, create a dummy file, say test.txt & go into the other 2 servers to check if test.txt
is there " - to do this, she'll lose her work done so far.

Also, if RAC clustering is used, is Linux clustering still needed or RAC clustering can
coordinate the IO between the servers?  If Linux clustering is needed, kindly let me
know the Linux command to start up the clustering service

We have another set of older Linux servers which the outsourced DBA told us
they used /dev/raw...   device files which also connects to Netapp SAN disk partitions
& no Linux clustering is running but this set of servers is owned by the outsourced
DBAs/ vendors & I have yet o verify what she said is true.

Lastly, we're contemplating if we should use character device instead of raw device.
Can Oracle ASM be used on a non-raw (character) device Unix file system?

I'm completely newbie to Oracle/RAC/ASM & NetApp SAN, so bear with me.
Start Free Trial
[+][-]06.17.2008 at 01:00AM PDT, ID: 21800693

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]06.17.2008 at 03:32AM PDT, ID: 21801507

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Oracle Database, Linux Setup, Storage Technology
Tags: Oracle Redhat Netapp, Oracle RAC ASM RHES, Oracle RAC ASM setup on a shared Netapp SAN partition in RHES
Sign Up Now!
Solution Provided By: rolutola
Participating Experts: 2
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628