[sr-dev] ORACLE_DB module Problem

[laura testi]

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?



Thanks for your help,
laura
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20110420/c3f06ffe/attachment.htm>