Cannot Connect to Oracle 9i DB Server

452573

Hi,

My problem is, I cannot connect to Oracle 9i DB Server. I tried to run the php_info() and it displays: <br><br>

OCI8 Support enabled <br>
Version 1.2.2 <br>
Revision $Revision: 1.322 $ <br>
Active Persistent Connections 0 <br>
Active Connections 0 <br>
Temporary Lob support enabled <br>
Collections support enabled <br><br>

Directive Local Value Master Value <br>
oci8.default_prefetch 10 10 <br>
oci8.max_persistent -1 -1 <br>
oci8.old_oci_close_semantics 0 0 <br>
oci8.persistent_timeout -1 -1 <br>
oci8.ping_interval 60 60 <br>
oci8.privileged_connect Off Off <br>
oci8.statement_cache_size 20 20 <br><br>

I've got this from error.log in apache server. <br><br>

PHP Warning: ocilogon() [function.ocilogon]: <br>OCIEnvNlsCreate() failed. There is something wrong with your system - please <br>check that PATH includes the directory with Oracle Instant Client libraries in <br>C:\\EID_Web\\Exercises\\connect_to_oracle.php on line 14<br><br>

PHP Warning: ociparse() expects parameter 1 to be resource, boolean given in <br>C:\\Web\\connect_to_oracle.php on line 15<br><br>

PHP Warning: ociexecute() expects parameter 1 to be resource, null given in <br>C:\\Web\\connect_to_oracle.php on line 16<br><br>

PHP Warning: ocifetch() expects parameter 1 to be resource, null given in <br>C:\\Web\\connect_to_oracle.php on line 22<br><br>

PHP Warning: ocifreestatement() expects parameter 1 to be resource, null given in <br>C:\\Web\\connect_to_oracle.php on line 32<br><br>

PHP Warning: ocilogoff() expects parameter 1 to be resource, boolean given in <br>C:\\Web\\connect_to_oracle.php on line 33<br><br>

By the way, I'm using apache server version 2.2.3 and PHP/5.2.0RC6-dev running on <br>windows 2000 as our web server. We have a remote Oracle9i DB Server.<br><br>
Thanks in advance for the help.

392393

Well, does your PATH environment varaible contain the Instant Client Libraries?
That's what the error message says to check...

~Jer

452573

I already solved the problem. The problem is incompatability issue with regards to the version of apache, php and oracle. If you are using Oracle9i DB, use PHP version 4.4.4 and Apache version 1.3.35. Don't forget to add the ORACLE_HOME and its path at the Environment Variable tab.

392393

I have php 5.1.2 and apache 2.2 with instantclient 10 connected to a 9.2 database and it runs great. So I suppose I disagree with the suggestion to downgrade php and apache.


~Jer

452573

Ok. I will try to test your suggestion. Thanks for the comment

553210

I get this error, i decided to change directory for oracle_home

putenv("ORACLE_HOME=C:/oracle/product/10.2.0/db_1/bin");

to

putenv("ORACLE_HOME=C:/oracle/product/10.2.0/db_1");

it functioned.

my code


<?php

putenv("ORACLE_HOME=C:/oracle/product/10.2.0/db_1");

putenv("ORACLE_SID=PLSExtProc");

$user ="name"; // set user
$senha="password"; // set password
$banco="(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)
(HOST=127.0.0.1)(PORT=1521)
)
)
(CONNECT_DATA=(SERVICE_NAME=orcl))
)"; // configuracoes do banco (isso muda um pouco no oracle)

if ($conexao = OCILogon($user,$senha,$banco))
echo "Conexão bem sucedida.";
else
echo "Erro na conexão com o Oracle.";
?>

Christopher Jones-Oracle

Don't use putenv() with Oracle environment variables - it is error prone and
not portable. See http://www.oracle.com/technology/tech/php/htdocs/php_troubleshooting_faq.html#envvars

-- cj

PS If you had a question, please start a new thread.

1052938

The problem is driver OCI 8 version:

INFO muy práctica y sencilla: Solución: Error driver oci8 en php codigniter con oracle