Solved

Oracle AIX error

Posted on 2004-10-13
5
4,406 Views
Last Modified: 2008-06-20
Could not load program oraclekom:
Symbol resolution failed for /usr/lib/libc.a[aio_64.o] because:
   Symbol kaio_rdwr64 (number 0) is not exported from dependent
     module /unix.
   Symbol listio64 (number 1) is not exported from dependent
     module /unix.
   Symbol acancel64 (number 2) is not exported from dependent
     module /unix.
   Symbol iosuspend64 (number 3) is not exported from dependent
     module /unix.
   Symbol aio_nwait (number 4) is not exported from dependent
     module /unix.
   Dependent module libc.a(aio_64.o) could not be loaded.
Error was: Exec format error
Examine .loader section symbols with the 'dump -Tv' command.
ERROR:
ORA-12547: TNS:lost contact


SP2-0640: Not connected
Could not load program oraclekom:
Symbol resolution failed for /usr/lib/libc.a[aio_64.o] because:
   Symbol kaio_rdwr64 (number 0) is not exported from dependent
     module /unix.
   Symbol listio64 (number 1) is not exported from dependent
     module /unix.
   Symbol acancel64 (number 2) is not exported from dependent
     module /unix.
   Symbol iosuspend64 (number 3) is not exported from dependent
     module /unix.
   Symbol aio_nwait (number 4) is not exported from dependent
     module /unix.
   Dependent module libc.a(aio_64.o) could not be loaded.
Error was: Exec format error
Examine .loader section symbols with the 'dump -Tv' command.
Could not load program oraclekom:
Symbol resolution failed for /usr/lib/libc.a[aio_64.o] because:
   Symbol kaio_rdwr64 (number 0) is not exported from dependent
     module /unix.
   Symbol listio64 (number 1) is not exported from dependent
     module /unix.
   Symbol acancel64 (number 2) is not exported from dependent
     module /unix.
   Symbol iosuspend64 (number 3) is not exported from dependent
     module /unix.
   Symbol aio_nwait (number 4) is not exported from dependent
     module /unix.
   Dependent module libc.a(aio_64.o) could not be loaded.
Error was: Exec format error
Examine .loader section symbols with the 'dump -Tv' command.
ORA-12547: TNS:lost contact
Could not load program oraclekom:
Symbol resolution failed for /usr/lib/libc.a[aio_64.o] because:
   Symbol kaio_rdwr64 (number 0) is not exported from dependent
     module /unix.
   Symbol listio64 (number 1) is not exported from dependent
     module /unix.
   Symbol acancel64 (number 2) is not exported from dependent
     module /unix.
   Symbol iosuspend64 (number 3) is not exported from dependent
     module /unix.
   Symbol aio_nwait (number 4) is not exported from dependent
     module /unix.
   Dependent module libc.a(aio_64.o) could not be loaded.
Error was: Exec format error
Examine .loader section symbols with the 'dump -Tv' command.
ERROR:
ORA-12547: TNS:lost contact


Could not load program oraclekom:
Symbol resolution failed for /usr/lib/libc.a[aio_64.o] because:
   Symbol kaio_rdwr64 (number 0) is not exported from dependent
     module /unix.
   Symbol listio64 (number 1) is not exported from dependent
     module /unix.
   Symbol acancel64 (number 2) is not exported from dependent
     module /unix.
   Symbol iosuspend64 (number 3) is not exported from dependent
     module /unix.
   Symbol aio_nwait (number 4) is not exported from dependent
     module /unix.
   Dependent module libc.a(aio_64.o) could not be loaded.
Error was: Exec format error
Examine .loader section symbols with the 'dump -Tv' command.
Could not load program oraclekom:
Symbol resolution failed for /usr/lib/libc.a[aio_64.o] because:
   Symbol kaio_rdwr64 (number 0) is not exported from dependent
     module /unix.
   Symbol listio64 (number 1) is not exported from dependent
     module /unix.
   Symbol acancel64 (number 2) is not exported from dependent
     module /unix.
   Symbol iosuspend64 (number 3) is not exported from dependent
     module /unix.
   Symbol aio_nwait (number 4) is not exported from dependent
     module /unix.
   Dependent module libc.a(aio_64.o) could not be loaded.
Error was: Exec format error
Examine .loader section symbols with the 'dump -Tv' command.
ORA-12547: TNS:lost contact
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SP2-0640: Not connected

Why ...????????
0
Comment
Question by:Dhalfin Rich
  • 3
  • 2
5 Comments
 
LVL 48

Expert Comment

by:schwertner
ID: 12305652
·      change: Filesystem mode changed from JFS2 to JFS
·      cause: Asynchronous I/O has not been configured or started on the system.

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

0
 

Author Comment

by:Dhalfin Rich
ID: 12317377
I  have tried this, but still get the same error when I create a
database.  do U Have another Tips Mr. schwertner ...
Thanks For U Kind help...
0
 
LVL 48

Expert Comment

by:schwertner
ID: 12320285
Sorry for this. I am terribly tired and will try to look in metalink on Monday afternoon. Sorry, have installed Oracle on Linux...
0
 

Author Comment

by:Dhalfin Rich
ID: 12327919
Thanks..But If U Find the Solusion please give cause is urgent
0
 
LVL 48

Accepted Solution

by:
schwertner earned 500 total points
ID: 12337297
I found only this:


Turn off asynchronous I/O - reboot.
Turn on asynchronous I/O - reboot.
Then it works...

0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question