php7 cannot connect to oracle pooled connection

Question

this is working fine on cli and on a non pooled connection. when i try the following on cli it works

sqlplus CCP/"***"@DECCP1ST_POOLED.test.vis

but when i try to do this in php it throws an error

$c = oci_connect('CCP', "***", 'domain.com:33001/DECCP1ST_POOLED.test.vis');
print_r($c);

output is

Warning: oci_connect(): ORA-12514: TNS:listener does not currently know of service requested in connect descriptor in

in my tnsnames.ora i have

DECCP1ST_POOLED.test.vis =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = domain.com)(PORT = 33001))
    (CONNECT_DATA =
      (SERVER = POOLED)
      (SERVICE_NAME = DECCP1ST.test.vis)
    )
  )

I have followed this pdf. i have set oci8.connection_class = SHARED

Typo in: ddomain.de.

timclutton
– timclutton

2018-02-13 16:48:46 +00:00
Commented Feb 13, 2018 at 16:48 — timclutton
– timclutton, Commented Feb 13, 2018 at 16:48
updated but its same thing

shorif2000
– shorif2000

2018-02-13 16:55:51 +00:00
Commented Feb 13, 2018 at 16:55 — shorif2000
– shorif2000, Commented Feb 13, 2018 at 16:55

timclutton · Accepted Answer · 2018-02-13 17:08:08Z

1

According to the PDF you linked in your question, page 15:

PHP applications must specify the server type POOLED in the connect string to use DRCP. Using Oracle’s Easy Connect syntax, the PHP call to connect to the sales database on myhost would look like:
$c = oci_pconnect('myuser', 'mypassword', 'myhost/sales:POOLED');

Based on the above, and your TNS string, you need to use the following in your script:

$c = oci_connect('CCP', '***', 'domain.com:33001/DECCP1ST.test.vis:POOLED');

It's important to note that you are using the Easy Connect syntax here so the TNSNAMES.ORA file is ignored. Because of this you must use the defined SERVICE_NAME (DECCP1ST.test.vis) not the TNS alias (DECCP1ST_POOLED.test.vis)!

answered Feb 13, 2018 at 17:08

timclutton

13.1k3 gold badges37 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

php7 cannot connect to oracle pooled connection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related