[sr-dev] ORACLE_DB module Problem

[Daniel-Constantin Mierla]

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" :-)

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.

Cheers,
Daniel

-- 
Daniel-Constantin Mierla
http://www.asipto.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20110420/3e5a2f08/attachment.htm>