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,