ADW - Autonomous Database details:修订间差异
跳到导航
跳到搜索
(→TNS) |
|||
(未显示同一用户的1个中间版本) | |||
第44行: | 第44行: | ||
==== TNS ==== | ==== TNS ==== | ||
TNS name path: <PATH> | TNS name path: <PATH> | ||
Network Alias: 可以选择 tnsnames.ora 中定义的连接 | |||
=== Keep OracleDB === | === Keep OracleDB === |
2023年12月27日 (三) 09:34的最新版本
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
- OR -
- CIDR: 0.0.0.0/0
Mutual TLS (mTLS) authentication:
- Not Required
#OLD: 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")))' DSN='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_dn_match=yes))) USER='admin' PASSWD='orB.db.1.2..8' 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)
Run Toad/PLSQL With a Wallet
SYS EVN
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK path = %ORACLE_HOME% TNS_ADMIN = %ORACLE_HOME%\network\admin
Wallet
wallet_*.zip 文件解压放入 TNS_ADMIN
Run DBeaver With a Wallet
Wallet
wallet_*.zip 文件解压放入 <PATH>
TNS
TNS name path: <PATH>
Network Alias: 可以选择 tnsnames.ora 中定义的连接
Keep OracleDB
Shell
cd /u01/git/pangolin/ ./dbct mc_bidb 'select * from test'
Crontab
0 1 * * * sh ~/bin/keep_oradb.sh >/dev/null 2>&1
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