While i am trying to connect with with database by the command sqlplus /nolog

than the error message is coming

"sp2-0667 message file sp2 lang .msb not found and sp2-0750 error is coming on windows"

Earlier it was working fine i think some path issue is there so can any one tell me how to resolve the issue or how to set the path on windows machine

  • 1
    have you checked ORACLE_HOME environment variable is set properly? I think the errors SP2-0667 and SP2-0750 are caused by ORACLE_HOME is not set correctly.
    – atokpas
    Commented Jan 6, 2016 at 5:07
  • pls tell me how to set through command prompt
    – sam
    Commented Jan 6, 2016 at 5:14
  • C:>Set ORACLE_HOME=path to oracle home
    – atokpas
    Commented Jan 6, 2016 at 5:16

1 Answer 1


Setting the ORACLE_HOME environment variable incorrectly may cause these errors.

On Linux, you can set ORACLE_HOME as $ export ORACLE_HOME=path\to\oracle\home and on Windows you can set as C:\>set ORACLE_HOME=/path/to/oracle/home/.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.