Error 6 initializing SQL*Plus; SP2-0667: Message file sp1.msb not found ; SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

After having installed Oracle Instant Client, you unexpectedly run into this problem when executing the command: sqlplus <oracle user>/<oracle password>@<oracle IP address>:<port>/<oracle database name>.

It returns the following messages:

      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 

To fix this problem:

1. Create a lib directory in your Oracle Instant Client directory.

      mkdir lib

2. Copy the  ojdbc6.jar, ojdbc5.jar, xtreams.jar, and all the .so files to the lib directory.

3. Create a bin directory in your Oracle Instant Client directory.

4. Copy the adrci, genezi, odbc_update_ini.sh, sqlplus, and uidrvci files to the bin directory.

5. Create a sqlplus/admin directory in your Oracle Instant Client directory and copy the glogin.sql to this directory.

6. Create a network/admin directory in your Oracle Instant Client directory.

7. Create the tnsnames.ora file in the network/admin directory.

      <Oracle database name> =
          (DESCRIPTION =
              (ADDRESS = (PROTOCOL = TCP)(HOST = <oracle IP address>)(PORT = 1521))
              (CONNECT_DATA =
                  (SERVER = DEDICATED)
                  (SERVICE_NAME = <Oracle service name>)
              )

Create the sqlnet.ora file in the network/admin directory.

      TCP.CONNECT_TIMEOUT=10

8. Set the environmental variables.

      export ORACLE_HOME=/usr/oracle/instantclient_12_1

      export PATH=$ORACLE_HOME/bin:$PATH

      export LD_LIBRARY_PATH=$ORACLE_HOME/lib

      export SQLPATH=$ORACLE_HOME/sqlplus/admin

      export TNS_ADMIN=$ORACLE_HOME/network/admin

      export NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252

9. Logout and log back in.

Reference:

1. oracle instant client 12.1 SP2-0667: Message file sp1<lang>.msb not found

-----------------------------------------------------------------------------------------------------------------

Watch the blessing and loving online channel: SupremeMasterTV live

If you have ever asked yourself these questions, this is the book for you. What is the meaning of life? Why do people suffer? What is in control of my life? Why is life the way it is? How can I stop suffering and be happy? How can I have a successful life? How can I have a life I like to have? How can I be the person I like to be? How can I be wiser and smarter? How can I have good and harmonious relations with others? Why do people meditate to achieve enlightenment? What is the true meaning of spiritual practice? Why all beings are one? Read the book for free here.