Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Problem with oracle database connection - oci

973930Nov 13 2012 — edited Nov 13 2012
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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 11 2012
Added on Nov 13 2012
1 comment
1,600 views