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 次
沒有答案

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南