Re: STILL trouble with getting Oracle 8i/PHP running
| From: | thies at digicol dot de | Date: | Wed, 09 Aug 2000 09:28:53 +0000 |
| Subject: | Re: STILL trouble with getting Oracle 8i/PHP running | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-1890@lists.php.net to get a copy of this message | ||
On Tue, Aug 08, 2000 at 12:02:05PM -0700, Deirdre Saoirse wrote:
> I have the compiles done. I can log into Oracle via sqlplus. I set up my
> apache. I now know I'm *talking* to Oracle, but it's still not happy.
> phpinfo() shows Oracle is there. The database is up. The web server is
> running as a user that can log in via sqlplus. The environment variables
> are set correctly. The copy of oracle is running on the local host.
>
> I have searched archives, google, deja and no one seemed to have an answer
> that was relevant.
>
> The script I'm using:
>
> <html> <head> <title>Oracle Test Results Page</title> </head>
> <body
> bgcolor=#FFFFFF>
>
> <h1 align=center>Oracle Test Results Page</h1>
>
> <?php
> $conn = OCILogon("system","manager");
> print "Oracle HOME = $ORACLE_HOME\n<br>";
> print "Oracle Connection ID = $conn\n<br>";
> if ($conn != "")
> {
> print "Server Version: " . OCIServerVersion($conn);
> OCILogOff($conn);
> } ?>
>
>
> </body>
> </html>
>
> The results are the same:
>
> Warning: OCISessionBegin: ORA-01034: ORACLE not available in
> /home/httpd/html/oratest.php on line 10
are you sure that you have ORACLE_SID set in your
environment?
tc
>
> I have recompiled now that suid is set on Oracle.
>
> I am out of ideas.
>
> And, given that I've been banging on this for a week, if I can't get it up
> in the next day, it's going to have to be done in another language, which
> I would *rather* not do. But deadlines are deadlines.
>
> Help!
>
> --
> _Deirdre * http://www.sfknit.org *
> http://www.deirdre.net
> "We can always count on the British. Except for the Revolutionary War
> they've been perfect." -- Mel Brooks, on the first Concorde flight since
> the Paris crash.
>
>
> --
> PHP Install Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-install-unsubscribe@lists.php.net
> For additional commands, e-mail: php-install-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
--
Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!"
Digital Collections Phone +49 40 235350 Fax +49 40 23535180
Hammerbrookstr. 93 20097 Hamburg / Germany