Today i got lots complains about our NFS shared oracle client on AIX plaform.
The sqlplus totally doesn't work and gives the aio64 error.
Search the metalink, found the solution as below:
Oracle executables fail to run on AIX: Symbol resolution failed for /usr/lib/libc.a[aio_64.o]
Note:235537.1
symptom:
0509-130 Symbol resolution failed for /usr/lib/libc.a[aio_64.o]
because:
symptom: 0509-136 Symbol listio64 (number 1) is not exported from dependent module /unix.
symptom: 0509-136 Symbol iosuspend64 (number 3) is not exported from dependent module /unix.
symptom: 0509-136 Symbol aio_nwait64 (number 5) is not exported from dependent module /unix.
symptom: 0509-136 Symbol aio_nwait_timeout64 (number 7) is not exported from dependent module /unix.
symptom: 0509-192 Examine .loader section symbols with the 'dump -Tv' command.
change: Filesystem mode changed from JFS2 to
Solution:
Make Asynchronous I/O available on system, following the next steps to set it
up:
1. Log in as root
2. Type:
mkdev -l aio0
This command attempts to verify that Asynchronous I/O services are
running (available on system), if not, they are started.
3. To ensure it is configured at each system restart :
a. Type: smit aio
b. Select the menu item "Change/Show Characteristics of Asynchronous
I/O"
c. Change the field "STATE to be configured at system restart"
from DEFINED to AVAILABLE.
or just execute the next command and it will do the same as the previous a, b
and c steps:
chdev -l aio0 -a autoconfig='available'
which should return the message "aio0 changed".
Step 3 (either of the two ways) will toggle the state to be configured at
system restart to be
available, making asynchronous I/O available with each system reboot.