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.
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'
> I get the same response as before:
> Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name
>c:\program files\apache group\apache\htdocs\dna\dna_oci_sys_list.php on
> Anything else I can try?
>"Rouvas Stathis" <[EMAIL PROTECTED]> wrote in 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?
>> > This implies that I am reaching the Net8 oci client libraries (right?).
>> > My environment: PHP 4.0.5, Apache 1.3.19, W2K, Net8 184.108.40.206.0, remote
>> > 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]