ADW - Autonomous Database details：修订间差异
跳到导航
跳到搜索
（创建页面，内容为“===Oracle Cloud ADW - Autonomous Database details=== Run Python Application Without a Wallet ===Network=== ====Access type:==== *Allow secure access from specified IPs and VCNs ====Access control list:==== *Enabled IP: 36.112.25.131,132.145.51.204 ====Mutual TLS (mTLS) authentication:==== *Not Required DSN='(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.uk-london-1.oraclecloud .com))(connect_data=(service_name=g0afda2…”） |
无编辑摘要 |
||
| 第40行： | 第40行： | ||
[[分类:Develop]] | [[分类:Develop]] | ||
[[分类:DB]] | [[分类:DB]] | ||
{{DEFAULTSORT: | {{DEFAULTSORT:ADW_Autonomous_Database_details}} | ||
2022年12月27日 (二) 16:24的版本
Oracle Cloud ADW - Autonomous Database details
Run Python Application Without a Wallet
Network
Access type:
- Allow secure access from specified IPs and VCNs
Access control list:
- Enabled IP: 36.112.25.131,132.145.51.204
Mutual TLS (mTLS) authentication:
- Not Required
DSN='(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.uk-london-1.oraclecloud .com))(connect_data=(service_name=g0afda210a8192f_bidb_medium.adb.oraclecloud.com))(security=(ssl_server_cert_dn="CN=a dwc.eucom-central-1.oraclecloud.com, OU=Oracle BMCS FRANKFURT, O=Oracle Corporation, L=Redwood City, ST=California, C=US")))'
USER='admin'
PASSWD='PASSWORD'
import oracledb
conn=oracledb.connect(user=USER, password=PASSWD, dsn=DSN)
cur=conn.cursor()
res=cur.execute("select count(*) from tab")
for TN in res:
print(TN)
Error
AttributeError: module 'lib' has no attribute 'X509_V_FLAG_CB_ISSUER_CHECK'
系统当前的python和pyOpenSSL版本不对应
mv /usr/lib/python3/dist-packages/OpenSSL /tmp/ pip3 install pyOpenSSL --upgrade
Collecting pyOpenSSL
Downloading pyOpenSSL-22.1.0-py3-none-any.whl (57 kB)
|████████████████████████████████| 57 kB 5.5 MB/s
Requirement already satisfied, skipping upgrade: cryptography<39,>=38.0.0 in /usr/local/lib/python3.8/dist-packages ( from pyOpenSSL) (38.0.4)
Requirement already satisfied, skipping upgrade: cffi>=1.12 in /usr/local/lib/python3.8/dist-packages (from cryptography<39,>=38.0.0->pyOpenSSL) (1.15.0)
Requirement already satisfied, skipping upgrade: pycparser in /usr/local/lib/python3.8/dist-packages (from cffi>=1.12->cryptography<39,>=38.0.0->pyOpenSSL) (2.21)
Installing collected packages: pyOpenSSL
Attempting uninstall: pyOpenSSL
Found existing installation: pyOpenSSL 19.0.0
Not uninstalling pyopenssl at /usr/lib/python3/dist-packages, outside environment /usr
Can't uninstall 'pyOpenSSL'. No files were found to uninstall.
Successfully installed pyOpenSSL-22.1.0