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

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. Received on Wed Feb 02 2000 - 14:17:30 CST