ADW - Autonomous Database details：修订间差异

来自牛奶河Wiki
跳到导航 跳到搜索
无编辑摘要
（→‎TNS）
 
（未显示同一用户的10个中间版本）
第1行： 第1行：
===Oracle Cloud ADW - Autonomous Database details===
Oracle Cloud ADW - Autonomous Database details
Run Python Application Without a Wallet
 
===Network===
=== Run Python Application Without a Wallet ===
====Access type:====
 
==== Network ====
 
===== Access type: =====
*Allow secure access from specified IPs and VCNs
*Allow secure access from specified IPs and VCNs
====Access control list:====
 
===== Access control list: =====
*Enabled IP: 36.112.25.131,132.145.51.204
*Enabled IP: 36.112.25.131,132.145.51.204
====Mutual TLS (mTLS) authentication:====
- OR -
 
* CIDR: 0.0.0.0/0
 
===== Mutual TLS (mTLS) authentication: =====
*Not Required
*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")))'
  #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'
  USER='admin'
  PASSWD='PASSWORD'
  PASSWD='orB.db.1.2..8'
   
   
  import oracledb
  import oracledb
第19行： 第28行：
  for TN in res:
  for TN in res:
     print(TN)
     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===
===Error===
====AttributeError: module 'lib' has no attribute 'X509_V_FLAG_CB_ISSUER_CHECK'====
====AttributeError: module 'lib' has no attribute 'X509_V_FLAG_CB_ISSUER_CHECK'====
系统当前的python和pyOpenSSL版本不对应
系统当前的 python 和 pyOpenSSL 版本不对应
  mv /usr/lib/python3/dist-packages/OpenSSL /tmp/
  mv /usr/lib/python3/dist-packages/OpenSSL /tmp/
   
   

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
取自“https://mwbbs.eu.org/wiki/index.php?title=ADW_-_Autonomous_Database_details&oldid=1757”