SQLSTATE[HY000]: OCISessionBegin: ORA-21561: OID generation failed

php oracle pdo oracle-call-interface
Camden S. picture Camden S. · Oct 29, 2013 · Viewed 8.7k times · Source

I'm receiving the following error when trying to do a PDO OCI SQL query on one of my web servers:

SQLSTATE[HY000]: OCISessionBegin: ORA-21561: OID generation failed

I've confirmed that the Oracle server is accessible from the machine and network configuration looks fine. Google returns very few, and not very helpful results.

Has anyone else run into this, or have any suggestions on how to resolve?

Answer

Mustafa Hussain picture Mustafa Hussain · Jan 24, 2014

I was facing the same issue. I was trying to connect to database on my localhost. This is how I solved it.

  • Get the hostname 

    > hostname 
localhost.idc.company.com

  • Add this name to /etc/hosts file 

    127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4 localhost.idc.company.com

Related questions

Enabling PDO OCI

I've tried to install OCI, so I can use new PDO("oci:dbname... After 1,5h of fight I've installed oracle instantclient (basic and sdk) and then oci for php (as described here http://ubuntuforums.org/showthread.php?t=92528). Now I'm …

Read More
Oracle, PDO_OCI vs OCI8

The company I work for currently uses some basic functions to abstract the OCI libraries as a means for DB connectivity. We're considering switching to PHP's PDO object, but from some quick searches, it looks like the Oracle driver is …

Read More
How to install oracle instantclient and pdo_oci on ubuntu machine?

I need to install PDO_OCI in ubuntu machine, there is no default package that I could install with apt-get. There are a lot of tutorials showing how to do it, but when I follow them, I have problems related …

Read More