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?