21 Apr
2011
21 Apr
'11
8:19 a.m.
Hello,
Oracle module was developed some time ago, probably
using an older version
of oracle server and library. You should add some >debug
messages inside
function get_rows() from modules_k/db_oracle/res.c in order to see exactly
what function threw the error. >Then you may find more hints searching on
the web for that function name and error message.
thanks for your suggestion, Daniel.
I added debug messages inside the db_oracle/res.c module and I was able to
find the function ends in error.
This function is:
*OCIStmtFetch2(_c, con->errhp, 1, OCI_FETCH_LAST, 0, OCI_DEFAULT);*
where:
OCIStmt* _c;
ora_con_t* con;
I have also tried to compile the module using both the
instantclient-sdk-11.2.0.2 or oracle-instantclient-basic-10.2.0.3-1, but
receiving the same error.
Any idea?
Thanks and regards,
laura
On Wed, Apr 20, 2011 at 11:32 PM, Daniel-Constantin Mierla <
miconda(a)gmail.com> wrote:
Hello,
On 4/20/11 6:52 PM, laura testi wrote:
Hi all,
we are trying to setup a Kamailio as a SIP/SIMPLE presence server for
chat based on the guide published in SIP SIMPLE Presence Made Simple with
Kamailio 3.1.x on the site:
http://kb.asipto.com/kamailio:presence:k31-made-simple.
*The OS we are using is Linux RHEL 5.6 x64 and ORACLE 11g as Database*.
So I have compiled the db_oracle module using instantclient-sdk-11.2.0.2
but when I start kamailio I receive the following errors:
Apr 19 23:12:07 localhost /opt/openkore/sbin/kamailio[10394]: INFO:
db_oracle [ora_con.c:132]: server version is Oracle Database 11g Enterprise
Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP,
Data Mining and Real Application Testing options
Apr 19 23:12:08 localhost /opt/openkore/sbin/kamailio[10394]: ERROR: *db_oracle
[res.c:423]: driver: ORA-24330: internal OCI error*
Apr 19 23:12:08 localhost /opt/openkore/sbin/kamailio[10394]: ERROR:
db_oracle [res.c:475]: error while converting rows
Apr 19 23:12:08 localhost /opt/openkore/sbin/kamailio[10394]: ERROR: <core>
[db_query.c:108]: error while storing result
Apr 19 23:12:08 localhost /opt/openkore/sbin/kamailio[10394]: ERROR: <core>
[db.c:366]: error in db_query
Apr 19 23:12:08 localhost /opt/openkore/sbin/kamailio[10394]: ERROR: <core>
[db.c:405]: querying version for table presentity
Apr 19 23:12:08 localhost /opt/openkore/sbin/kamailio[10394]: ERROR:
presence [presence.c:300]: error during table version check
Apr 19 23:12:08 localhost /opt/openkore/sbin/kamailio[10394]: ERROR: <core>
[sr_module.c:875]: init_mod(): Error while initializing module presence
(/opt/openkore/lib64/kamailio/modules_k/presence.so)
Apr 19 23:12:10 localhost /opt/openkore/sbin/kamailio[10394]: ERROR:
db_oracle [ora_con.c:173]: driver: ORA-03127: no new operations allowed
until the active operation ends
Apr 19 23:12:11 localhost /opt/openkore/sbin/kamailio[10394]: INFO:
db_oracle [db_oracle.c:91]: Oracle terminate
Is it a known bug of db_oracle module?
Could you please help me to solve this problem?
"internal OCI error" is very intuitive coming from Oracle, moreover
searching google for this ORA error says the action to do is "Contact Oracle
Support" :-)
Cheers,
Daniel
--
Daniel-Constantin Mierlahttp://www.asipto.com