Re: [PHP-DB] Ora_Logon problems From: Luis Castro Mendoza (lcastro <email protected>)
Date: 12/28/00

Vlad wrote:

> Hi all
> I have such problem:
>
> $conn = Ora_Logon("user <email protected>", "pass");
>
> Dont works. Message is : Cant resolve TNS name.
> MYTNSNAME exists and when using it from PL\SQl it works...
> Help please ...
>
> Thanks Vlad
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>

You must set ORACLE_HOME env variable for apache, I do this add
ORACLE_HOME=path_oracle_home
export ORACLE_HOME
in apachectl script

The problem is in your config, cause for APACHE doesn't exist the env
variable that is necessary to search TNSNAMES.ORA (oracle search it in
$ORACLE_HOME/network/admin)

Hope this helps 

--
Luis Castro Mendoza
Universidad de Chile
Vicerrectoría de Economía y Administración
Servicios Tecnológicos de Gestión
mailto:lcastro <email protected>
Phone: 56-2-6782662
Fax: 56-2-6782670