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

In article <38989ea6_3_at_news3.prserv.net>,   "Jane Schrock" <jschrock_at_us.ibm.com> wrote:
> Have you granted connect and resource to the scott user?
>

The problem seems to be _before_ i get on sqlplus; so scott's privileges are irrelevant. Through oracle account (Unix account), I can login as scott (db user) and do whatever he is permitted to do.

> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Feb 03 2000 - 09:42:06 CST