RE: [PHP-DB] Connecting to a Remote Oracle Database
| From: | Richard Crawford | Date: | Sat, 06 Jan 2001 00:26:17 +0000 |
| Subject: | RE: [PHP-DB] Connecting to a Remote Oracle Database | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5640@lists.php.net to get a copy of this message | ||
Very helpful. Thanks, Luis.
> -----Original Message-----
> From: Luis Castro Mendoza [mailto:lcastro@uchile.cl]
> Sent: Friday, January 05, 2001 12:00 PM
> To: Richard Crawford
> Cc: php-db@lists.php.net
> Subject: Re: [PHP-DB] Connecting to a Remote Oracle Database
>
>
> Richard Crawford wrote:
>
> > Does anyone have any thoughts on how to connect to an Oracle
> database which
> > resides on a remote server? The connection script looks
> something like this
> > already:
> >
> > putenv("ORACLE_SID=[db]");
> > putenv("ORACLE_HOME=[location of tns file]");
> > $db = ocilogon("[user]","[password]");
> >
> > Is there a param I can put in somewhere to designate server ID?
> >
> > --
> > 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
>
> The first is install Oracle client software in the box where
> web-server resides.
>
> Add in apachectl
> ORACLE_HOME=path_to_oracle_home
> export ORACLE_HOME
>
> You must sure that you connect descriptor (thirth parameter in
> ocilogon) is in
> TNSNAMES.ORA 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
>
>