ORA-03113 when passing clientinfo to cx_Oracle.connect()

Walter Dörwald <[email protected]>
Newsgroups gmane.comp.python.db.cx-oracle
Organization LivingLogic AG, Bayreuth/Germany
Message-ID <[email protected]>
Hello all!

I'm using cx_Oracle 5.1.2 with Python 3.3.3. When I connect to an 
11.2.0.4.0 database and pass the clientinfo parameter I get an ORA-03113 
exception. Without the parameter it works. Setting the parameter after 
the connection is established works (somewhat):

▸ python
Python 3.3.3 (default, Nov 19 2013, 12:08:16)
[GCC 4.2.1 Compatible Apple LLVM 5.0 (clang-500.2.79)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
 >>> import cx_Oracle
 >>> db = cx_Oracle.connect("user/pwd@db", clientinfo="foo")
Traceback (most recent call last):
   File "<stdin>", line 1, in <module>
cx_Oracle.OperationalError: ORA-03113: end-of-file on communication channel
Process ID: 0
Session ID: 0 Serial number: 0

 >>> db = cx_Oracle.connect("user/pwd@db")
 >>> db.version
'11.2.0.4.0'
 >>> db.clientinfo = "foo"
 >>>

However when I do a "select distinct client_info from v$session" I don't 
see the value "foo".

This bug only happens on 11.2.0.4 databases. Connecting to 11.2.0.3 or 
11.2.0.1 instances seems to work (both when passing the clientinfo 
parameter in the constructor and when setting it afterwards).

The client is an Oracle Instant client 11.2.0.3 on Mac OS X 10.9.1.

Is this a cx_Oracle or Oracle problem?

Servus,
    Walter

------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
_______________________________________________
cx-oracle-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.