Node-oracledb: Error: ORA-21561: OID generation failed

Created on 8 Mar 2017  路  4Comments  路  Source: oracle/node-oracledb

Today it stopped working the connection to my oracle database.

I'm receiving this error:

Error: ORA-21561: OID generation failed

the connection is working fine using RazorSQL client

node v6.10.0
Instant Client 12.2

question

Most helpful comment

fixed adding this to my /etc/hosts

127.0.0.1 localhost ${hostname}

${hostname} - hostname from terminal

All 4 comments

fixed adding this to my /etc/hosts

127.0.0.1 localhost ${hostname}

${hostname} - hostname from terminal

Instead of put the hostname in /etc/hosts, I just did it in the end and it worked:

sudo sh -c "echo '/opt/oracle/instantclient' | tee -a /etc/ld.so.conf.d/oracle_instant_client.conf" && sudo ldconfig

all instant client were installed on opt >> oracle folder.

fixed adding this to my /etc/hosts

127.0.0.1 localhost ${hostname}

${hostname} - hostname from terminal

I couldnt able to save the file. (MacOS Error code: -4960)

@kishorkumarravi does using a HOSTALIASES environment variable pointing to a custom file help?
https://github.com/oracle/node-oracledb/issues/458#issuecomment-387760515
https://stackoverflow.com/questions/39201869/aws-python-lambda-with-oracle-oid-generation-failed

Was this page helpful?
0 / 5 - 0 ratings

Related issues

sanfords picture sanfords  路  3Comments

ronnn picture ronnn  路  3Comments

xpro666 picture xpro666  路  3Comments

PaulBrookes picture PaulBrookes  路  4Comments

rheinripper picture rheinripper  路  4Comments