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

Are the permissions on $ORACLE_HOME/bin/oracle correct? On SUN Solaris ours are: *rwsr-sr-x

HTH Helen

huseyinsikici_at_my-deja.com wrote:
: 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.

--
Helen Received on Thu Feb 03 2000 - 10:08:49 CST