Re: [cx-oracle-users] ERRO ORA-12154/ORA-24315

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Thanks Anthony!

=)

2015-11-12 15:51 GMT-02:00 Anthony Tuininga <ant...@gm...>:

> 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 <ed...@gm...>
> 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/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?
>>
>>
>> ------------------------------------------------------------------------------
>>
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>>
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>