[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.
Running SVRMGRL (or any other Oracle tool such as SQL*Plus) on an IBM AIX RS/6000
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.
Asynchronous I/O has not been configured or started on the system.
Make Asynchronous I/O available on system, following the next steps to set it up:
1. Log in as root
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.
Oracle executables need of Asynchronous I/O to work properly.
libc_r.a, libc.a, Async, Undefined, Symbol, Asynchronous
kaio_rdwr, aio.o, forma