- 基本连接–使用Oracle tns alias
connection = cx_Oracle.connect("tp/tp@ocn_test") #查看tns alias命令 cmd>tnsping ocn_test TNS Ping Utility for Linux: Version 9.2.0.8.0 - Production on 27-SEP-2011 10:47:48 Copyright (c) 1997, 2006, Oracle Corporation. All rights reserved. Used parameter files: /opt/……/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.36.19)(PORT = 1520))) (CONNECT_DATA = (SID = ocntest))) OK (10 msec)
- 用户输入密码连接
pwd = getpass.getpass() connection = cx_Oracle.connect("tp",pwd,"ocn_test")
- 用户直接在Python命令中输入连接账号信息,格式如python script.py tp/tp@ocn_test
connection = cx_Oracle.connect(sys.argv[1])
- 使用Easy Connect语法,通过Drive连接数据库
connection = cx_Oracle.connect('tp','tp','10.20.36.19:1521/ocntest') #or connection = cx_Oracle.connect('tp/tp@10.20.36.19:1521/ocntest')
- 先使用DSN构成TNSNAME
tns_name = cx_Oracle.makedsn('10.20.36.19','1521',' ocntest ') connection = cx_Oracle.connect('tp','tp',tns_name)
- 登陆as SYSDBA
connection = cx_Oracle.connect('tp/tp@ocn_test', mode=cx_Oracle.SYSDBA) #or as SYSOPER connection = cx_Oracle.connect('tp/tp@ocn_test', mode=cx_Oracle.SYSOPER)