From: "Ronald Kuczek" <ronald@breitenbach.pl>
Subject: Re: Mystery ORA-1034 (Oracle Not Available)
Date: 2000/08/08
Message-ID: <8mpqiv$cdg$1@news.netcologne.de>#1/1
Distribution: world
References: <39844E27.1C45B111@okara.com> <8mpo56$dq4$1@nnrp1.deja.com>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
X-Complaints-To: abuse@netcologne.de
X-Trace: news.netcologne.de 965766559 12720 195.14.248.186 (8 Aug 2000 20:29:19 GMT)
X-MSMail-Priority: Normal
NNTP-Posting-Date: 8 Aug 2000 20:29:19 GMT
Newsgroups: comp.databases.oracle.server



<deirdre@deirdre.net> schrieb im Newsbeitrag
news:8mpo56$dq4$1@nnrp1.deja.com...
> I've been trying to hook up PHP4 to use Oracle and, as the problem may
> be a permissions issue, I thought I'd post here as I've exhausted help
> on the PHP lists.
>
> I'm using Red Hat Linux 6.2, PHP4 (a late snapshot, though I've tried),
> statically built into Apache 1.3.12 with threading support. I have
> verified that PHP and Apache are built with threads via ldd (this is to
> work around a glibc 2.1 bug). I have rebuilt the kernel with the shared
> memory and rebooted. This is Oracle 8i (8.1.6).
>
> I am able to start the database and issue commands from within sqlplus.
>
> I am running my web server as an Oracle privileged user (oracle)
> temporarily while debugging. So it *should* work.
>
> But, when I try to connect, I get "ORA-1034: Oracle not available."
>
> When I was using php's OCI logon, I was not specifying an ORACLE_SID as
> I'm running the database on the web server locally. (This is just a test
> setup for proof-of-concept so that's fine). The ORACLE_SID is correctly
> set in the environment, as are all the expected variables.
>
> However, I think somehow *something* didn't get done as yesterday I had
> to explicitly chmod the oracle binary so other users could log in. My
> guess is that was probably done in some script that didn't get run and
> this may be part of the side effects.
>
> Does anyone have *any* useful ideas? I am a moderately experienced
> Oracle DBA, but this has really been frustrating.
>
> _Deirdre
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Hi !
See Oracle documentation:
"ORA-01034: Oracle not available
Cause: Oracle was not started up. Possible causes include the following:

The SGA requires more space than was allocated for it.

The operating system variable pointing to the instance was improperly
defined.

Action: Refer to accompanying messages for possible causes and correct the
problem mentioned in the other messages. Retry after Oracle has been
initialized.

If Oracle has been initialized, then on some operating systems, verify that
Oracle was linked correctly. See the platform-specific Oracle documentation.
"

Greetings
Rony