I have a big problem to connect PHP and Oracle !
I develop a site that use connections among PHP and oracle! The problem is that I can抰 connect PHP to the data base which is a distant server (with sqlnet)! The connection failed with the error message ORA-12154. I have activate php_oracle.dll in the php.ini file and my program of connection is quite simple:
<head><title></title></head><body>
<?
if ($conn=Ora_Logon("login@TNSnames","pwd")) {
echo "<B>SUCCESS !!! <B>\n";
Ora_Logoff($conn);
} else {
echo "<br><hr><br><B>--- ERROR ---connexion failed !!! <B>\n";
}
?>
</body>
The file Tnsnames.ora is correctly configured because before developing with php, I have to realize a site in perl on the same machine with the same configuration (Win98SE, Apache 1.3, oracle 7) and connection in the data base work!
The sqlnet.log file which is created in my php directory indicates the following errors:
***********************************************************************
Fatal OSN connect error 12154, connecting to:
orleansA
VERSION INFORMATION:
TNS for 32-bit Windows: Version 2.3.4.0.0 - Production
Time: 08-NOV-00 15:53:48
Tracing not turned on.
***********************************************************************
Fatal OSN connect error 12203, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=PHP.EXE)(HOST=******)(USER=*****))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 2.3.4.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 2.3.4.0.0 - Production
Time: 08-NOV-00 15:53:48
Tracing not turned on.
Tns error struct:
nr err code: 12203
TNS-12203: TNS: connexion ?la destination impossible
ns main err code: 12560
TNS-12560: TNS: erreur d'adaptateur de protocole
ns secondary err code: 0
nt main err code: 102
TNS-00102: Erreur dans l'op閞ation de lien de valeur clavier
nt secondary err code: 0
nt OS err code: 0
How can I resolve my problem ?Thank you for your assistant!
I develop a site that use connections among PHP and oracle! The problem is that I can抰 connect PHP to the data base which is a distant server (with sqlnet)! The connection failed with the error message ORA-12154. I have activate php_oracle.dll in the php.ini file and my program of connection is quite simple:
<head><title></title></head><body>
<?
if ($conn=Ora_Logon("login@TNSnames","pwd")) {
echo "<B>SUCCESS !!! <B>\n";
Ora_Logoff($conn);
} else {
echo "<br><hr><br><B>--- ERROR ---connexion failed !!! <B>\n";
}
?>
</body>
The file Tnsnames.ora is correctly configured because before developing with php, I have to realize a site in perl on the same machine with the same configuration (Win98SE, Apache 1.3, oracle 7) and connection in the data base work!
The sqlnet.log file which is created in my php directory indicates the following errors:
***********************************************************************
Fatal OSN connect error 12154, connecting to:
orleansA
VERSION INFORMATION:
TNS for 32-bit Windows: Version 2.3.4.0.0 - Production
Time: 08-NOV-00 15:53:48
Tracing not turned on.
***********************************************************************
Fatal OSN connect error 12203, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=PHP.EXE)(HOST=******)(USER=*****))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 2.3.4.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 2.3.4.0.0 - Production
Time: 08-NOV-00 15:53:48
Tracing not turned on.
Tns error struct:
nr err code: 12203
TNS-12203: TNS: connexion ?la destination impossible
ns main err code: 12560
TNS-12560: TNS: erreur d'adaptateur de protocole
ns secondary err code: 0
nt main err code: 102
TNS-00102: Erreur dans l'op閞ation de lien de valeur clavier
nt secondary err code: 0
nt OS err code: 0
How can I resolve my problem ?Thank you for your assistant!