topic Re: PHP with Oracle problem in Operating System - Linux

PHP with Oracle problem

Fadia Almarei — Mon, 15 Aug 2005 05:04:13 GMT

Dear All
i have Redhat Enterprise Linux v.4 As,i install on it Apache 1.3.33 and php-4.4 and oracle 10g v.2 ,i run the apache and t is good i try to try a PHP file and it works , but when i try a cript which connect to the oracle DB it gives me the following error
"ocilogon(): _oci_open_server: Error while trying to retrieve text for error ORA-12546 "
i see that it is permission error but i do not know what to do, the apache installed as a root user and it runs as a nobody user, kindly help.
BR,
Fadia

Re: PHP with Oracle problem

Alex Lavrov. — Mon, 15 Aug 2005 08:12:01 GMT

It seems that oracle client is not configured right on your box. Ususally you get this message when it doesn't find the files of oracle client, so it can't fetch the description of the errors.

Do you have oracle client files on this server?

create php file "phpinfo.php" with this code:

And run it. Check if you see OCI support enabled. If not, it seems that you should compile PHP with OCI libraries.

Alex.

Re: PHP with Oracle problem

Fadia Almarei — Mon, 15 Aug 2005 08:28:20 GMT

i do not have oracle client , the oracle server and the PHP in the same server.

Re: PHP with Oracle problem

Alex Lavrov. — Mon, 15 Aug 2005 08:38:07 GMT

OK, it's even better. What about "phpinfo.php" output?

Re: PHP with Oracle problem

Steven E. Protter — Mon, 15 Aug 2005 09:06:34 GMT

There is definitely an integration issue with Oracle.

Oracle ships this product with its own port of apache with special extensions made to give database access.

The error code you are getting is pretty generic and pretty much shows that Oracle is not really sure whats wrong, but something is wrong.

General advice here is that if possible its better to use the products that Oracle has integrated instead of what ships with Linux. Their httpd server will use a different port and will co-exist nicely with the apache that ships with the OS.

The PHP script itself probably has an environment variable thats pointing to the wrong apache server or binaries and I'd look at the script carefully and see if there is a problem there.

SEP

Re: PHP with Oracle problem

Alex Lavrov. — Mon, 15 Aug 2005 09:52:49 GMT

Oh, right, it's been a while I did it.

Now that SEP brought up the environment issue.

Check if the ORACLE_HOME environment set in apache, I bet this is the problem.

Alex.

Re: PHP with Oracle problem

Fadia Almarei — Wed, 17 Aug 2005 00:46:39 GMT

Dear Alex
the ORACL_HOME variable set ccorrectly before i start the apache, i install apache in /opt/apache filder , if you can send me a php script to connect to oracle and i will try it.

Re: PHP with Oracle problem

Alex Lavrov. — Wed, 17 Aug 2005 00:48:44 GMT

You can see samples here:

http://il.php.net/manual/en/ref.oci8.php

But according to your error, something is wrong, so if you want to help us help you, it will be very helpfull to attach an output of script :)

Re: PHP with Oracle problem

Fadia Almarei — Wed, 17 Aug 2005 01:00:07 GMT

thanks for your help Alex,the php script in the attachment