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后,问题解决