Does anyone know anything about Oracle?

davidstvz · 10-17-2008, 02:59 PM

I have oracle database 9 installed on this old sun solaris machine. It's used every semester for students to run sql queries and junk for classwork.

The problem is the previous sysadmin is gone and now I have to run this stuff. I have a password for an account called "system", but when I try to run sqlplus it tells me:

Code:

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

However, there are no .msb files anywhere on the server. I know the course work is cleared each semester for the next round of students, so maybe I need to start from scratch here.

Anyone got any ideas?

carltm · 10-18-2008, 04:15 AM

Did you try "echo $ORACLE_HOME" and "echo $PATH" to
make sure you have the right stuff in your environment?

If it's missing, see if you can add what you need.
If not, you may may want to consider reinstalling.

davidstvz · 10-20-2008, 01:26 PM

Quote:

Originally Posted by carltm

Did you try "echo $ORACLE_HOME" and "echo $PATH" to
make sure you have the right stuff in your environment?

If it's missing, see if you can add what you need.
If not, you may may want to consider reinstalling.

I did a system wide search for files with the extension .mdb and found nothing. ORACLE_HOME is not set, but setting it doesn't fix anything.

I guess I'm stuck with trying to do a new installation from scratch.