How to Enable Async I/O for Sqlplus

How to Enable Async I/O for Sqlplus

If you hit the following error, it mean you had hit the async I/O problem.

SQL> connect / as sysdba
exec(): 0509-036 Cannot load program oracleebsprd because of the following errors:
        0509-130 Symbol resolution failed for /usr/lib/libc.a[aio_64.o] because:
        0509-136   Symbol kaio_rdwr64 (number 0) is not exported from
                   dependent module /unix.
        0509-136   Symbol listio64 (number 1) is not exported from
                   dependent module /unix.
        0509-136   Symbol acancel64 (number 2) is not exported from
                   dependent module /unix.
        0509-136   Symbol iosuspend64 (number 3) is not exported from
                   dependent module /unix.
        0509-136   Symbol aio_nwait (number 4) is not exported from
                   dependent module /unix.
        0509-136   Symbol aio_nwait64 (number 5) is not exported from
                   dependent module /unix.
        0509-136   Symbol aio_nwait_timeout (number 6) is not exported from
                   dependent module /unix.
        0509-136   Symbol aio_nwait_timeout64 (number 7) is not exported from
                   dependent module /unix.
        0509-026 System error: Error 0
        0509-192 Examine .loader section symbols with the
                 'dump -Tv' command.
ERROR:
ORA-12547: TNS:lost contact

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: smitty 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.

Step 3 will toggle the state to be configured at system restart to be available, making
asynchronous I/O available with each system reboot.