[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:
Cocould 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
Cocould 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 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 shoshould 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