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

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

SP2-0750

From: sol beach <sol.beach_at_gmail.com>
Date: Sat, 5 Feb 2005 11:33:02 -0800
Message-ID: <40a16b3605020511332f2fae15@mail.gmail.com>


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
Received on Sat Feb 05 2005 - 14:35:42 CST

Original text of this message

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