Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Should I use automount nfs filesystems for Oracle datafiles?

Posted on 2011-09-07
10
Medium Priority
?
913 Views
Last Modified: 2012-05-12
I'm running some Oracle v11g databases on Solaris 10, and all of our datafiles are on nfs attached storage.  I would like to know:

Q: Should I use permanently mounted filesystems in /etc/vfstab, or automount filesystems in /etc/auto_direct

Both can be given the same parameters for hard mounting, transfer size, etc. but Oracle don't say one way or the other what is best.  Can anyone provide a white paper that gives some solid advice that's backed up with a rationale as opposed to simply a preference?
0
Comment
Question by:Sophia Paterakis
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 300 total points
ID: 36498789
I would go with permanently mounted.  I don't have a paper that will say this but I would want to ensure they are mounted independently of access.
0
 
LVL 2

Expert Comment

by:achellstrom
ID: 36499514
If I had my choice I would not nfs mount file systems, however it does make for an easy way to add storage to a system.  You will see about 20% high CPU rates than a standard UFS file system, but the throughput is relatively close to what you could expect from standard spinning disks.  Of course there is direct attached SSD that standard UFS or NFS couldn't come close on. SSD would be my preferred database storage. However, if you are looking to save money and have CPU to spare then NFS is viable.  Here is a link to a white paper on the subject: http://www.cptech.com/stuff/contentmgr/files/0/f5e142f537d0b7b873e782e1d9603521/download/database_performance_with_nas_optimizing_oracle_on_nfs.pdf
0
 
LVL 1

Author Comment

by:Sophia Paterakis
ID: 36499735
@slightvw

Yes, that's what I consider best-practice also... but my sysadmin and I have a difference of opinion, so I'd like something to help argue my case.


@achellstrom

Thanks for the advice, but we're locked into NFS at the moment.  We'll probably get SSD for the Redo logs during next years budget, but for now we're NFS only.

As for the PDF, under the section "NFS MOUNT OPTIONS", it says things such as:


The recommended mount options for Oracle9i RAC on Solaris are:  

rw,bg,vers=3,proto=tcp,hard,intr,rsize=32768,wsize=32768,forcedirectio,noac

... but nothing I can find mentions either setting them up in vfstab (permanently), or auto_direct (automount/dismount) <sigh>
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36499890
Ah, debates.  Honestly anything we could likely provide would be from a Google search.

I suggest opening an SR with Oracle Support of contacting your Oracle Sales team for supporting evidence.


Who knows, it might not matter.
0
 
LVL 1

Author Comment

by:Sophia Paterakis
ID: 36499942
Thanks slightvw.  I actually raised an SR before I posted here, but I figured they would never deliver... just call me a cynic.

If they do pull a rabbit out of the hat, then I'll let you know... but I'd still like to hear from anyone else if you have the smallest sliver of backing documentation.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36499972
lol..  I feel your pain from the Support point of view.


Maybe I am just lucky but my sales team is fairly responsive to general questions.

Did you try them?
0
 
LVL 22

Expert Comment

by:robocat
ID: 36501563

Never ever use automounting for Oracle database files.

Automounter is intended for filesystems that don't need to be mounted permanently, such as home directories, saving the trouble of manually mounting and saving server/client resources.

Oracle database filesystems always need to be mounted as the database is always online, so it makes no sense to automount these filesystems.

Using the automounter could potentially result in reliability issues that are difficult to trace back to the automounter.

Keep It Simple (KISS): something that isn't used can not cause problems.

0
 
LVL 1

Author Comment

by:Sophia Paterakis
ID: 36503848
Thanks robocat, and I agree that it's best practice not to use automount, and KISS as you mentioned.  What would really seal the deal for me is a document from Oracle, Sun, NetApp, or anyone of authority that confirms our collective opinion.
0
 
LVL 22

Accepted Solution

by:
robocat earned 1200 total points
ID: 36504564

http://communities.netapp.com/servlet/JiveServlet/previewBody/1394-102-1-1536/tr-3369.pdf

Automount is not explicitly mentioned, but it does say to either mount the file systems manually or using /etc/vfstab

0
 
LVL 1

Author Closing Comment

by:Sophia Paterakis
ID: 36505720
Thanks everyone.  I leveraged the document that @robocat gave, to find this PDF:

NetApp Best Practice Guidelines for Oracle Database 11g
Oracle Alliance Engineering Team, NetApp
August 2011 | TR-3633

http://media.netapp.com/documents/tr-3633.pdf

It specifically relates to v11g, and was released only a few weeks ago so it's fresh advice.  Unfortunately the section on vfstab is copy/pasted directly from the previous document and makes no mention of automount:


Solaris NFS Protocol: Mount Options

For the latest NFS mount options and related information, see
http://kb.netapp.com/support/index?page=content&id=3010189.

Mount options are specified in /etc/vfstab for Oracle mounts that occur automatically at boot time. To specify mount options:

1. Edit the /etc/vfstab.
2. For each NFS mount participating in a high-spee

Oracle's advice on the subject was "Go and ask NetApp". :-)
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Concerto Cloud Services, a provider of fully managed private, public and hybrid cloud solutions, announced today it was named to the 20 Coolest Cloud Infrastructure Vendors Of The 2017 Cloud  (http://www.concertocloud.com/about/in-the-news/2017/02/0…
Windows Server 2003 introduced persistent Volume Shadow Copies and made 2003 a must-do upgrade.  Since then, it's been a must-implement feature for all servers doing any kind of file sharing.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question