FAN and PHP

User_TEJ1Z

Hi,

I'm trying to set up my PHP Applications with FAN Support. After about a week of unsuccessful testing I am really stuck and would like to ask here for further

help. This is my configuration:

OCI8 Version = 2.0.8

PHP Version = 5.5.23

Oracle DB Version = 11.2.0.3

Oracle Client Version = 11.2.0.3

oci8.events = On

I am using a new service with AQ notification = on

When I shutdown one instance (killing pmon or shutdown abort) my application gets:

ORA-12520: TNS:listener could not find available handler for requested type of server

I thought that it should switch the connection to a surviving instance. But it seems that it caches the connect information to the local instance/local listener but

as this listener doesn't have informationen about the killed instance my application receives ora-12520

Does someone have further hints on how to fix that problem? Thanks in advance!

Christopher Jones-Oracle

How did you set up your DB services - is FAN on in the DB service?  Did you use dbms_service.modify_service?

Is the PHP app using the correct service?  Are you using oci_connect or oci_pconnect?

User_TEJ1Z

Thanks for you reply.

I used srvctl modify service -D DB_NAME -s SERVICE_NAME -q true

Currently we are using oci_pconnect

Christopher Jones-Oracle

What's the connect string (or the tnsnames.ora entry it maps to) you are using to connect in the app? 

Are you using RAC or DG?

Is TG enabled?