Xref: alice comp.databases.oracle.misc:52390
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: huseyinsikici@my-deja.com
Newsgroups: comp.databases.oracle.misc
Subject: Re: sqlplus fine from "oracle" account, error from other account
Date: Wed, 02 Feb 2000 21:04:05 GMT
Organization: Deja.com - Before you buy.
Lines: 59
Message-ID: <87a641$1bu$1@nnrp1.deja.com>
References: <879vq8$s5s$1@nnrp1.deja.com> <87a3cj$v41$1@nnrp1.deja.com>
X-Article-Creation-Date: Wed Feb 02 21:04:05 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
X-Http-Proxy: 1.0 x36.deja.com:80 (Squid/1.1.22) for client 38.164.171.7
X-MyDeja-Info: XMYDJUIDhuseyinsikici



They are set. Everything is the same on both accounts. (oracle acct.
and say, guest). If the ld_library_path wasn't set, sqlplus wouldn't
even startup. It does startup but you'll get the error below.

-B

In article <87a3cj$v41$1@nnrp1.deja.com>,
  steyaert@my-deja.com wrote:
> 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.
>


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