AWS RDS oracle python连接

您需要(a)安装32位Oracle客户端库,或(b)确保使用64位Python和64位cx\U Oracle。请参见 installation instructions 了解更多信息。

请检查,32位/64位库,以及 Installation Guide

此外,您可以参考以下代码段

    from __future__ import print_function
    
    import cx_Oracle
    import boto3
    import base64
    import requests
    import json
    import configparser
    
    def connect_oracle(oracle_arn,oracle_host,oracle_port,oracle_db):
        session = boto3.session.Session()
        client = session.client('secretsmanager','us-west-2')
    
        response = client.get_secret_value(SecretId=oracle_arn)
        data = json.loads(response['SecretString'])
    
        dsn_tns = cx_Oracle.makedsn(oracle_host,oracle_port,oracle_db)
    
        conn = cx_Oracle.connect(data['username'],data['password'],dsn_tns)
    
        return conn
    
    
    
    def test_oracle_connect():
    
        #change the variable value as required 
        oracle_arn = 'oracle_arn'
        oracle_host = 'oracle_host'
        oracle_port = 'oracle_port'
        oracle_db = 'oracle_db'
        
        run_rds_test_scripts = 'true'
    
        if run_rds_test_scripts == 'true':
            conn = connect_oracle(oracle_arn,oracle_host,oracle_port,oracle_db)
    
            cur = conn.cursor()
            executed = cur.execute('select count(*) from dba_tables')
            res = cur.fetchmany(numRows=1)
    
            row_number = len(res)
    
            assert row_number == 1
            cur.close()
            conn.close()
        else:
            print('no run')

test_oracle_connect()