An NFS file system is unavailable, causing databaseinstancehang to stay until the mount point is restored. Oracle Client cannot log on to databaseinstance.
An NFS file system is unavailable, causing the database instance to hang until the mount point is restored. The Oracle Client cannot log on to the database instance.
Oracle instance hang is occupied by NFS mount points disconnected on AIX.
From mos: Disconnected NFS Mount Point Causes Instance to Hang on AIX (Document ID 1445600.1)
Applicable:
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)
Features:
An NFS file system is unavailable, causing the database instance to hang until the mount point is restored. The Oracle Client cannot log on to the database instance. However, the file system is not used by the database.
Change:
Remote file systems are unavailable.
Cause:
This is an issue with the way in which the system call getcwd is implemented within AIX.
Solution:
In addition to the root directory, this problem does not occur as long as the NFS mount point has at least one parent directory. Whether the remote file system is accessible or not.
Example:
Assume that the current NFS mount point is/faraway_files. The solution is to rename the mount point and change it to a format such as/my_mounts/faraway_files (level-2 directory)
# Unmount/faraway_files
# Mkdir/my_mounts
# Mv/faraway_files/my_mounts
# Mount remhost01:/documents/my_mounts/faraway_files
Make sure to make similar configuration changes in smit, so that the configuration can be retained after reboot.