Re: 'ORA-12203: TNS:unable to connect to destination' error
| From: | Rouvas Stathis | Date: | Fri, 20 Jul 2001 17:57:46 +0000 |
| Subject: | Re: 'ORA-12203: TNS:unable to connect to destination' error | ||
| References: | 1 | Groups: | php.db php.install php.windows |
| Request: | Send a blank email to php-db+get-10604@lists.php.net to get a copy of this message | ||
Barry Prentiss wrote:
>
> Hi All,
> I finally got past the php_oci8.dll problem by moving it to the same
> directory as php.exe and changing the php.ini extensions_dir back to './'.
>
> Now I am getting the following error:
>
> Warning: _oci_open_server: ORA-12203: TNS:unable to connect to
> destination in c:\program files\apache
> group\apache\htdocs\dna\dna_oci_sys_list.php on line 20
>
> which occurs at the $conn line below:
>
> error_reporting (E_ALL);
> putenv('ORACLE_HOME=C:\orant');
> putenv('TNS_ADMIN=C:\orant\NET80\ADMIN');
> putenv('ORACLE_SID=SLAC');
> putenv('TWO_TASK=SLAC_TCP');
>
> $conn = ociLogon("user","password");
Try, OciLogon("user","pass",'SLAC'). What do you get?
-Stathis.
>
> This implies that I am reaching the Net8 oci client libraries (right?).
>
> My environment: PHP 4.0.5, Apache 1.3.19, W2K, Net8 8.0.6.0.0, remote Oracle
> 8.1.6 on Solaris.
>
> I can connect through SQL*Plus, tests OK through Net8 assistant,
> tnsnames.ora is in proper place (as defined in TNS_ADMIN above).
>
> What am I doing wrong?
> Thx in advance,
> Barry Prentiss