Possible cause of "Message file SP1<lang>.msb not found"

[THoey]

Just in case anyone does a search for this error message, I post a problem/fix I found.

I had an Windows NT batch file that was used to load a data file into Oracle using SQL*Loader and then run some other queries using SQL*Plus. In this batch file, I had several temporary environment variables declared for consistancy and ease of typing. Some examples of these were:

REM Environmental Constants
SET ORACLE_SID=TSOR
SET SQLLDR=D:\ORACLE\ORA817\BIN\SQLLDR.EXE
SET SQLPLUS=D:\ORACLE\ORA817\BIN\SQLPLUS.EXE

I would use these variables the following way:

%SQLLDR% login/passwd@tsor %CTL_FILE1% %LOG_LDR1% %BAD_AITNCFU% 
%SQL_PLUS% login/passwd@tsor %SQL_UPDATE% >> %LOG_AITNCFU%

This worked with a Oracle 7.3.4 database, but it generates a Dr. Watson error with Oracle 8.1.7.1.5. Looking in the dump file, you see the following error:

Message file SP1<lang>.msb not found

Changing the variable name fixed it:

SET SQL_PLUS=D:\ORACLE\ORA817\BIN\SQLPLUS.EXE

It took me a week to figure it out, so I thought I might try and save someone else the time...

Hope that helps... Terry M. Hoey