<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
On 4/20/11 6:52 PM, laura testi wrote:
<blockquote
cite="mid:BANLkTi=rLyfabjX80E6optieR-zT1h3e1A@mail.gmail.com"
type="cite">
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font size="3"><font
face="Calibri">Hi all,</font></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font
face="Calibri" size="3">we are trying to setup a Kamailio <span
style="mso-spacerun: yes"> </span>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: </font><a
moz-do-not-send="true"
href="http://kb.asipto.com/kamailio:presence:k31-made-simple"><font
color="#0000ff" face="Calibri" size="3">http://kb.asipto.com/kamailio:presence:k31-made-simple</font></a><font
size="3"><font face="Calibri">.</font></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font
face="Calibri" size="3"> </font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font size="3"><font
face="Calibri"><u>The OS we are using is Linux RHEL 5.6 x64
and ORACLE 11g as Database</u>.</font></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font
face="Calibri" size="3"> </font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font size="3"><font
face="Calibri">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:</font></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font
face="Calibri" size="3"> </font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font size="3"><font
face="Calibri"><span style="mso-spacerun: yes"> </span>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</font></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font size="3"><font
face="Calibri">Apr 19 23:12:08 localhost
/opt/openkore/sbin/kamailio[10394]: ERROR: <b
style="mso-bidi-font-weight: normal">db_oracle
[res.c:423]: driver: ORA-24330: internal OCI error</b></font></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font size="3"><font
face="Calibri">Apr 19 23:12:08 localhost
/opt/openkore/sbin/kamailio[10394]: ERROR: db_oracle
[res.c:475]: error while converting rows</font></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font size="3"><font
face="Calibri">Apr 19 23:12:08 localhost
/opt/openkore/sbin/kamailio[10394]: ERROR: <core>
[db_query.c:108]: error while storing result</font></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font size="3"><font
face="Calibri">Apr 19 23:12:08 localhost
/opt/openkore/sbin/kamailio[10394]: ERROR: <core>
[db.c:366]: error in db_query</font></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font size="3"><font
face="Calibri">Apr 19 23:12:08 localhost
/opt/openkore/sbin/kamailio[10394]: ERROR: <core>
[db.c:405]: querying version for table presentity</font></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font size="3"><font
face="Calibri">Apr 19 23:12:08 localhost
/opt/openkore/sbin/kamailio[10394]: ERROR: presence
[presence.c:300]: error during table version check</font></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font size="3"><font
face="Calibri">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)</font></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font size="3"><font
face="Calibri">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</font></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font size="3"><font
face="Calibri">Apr 19 23:12:11 localhost
/opt/openkore/sbin/kamailio[10394]: INFO: db_oracle
[db_oracle.c:91]: Oracle terminate</font></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font
face="Calibri" size="3"> </font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font size="3"><font
face="Calibri">Is it a known bug of db_oracle module?</font></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font size="3"><font
face="Calibri">Could you please help me to solve this
problem?</font></font></p>
</blockquote>
"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" :-)<br>
<br>
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.<br>
<br>
Cheers,<br>
Daniel<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a></pre>
</body>
</html>