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

Oracle8i Installation Guide:

The oracle executable, and the following network executables: cmctl, cmadmin, cmgw, names, namesctl, tnsping, osslogin, trcroute, trcasst, onrsd, oemevent, oratclsh, dbsnmp, lsnrctl and tnslsnr require perms 6751 (yes I know ours differs) so the executables run as the oracle user and dba group regardless of who executes them.

HTH Helen

huseyinsikici_at_my-deja.com wrote:

: 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 Fri Feb 04 2000 - 04:52:33 CST