[cx-oracle-users] ORA-03113 when passing clientinfo to cx_Oracle.connect()
Brought to you by:
atuining
|
From: Walter D. <wa...@li...> - 2014-02-27 13:30:24
|
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
|