Xref: alice comp.databases.oracle.misc:52384
Path: alice!news-feed.fnsi.net!hammer.uoregon.edu!logbridge.uoregon.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: steyaert@my-deja.com
Newsgroups: comp.databases.oracle.misc
Subject: Re: sqlplus fine from "oracle" account, error from other account
Date: Wed, 02 Feb 2000 20:17:30 GMT
Organization: Deja.com - Before you buy.
Lines: 43
Message-ID: <87a3cj$v41$1@nnrp1.deja.com>
References: <879vq8$s5s$1@nnrp1.deja.com>
X-Article-Creation-Date: Wed Feb 02 20:17:30 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows 98)
X-Http-Proxy: 1.1 x22.deja.com:80 (Squid/1.1.22) for client 166.90.234.217
X-MyDeja-Info: XMYDJUIDsteyaert

The other accounts to have ORACLE_HOME, ORACLE_SID and LD_LIBRARY_PATH
set.  You cannot connect to an Oracle database (that I know of) without
those environment variables being set.

Terry Steyaert
steyaert@my-deja.com

In article <879vq8$s5s$1@nnrp1.deja.com>,
  huseyinsikici@my-deja.com wrote:
>
> > Hello everyone,
> >
> > I can successfully connect sqlplus to any database. Oracle 8i on
> RedHat
> > 6.1. However, I can't get any other account to do the same. The
paths
> > look exactly the same. I get
> >
> > Enter user-name: scott
> > Enter password: tiger
> > ERROR:
> > ORA-02034: ORACLE not available
> >
> > -------
> >
> > The database is available; I can connect to the same db using
sqlplus
> > on a "oracle" xterm. I believe there is some kind of permission that
> > has to be set on oracle files, I am not sure which one needs to be
> > changing. I mean, I could use oracle account for all sqlplus
sessions,
> > but ORACLE documentation suggests otherwise.
> >
> > Thanks in advance,
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>


Sent via Deja.com http://www.deja.com/
Before you buy.