Saturday, 22 April 2017

SP2-0667: Message file sp1.msb not found | Fixed

SP2-0667: Message file sp1<lang>.msb not found | Fixed

This if the one of the most common errors that is being faced by many of Oracle DBA Professionals while trying to run the SQLPLUS Utility to create a Session in Oracle Database. But if you'll see the Error Messages that it is showing, you will yourself get an idea of the reason for why this happened.

[oracle@as ~]$ sqlplus
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

"SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory" clearly indicates that you are missing one of your major Environment Variables in order to get connected to the Oracle. The Environment Variables should be properly defined in bash_profile (in Linux) or profile (in Unix) to avoid such issues.

But still if you want to continue without making the entries in the bash_profile or profile, just set the variables on terminal or Command Windows and continue. After setting the correct Environment Variables, SQLPLUS connectivity to Oracle Database will be successfully done.


  1. do you have any fix for that? maybe an example showing how everything should be

  2. These often involve store-bought and more natural home remedies. Let's get right into it! Pros • Uses real-chemical urine compounds • Matches the PH of real urine • Simple to use Cons • Short shelf life • Some testing facilities can detect it Some companies like Test Negative sell synthetic urine, which some people use to pass drug tests with. The fake urine comes in various forms, such as a belt with a premixed solution that you'd wear under your clothes to maintain the mixture’s temperature. After this, the false urine passes through a rubber tube which is released through the bladder bag. Seems like a lot of work. Now, all this might seem overwhelming due to the sheer number of components in the kit, but the company’s detailed instructions make sure that you don’t get lost during the process Visit: