Re: 'ORA-12203: TNS:unable to connect to destination' error

Thx Peter, I have spent some time on the oracle site. They focus on troubleshooting the Net8 connection, which works fine. I am not sure what you mean when you ask if apache is setup correctly to access Oracle. When running a phpinfo() environment query it shows that oci8 is enabled. Is ther more I need to do? Thx, Barry "Peter J. Krawetzky" <krawetzky1@earthlink.net> wrote in message news:001201c11147$66dc0510$91131eac@W559878.hartford.aetna.com... > This is saying that your request to connect to Oracle via php and apache is > failing because it cannot find the tnsnames.ora file. Is apache setup > correctly to access Oracle? > > Also, if you want detailed information on an error message from Oracle, > logon to the Oracle server with owner id of oracle and type in oerr ora > 12154. This works for any Oracle error message. > -----Original Message----- > From: Barry Prentiss <thebear@antispam.stanford.edu> > To: php-db@lists.php.net <php-db@lists.php.net> > Date: Friday, July 20, 2001 2:02 PM > Subject: Re: [PHP-DB] 'ORA-12203: TNS:unable to connect to destination' > error > > > >Thx Stathis, > > I get the same response as before: > > Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name > in > >c:\program files\apache group\apache\htdocs\dna\dna_oci_sys_list.php on > line > >20 > > Anything else I can try? > > Barry > > > >"Rouvas Stathis" <rouvas@di.uoa.gr> wrote in message > >news:3B58711A.EECDF435@di.uoa.gr... > >> 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@lists.php.net > >For additional commands, e-mail: php-db-help@lists.php.net > >To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >