[work log] Errors when run sqlplus and svrmgrl after relink oracle server

July 12. 2004

I met a couple of time the problem.  The nearest time was last week.

solution - from Metalink note.

Problem Description:
====================
Running SVRMGRL (or any other Oracle tool such as SQL*Plus) on an IBM AIX RS/6000
machine returns:

On AIX prior to 4.3:
Could not load program oracle
Symbol kaio_rdwr in /usr/lib/libc.a is undefined
Symbol iosuspend in /usr/lib/libc.a is undefined
Symbol cancel in /usr/lib/libc.a is undefined
Symbol listio in /usr/lib/libc.a is undefined
Could not load library libc.a[aio.o]
Error was: Exec format error
Cannot startup oracle.

On AIX 4.3.x:
exec(): 0509-036 Cannot load program svrmgrl because of the following errors:
0509-023 Symbol kaio_rdwr in /usr/lib/libc_r.a is not defined.
0509-023 Symbol listio in /usr/lib/lib c_r.a is not defined.
0509-023 Symbol acancel in /usr/lib/libc_r.a is not defined.
0509-023 Symbol iosuspend in /usr/lib/libc_r.a is not defined.
0509-022 Cannot load library libc_r.a[aio.o].
0509-026 System error: Cannot run a file that does not have a valid format.

Problem Explanation:
====================
Asynchronous I/O has not been configured or started on the system.

Solution Description:
====================
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.

Solution Explanation:
=====================
Oracle executables need of Asynchronous I/O to work properly.

Search words:
=============
libc_r.a, libc.a, Async, Undefined, Symbol, Asynchronous
kaio_rdwr, aio.o, forma