php-db | 2001072

Re: [PHP-DB] 'ORA-12203: TNS:unable to connect to destination' error From: Barry Prentiss (thebear <email protected>)
Date: 07/20/01

Solved!
 Thx Stathis, but it wasn't OciLogon("user","pass",'SLAC'), but
OciLogon("user","pass",'SLAC_TCP').
i.e. not the SID but the TWO_TASK variable it was after...
 Thx Again,
 Barry

"Rouvas Stathis" <rouvas <email protected>> wrote in message
news:3B58711A.EECDF435 <email protected>
> 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 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>