This discussion is archived
1 Reply Latest reply: Nov 13, 2012 2:48 PM by cj RSS

Problem with oracle database connection - oci

973930 Newbie
Currently Being Moderated
Hello

I am writing an html page and I want to connect with the oracle database. I am using oci, this is the code:
$host = "IP";
$port=1521;
$nazwa_uslugi = "XE"; // dbServiceName
$uzytkownik = "elin";
$haslo = "maleDUZE9";
$deskryptor = "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST=$host)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=XE)))";
echo "AAA2 deskryptor = $deskryptor ";

$polaczenie = oci_connect(elin1,maleDUZE9,$deskryptor, 'AL32UTF8');
echo "AAA3";

if(!$polaczenie)
{
$err = oci_error();
trigger_error('Nie mozna nawiazac polaczenia z baza danych: '. $err['message'], E_USER_ERROR);
echo "AAA4";
}
echo "AAA5";

On the page is displaying everything till -> echo "AAA2 deskryptor = $deskryptor ";
After that nothing happens, no information about error, nothing...

In php.ini I tried to used to options (only one probably can be used):
extension=php_oci8.dll ; Use with Oracle 10gR2 Instant Client
extension=php_oci8_11g.dll ; Use with Oracle 11gR2 Instant Client
and no positiv results.

The Oracle client is installed and is working properly:
sqlplus user/passwd@xe - this is working
The Oracle client is : Oracle_OraClient10g
Installed database : Oracle Database 11g Express edition

Please help.
  • 1. Re: Problem with oracle database connection - oci
    cj Employee ACE
    Currently Being Moderated
    You have:
    $polaczenie = oci_connect(elin1,maleDUZE9,$deskryptor, 'AL32UTF8');
    Shouldn't that be:
    $polaczenie = oci_connect($uzytkownik,$haslo,$deskryptor, 'AL32UTF8');
    I suggest you add this to the top of your script so you can see any errors:
    error_reporting(E_ALL);  // In PHP 5.3 use E_ALL|E_STRICT
    ini_set('display_errors', 'On');
    There is a free book that shows how to connect. You can simplify some things in your code. The book is at http://www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-098250.html

    You can only have one of the extensions uncommented in php.ini.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points