Re: sqlplus fine from "oracle" account, error from other account

Have you granted connect and resource to the scott user?

Jane

<huseyinsikici_at_my-deja.com> wrote in message news:87a641$1bu$1_at_nnrp1.deja.com...
>
>
> 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_at_nnrp1.deja.com>,
> steyaert_at_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_at_my-deja.com
> >
> > In article <879vq8$s5s$1_at_nnrp1.deja.com>,
> > huseyinsikici_at_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.
Received on Wed Feb 02 2000 - 16:11:52 CST