使用NFS安裝oracle軟體，nfsoracle軟體

使用NFS安裝oracle軟體，nfsoracle軟體

昨天，使用openfiler建立nas儲存系統，並安裝oracle軟體，前面一切順利，到建立資料庫時報ora錯誤，原來使用nfs安裝oracle資料庫時，mount選項有特殊要求，整理總結如下，以備查：

RAC  

In the table below

• Binaries is the shared mount points where the Oracle Home and CRS_HOME is installed.
• Datafiles includes Online Logs, Controlfile and Datafiles

Operating System	Mount options for Binaries	Mount options for Oracle Datafiles	Mount options for CRS Voting Disk and OCR
Sun Solaris *	rw,bg,hard,nointr,rsize=32768, wsize=32768,proto=tcp, noac,vers=3,suid	rw,bg,hard,nointr,rsize=32768, wsize=32768,proto=tcp,noac, forcedirectio, vers=3,suid	rw,bg,hard,nointr,rsize=32768, wsize=32768,proto=tcp,vers=3, noac,forcedirectio
AIX (5L) **	rw,bg,hard,nointr,rsize=32768, wsize=32768,proto=tcp,vers=3, timeo=600	cio,rw,bg,hard,nointr,rsize=32768, wsize=32768,proto=tcp,noac, vers=3,timeo=600	cio,rw,bg,hard,intr,rsize=32768, wsize=32768,tcp,noac, vers=3,timeo=600
HPUX 11.23 ****  –	rw,bg,vers=3,proto=tcp,noac, hard,nointr,timeo=600, rsize=32768,wsize=32768,suid	rw,bg,vers=3,proto=tcp,noac, forcedirectio,hard,nointr,timeo=600, rsize=32768,wsize=32768,suid	rw,bg,vers=3,proto=tcp,noac, forcedirectio,hard,nointr,timeo=600 ,rsize=32768,wsize=32768,suid
Linux x86 #	rw,bg,hard,nointr,rsize=32768, wsize=32768,tcp, vers=3, timeo=600, actimeo=0	rw,bg,hard,nointr,rsize=32768, wsize=32768,tcp,actimeo=0, vers=3,timeo=600	rw,bg,hard,nointr,rsize=32768, wsize=32768,tcp,noac,vers=3, timeo=600
Linux x86-64 #	rw,bg,hard,nointr,rsize=32768,  wsize=32768,tcp,vers=3, timeo=600, actimeo=0	rw,bg,hard,nointr,rsize=32768,  wsize=32768,tcp,actimeo=0,  vers=3,timeo=600	rw,bg,hard,nointr,rsize=32768,  wsize=32768,tcp,vers=3, timeo=600,noac
Linux – Itanium	rw,bg,hard,nointr,rsize=32768,  wsize=32768,tcp,vers=3, timeo=600, actimeo=0	rw,bg,hard,nointr,rsize=32768,  wsize=32768,tcp,actimeo=0,  vers=3,timeo=600	rw,bg,hard,nointr,rsize=32768,  wsize=32768,tcp,noac,vers=3, timeo=600

* NFS mount option “forcedirectio” is required on Solaris platforms when mounting the OCR/CRS files when using Oracle 10.1.0.4 or 10.2.0.2 or later (Oracle unpublished bug 4466428) 
** AIX is only supported with NAS on AIX 5.3 TL04 and higher with Oracle 10.2.0.1 and later (NetApp) 
*** NAS devices are only supported with HPUX 11.23 or higher ONLY 

# These mount options are for Linux kernels 2.6 and above for older kernels please check Note 279393.1

Due to Unpublished bug 5856342, it is necessary to use the following init.ora parameter when using NAS
with all versions of RAC on Linux (x86 & X86-64 platforms) until 10.2.0.4. This bug is fixed and included in 10.2.0.4 patchset.
filesystemio_options = DIRECTIO Single Instance

Operating System	Mount options for Binaries	Mount options for Oracle Datafiles
Sun Solaris * (8, 9, 10)	rw,bg,hard,rsize=32768, wsize=32768,vers=3,nointr, proto=tcp,suid	rw,bg,hard,rsize=32768, wsize=32768,vers=3,[forcedirectio or llock], nointr,proto=tcp,suid
AIX (5L) **	rw,bg,hard,rsize=32768, wsize=32768,vers=3,intr, timeo=600,proto=tcp	rw,bg,hard,rsize=32768, wsize=32768,vers=3,cio,intr, timeo=600,proto=tcp
HPUX 11.23 ****	rw,bg,hard,rsize=32768, wsize=32768,vers=3,nointr, timeo=600,proto=tcp,suid	rw,bg,hard,rsize=32768, wsize=32768,vers=3,nointr, timeo=600,proto=tcp,suid
Linux x86 #	rw,bg,hard,rsize=32768, wsize=32768,vers=3,nointr, timeo=600,tcp	rw,bg,hard,rsize=32768, wsize=32768,vers=3,nointr, timeo=600,tcp,actime=0*
Linux x86-64 #	rw,bg,hard,rsize=32768, wsize=32768,vers=3,nointr, timeo=600,tcp	rw,bg,hard,rsize=32768, wsize=32768,vers=3,nointr, timeo=600,tcp,actime=0*
Linux – Itanium	rw,bg,hard,rsize=32768, wsize=32768,vers=3,nointr, timeo=600,tcp	rw,bg,hard,rsize=32768, wsize=32768,vers=3,nointr, timeo=600,tcp

* actime=0 or noac can be used

按照上面所示，設定參數，結果仍然報錯ora-27086,錯誤資訊如下：

[oraten@yue ~]$ oerr ora 2708627086, 00000, "unable to lock file - already in use"// *Cause:  the file is locked by another process, indicating that it is//          currently in use by a database instance.// *Action: determine which database instance legitimately owns this file.

重啟openfiler，成功解決問題，看來是之前mount不當導致在openfiler端有鎖一直沒有釋放。

雖然oracle支援nfs，但使用nfs的情景比較少，多數使用nfs來備份資料庫或者存放歸檔

nfs後ORACLE使用者不可以建立檔案，產生資料檔案

NFS做資料表空間的儲存, 網路異常一下, oracle就掛了, 快加硬碟才是正道.
 
oracle linux 64下載各種檔案的作用

1.Oracle Linux 6.4(64位)
2.啟動光碟片，最小花的系統，啟動後允許你選擇安裝源（通過nfs，ftp等方式安裝），可以用來系統維護、拯救系統
3.uek(Unbreakable Enterprise Kernel)的核心的啟動光碟片， uek核心是Oracle Linux、Oracle Database、中介軟體和硬體工程師團隊合作的結果，是一個快速、現代、可靠的核心，專門針對Oracle軟體和硬體進行了最佳化
4.第一張源碼光碟片
5.第二張源碼光碟片