mount nfs rsize>=32768 oracle,REDHAT linux上用NFS空间存放oracle DB数据文件时的注意点

REDHAT linux上用NFS空间存放oracle DB数据文件时的注意点

如果用默认参数mount NFS空间到主机上，在创建数据库主机时有可能会报ORA-00600 [2113][900]错误，这里用以下方式重新mount NFS空间，可以避免这个错误

mount -o tcp,nolock,rw nfs_host:/oradata /oradata

以上是在oracle 9206版本碰到的.

在10.2.0.4里用上面的方法不行,还是会报ORA-27054: NFS file system where the file is created or resides is not mounted ,要用以下mont方法才可以:

mount -o rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0

如:

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE    10.2.0.4.0      Production

TNS for Linux: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

SQL>

SQL>

SQL> create tablespace TS_NAS_DW_DATA1 datafile

2  '/netapp/oradata/dwsds/ts_nas_dw_data1_01.dbf' size 8192M reuse autoextend off

3  extent management local uniform size 8M SEGMENT SPACE MANAGEMENT  AUTO;

create tablespace TS_NAS_DW_DATA1 datafile

*

ERROR at line 1:

ORA-01119: error in creating database file '/netapp/oradata/dwsds/ts_nas_dw_data1_01.dbf'

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

Additional information: 3

SQL> exit

用-o rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0参数重新mount后,问题解决