How to connect to a remote Oracle 11g database using PHP

Question

I have tried to make oci_connect work, by following these directions, but I still get the error:

ora-24408 could not generate unique server group name in test.php

Here is my PHP snippet (with bogus IP):

   $tns2 = "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 123.123.123.123)(PORT = 1521)) (CONNECT_DATA = (SID = foo)))";
   if ($conn = oci_connect("username","pwd", $tns2))
   {
       echo "Connected to foo";
       oci_close($conn);
   }
   else
   {
       die("could not connect to foo");
   }

I use SQL Developer and can connect to this database just fine from this Ubuntu server. I also have Java applications that connect from this Ubuntu server to the remote Oracle database without any problems.

What am I missing to make PHP work?

I even did the phpinfo() and it showed the oci8 information.

This is unrelated to what you're asking about but I'm assuming you made a typographical error when you typed: (PROTOCAL = TCP) - I'm assuming you meant (PROTOCOL = TCP). — Benny Hill
– Benny Hill, Commented Jun 13, 2013 at 20:26

Luigi Siri · Accepted Answer · 2013-06-13 20:23:36Z

6

Take a closer look to oci_connect.

And try with this conection string: "123.123.123.123:1521/foo"

$conn = oci_connect("username","pwd", "123.123.123.123:1521/foo");

Hope it helps.

answered Jun 13, 2013 at 20:23

Luigi Siri

2,0182 gold badges19 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Dean-O Over a year ago

nope tried that too... still get error ora-24408 could not generate unique server group name in test.php line 75

Luigi Siri Over a year ago

@Dean-O, Check on this Answer.

Dean-O Over a year ago

bingo, that did the trick... no /etc/hosts entry and also no file sysconfig/nextwork

sandino · Accepted Answer · 2013-06-13 21:41:25Z

0

You can try something like this:

define ('DB_USER','username');
define ('DB_PASS','pwd');
define ('DB_HOST', '123.123.123.123');
define ('DB_NAME', 'YOUR_DATABASE_NAME');
define ('CONST_DB_CHARSET_FOR_CONNECT','WE8ISO8859P15');
define ('DB_CONNECTION_STRING','\\123.123.123.123/DBSCHEMA');//in localhost use ''


$conexion = oci_connect(DB_USER, DB_PASS,DB_CONNECTION_STRING,CONST_DB_CHARSET_FOR_CONNECT);

Just put the right value for: YOUR_DATABASE_NAME that's how I connect to remote oracle 11.g database.

Hope this helps you.

edited Jun 13, 2013 at 21:41

answered Jun 13, 2013 at 20:26

sandino

3,8421 gold badge22 silver badges24 bronze badges

1 Comment

Dean-O Over a year ago

What is your define for DB_CONNECTION_STRING

Collectives™ on Stack Overflow

How to connect to a remote Oracle 11g database using PHP

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related