1 Reply Latest reply on Nov 27, 2012 9:14 AM by Laurenz Albe

    Oracle Instant Client


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

      I downloaded instantclient-basic-aix.ppc32- and instantclient-sqlplus-aix.ppc32-

      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
          Laurenz Albe
          First, you should copy the shared objects from instantclient-sqlplus-aix.ppc32- 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.

          Laurenz Albe