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

Do you have questions regarding other database enginges (not MySQL) -- ask here!

Moderators: egami, macek, gesf

Post Reply
markyochoa
New php-forum User
New php-forum User
Posts: 2
Joined: Thu Aug 24, 2017 7:37 am

Thu Aug 24, 2017 7:39 am

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.

markyochoa
New php-forum User
New php-forum User
Posts: 2
Joined: Thu Aug 24, 2017 7:37 am

Thu Aug 24, 2017 10:16 am

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

Post Reply