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 <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]> wrote in message
>news:[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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to