[Python] DatabaseError: ORA-12506: TNS:listener rejected connection based on service ACL...

not able to connect to the DB hosted on oracle cloud: Autonomous Data Base (Warehousing) from python

from sqlalchemy import create_engine
user = 'admin'
password = '****'
tns = <string from the tnsnames.ora file>

engine = create_engine('oracle+cx_oracle://{0}:{1}@{2}'.format(user, password, tns))
con = engine.connect()


need to access the tables and data form the oracle database using python.

Continue reading...