How to resolve SP2-0750: You may need to set ORACLE_HOME in Oracle 10g

Hi,

This post will help you to set the ORACLE_HOME when you are getting error while connecting to SQL* plus like below

Error 6 initializing SQL*Plus
Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

While when we are unable to connect SQL* plus because of the above error We have to set ORACLE_HOME. To do that, we need to follow the below steps.

1. Find out the oracle installed directory
(In My PC I installed in D:\oracle\product\10.2.0\db_1 folder.)
2. Navigate to the installed directory (D:\oracle\product\10.2.0\db_1) through command prompt. (How to navigate within the directories in CMD prompt)
3. Type the below command to set ORACLE_HOME(With out quotes)

"SET ORACLE_HOME=D:\oracle\product\10.2.0\db_1"

4. Now you can log in with SCOTT, SYSTEM what ever user you required.