Skip to Main Content

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I want to connect autonomous database warehouse and my pycharm with anaconda

4180832Feb 5 2020 — edited Feb 5 2020

<Connecting to the ADB Instance/Database Connectivity Issues>

I followed tutorials but it's not worked

https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connecting-nodejs.html#GUID-AB1E323A-65B9-47C4-840B-EC3453F3AD53

This is the tutorial link that i followed. Its official tutorial that provided by oracle.

this is the code that i used

import cx_Oracle

connection = cx_Oracle.connect('adb.ap-seoul-1.oraclecloud.com:1522/zjgfo1nip1q32o2_db_high.adwc.oraclecloud.com')

print(connection.version)

Error Codes: cx_Oracle.DatabaseError: ORA-12560: TNS:protocol adapter error

->

I installed oracle instant client in my computer and set wallet in it, also changed path variable.

Also I installed cx_oracle in anaconda3 that i use to interpret my python code in pycharm.

I changed tnsnames.ora file with adding http proxy and sqlnet.ora file with adding wallet location.

But it still returns error with tns protocol adapter error.

Comments
Post Details
Added on Feb 5 2020
0 comments
384 views