I downloaded the instant client packages for AIX from the following link.
I downloaded instantclient-basic-aix.ppc32-220.127.116.11.0.zip and instantclient-sqlplus-aix.ppc32-18.104.22.168.0.zip.
I extracted all files from the basic to */home/client/lib* and all files from sqlplus to */home/client/sqlplus/bin*
I copied */home/client/sqlplus/bin/sqlplus* to */home/client/bin*.
And I set the environment variables. export ORACLE_HOME=/home/client export PATH=/home/client/bin:$PATH export LD_LIBRARY_PATH=/home/client/lib:$LD_LIBRARY_PATH
I could not startup sqlplus with the following errors.
Error 6 initializing SQL*Plus SP2-0667: Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
It was fixed by copying sqlplus/mesg from oracle 22.214.171.124 to my directory ( */home/client/sqlplus/mesg* )
I cannot start up sqlplus with the following errors. SP2-1503: Unable to initialize Oracle call interface SP2-0152: ORACLE may not be functioning properly
This error was fixed by copying oracore/zoneinfo from oracle 126.96.36.199 to my directory ( */home/client/oracore/zoneinfo* )
I also needed to create tnsnames.ora file inside */home/client/network/admin/tnsnames.ora*
I don't know, if I don't have any other oracle client version, where I can download those necessary files.
First, you should copy the shared objects from instantclient-sqlplus-aix.ppc32-188.8.131.52.0.zip to your /home/client/lib so that they can be found.
It is not necessary to set ORACLE_HOME with Instant Client (but it should not hurt either).
Your error message (SP2-0667: Message file sp1<lang>.msb not found) indicates that the Instant Client shared library libociei.so was not found.
You should not copy the message and time zone files from another installation, they are contained in libociei.so.
- Make sure that you use the correct sqlplus (the one from the Instant Client installation).
- Check what shared libraries are loaded (ldd /home/client/bin/sqlplus).
If that uses /home/client/lib/libclntsh.so, it should be ok.
- If all fails, use "truss" to find out if and where sqlplus is looking for libociei.so, maybe then you can figure out why it is not found.