Python-сообщество

self.conn = cx_Oracle.connect("%s/%s@%s:1521/%s" % (user,passwd,host,service))

cx_Oracle.DatabaseError: ORA-24315: illegal attribute type

SELECT * from v$version;

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
"CORE	10.2.0.4.0	Production"
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

tns = cx_Oracle.makedsn(host, 1521, service)
db = cx_Oracle.connect(user, password, tns)

tns = cx_Oracle.makedsn(host,port,service)
self.conn = cx_Oracle.connect(user,passwd,tns)

cx_Oracle.DatabaseError: ORA-12505: TNS:listener does not currently know of SID
given in connect descriptor

connection = cx_Oracle.connect("user/password@TNS")
connection = cx_Oracle.connect("user", "password", "TNS")

DB_APP1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sun1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = AXAPTA)
    )
  )

DB_APP2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.XX.XX.XX)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = DB12)
    )
  )

		dsn = cx_Oracle.makedsn(host,port,sid)
		conn = cx_Oracle.connect(user,passwd,dsn)