Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORACLE_HOME doesn't work for sqlplus

11242May 23 2007 — edited Jun 1 2007

When I define the system environment variable ORACLE_HOME within the system properties, the sqlplus doesn't work in the command line. I got an error as follows:

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

If I remove the ORACLE_HOME variable, the sqlplus works. However, I have to set the ORACLE_HOME variable for my standalone OC4J. The value of ORACLE_HOME is c:\oc4j.

How can I resolve this problem?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 29 2007

Added on May 23 2007

3 comments

1,831 views