How i can set the ORACLE_HOME and ORACLE_SID system variables. I also got this error.But i can see sp1us.msb on my this directory C:\Oracle\product\10.1.0\Client_2\install\sqlplus\mesg.
How to solve it... I hope you can help me..And i appreciate you help.
I hava the same problem in windws 2000 with ORACLE Express data base; in my enviroments variables I wrote:
and add this to PATH:
But when execute the command sqlplus under
send me the error message
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
I rewied that sp1<lang>.msb found in the directory and it is ok
I tried set enviroment under DOS window, but the problem persist
I had a similiar issue. I had a CMD file that would setup my login & pwd based on params, then CD, then run SqlPlus. When I ran the CMD file, I would get the "Message file sp1 lang .msb not found" error, but if I manually executed the same line the CMD file was using to launch SqlPlus, everything worked great. The CMD was using an environment var to specify the full path of the SqlPlus executable. What I discovered is that the SqlPlus.exe executable didn't like the fact that I was using an environment variable called "SQLPLUS":
... do some stuff...
%SQLPLUS% %OPTIONS% %UID%@%SID%
As it turns out, the name "SQLPLUS" (along with about 6 billion other names) is a special / sacred environment variable name for Oracle... I took out the SQLPLUS env var and the CMD file worked.
I had installed an earlier version of Oracle client which had an environment variable set in the system variables in the environment variable dialog available from the Advances tab in the system properties dialog. During the install of 10 this got unset. I didn't notice it was still there and unset and I set a new one as a user variable. After I deleted the unset one which was overriding my user one I was in the clear.
Note that even in my cygwin shell, the user set variable was correct, but the unset version was causing the issue.