AIX-Oracle : Symbol resolution Failed For ..

If you are an Oracle DBA & Own an iPhone , Here we have must to download app for you . Available World Wide in App store !!

iDBA DownLoad

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Its possible sometime you prefer to copy the Oracle Binaries instead of installing gracefully as you don't have time to go thru time consuming process .

Don't be surprised if you are hitting below error .

[uoracle:/u01/app/oracle/product/9.2.0/bin]/>./sqlplus

exec(): 0509-036 Cannot load program ./sqlplus 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-150 Dependent module libc.a(aio_64.o) could not be loaded.

0509-026 System error: Cannot run a file that does not have a valid format.

0509-192 Examine .loader section symbols with the

'dump -Tv' command.

[uoracle:/u01/app/oracle/product/9.2.0/bin]/>

Then to resolve it , You will do below :

[uoracle:/u01/app/oracle/product/9.2.0/bin]/>relink all

- - - - - - - - - - - - -

Even After still getting below Error , Let's have a look .

In General we may encounter below linkage problem during invoacation of sqlplus

[uoracle:/home/uoracle]/>sqlplus

exec(): 0509-036 Cannot load program sqlplus 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-150 Dependent module libc.a(aio_64.o) could not be loaded.

0509-026 System error: Cannot run a file that does not have a valid format.

0509-192 Examine .loader section symbols with the

'dump -Tv' command.

Caused By : Problem may caused by AIX aio . Which has to be changed explicitly for Oracle .

[uoracle:/home/uoracle]/>exit

Resolution : Run rootpre.sh avilalabe within Oracle installer sfotware for AIX (using root user) .

apd2t:root:/u01/app/oracle/product>./rootpre.sh

Configuring Asynchronous I/O...

aio0 Available

aio0 changed

apd2t:root:/u01/app/oracle/product>

Problem Solved :

wapd2t:root:/u01/app/oracle/product>su - uoracle

[uoracle:/home/uoracle]/>

[uoracle:/home/uoracle]/>sqlplus

SQL*Plus: Release 9.2.0.5.0 - Production on Tue Mar 9 21:49:27 2010

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name:

[uoracle:/home/uoracle]/>