David Leach <dleach@securenet.com.au> wrote:
> If I specify the ORACLE_SID, and export it within my environment before
> webserver startup, php/oracle do not look up the SID within
> tnsnames.ora. I verified this with truss:
>
> Trace output:
> Fatal NI connect error 12545, connecting to:
>
> (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/data01/oracle/bin/oracle)(
> ARGV0=orac
> leblah)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH
> =NO))(
> CONNECT_DATA=(CID=(PROGRAM=)(HOST=foo)(USER=fish))))
>
> [---- ORACLE_SID=blah, OciLogon ( "user", "pw", "" ); -----]
If you are really using that third, empty parameter, omit it. The manual
says:
| If the optional third parameter is not specified, PHP uses the
| environment variables ORACLE_SID (Oracle instance) or TWO_TASK
| (tnsnames.ora) to determine which database to connect to.
OciLogon("user", "pw");
Regards...
Michael
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
