note 2999 modified in ref.oracle by irchtml
| From: | irchtml@php.net | Date: | Tue, 17 Feb 2004 14:34:13 +0000 |
| Subject: | note 2999 modified in ref.oracle by irchtml | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-65303@lists.php.net to get a copy of this message | ||
...and with the dawning of the new year, my TNS problem is gone. I've been having trouble
connecting to a remote db server from Linux running Apache/PHP+Oracle. I'd set the ORACLE_HOME
and ORACLE_SID (although, I'm not sure if it cares about the SID when connecting via
SQL*Net/Net8) with no luck. The environment variable that does the trick is TNS_ADMIN. (I saw a
mention of this on phpbuilder and thought I'd mention it here)<br>
Set TNS_ADMIN to the directory with your tnsnames.ora file and see if that dosen't help the TNS
unable to connect problems<p>
setenv("TNS_ADMIN=/opt/oracle/product/8.1.5/network/admin");
... does the trick for me.
--was--
...and with the dawning of the new year, my TNS problem is gone. I've been having trouble
connecting to a remote db server from Linux running Apache/PHP+Oracle. I'd set the ORACLE_HOME
and ORACLE_SID (although, I'm not sure if it cares about the SID when connecting via
SQL*Net/Net8) with no luck. The environment variable that does the trick is TNS_ADMIN. (I saw a
mention of this on phpbuilder and thought I'd mention it here)<br>
Set TNS_ADMIN to the directory with your tnsnames.ora file and see if that dosen't help the TNS
unable to connect problems<p>
setenv("TNS_ADMIN=/opt/oracle/product/8.1.5/network/admin");
<P>
... does the trick for me.<P>
http://www.php.net/manual/en/ref.oracle.php