ERRO ORA-12154/ORA-24315

Eduardo Nascimento <[email protected]> Thu, 12 Nov 2015 15:00:58 -0200
Newsgroups gmane.comp.python.db.cx-oracle
Message-ID <CAJb1bFydRjUWMQE2yhMNZ402UWyhXoQsmj-u79zW_9a-VkjpnA@mail.gmail.com>
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