note 2999 deleted from ref.oracle by danbrown
| From: | danbrown@php.net | Date: | Fri, 28 Nov 2008 22:25:17 +0000 |
| Subject: | note 2999 deleted from ref.oracle by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-147339@lists.php.net to get a copy of this message | ||
Note Submitter: lmg at webfarm dot com
----
...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.