How to connect from Glue ETL job to Oracle Autonomous Database?

0

Hi all! I need some guidance on the proper way to connect to an Oracle Free Tier Autonomous Database from a Glue ETL Job. I’ve been using the following code snippet, but I encountered an error - “Connection reset by peer.” db_url=“jdbc:oracle:thin:@//adb.eu-frankfurt-1.oraclecloud.com:1521/ga8a15e2c641e7b_bfrceddyo0fopful_low.adb.oraclecloud.com” connection_oracle19c_options = { “url”: db_url, “dbtable”: “docrow”, “user”: “atpc_user”, “password”: “*******“, “customJdbcDriverS3Path”: “s3://abernads-oracle-jdbc-drivers/ojdbc8-21.7.0.0.jar”, “customJdbcDriverClassName”: “oracle.jdbc.OracleDriver”} df_oracle19 = glueContext.create_dynamic_frame.from_options(connection_type=“oracle”, connection_options=connection_oracle19c_options) mTLS is disabled, and network access is confirmed to be okay. Can you help me identify what I might be missing?

AWS
已提问 3 个月前614 查看次数
没有答案

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则