Re: problem with php oracle on linux
| From: | PHP - NEWS | Date: | Wed, 15 Jun 2005 15:32:44 +0000 |
| Subject: | Re: problem with php oracle on linux | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39686@lists.php.net to get a copy of this message | ||
TEST your connection :
if ($c=OCILogon("user", "password", "db")) {
echo "Successfully connected to Oracle.\n";
} else {
$err = OCIError();
echo "Oracle Connect Error " . $err[text];
}
if you have an error try to add other putenv() as :
putenv("ORACLE_BASE=/home/oracle");
putenv("ORACLE_HOME=/home/oracle/OraHome");
putenv("ORACLE_SID=TEST");
putenv("NLS_LANGUAGE=FRENCH_FRANCE.WE8ISO8859P1");
putenv("TNS_ADMIN=/home/oracle/OraHome/network/admin");
putenv("TNS_ADMIN=/home/oracle/OraHome/");
putenv("ORA_NLS33=/home/oracle/OraHome/ocommon/nls/admin/data");
putenv("LD_LIBRARY_PATH=/home/oracle/OraHome/lib:/home/oracle/OraHome/network/l$
putenv("TWO_TASK=TEST-ORCL");
GL
Anom a écrit :
i have configured and compiled php 4.11 with oracle client 10g (not instant client) on linux and works fine. the client connects well with the oracle server which reside on other machine. but the problem arise when i used php, i've got the following warning : *Warning*: ocilogon(): _oci_open_server: Error while trying to retrieve text for error ORA-12154 what have i missed? i've set the ORACLE_HOME and ORACLE_SID env variable in the linux box. well i hope someone could help me solve the problem. TiA