2020年2月2日 星期日
oracle tnsnames.ora
http://www.aspphp.online/shujuku/oraclesjk/oraclezs/201701/226892.html
環境
db01 = 192.168.240.171 ver 11.2.0.4
db03 = 192.168.240.173 ver 19.3.0.0
--- Create User
CREATE USER pythonhol IDENTIFIED BY welcome ;
-- SYSTEM PRIVILEGES
GRANT CREATE SESSION TO pythonhol ;
GRANT SELECT ANY DICTIONARY TO pythonhol ;
---
Test Client
db1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.240.171)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
db3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.240.173)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
db =
(DESCRIPTION =
(LOAD_BALANCE=on)
(FAILOVER=on)
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.240.171)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.240.173)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
t.py
#!python
import cx_Oracle
con = cx_Oracle.connect('pythonhol/welcome@db')
cur = con.cursor()
cur.execute('SELECT host_name FROM v$instance')
for result in cur:
print result
cur.close()
con.close()
訂閱:
張貼留言 (Atom)
RHEL install EPEL
https://www.linuxtechi.com/install-epel-repo-on-rhel-system/ EPEL dnf install -y https://dl.fedoraproject.org/pub/epel/epel-release-latest...
-
記事本開啟 HKEY_CLASSES_ROOT\*\shell] [HKEY_CLASSES_ROOT\*\shell\NotePad] @="用記事本開啟" [HKEY_CLASSES_ROOT\*\shell\NotePad\command] @=...
-
下載 http://dba-tips.blogspot.tw/2015/05/oracle-database-health-check-script.html Oracle Database Health Check Script Do you wan...
-
旋轉泡泡: Oracle DataGuard 相關 Oracle DataGuard 檢查開啟狀態 -- 請全貼 -- ===check=== select dbid,name from v$database; select log_mode , OPE...
沒有留言:
張貼留言