使用NFS安装oracle软件
昨天。使用openfiler创建nas存储系统，安装oracle软件，在所有正面最好，要创建一个数据库时报ora错，原来使用nfs安装oracle数据库，mount选项有特殊要求，如以下。以备查：
RAC
- 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, |
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, |
cio,rw,bg,hard,nointr,rsize=32768, |
cio,rw,bg,hard,intr,rsize=32768, |
| 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, |
rw,bg,hard,nointr,rsize=32768, wsize=32768,tcp,actimeo=0, vers=3,timeo=600 |
rw,bg,hard,nointr,rsize=32768, |
| 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
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, |
rw,bg,hard,rsize=32768, wsize=32768,vers=3,[forcedirectio or llock], nointr,proto=tcp,suid |
| AIX (5L) ** |
rw,bg,hard,rsize=32768, |
rw,bg,hard,rsize=32768, |
| 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 27086
27086, 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要备份数据库或存储归档
版权声明：本文博客原创文章，博客，未经同意，不得转载。
最新文章
- windows多线程编程
- 关于editor网页编辑器ueditor.config.js 配置图片上传
- Java性能调优
- docker在ubuntu14.04下的安装笔记
- 中小公司PMO不一样期间的责任
- HDFS原理介绍
- ！对c++类的理解
- AtomicInteger
- 发布 PM2.5 数据的城市列表
- Html页中使用OCX控件
- [原博客] POI系列(1)
- 在Windows下github展示代码
- 对[foreach]的浅究到发现[yield]
- 手把手教学系列：从零开始配置VPS服务器
- 学习虚拟机时Vbox提示硬件加速不可用时应该怎么办?
- kubernetes 源码安装部署 1.12
- 风格豆腐干地方v出vccxzzxx
- Linux 入侵检测小结
- 利用nginx添加账号密码验证
- JAVA中byte为负数处理