Jump to content


Photo

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


Best Answer MarkyO, 24 August 2017 - 06:15 PM

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

Go to the full post


  • Please log in to reply
1 reply to this topic

#1 MarkyO

MarkyO
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 24 August 2017 - 03:40 PM

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.



#2 MarkyO

MarkyO
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 24 August 2017 - 06:15 PM   Best Answer

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






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users