search

nalbion / node-oracledb-for-lambda

node-oracledb, pre-compiled for AWS Lambda
19 stars 13 forks source link

ORA-21561: OID generation failed with oracle RAC 11g on-premise server #10

Open vksandeep opened 5 years ago

vksandeep commented 5 years ago

We are getting

ORA-21561: OID generation failed

even with the HOSTALIAS solution given in > https://medium.com/@mitchplanck/aws-lambda-node-js-oracle-3b5806fbecd3

The code and setup works for a simple oracle 11g database on AWS but its not working when lambda within a VPC which go over various network layers and connect to a on-prem Oracle 11g RAC cluster.

I have posted a stackoverflow question too - https://stackoverflow.com/questions/54188773/aws-nodejs-lambda-query-on-prem-oracle-11g-rac

A comment response asks to upgrade to v18 libraries which seems to handle OIDC generation in a better way. Is there any upgrade planned for these libraries to node-oracledb v3.0.1 and v18 drivers?

romanbalayan commented 5 years ago

Created a pull request on #12, using a precompiled node-oracledb v3.1.2.