'ORA-12203: TNS:unable to connect to destination' error
| From: | Barry Prentiss | Date: | Fri, 20 Jul 2001 17:36:26 +0000 |
| Subject: | 'ORA-12203: TNS:unable to connect to destination' error | ||
| Groups: | php.db php.install php.windows | ||
| Request: | Send a blank email to php-db+get-10603@lists.php.net to get a copy of this message | ||
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");
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