Re: Install Question.

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: 1997/06/17
Message-ID: <33a6d529.26481448@newshost.us.oracle.com>#1/1

Sounds like you don't have the environment variable ORACLE_SID set. See the example below where I unset the variable, recreate your error, and then set it back:

elvis> unsetenv ORACLE_SID
elvis> sqlplus scott/tiger

SQL*Plus: Release 3.3.2.0.0 - Production on Tue Jun 17 14:19:03 1997

ERROR: ORA-01034: ORACLE not available
ORA-07200: slsid: oracle_sid not set.

elvis>
elvis> setenv ORACLE_SID office
elvis> sqlplus scott/tiger

SQL*Plus: Release 3.3.2.0.0 - Production on Tue Jun 17 14:19:20 1997

Connected to:
Oracle7 Server Release 7.3.2.2.0 - Production Release With the distributed option
PL/SQL Release 2.3.2.2.0 - Production

SQL> On Tue, 17 Jun 1997 14:48:54 +0000, Pieter Huyser <pieter_at_inetsys.alt.za> wrote:

>Hi,
>
>I have a problem with an Oracle install.
>Under the unix user oracle everything works fine.
> sqlplus user/password
>When I change to another user sqlplus complains that it could not
>connect to the database
> sqlplus user/password
>
>but when I type in
> sqlplus user/password_at_host
>everything works fine.
>
>Any idea where you set the default host?
>--
>Pieter Huyser
>pieter_at_inetsys.alt.za
>Telephone: +27 12 3484246
>Fax : +27 12 3484249
>
>Those who do not understand Unix are condemned to reinvent it, poorly.
> -- Henry Spencer

Thanks!

Joel

Joel R. Kallman          Enabling the Information Age through
Oracle Government                Network Computing!
Bethesda, MD                  http://govt.us.oracle.com
jkallman@us.oracle.com          http://www.oracle.com

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Tue Jun 17 1997 - 00:00:00 CDT