Re: Oracle 9.2 on Linux SuSE 8.1 sqlplus error and jre problem

Peter,

It's complaining about an environment variable not being set. Although it doesn't tell you which one it's actually missing there are not that many env. vars that cannot be missed at startup. On my own system I tried to start my 9.2 database after unsetting ORACL:E_SID and see what happens: exactly the same error as you got on your laptop! Another guess would have been ORACLE_HOME, but this one will give you another error:
$ 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

So my guess is: set your ORACLE_SID to the appropriate value and start your database.

regards,
Peter

"Peter BUSS" <pbuss_at_datacomm.ch> schreef in bericht news:apiv3a$1uv5$1_at_news.imp.ch...
> I recently installed Oracle 9.2 on my Linux PC and Notebook
> and the installation and creation of the sample dataware house
> went fine.
>
> I then upgraded my notebook to SuSE Linux 8.1. I was forced to
> make a complete reinstallation because the upgrade was bad.
>
> I also accidently formatted the partitions erasing everthing.
>
> I Then re-installed Oracle 9.2 with problems
> - When it came time to run the 4 optional installations the installer
> couldn't find the jre. I used the blackdown jre 1.1.8 v3 and
> the installation completed with success.
> - The database was up after installation but after a reboot
> I couldn't start the database because sqlplus would give
> the error :
> ...
> SQL> startup
> ORA-07217: sltln: environment variable cannot be evaluated.
>
> My notebook is a toshiba 4000CDS with a Pentium II 233MHz
>
> Hope someone can help.
>
> Peter
>
>
Received on Mon Oct 28 2002 - 07:53:45 CST