Today I ran into this error on my Linux environment where I have Oracle 10XE installed:
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 did not have $ORACLE_HOME variable setup. I added the below line to my .bashrc file and reran as . .bashrc:
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
The above resolution fixed the issue.
sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 17 16:10:48 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name:
