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

Hi,

This error means that ORACLE_SID is not set. Sqlplus doesn't know what database/instance you want to talk to.

You have to set ORACLE_SID, use oraenv.

"Peter BUSS" <pbuss_at_datacomm.ch> wrote in message 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 - 05:58:53 CST