OCI Data Science Notebook scenarios to Connect to Autonomous Database with ORA-01017 scenarios
I'm reviewing some code and I'm refactoring my project and Could someone explain I tried several approaches but none seem to work. I've been banging my head against this for hours. I am trying to connect to an Oracle Autonomous Database from a Data Science Notebook in OCI, but I am running into an ORA-01017: invalid username/password; logon denied behavior. I have confirmed that the username and password are correct, and I have also checked that the database is up and running. I am using the following connection setup in Python: ```python import cx_Oracle dsn = cx_Oracle.makedsn('myadb.region.oraclecloud.com', 1522, service_name='mydb_service') connection = cx_Oracle.connect(user='myusername', password='mypassword', dsn=dsn) ``` I have made sure that the `cx_Oracle` library is installed and up to date, as I'm currently using version 8.2.1. However, I'm still working with this scenario. I also modified the database user settings to allow connections from the Data Science service, but that didn't resolve it either. I can connect to the database using SQL Developer with the same credentials, which makes this more perplexing. Any insights on why this might be happening or how to troubleshoot it further would be greatly appreciated. My development environment is Windows. This is part of a larger application I'm building. Thanks in advance! I'm working with Python in a Docker container on CentOS. I'd love to hear your thoughts on this. My team is using Python for this CLI tool. I appreciate any insights! Hoping someone can shed some light on this.