This content has been marked as final. Show 1 reply
First, you should copy the shared objects from instantclient-sqlplus-aix.ppc32-18.104.22.168.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.