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

Thanks for the info, it didn't work though. Tried both methods you suggested...

Since the error is coming from sqlplus, not from OS, I tempted to think a sqlplus configuration file needs to be changed so that other users can login. I still don't know what that file is though....

Regards,

In article <87c4nc$csq$1_at_nnrp1.deja.com>,   steyaert_at_my-deja.com wrote:
> I don't currently have an 8.1.5 database available, but my 8.0.5
> database has permissions rw-rw----. This means that having a user not
> in your dba group would fail. You can try changing the permissions of
> the actual dbf files to o+r.
>
> That should be a very legal change.
>
> Terry Steyaert
> steyaert_at_my-deja.com.
>
> P.S. With the 6.0 database, the users that wanted to use the database
> had to be running osh. You can try exec osh and see if that
functions,
> too.
>
> 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?
> >
> > 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Feb 03 2000 - 09:53:51 CST