NFS mount points that are disconnected on AIX cause Oracle instance Hang

NFS mount points that are disconnected on AIX cause Oracle instance Hang
Translated from MoS article: Disconnected NFS Mount point causes Instance to hang on AIX (document ID 1445600.1)

Suitable for:
Oracle server-enterprise edition-version:10.2.0.1 and later [release:10.2 and later]
IBM AIX on POWER Systems (64-bit)
IBM AIX on POWER Systems (32-bit)

Characteristics:
An NFS file system is not available, causing database instance to hang until the mount point resumes. Oracle's client cannot log in to database instance. However, the file system is not used by the database.

Change:
The remote file system is not available.

Reason:
This is a issue with the on which the system call GETCWD is implemented within AIX.

Solution:
Outside of the root directory, this problem does not occur as long as there is at least one parent directory for the Mount point of NFS. The remote file system is either accessible or inaccessible.

Example:
Assuming that the current NFS mount point is/faraway_files, the solution is to rename the mount point and change to a format such as/my_mounts/faraway_files (Level two directory)

# unmount/faraway_files # mkdir/my_mounts# mv/faraway_files/my_mounts# Mount Remhost01:/documents/my_mounts/faraway_ Files

Be sure to make a similar configuration change in Smit so that the configuration is preserved after reboot.

NFS mount points that are disconnected on AIX cause Oracle instance Hang