Re: ERRO ORA-12154/ORA-24315

Hi,

This is an easy one. :-)

You are trying to use a version of cx_Oracle compiled for 11g with an
Oracle 10g client. That won't work! Make sure you are using an 11g client
or use a version of cx_Oracle compiled for 10g.

Anthony

On Thu, Nov 12, 2015 at 10:00 AM, Eduardo Nascimento <[email protected]>
wrote:

> 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/[email protected]/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/[email protected]/IRSCRPPR'
>                                                             ^
> SyntaxError: invalid syntax
> >>> con = cx_Oracle.connect (iris/[email protected]/IRSCRPPR)
>   File "<stdin>", line 1
>     con = cx_Oracle.connect (iris/[email protected]/IRSCRPPR)
>                                       ^
> SyntaxError: invalid syntax
> >>> con = cx_Oracle.connect ("iris/[email protected]/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/[email protected]/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/[email protected]")
> 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/[email protected]/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?
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> cx-oracle-users mailing list
> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

------------------------------------------------------------------------------

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users