最近遇到一个问题很是麻烦!
使用Oracle 10g, AIX, NFS.
问题是这样的:
公司备份出来的数据在别的机器上Linux (AS3U3)上,通过NFS访问让AIX的机器上的Oracle可以打开来查看。我们只要想象一下AIX的Oracle数据文件全部在Linux机器上就可以了!
现在遇到Oracle 10g访问NFS有点问题:
具体步骤如下:
1>. 在到(Oracle 10g)本地机器的控制文件, 将控制文件复制到"/aa"下面
2>. 将本地机器设置为NFS Server, NFS Client端也为本地机器, NFS Server将输出"/aa"
3>. 在本地机器上mount "/aa" 为 "/aa1"使用的文件系统为NFS
4>. 将Oracle打开时使用的控制文件指定在NFS文件系统"/aa1"下面.
5>. SQL>startup mount pfile=initdb10g.ora;
6>. 这样就出现错误了, 具体错误信息见下面.
AIX NFS configure:
##########
testcc-test:test:/test>uname -a
AIX testcc-test 3 5 000000004C00
修改下面的配置文件:
在“/etc/hosts”中添加: ip_addr tt
在“/etc/exports”中添加: /aa1 -rw,root=tt,access=tt
使用下面命令来启动NFS服务:
startsrc -g nfs
stopsrc -g nfs
lssrc -g nfs
Oracle Version:
###########
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Productio
NLSRTL Version 0.2.0.2.0 - Production
我已经测试了下面的mount参数,出现的错误信息是一样的。NFS Command:
###########
mount -v nfs -o vers=3,proto=udp,rsize=8192,wsize=8192 ip_addr:/aa /aa1
mount -v nfs -o vers=3,hard,rsize=32768,wsize=32768 ip_addr:/aa /aa1
mount -v nfs -o rw,bg,hard,intr,proto=tcp,vers=3,rsize=32768,wsize=32768,timeo=600 ip_addr:/aa /aa1
mount -v nfs -o rw,bg,hard,intr,proto=udp,vers=3,rsize=32768,wsize=32768,timeo=600 ip_addr:/aa /aa1
mount -V nfs -o rw,bg,hard,intr,rsize=32768,wsize=32768,timeo=600,vers=3,proto=tcp,noac,sec=sys ip_addr:/aa /aa1
Oracle提示的错误信息,在log文件中。Error information:
##########
ALTER DATABASE MOUNT
Tue Jun 19 15:05:19 2007
ORA-00202: control file: '/aa1/db10g_contl_01'
ORA-27054: NFS file system where the file is created or resides is not mounted
with correct options
Additional information: 6
Tue Jun 19 15:05:19 2007
ORA-205 signalled during: ALTER DATABASE MOUNT...
该机器的man mount信息:
##############
Makes a file system available for use.
Syntax
mount [ -f ] [ -n Node ] [ -o Options ] [ -p ] [ -r ] [ -v VfsName ] [ -t Type | [ Device |
Node:Directory ] Directory | all | -a ] [-V [generic_options] special_mount_points ]
Description
The mount command instructs the operating system to make a file system available for use at a
specified location (the mount point). In addition, you can use the mount command to build other
file trees made up of directory and file mounts. The mount command mounts a file system
expressed as a device using the Device or Node:Directory parameter on the directory specified by
the Directory parameter. After the mount command has finished, the directory specified becomes
the root directory of the newly mounted file system.
Only users with root authority or are members of the system group and have write access to the
mount point can issue file or directory mounts. The file or directory may be a symbolic link.
The mount command uses the real user ID, not the effective user ID, to determine if the user has
appropriate access. System group members can issue device mounts, provided they have write
access to the mount point and those mounts specified in the /etc/filesystems file. Users with
root user authority can issue any mount command.
Users can mount a device provided they belong to the system group and have appropriate access.
When mounting a device, the mount command uses the Device parameter as the name of the block
device and the Directory parameter as the directory on which to mount the file system.
If you enter the mount command without flags, the command displays the following information for
the mounted file systems:
* the node (if the mount is remote)
* the object mounted
* the mount point
* the virtual-file-system type
* the time mounted
* any mount options
If you specify only the Directory parameter, the mount command takes it to be the name of the
directory or file on which a file system, directory, or file is usually mounted (as defined in
the /etc/filesystems file). The mount command looks up the associated device, directory, or file
and mounts it. This is the most convenient way of using the mount command, because it does not
require you to remember what is normally mounted on a directory or file. You can also specify
only the device. In this case, the command obtains the mount point from the /etc/filesystems
file.
The /etc/filesystems file should include a stanza for each mountable file system, directory, or
file. This stanza should specify at least the name of the file system and either the device on
which it resides or the directory name. If the stanza includes a mount attribute, the mount
command uses the associated values. It recognizes five values for the mount attributes:
automatic, true, false, removable, and readonly.
The mount all command causes all file systems with the mount=true attribute to be mounted in
their normal places. This command is typically used during system initialization, and the
corresponding mounts are referred to as automatic mounts. Note: If the cdromd CD and DVD
automount daemon is enabled, then those devices will be automatically mounted as specified in
the /etc/cdromd.conf file. Use the cdumount or cdeject command to unmount an automounted CD or
DVD. Use stopsrc -s cdromd to disable the CD/DVD automount daemon. Note: For CacheFS, the remote
filesystem that is to be cached locally must be exported such that the root ID of the local
system is not remapped on the remote host to nobody (or the ID that the remote host uses as the
anonymous user). For example, if host A were to export a filesystem /F, which would be mounted
with CacheFS on host B, then the /etc/exports on host A would need to have an entry similar to:
/F -rw,root=B
or
/F -ro,root=B
depending on the mount options used for the local CacheFS mount. Note: Mounting a JFS filesystem
on a read-only logical volume is not supported.
Flags
-a
Mounts all file systems in the /etc/filesystems file with stanzas that contain the true
mount attribute.
all
Same as the -a flag.
-f
Requests a forced mount during system initialization to enable mounting over the root file
system.
-n Node
Specifies the remote node that holds the directory to be mounted. For NFS version 4 mounts
only, the node can be specified as a colon-separated IPv6 address. If this is done with the
node:directory format, the colon-separated IPv6 address must be enclosed in square
brackets.
File System Specific Options
-o Options
Specifies options. Options entered on the command line should be separated only by a comma.
The following file system-specific options do not apply to all virtual file system types:
bsy
Prevents the mount operation if the directory to be mounted over is the current
working directory of a process.
cio
Specifies the file system to be mounted for concurrent readers and writers. I/O on
files in this filesystem will behave as if they had been opened with O_CIO specified
in the open() system call. Using this option will prevent access in any manner other
than CIO. It is impossible to use cached I/O on a filesystem mounted with the cio
option. This means that mapping commands such as mmap() and shmat() will fail with
EINVAL when used on any file in a filesystem mounted with the cio option. One side-
effect of this is that it is impossible to run binaries out of a cio mounted
filesystem, since the loader may use mmap().
dio
Specifies that I/O on the filesystem will behave as if all the files had been opened
with O_DIRECT specified in the open() system call. Note: Using the -odio or -ocio
flags can help performance on certain workloads, but users should be aware that
using these flags will prevent file caching for these file systems. Because
readahead is disabled for these file systems, this may decrease performance for
large sequential reads.
fmode=octal
Specifies the mode for a file and directory. The default is 755.
gid=gid
Specifies the GID that is assigned to files in the mount. The default is bin.
log=LVName
Specifies the full path name of the filesystem logging logical volume name where the
following file-system operations are logged.
maxpout=value
Specifies the pageout level for files on this filesystem at which threads should be
slept. If maxpout is specified, minpout must also be specified. Value must be non-
negative and greater than minpout. The default is the kernel maxpout level.
minpout=value
Specifies the pageout level for files on this filesystem at which threads should be
readied. If minpout is specified, maxpout must also be specified. Value must be
non-negative. The default is the kernel minpout level.
nocase
Turns-off case mapping. This is useful for CDROMs using the ISO 9660:1998/HSG
standard.
nodev
Specifies that you cannot open devices from this mount. This option returns a value
of ENXIO if a failure occurs.
nosuid
Specifies that execution of setuid and setgid programs by way of this mount is not
allowed. This option returns a value of EPERM if a failure occurs.
rbr
Mount filesystem with the release-behind-when-reading capability. When sequential
reading of a file in this filesystem is detected, the real memory pages used by the
file will be released once the pages are copied to internal buffers. Note: When rbr
is specified, the D_RB_READ flag is ultimately set in the _devflags field in the
pdtentry structure.
rbw
Mount filesystem with the release-behind-when-writing capability. When sequential
writing of a file in this filesystem is detected, the real memory pages used by the
file will be released once the pages written to disk. Note: When rbw is specified,
the D_RB_WRITE flag is set.
rbrw
Mount filesystem with both release-behind-when-reading and release-behind-when-
writing capabilities. Note: If rbrw is specified, both the D_RB_READ and the
D_RB_WRITE flags are set.
ro
Specifies that the mounted file is read-only. The default value is rw.
rw
Specifies that the mounted file is read/write accessible. rw is the default value.
snapshot
Specifies the Device to be mounted is a snapshot. The snapped file system for the
specified snapshot must already be mounted or an error message will display.
snapto=snapshot
Specifies the location to start a snapshot with the value of snapshot when mounting
the specified JFS2 file system.
upcase
Changes case mapping from default lowercase to uppercase. This is useful for CDROMs
using the ISO 9660:1998/HSG standard.
uid=uid
Specifies the UID that is assigned to files in the mount, the defeult is bin.
wrkgrp=workgroup
Specifies the workgroup that the SMB server belongs.
NFS Specific Options
-o Options
Specifies options. Options you enter on the command line should be separated only by a
comma, not a comma and a space. The following NFS-specific options do not apply to all
virtual file system types:
acdirmax=n
Holds cached attributes for no more than n seconds after directory update. The
default is 60 seconds.
acdirmin=n
Holds cached attributes for at least n seconds after directory update. The default
is 30 seconds.
acl
Requests using the Access Control List RPC program for this NFS mount. If the acl
option is used, the ACL RPC program is used only if the NFS server provides it. The
default is noacl.
acregmax=n
Holds cached attributes for no longer that n seconds after file modification. The
default is 60 seconds.
acregmin=n
Holds cached attributes for at least n seconds after file modification. The default
is 3 seconds.
actimeo=n
Sets minimum and maximum times for regular files and directories to n seconds. If
this option is set, it overrides any settings for the acregmin, acregmax, acdirmin,
and acdirmax options.
bg
Attempts mount in background if first attempt is unsuccessful. The default value is
fg.
biods=n
Sets the maximum number of biod threads that perform asynchronous I/O RPC requests
for an NFS mount. The maximum value that can be set is 128. Values greater than 128
are limited to 128 within the NFS client. The NFS client dynamically manages the
number of running biod threads up to the maximum based on activity. The default
maximums for the different NFS protocols are 7 for NFS version 2, 4 for NFS version
3, and 16 for NFS version 4. These defaults are subject to change in future
releases.
cio
Specifies the file system to be mounted for concurrent readers and writers. I/O on
files in this filesystem will behave as if they had been opened with O_CIO specified
in the open() system call. Using this option will prevent access in any manner other
than CIO. It is impossible to use cached I/O on a filesystem mounted with the cio
option. This means that mapping commands such as mmap() and shmat() will fail with
EINVAL when used on any file in a filesystem mounted with the cio option. One side-
effect of this is that it is impossible to run binaries out of a cio mounted
filesystem, since the loader may use mmap().
dio
Specifies that I/O on the filesystem will behave as if all the files had been opened
with O_DIRECT specified in the open() system call. Note: Using the -odio or -ocio
flags can help performance on certain workloads, but users should be aware that
using these flags will prevent file caching for these file systems. Because
readahead is disabled for these file systems, this may decrease performance for
large sequential reads.
fastattr
Bypasses the requirement that files currently being written will be sent to the
server before the attributes of the file is read. This option is to be used with
caution, since it will cause the client to assume that the file data that has not
yet reached the server will be written without problem. In case of write errors, the
client and server will have different opinions on what the size of the file really
is. Likewise, a client will not be aware of attribute changes to the file being made
by another client, so this option must not be used in environments where two clients
are writing to the same files.
fg
Attempts mount in foreground if first attempt is unsuccessful. fg is the default
value.
grpid
Directs any file or directory created on the file system to inherit the group ID of
the parent directory.
hard
Retries a request until server responds. The option is the default value.
intr
Allows keyboard interrupts on hard mounts.
llock
Requests that files lock locally at the NFS client. NFS network file locking
requests are not sent to the NFS server if the llock option is used.
maxgroups=n
Indicates that NFS RPC calls using AUTH_UNIX may include up to n member groups of
information. Using this option to increase the number of member groups beyond the
RPC protocol standard of 16 will only work against servers that support more than 16
member groups. Otherwise, the client will experience errors.
Values below 16 or greater than 64 will be ignored. By default, the protocol
standard maximum of 16 is adhered to. AIX NFS servers will accept and process
AUTH_UNIX credentials with up to 64 groups starting with AIX 5L Version 5.2 with the
5200-01 Recommended Maintenance package. The actual number of member groups sent by
the NFS client is dependent on the number of groups the involved user is a member
of, and may be limited by the length of the NFS client's hostname (which is included
in the AUTH_UNIX information).
noac
Specifies that the mount command performs no attribute or directory caching. If you
do not specify this option, the attributes (including permissions, size, and
timestamps) for files and directories are cached to reduce the need to perform
over-the-wire NFSPROC_GETATTR Remote Procedure Calls (RPCs). The NFSPROC_GETATTR RPC
enables a client to prompt the server for file and directory attributes. The
acregmin, acregmax, acdirmin, and acdirmax options control the length of time for
which the cached values are retained.
noacl
Specifies not to use the Access Control List RPC program for this NFS mount request.
The default is noacl.
nointr
Specifies no keyboard interrupts allowed on hard mounts.
port=n
Sets server Internet Protocol (IP) port number to n. The default value is the 2049.
posix
Requests that pathconf information be exchanged and made available on an NFS Version
2 mount. Requires a mount Version 2 rpc.mountd at the NFS server.
proto=[udp|tcp]
Specifies the transport protocol. The default is tcp. Use the proto=[udp|tcp] option
to override the default.
proto=udp cannot be specified if vers=4.
retrans=n
Sets the number of NFS transmissions to n. The default value is 5. The retrans
setting determines how many times the NFS client retransmits a given UDP RPC request
to an NFS server for file system operations. The retrans setting is not used during
communication with the NFS server rpc.mountd service when processing NFS version 2
and 3 mounts. Retries to rpc.mountd are controlled with the retry mount option.
retry=n
Sets the number of times the mount is attempted to n; the default value is 1000.
When the retry value is 0, the system makes 10,000 attempts.
rsize=n
Sets the read buffer size to n bytes. The default value is 8192. For AIX 4.2.1 and
later, the default value is 32768 when using Version 3 of the NFS protocol. For AIX
5.3 and later, the default value is 32768 when using Version 4 of the NFS protocol.
secure
Specifies that the mount command uses Data Encryption Standard (DES) for NFS
transactions.
sec=flavor[:flavor...]
Specifies a list of security methods that may be used to access files under the
mount point. Allowable flavor values are:
sys
UNIX(R) authentication. This is the default method.
dh
DES authentication.
krb5
Kerberos. Authentication only.
krb5i
Kerberos. Authentication and integrity.
krb5p
Kerberos. Authentication, integrity, and privacy.
The secure option may be specified, but not in conjunction with a sec option.
The secure option is deprecated and may be eliminated in a future release.
Use sec=dh instead.
sec=[flavor1:...:flavorn]
The sec option specifies the security flavor list for the NFS mount. The available
flavors are des, unix, sys, krb5, krb5i, and krb5p. This option only applies to AIX
5.3 or later.
shortdev
Specifies that you are mounting a file system from a host that does not support 32-
bit device special files.
soft
Returns an error if the server does not respond. The default value is hard.
timeo=n
Sets the Network File System (NFS) time-out period to n tenths of a second. For TCP
mounts, the default timeout is 100, which equals 10 seconds. For UDP mounts, the
default timeout is 11, which equals 1.1 seconds, but varies depending on the NFS
operation taking place. For UDP mounts, the timeout will increase for each failed
transmission, with a maximum value of 20 seconds. Each transmission will be
attempted twice, after which the timeout value is updated. The timeo option does not
apply to communication from the NFS client to the rpc.mountd service on NFS servers.
A timeout of 30 seconds is used when making calls to rpc.mountd.
vers=[2|3|4]
Specifies NFS version. The default is the version of NFS protocol used between the
client and server and is the highest one available on both systems. If the NFS
server does not support NFS Version 3, the NFS mount will use NFS Version 2. Use the
vers=[2|3|4] option to select the NFS version. By default, the NFS mount will never
use NFS Version 4 unless specified. The vers=4 only applies to AIX 5.3 or later.
wsize=n
Sets the write buffer size to n bytes. The default value is 8192. For AIX 4.2.1 and
later, the default value is 32768 when using Version 3 of the NFS protocol. For AIX
5.3 and later, the default value is 32768 when using Version 4 of the NFS protocol.
-p
Mounts a file system as a removable file system. While open files are on it, a removable
mounted file system behaves the same as a normally mounted file system. However, when no
files are open (and no process has a current directory on the file system), all of the file
system disk buffers in the file system are written to the medium, and the operating system
forgets the structure of the file system.
-r
Mounts a file system as a read-only file system, regardless of its previous specification
in the /etc/filesystems file.
-t Type
Mounts all stanzas in the /etc/filesystems file that contain the type=Type attribute and
are not mounted. The Type parameter specifies the name of the group.
-v VfsName
Specifies that the file system is defined by the VfsName parameter in the /etc/vfs file.
CacheFS Specific Options
The CacheFS-specific version of the mount command mounts a cached file system; if necessary, it
NFS-mounts its back file system. It also provides a number of CacheFS-specific options for
controlling the caching process.
To mount a CacheFS file system, use the mount command with the -V flag followed by the argument.
The following mount flags are available.
The following arguments to the -o flag are specifically for CacheFS mounts. Options you enter on
the command line should be separated only by a comma, not a comma and a space. Note: The
backfstype argument must be specified.
-o
Specifies options.
acdirmax=n
Specifies that cached attributes are held for no more than n seconds after directory
update. Before n seconds, CacheFS checks to see if the directory modification time
on the back file system has changed. If it has, all information about the directory
is purged from the cache and new data is retrieved from the back file system. The
default value is 60 seconds.
acdirmin=n
Specifies that cached attributes are held for at least n seconds after directory
update. After n seconds, CacheFS checks to see if the directory modification time on
the back file system has changed. If it has, all information about the directory is
purged from the cache and new data is retrieved from the back file system. The
default value is 30 seconds.
acregmax=n
Specifies that cached attributes are held for no more than n seconds after file
modification. After n seconds, all file information is purged from the cache. The
default value is 30 seconds.
acregmin=n
Specifies that cached attributes are held for at least n seconds after file
modification. After n seconds, CacheFS checks to see if the file modification time
on the back file system has changed. If it has, all information about the file is
purged from the cache and new data is retrieved from the back file system. The
default value is 30 seconds.
actimeo=n
Sets acregmin, acregmax, acdirmin, and acdirmax to n.
backfstype=file_system_type
The file system type of the back file system (for example, nfs).
backpath=path
Specifies where the back file system is already mounted. If this argument is not
supplied, CacheFS determines a mount point for the back file system.
cachedir=directory
The name of the cache directory.
cacheid=ID
ID is a string specifying a particular instance of a cache. If you do not specify a
cache ID, CacheFS will construct one.
demandconst
Enables maximum cache consistency checking. By default, periodic consistency
checking is enabled. When you enable demandconst, it checks on every read and write.
Note: Note: If this option is used the first time a specific CacheFS is mounted,
then the option must also be specified for subsequent mounts. There is state
information stored in the cache control files that enforces consistent use of this
option.
local_access
Causes the front file system to interpret the mode bits used for access checking
instead or having the back file system verify access permissions. Do not use this
argument with secure NFS.
noconst
Disables cache consistency checking. By default, periodic consistency checking is
enabled. Specify noconst only when you know that the back file system will not be
modified. Trying to perform cache consistency check using cfsadmin-s will result in
error. demandconst and noconst are mutually exclusive. Note: Note: If this option is
used the first time a specific CacheFS is mounted, then the option must also be
specified for subsequent mounts. There is state information stored in the cache
control files that enforces consistent use of this option.
purge
Purge any cached information for the specified file system. Note: Note: If this
option is used the first time a specific CacheFS is mounted, then the option must
also be specified for subsequent mounts. There is state information stored in the
cache control files that enforces consistent use of this option.
rw | ro
Read-write (default) or read-only.
suid | nosuid
Allow (default) or disallow set-uid execution
write-around | non-shared
Write modes for CacheFS. The write-around mode (the default) handles writes the same
as NFS does; that is, writes are made to the back file system, and the affected file
is purged from the cache. You can use the non-shared mode when you are sure that no
one else will be writing to the cached file system. Note: Note: If this option is
used the first time a specific CacheFS is mounted, then the option must also be
specified for subsequent mounts. There is state information stored in the cache
control files that enforces consistent use of this option.
-V
Mounts a CacheFS file system.
Examples
1 To list the mounted file systems, enter:
mount
This command produces output similar to the following:
node mounted mounted vfs date options over
---- ------- --------- --- ------------ ------- ---------
/dev/hd0 / jfs Dec 17 08:04 rw, log =/dev/hd8
/dev/hd3 /tmp jfs Dec 17 08:04 rw, log =/dev/hd8
/dev/hd1 /home jfs Dec 17 08:06 rw, log =/dev/hd8
/dev/hd2 /usr jfs Dec 17 08:06 rw, log =/dev/hd8
sue /home/local/src /usr/code nfs Dec 17 08:06 ro, log =/dev/hd8
For each file system, the mount command lists the node name, the device name, the name
under which it is mounted, the virtual-file-system type, the date and time it was mounted,
and its options.
2 To mount all default file systems, enter: mount all
This command sequence mounts all standard file systems in the /etc/filesystems file marked
by the mount=true attribute.
3 To mount a remote directory, enter: mount -n nodeA /home/tom.remote /home/tom.local
This command sequence mounts the /home/tom.remote directory located on nodeA onto the local
/home/tom.local directory. It assumes the default VfsName parameter=remote, which must be
defined in the /etc/vfs file.
4 To mount a file or directory from the /etc/filesystems file with a specific type, enter:
mount -t remote
This command sequence mounts all files or directories in the /etc/filesystems file that
have a stanza that contains the type=remote attribute.
5 To CacheFS-mount the file system which is already NFS-mounted on /usr/abc, enter:
mount -V cachefs -o backfstype=nfs,backpath=/usr/abc,
cachedir=/cache1 server1:/user2 /xyz
The lines similar to the following appear in the /etc/mnttab file after the mount command
is executed:
server1:/user2 /usr/abc nfs
/usr/abc /cache1/xyz cachefs backfstype=nfs
6 To mount a snapshot, type:
mount -o snapshot /dev/snapsb /home/janet/snapsb
This command mounts the snapshot contained on the /dev/snapsb device onto the
/home/janet/snapsb directory.
7 To mount a file system and create a snapshot, type:
mount -o snapto=/dev/snapsb /dev/sb /home/janet/sb
This command mounts the file system contained on the /dev/sbdevice onto the /home/janet/sb
directory and creates a snapshot for the file system on the /dev/snapsbdevice.
8 To access files on an SMB server as a local filesystem, type:
mount -v cifs -n pezman/user1/pass1 -o uid=201,fmode=750 /home /mnt
Files
/etc/filesystems
Lists the known file systems and defines their characteristics.
/etc/vfs
Contains descriptions of virtual-file-system types.
Related Information
The cdcheck command, cdeject command, cdmount command, cdromd command, cdumount command, cdutil
command, nfso command, umount command.
The mntctl subroutine, mount subroutine, umount subroutine.
The filesystems file, vfs file.
For information on installing the Web-based System Manager, see Chapter 2: Installing Web-based
System Manager in AIX 5L Version 5.3 Web-based System Manager Administration Guide.
Mounting and System management interface tool in Operating system and device management.
Performance implications of hard or soft NFS mounts in Performance management.
===================================
直接I/O支持。
以前,Oracle数据库仅对Oracle集群文件系统(OCFS)提供直接I/O支持。现在,Oracle 10g还对网络文件系统(NFS)中的直接I/O提供支持。"有了Oracle 10g,就有了直接支持,而且是直接在数据库中提供的,而不是通过打补丁获得的,"Coekaerts说。"这可以确确实实地提高性能--尤其是在NFS 中,所有事务处理的速度都变快了。在NFS上运行RAC真好。"Coekaerts认为,这种直接I/O支持对于单个节点也非常重要,因为你不必将数据缓存在OS文件系统中,但却可以使用Oracle的算法。
来源:
===================================
该问题解决了[20060626]
参考文档: Oracle® Real Application Clusters 10g Release 2 with AIX 5L Version 5.3 and NetApp Storage
Note:
The “cio” mount option should not be used for ORACLE_HOME and CRS_HOME (the volume where CRS and Oracle binaries are placed).
Oracle install will fail if you dynamically mount the NFS volumes without adding entries in the /etc/filesystems file.
-o rw,bg,hard,intr,proto=tcp,vers=3,rsize=32768,wsize=32768,timeo=600
$ uname -a
AIX P270 2 5 0005A9DC4C00
在文件"/etc/filesystems"中添加的项目有:
/aa1:
dev = /aa
vfs = nfs
log = /tmp/nfslog
mount = true
options = rw
account = false