Re: ORACLE not available

Does that user has the same system priviledge as user oracle?

What is the exact steps that user take which results the error message?

Is that user trying to use sqlplus or svrmgrl?

In article <8pbgsr$h85$1_at_nnrp1.deja.com>,   softdesigner_at_my-deja.com wrote:
> Thanks much for the reply. This is how I set the environment
 variables
> in all user's .cshrc:
>
> setenv ORACLE_HOME /software/oracle
> setenv ORACLE_SID ORCL
> setenv ORACLE_OWNER oracle
>
> That's why it puzzles me why it does not work :)
>
> Dennis
>
> In article <8pbfk3$fm5$1_at_nnrp1.deja.com>,
> gmei_at_my-deja.com wrote:
> > Does that different user get all the environment variable as oracle
> > iuser gets, such as
> >
> > ORACLE_HOME
> > ORACLE_SID
> > ORACLE_BASE
> >
> > Make sure that user also get these. you can set this in .profile
> >
> > Guang
> >
> > In article <8pbbis$agl$1_at_nnrp1.deja.com>,
> > softdesigner_at_my-deja.com wrote:
> > > I am new to Oracle. I just installed Oracle 8i on a Solaris 2.6
 machine
> > > as user oracle. The database is up and running. If I login in as
> > > oracle, I can run "sqlplus system/manager". However, running the
 same
> > > command as different user I get the ERROR: ORA-01034: ORACLE not
> > > available message, even though the database is running at that
 moment
> > > (tnsping returns Ok). I can run a simple java program connecting
 to
 the
> > > database via jdbc thin driver successfully. It seems to be a
 permission
> > > problem when it comes to using sqlplus. Because of this issue the
> > > initiation of WebLogic EJB server fails. Any suggestion on how to
> > > tackle this problem is greatly appreciated. Thanks :)
> > >
> > > 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 Fri Sep 08 2000 - 15:39:44 CDT