Mystery ORA-1034 (Oracle Not Available)

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. Received on Tue Aug 08 2000 - 00:00:00 CDT