SP2-0750: You may need to set ORACLE_HOME to your Oracle



Share this article :

You are getting below error while trying to connect the Oracle SQL level,

> sqlplus "/as sysdba"
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

Solution

Set the ORACLE_HOME environment using the command prompt (for Windows operating system). Ensure to set the environment path before the \bin directory.

set ORACLE_HOME=C:\oracle\product\10.2.0\ITsiti

Alternatively, you can set by right click on the My Computer > Advanced > Environment Variables. Click New under System variables. On the New System Variable tab, fill in the Variable name as ORACLE_HOME and Variable value with the location as above. (Below screenshot is the example of maintaining the JAVA_HOME – You can do the same step)

Windows ORACLE_HOME Environment Variable

Once configured, you can check using below command,

>echo %ORACLE_HOME%
C:\oracle\product\10.2.0\ITsiti

Try to log in into SQL level again,

>sqlplus

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jan 8 17:48:15 2014

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter user-name:

Related posts

How to Find / List Available Schema in Oracle
How to Change Oracle Listener Default Name
How to Replace Specific Value in Oracle DB Column
How to Limit Oracle Query Result
© 2018 ITsiti. All Rights Reserved
Powered by KEEM