Re: Mystery ORA-1034 (Oracle Not Available)

<deirdre_at_deirdre.net> schrieb im Newsbeitrag news:8mpo56$dq4$1_at_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 Received on Tue Aug 08 2000 - 00:00:00 CDT