LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   Does anyone know anything about Oracle? (https://www.linuxquestions.org/questions/linux-software-2/does-anyone-know-anything-about-oracle-677183/)

davidstvz 10-17-2008 02:59 PM
Does anyone know anything about Oracle?
 
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 (Post 3314307)
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.


All times are GMT -5. The time now is 07:22 AM.