2011-11-11

installation / relink of oracle binaries is slow on NETAPP NFS mount

Relink of binaries on NetApp NFS filesystems is slow [ID 602858.1]

Symptoms

Plan to install Oracle CRS software -v10.2.0.3, and Oracle Database software - v10.2.0.3, on Oracle Enterprise Linux 4.0 Update 5 and above (x86-64), locally on every node, to be able to perform rolling patch application to Oracle CRS software and Oracle Database software.

Follow steps in Note 359515.1 to mount the file systems on NetApp NFS filesystems to install Oracle 10gR2 RAC on Oracle Enterprise Linux 4.0 Update 5 (x86-64) and above for Ebusiness R12.0.4.Use actimeo=0 to mount the filesystems on which the Oracle Clusterware software and Oracle Database software are installed.
1.Installation of the software takes very long at relink phase
2.Relink of Oracle Database software using adcfgclone.pl on database tier fails with timeout

Cause

actimeo=0 disables NFS attribute cache. It resets to zero the following:
acregmin = The minimum time in seconds that attributes of a regular file should be cached before requesting fresh information from server. The default is 3 seconds,
acregmax =  The maximum time in seconds that attributes of a regular file should be cached before requesting fresh information from the server. The default is 60 seconds
acdirmin=  The minimum time in seconds that attributes of a directory should be cached before requesting fresh information from a server. The default is 30 seconds.
acdirmax= The maximum time in seconds that attributes of a directory can be cached before requesting fresh information from a server. The default is 60 seconds.
When the above are set to zero, any process like a relink of executables involves additional metadata calls and the most current file attributes have to be accessed from the server everytime a file or directory is accessed.
In an environment with Shared Binaries, actimeo=0 needs to be set as per Note 359515.1 to ensure that the most current file attributes are available from the server.

In an environment with local installation of Oracle Database software and Oracle CRS software, this is not required since the same files are not shared across multiple nodes.
Oracle Datafiles, Redo Log files, Voting Disk and OCR must be on volumes mounted with the options listed in  Note 359515.1

Solution

1. Unmount the filesystems, on each node, on which the Oracle database binaries and Oracle CRS binaries will be installed locally(non-shared).
2. Mount the filesystems, locally(non-shared), on each node, (Oracle database software binaries and Oracle CRS software) with mount options:
rw,bg,hard,nointr,rsize=32768, wsize=32768,tcp,vers=3, timeo=600
3. Continue with the installation
4. Migrate a single instance Oracle Ebusiness R12 database binaries to the volume and clone using adcfgclone.pl

Niciun comentariu:

Trimiteți un comentariu