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

I don't have suid set for my oracle executable. Are you sure this is required for correct behaviour? I mean, my dbora start script runs oracle executable as "oracle". So the suid bit wouldn't have to be set. (I would think...). My database instances start fine. I am having trouble connecting to them from accounts other than oracle, for some reason though. I will try to set the suids and see what happens though.

Thanks

In article <87c96h$6uo$1_at_news.liv.ac.uk>,   qq45_at_liverpool.ac.uk (Ms. D.H. Harvey) wrote:
> 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
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Feb 03 2000 - 22:04:37 CST