Aws Python Lambda With Oracle - Oid Generation Failed Even After Adding Hostaliases

I am trying to connect to oracle on rds using lambda with python using cx_oracle package but i get: ORA-21561: OID generation failed: DatabaseError. Even after adding file /tmp

Solution 1:

That error is generally due to the fact that your host name cannot be determined. This post may be of help: https://osric.com/chris/accidental-developer/2015/10/connecting-to-oracle-instance-in-aws-rds/

Solution 2:

I ran into this same issue and found that the HOSTALIASES mechanism requires working DNS. If your Lambda function is VPC attached, you must allow outbound DNS to either Amazon VPC DNS or your own internal DNS server if you have one.