Add New Skills!

Udemy

Monday, October 17, 2011

SQL*Plus error: SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory


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: