Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SP2-0750

Re: SP2-0750

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Sat, 5 Feb 2005 20:02:31 -0000
Message-ID: <042501c50bbd$a08fcbb0$0301a8c0@porgand>


Hi,

Do your oracle user's environment variables ORACLE_HOME and ORA_NLS33 still correspond to actual directory locations? (maybe you didn't copy oracle-users .profile over or smth).

Also, check the file permissions.

Tanel.

> Linux sdb1.hitbox.com 2.4.9-e.43enterprise #1 SMP Tue Jun 29 13:57:26
> EDT 2004 i686 unknown
>
> Oracle V9.2.0.4
>
> I need help with a problem that has me baffled.
>
> The system had two drives; a 40 GB & an 80GB drive. The 80 GB was
> mounted under /b.
> /b holds ORACLE_HOME and all the DB datafiles. This drive filled up.
> We got a 300GB disk.
> We copied all the files from the 80 GB to the 300GB & mounted the
> 300GB under /b.
>
> Now SQLPLUS won't start.
>
> <sdb1-oracle_at_sdb1.hitbox.com:/b:> sqlplus
> 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
> <sdb1-oracle_at_sdb1.hitbox.com:/b:>
>
>
> find $ORACLE_HOME -name sp1us.msb -ls
> 8519687 12 -rw-r--r-- 1 oracle dba 11264 Apr 26 2002
> /b/oracle/product/9.2.0/sqlplus/mesg/sp1us.msb
>
> So from above it shows ORACLE_HOME is set & the file does exist.
> In theory nothing else on the system has changed.
> Therefore I am at a loss WRT what needs to change to get sqlplus to start.
> Any clues, suggestions, or pointers would be greatly appreciated.
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Feb 05 2005 - 15:05:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US