You can translate the question and the replies:

Error when trying access to Oracle Autonomous Database with Wallet

Hello, I tried to follow guide lines in this article to make a connection to an Oracle Database with wallet https://community.denodo.com/kb/en/view/document/Accessing%20Oracle%20Autonomous%20Database%20from%20Denodo Test connection receives this error: "Unable to establish connection: IO Error: Invalid connection string format, a valid format is: "host:port:sid" Our configuration is: Database adapter = Generic Driver class path = oracle-19c Driver class = oracle.jdbc.OracleDriver Database URI = jdbc:oracle:thin:@g4425b3a9762e3a_atpdev_tp.adb.oraclecloud.com?TNS_ADMIN=/opt/denodo/oracle/wallet/argus/ We download and use this driver : https://download.oracle.com/otn-pub/otnsoftware/jdbc/1913-IAM/ojdbc8-full.tar.gz, all jar files are copied into /opt/denodo/lib/extensions/jdbc-drivers/oracle-19c The wallet zip file is unzip under this folder: /opt/denodo/oracle/wallet/argus/ Maybe some configuration is missing ? Thanks
user
01-03-2022 10:17:45 -0500
code

1 Answer

Hi, I would troublshoot this scenario by performing the following steps 1. Verify if all the required steps are considered as per the documentation 2. Check the wallet physical location is defined in sqlnet.ora 3. Ensure Oracle 19c Database adapter is selected in [JDBC Data Source](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#importing-jdbc-sources) configuration and test the connection 4. Validate the connecting string/DB URI using an external JDBC client to check the connectivity If you still need help and if you are a valid support user then you can raise a support case on [Denodo Support Site](https://support.denodo.com/) so that our support team can help you Hope this helps!
Denodo Team
02-03-2022 07:58:01 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here