Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlplus fine from "oracle" account, error from other account
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 - 15:04:05 CST