Re: Ora_Logon problems
| From: | Vlad | Date: | Thu, 28 Dec 2000 11:36:29 +0000 |
| Subject: | Re: Ora_Logon problems | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5487@lists.php.net to get a copy of this message | ||
Just setting env variables dont work! are any other solutions?
I check phpinfo() for correct ORACLE_HOME & TNS_ADMIN. It is correct...
Luis Castro Mendoza <lcastro@uchile.cl> ÐÉÛÅÔ ×
ÓÏÏÂÝÅÎÉÉ:3A4B4042.DEF81437@uchile.cl...
> Vlad wrote:
>
> > Hi all
> > I have such problem:
> >
> > $conn = Ora_Logon("user@MYTNSNAME", "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@lists.php.net
> > For additional commands, e-mail: php-db-help@lists.php.net
> > To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
> 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@uchile.cl
> Phone: 56-2-6782662
> Fax: 56-2-6782670
>
>