Re: Newbie Question: Trying to Start SQLPlus, Error

OK, I should have investigated a little bit before posting. Figured that part out:

ORACLE_HOME=/usr/oracle/9.0
export ORACLE_HOME

Put that in my .bash_profile and viola sqlplus loads.

Now, I have a different problem:

---
SQL*Plus: Release 9.2.0.1.0 - Production on Sun Aug 18 18:19:30 2002

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: oracle
Enter password:
ERROR:
ORA-07217: sltln: environment variable cannot be evaluated.
---

What environment variable is it talking about?  Would this username and
password be any different that my unix login and password? Any ideas?

Thanks
Patrick


"Patrick Altman" <junk_at_pataltman.com> wrote in message
news:CLX79.65755$2p2.3169795_at_bin4.nnrp.aus1.giganews.com...


> This is what I get after logging on as the 'oracle' user and executing

> ./sqlplus from the shell:

>

> 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


>

> Does all this message mean is that the ORACLE_HOME shell variable is not

> getting set?  If this is the case, how would I set it and what could I do

to


> automatially set it every time I log in?

>

> Sorry for the elementary question.

>

> Patrick

>

>