Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
587 views
in Technique[技术] by (71.8m points)

python - Connecting to Oracle RDS

I am trying to connect to Oracle using AWS lambda and python.

These are the step I followed. (Everything has done EC2 instance)

  1. Downloaded the instantclient-basic-linux.x64-12.2.0.1.0.zip and
    instantclient-sdk-linux.x64-12.2.0.1.0.zip
  2. Created this folder structure ~/lambda/lib/
  3. Extracted the zip files in the ~/lambda/lib/
  4. copied the libaio.so.1.0.1 from /lib64/ into ~/lambda/lib/
  5. Created symbolic link of libaio.so.1.0.1 as libaio.so in ~/lambda
  6. using pip installed cx_Oracle in ~/lambda
  7. written below index.py script in ~lambda

`

import cx_Oracle

def handler(event, context):
    message = ""
    cursor = None
    connection = None    
    try:
        connection = cx_Oracle.connect("USERNAME", "PASSWORD", "DOMAIN/orcl")
        cursor = connection.cursor()
        cursor.execute("""QUERY""")
    except Exception as e:
        message += " {Error in connection} " + str(e)
    finally:
        if cursor:
            cursor.close()
        if connection:
            connection.close()
    return {'message' : message}

`

  1. Then zipped it using zip -r9 ~/upload.zip *

After running the code on AWS lambda it gives the following error.

Error while trying to retrieve text for error ORA-01804

I tried setting ENV ORACLE_HOME=/var/task and /var/task/lib but did not worked

I looked below answers but did not find help yet

Error while trying to retrieve text for error ORA-01019

Oracle with node-oracle: Error while trying to retrieve text for error ORA-01804

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

This post was much helpful for me to use cx_Oracle using Lambda functions. It worked as expected. Thanks for creating this post @Sayed Zainul Abideen

But i got another error from lambda stating 'cx_Oracle.DatabaseError: ORA-24454: client host name is not set'

I got it resolved by adding the below lines in my python code:

import os

with open('/tmp/HOSTALIASES', 'w') as hosts_file:
    hosts_file.write('{} localhost
'.format(os.uname()[1]))

After which i added below ENVIRONMENTAL VARIABLE to my Lambda function:

HOSTALIASES = /tmp/HOSTALIASES

Hope it helps somebody.

Please add comments if any issues relating to cx_Oracle. I would be happy to help as i struggled a lot to fix this.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...