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.

No comments:

Post a comment