DBA Sensation

July 7, 2008

oracle client got aio error on aix platform

Filed under: [client related] — zhefeng @ 11:26 pm
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.
Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: