英文:
DatabaseError: ORA-12506: TNS:listener rejected connection based on service ACL filtering
问题
无法连接到托管在Oracle Cloud上的数据库:使用Python连接自主数据仓库(Warehousing)。
from sqlalchemy import create_engine
user = 'admin'
password = '****'
tns = <来自tnsnames.ora文件的字符串>
engine = create_engine('oracle+cx_oracle://{0}:{1}@{2}'.format(user, password, tns))
con = engine.connect()
需要使用Python访问Oracle数据库的表格和数据。
英文:
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.
答案1
得分: 1
你需要使用“添加我的地址”选项将您的IP地址添加到Oracle Cloud的ACL列表中。
英文:
You need to add your IP address to the ACL list using "Add My Address" in the ACL options in oracle cloud.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论