Re: PHP4.22/OCI8/Netscape 3.63 tnsnames problem...
| From: | (Michael Mauch) | Date: | Sat, 30 Nov 2002 19:48:28 +0000 |
| Subject: | Re: PHP4.22/OCI8/Netscape 3.63 tnsnames problem... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23745@lists.php.net to get a copy of this message | ||
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