[cx-oracle-users] ERRO ORA-12154/ORA-24315
Brought to you by:
atuining
From: Eduardo N. <ed...@gm...> - 2015-11-12 17:01:06
|
Gentlemen, I'm trying to connect to a schema, but I'm not getting. I've tried a number of ways, but to no avail: C:\Python27>python.exe Python 2.7.10 (default, May 23 2015, 09:40:32) [MSC v.1500 32 bit (Intel)] on win32 Type "help", "copyright", "credits" or "license" for more information. >>> import cx_Oracle >>> >>> con = cx_Oracle.connect('iris/iris@10.10.160.67/IRSCRPPR') Traceback (most recent call last): File "<stdin>", line 1, in <module> cx_Oracle.DatabaseError: ORA-24315: illegal attribute type con = cx_Oracle.connect 'iris/iris@10.10.160.67/IRSCRPPR' ^ SyntaxError: invalid syntax >>> con = cx_Oracle.connect (iris/iris@10.10.160.67/IRSCRPPR) File "<stdin>", line 1 con = cx_Oracle.connect (iris/iris@10.10.160.67/IRSCRPPR) ^ SyntaxError: invalid syntax >>> con = cx_Oracle.connect ("iris/iris@10.10.160.67/IRSCRPPR") Traceback (most recent call last): File "<stdin>", line 1, in <module> cx_Oracle.DatabaseError: ORA-24315: illegal attribute type >>> con = cx_Oracle.connect ("iris/iris@IRSCRPPR") Traceback (most recent call last): File "<stdin>", line 1, in <module> cx_Oracle.DatabaseError: ORA-12154: TNS:could not resolve the connect identifier specified >>> con = cx_Oracle.connect ("iris/iris@10.10.160.67/IRSCRPPR") Traceback (most recent call last): File "<stdin>", line 1, in <module> cx_Oracle.DatabaseError: ORA-24315: illegal attribute type >>> con = cx_Oracle.connect ("iris/iris@10.10.160.67") Traceback (most recent call last): File "<stdin>", line 1, in <module> cx_Oracle.DatabaseError: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor >>> con = cx_Oracle.connect ("iris", "iris", "10.10.160.67:1521") Traceback (most recent call last): File "<stdin>", line 1, in <module> cx_Oracle.DatabaseError: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor >>> con = cx_Oracle.connect ("iris", "iris", "10.10.160.67") Traceback (most recent call last): File "<stdin>", line 1, in <module> cx_Oracle.DatabaseError: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor >>> con = cx_Oracle.connect ("iris", "iris", "10.10.160.67/IRSCRPPR") Traceback (most recent call last): File "<stdin>", line 1, in <module> cx_Oracle.DatabaseError: ORA-24315: illegal attribute type >>> con = cx_Oracle.connect ("iris", "iris", "10.10.160.67@IRSCRPPR") Traceback (most recent call last): File "<stdin>", line 1, in <module> cx_Oracle.DatabaseError: ORA-12154: TNS:could not resolve the connect identifier specified >>> con = cx_Oracle.connect ("iris/iris", "10.10.160.67@IRSCRPPR") Traceback (most recent call last): File "<stdin>", line 1, in <module> cx_Oracle.DatabaseError: ORA-12154: TNS:could not resolve the connect identifier specified >>> con = cx_Oracle.connect ('iris','iris', '10.10.160.67','IRSCRPPR') Traceback (most recent call last): File "<stdin>", line 1, in <module> TypeError: an integer is required >>> con = cx_Oracle.connect ('iris','iris', '10.10.160.67@IRSCRPPR') Traceback (most recent call last): File "<stdin>", line 1, in <module> cx_Oracle.DatabaseError: ORA-12154: TNS:could not resolve the connect identifier specified C:\Python27>tnsping 10.10.160.67 TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 12-NOV-2015 13:40:56 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: C:\oracle\ora102\network\admin\sqlnet.ora Used HOSTNAME adapter to resolve the alias Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=10.10.160.67))(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.160.67)( PORT=1521))) OK (10 msec) C:\Python27> ################# with sqlplus I can ############ C:\Users\castec>sqlplus "iris/iris@10.10.160.67/IRSCRPPR" SQL*Plus: Release 10.2.0.1.0 - Production on Thu Nov 12 13:42:55 2015 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> Please can you help me? |