Re: ORACLE not available

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. Received on Fri Sep 08 2000 - 15:07:09 CDT