RE: SP2-0750
- From: "Hollis, Les" <Les.Hollis@xxxxxx>
- To: <tanel.poder.003@xxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 5 Feb 2005 16:44:58 -0600
When you copied the files, did you do so maintaining the file =
permissions? Sounds like a permissions problem.....
cp -rp
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tanel P=F5der
Sent: Saturday, February 05, 2005 2:03 PM
To: Oracle-L Freelists
Subject: Re: SP2-0750
Hi,
Do your oracle user's environment variables ORACLE_HOME and ORA_NLS33 =
still=20
correspond to actual directory locations? (maybe you didn't copy=20
oracle-users .profile over or smth).
Also, check the file permissions.
Tanel.
----- Original Message -----=20
From: "sol beach" <sol.beach@xxxxxxxxx>
To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
Sent: Saturday, February 05, 2005 7:33 PM
Subject: SP2-0750
> 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@xxxxxxxxxxxxxxx:/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=20
> directory
> <sdb1-oracle@xxxxxxxxxxxxxxx:/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.
> --
> //www.freelists.org/webpage/oracle-l=20
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
