Subject: Re: [LINUX:8596] solaris 2.5.1 php oracle
From: Murat Kasikcioglu (muratk@innovaconsulting.com)
Date: Thu 02 Sep 1999 - 09:16:26 EET DST
merhaba,
sqlplus ile baglanabiliyor musunuz?
sqlplus username/password@connect_string (sunttfTTF)
iyi calismalar,
Murats@turktraktor.com.tr wrote:
> Arkadaslar sonunda su oracle php3 solaris ve apache işi halloyor gibi tek
> bir sorun var.
>
> Web uzerinden programi cagirdigimda aldigim hata mesaji su
> Warning: Unable to connect to ORACLE (ORA-12154: TNS:could not resolve
> service name) in /usr/local/apache_1.3.6/htdocs/aa.php3 on line 6
> Bu hataya karsilik oracle soyle diyor
> oerr ora 12154
> 12154, 00000, "TNS:could not resolve service name"
> // *Cause: The service name specified is not defined correctly in the
> // TNSNAMES.ORA file.
> // *Action: Make the following checks and correct the error:
> // - Verify that a TNSNAMES.ORA file exists and is in the proper
> // place and accessible. See the operating system specific
> manual
> // for details on the required name and location.
> // - Check to see that the service name exists in one of the
> // TNSNAMES.ORA files and add it if necessary.
> // - Make sure there are no syntax errors anywhere in the file.
> // Particularly look for unmatched parentheses or stray
> characters.
> // Any error in a TNSNAMES.ORA file makes it unusable. See
> // Chapter 4 in the SQL*Net V2 Administrator's Guide. If
> // possible, regenerate the configuration files using the Oracle
> // Network Manager.
>
> Tns dosyasinda bir hata var diyor ama benim çagirdigim kod da su
> <?php
>
> putenv("ORACLE_SID=TTF");
>
> putenv("ORACLE_HOME=/export/home/oracle/product/7.3");
> $conn = ora_logon( "apps@sunttfTTF", "apps") or die;
> ?>
>
> ayrica tns dosyasindaki kesitte soyle
> sunttfTTF = (DESCRIPTION=
> (ADDRESS=(PROTOCOL=tcp)(HOST=10.72.0.202)(PORT=2000))
> (CONNECT_DATA=(SID=TTF))
> )
> benim tek suphelendigim port burada port 2000 den haberlesiliyor apache yada
> php3 bildigim kadari ile port 80
> . sizce hatanin nedeni nedir. Eger port ise nasil degiºtiririm.
> Teşekkürler.
>
> <<...>>
>
> Listeden cikmak icin:
> unsub linux
> mesajini listeci@bilkent.edu.tr'a gonderiniz.
> Lutfen Listeci icin MIME / HTML / Turkce Aksan kullanmayin.
> Liste arsivinin adresi: http://listweb.bilkent.edu.tr/
-- Murat Kasikcioglu Innova Consulting Company muratk@innovaconsulting.comListeden cikmak icin: unsub linux mesajini listeci@bilkent.edu.tr'a gonderiniz. Lutfen Listeci icin MIME / HTML / Turkce Aksan kullanmayin. Liste arsivinin adresi: http://listweb.bilkent.edu.tr/