Solved

Should I use automount nfs filesystems for Oracle datafiles?

Posted on 2011-09-07
10
872 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 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 100 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
 
LVL 76

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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 76

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 21

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 21

Accepted Solution

by:
robocat earned 400 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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

#Citrix #POC #XenDesktop #vCenter #VMware #ESX
I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

707 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now