Getting an ORA-12518 error when using OCI8 after an upgrade from 10g to 12c

[MarkyO]

Hello everyone,

We recently upgraded from Oracle 10g to 12c and in doing so we broke any custom php programs that used oracle to connect.

I'm now getting this error:
 

Warning: oci_connect(): ORA-12518: TNS:listener could not hand off client connection

Of the things I've researched I've tried restarting the Listener services and setting the LogOn user as "Local System" in the service.

I've also tried adding

 

DIRECT_HANDOFF_TTC_LISTENER=OFF

to the end of the listener.ora file.

Neither of those things worked.

Anyone have an idea? Should I x-post this to the oracle subreddit as well?


I have a .NET application that also connects to Oracle and that works fine, so I'm not sure why PHP doesn't connect.

[MarkyO]

Nevermind. Figured it out... I had to change my connection string.