[es] - Problem sa konekcijom na Oracle bazu

nezki
Miodrag Lapcevic
Beograd

Član broj: 101503
Poruke: 438
*.westend.com.

Sajt: www.websolutions.co.rs

Profil

Problem sa konekcijom na Oracle bazu

^{19.11.2008. u 17:11 - pre 187 meseci}

Instalirao sam Oracle, apache i php prema upustvu sa http://www.oracle.com/technolo...s/inst_php_apache_windows.html.
Sve sam ok podesio ali kada sam napravio probni fajl u kome mi stoji

Code:

<?php

    $db_conn = ocilogon("sys", "root", "//127.0.0.1/ocrl");

    $cmdstr = "select last_name, salary from employees";

    $parsed = ociparse($db_conn, $cmdstr);
    ociexecute($parsed);

    $nrows = ocifetchstatement($parsed, $results);

    echo "<html><head><title>Oracle PHP Test</title></head><body>";
    echo "<center><h2>Oracle PHP Test</h2><br>";
    echo "<table border=1 cellspacing='0' width='50%'>\n<tr>\n";
    echo "<td><b>Name</b></td>\n<td><b>Salary</b></td>\n</tr>\n";

    for ($i = 0; $i < $nrows; $i++ )
    {
      echo "<tr>\n";
      echo "<td>" . $results["LAST_NAME"][$i] . "</td>";
      echo "<td>$ " . number_format($results["SALARY"][$i],   2). "</td>";
      echo "</tr>\n";
    }

    echo "<tr><td colspan='2'> Number of Rows: $nrows</td></tr></table>";
    echo "<br><em>If you see data, then it works!</em><br></center></body></html>\n";

  ?>

Javlja mi sledeci error

Warning: ocilogon() [function.ocilogon]: ORA-12541: TNS:no listener in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\index.php on line 6

Warning: ociparse() expects parameter 1 to be resource, boolean given in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\index.php on line 10

Warning: ociexecute() expects parameter 1 to be resource, null given in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\index.php on line 11

Warning: ocifetchstatement() expects parameter 1 to be resource, null given in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\index.php on line 1

Da li neko zna do cega je?
hvala unapred

djLapac

Odgovor na temu

Jbyn4e

Član broj: 422
Poruke: 6049
*.ptt.rs.

+257 Profil

Re: Problem sa konekcijom na Oracle bazu

^{19.11.2008. u 20:41 - pre 187 meseci}

Probaj bez 127.0.0.1

Code:

$db_conn = ocilogon("sys", "root", "ocrl");

pod pretpostavkom da ti se baza (shema) zove orcl.

Deluje da tebi nije podignut listener, probaj telnet localhost 1521 pa javi sta dobijes.

Ako nista - onda bi trebalo da podignes nekako listener.

Ti si to radio sa XE verzijom - sa njom nisam nista probao, pa ne znam kako je kod 11gXE, ja sam poslednje koristio 10gR2.

Ah da, jos nesto:
Google: "ORA-12541: TNS:no listener"

Kad sve ostalo zakaže, pročitaj uputstvo...

Odgovor na temu

nezki
Miodrag Lapcevic
Beograd

Član broj: 101503
Poruke: 438
*.p3-gmbh.de.

Sajt: www.websolutions.co.rs

Profil

Re: Problem sa konekcijom na Oracle bazu

^{20.11.2008. u 12:02 - pre 187 meseci}

Uspeo sam da sredim ovaj problem, bila je greska do podesavanja LISTENERA
ALi sada imam ovu gresku

Warning: (E_WARNING) ocilogon() [function.ocilogon]: ORA-12154: TNS:could not resolve the connect identifier specified in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\HTTP\DB.php on line 295

a zatim mi javlja i ovu

Warning: (E_WARNING) ociparse() expects parameter 1 to be resource, boolean given in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\HTTP\DB\Statement.php on line 82 (Origin in portal: 'C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\HTTP\TPL\Version.php' on line 21) backtrace

u 295 redu fajla DB.php imam kod $this->_aryOptions['charset']);

Code:

286 if ($this->_aryOptions['persistent']) {
287            $this->_resConnection = ociplogon($this->_aryOptions['username'],
288                                                 $this->_aryOptions['password'],
289                                                 $this->_aryOptions['database'],
290                                                 $this->_aryOptions['charset']);
291        } else {
292            $this->_resConnection = ocilogon($this->_aryOptions['username'],
293                                                    $this->_aryOptions['password'],
294                                                   $this->_aryOptions['database'],
295                                                   $this->_aryOptions['charset']);
296        }

Mislim greska nastaje jer ne mogu da se konektujem na bazu
E sada malo pojasnjenje. ja se konektujem na bazu koja nije kod mene na lokalnom serveru.
Meni je ovo prvi put da radim sa oracle-ovom bazom, pa ako je neko voljan da mi pojasni zasto se desava ova greska.

PS. kada uradim print_r($this->_aryOptions) podaci su sledeci
Array ( [persistent] => [username] => userroot [password] => root [database] => database.de [charset] => [phptype] => oci )

djLapac

Odgovor na temu