PHP can't connect to oracle

[Anon]

Hi...

I work in a linux machine with red hat 6.0 distribution, php version 4 and oracle 8.1.5

I have tested php and it is ok.. apache is ok and oracle too..

but, when i try to connect to oracle from php I get an error.. I've been trying with OCI_Logon but i get an error.. it's an authentication page that asks for the user and password to get in..

this is the result:

------------
Hi prueba

Your password is prueba

initializing the connection...

Warning: _oci_open_server: ORA-12547: TNS:lost contact in /usr/local/apache/htdocs/prueba7.php on line 22

It was not possible to make the connection

----------

I have tried loading the oracle user variables before apache environment variables.. but it didn't work either..

any suggestion??

[Anon]

Example code is good.

[Anon]

take the string from tns names and plave that in your oracle like on ocilogon(user,pass,stringfromtnsnames)

<? function connectoracle($user,$pass)
{
$oralink = "(DESCRIPTION = (FAILOVER=ON) (LOAD_BALANCE=OFF)(ADDRESS=(PROTOCOL=TCP)(HOST=172.10.40.16)(PORT=1521)) (CONNECT_DATA=(SID=hits) ) )";

$connd = ocilogon('HITS','HITS',$oralink);
return $connd;
}