Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 2000051

[PHP3] update on oracle problem (still there and stranger...) From: Alex Black (enigma <email protected>)
Date: 05/10/00

My code is as follows:

<?
putenv("ORACLE_SID=SID");
putenv("ORACLE_HOME=/correct/home/oracle");

$c2 = ocilogon("username","pass","SID");
echo $c2;
phpinfo() ?>

I have the oracle client installed on the webserver, and I can tnsping the
SID:

tnsping SID 10
returns:

-----------------------------
TNS Ping Utility for Linux: Version 8.1.6.0.0 - Production on 10-MAY-2000
18:34:27

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Attempting to contact
(ADDRESS=(PROTOCOL=TCP)(HOST="MY.DATABASE.HOST)(PORT=1521))
OK (0 msec)
OK (0 msec)
OK (10 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (10 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
-----------------------------

ORACLE_SID and ORACLE_HOME come up properly in the "environment" section of
phpinfo...

I know the password is correct, and the sid seems to be working.
-----------

The error I receive on page:

Warning: OCISessionBegin: ORA-01034: ORACLE not available in ...test.php on
line 3

.........

Should I be looking towards my DBserver now? Is it likely an oracle problem
only?

has anyone run into this before?

if you are around, please e-mail, as my deadline is tonight
(wheeeeeeeeeeeeeee :)

thanks! really! thanks!

_alex 

--
Alex Black, Head Monkey
enigma <email protected>

The Turing Studio, Inc.
http://www.turingstudio.com

vox+510.666.0074
fax+510.666.0093

Saul Zaentz Film Center
2600 Tenth St Suite 433
Berkeley, CA 94710-2522

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>