This discussion is archived
1 Reply Latest reply: Nov 27, 2012 1:14 AM by LaurenzAlbe RSS

Oracle Instant Client

975125 Newbie
Currently Being Moderated

I downloaded the instant client packages for AIX from the following link.

I downloaded and

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

Edited by: 972122 on Nov 27, 2012 12:24 AM

Edited by: 972122 on Nov 27, 2012 12:36 AM
  • 1. Re: Oracle Instant Client
    LaurenzAlbe Journeyer
    Currently Being Moderated
    First, you should copy the shared objects from 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 was not found.
    You should not copy the message and time zone files from another installation, they are contained in

    - 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/, it should be ok.
    - If all fails, use "truss" to find out if and where sqlplus is looking for, maybe then you can figure out why it is not found.

    Laurenz Albe


  • Correct Answers - 10 points
  • Helpful Answers - 5 points