Tuesday, April 1, 2014

Knowledge Base - SP2-0750 Oracle Home Not Set

When  I create a new database  using DBUA and It gave me  the following error.

Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

When I read through the threads and oracle materials. It clearly said it is a ORACLE_HOME issue.I did following work around to  overcome the problem.

C:\>set ORACLE_HOME=<your Oracle Home>
C:\>set PATH=%ORACLE_HOME%\bin;%PATH%
C:\>set ORACLE_SID=<your SID>
C:\>sqlplus "/ as sysdba"

It woked.  :)

Thank you!

No comments:

Post a Comment