Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORACLE not available

Re: ORACLE not available

From: <softdesigner_at_my-deja.com>
Date: Fri, 08 Sep 2000 20:07:09 GMT
Message-ID: <8pbgsr$h85$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US