<div><font face="arial,helvetica,sans-serif">Hello,</font></div>
<div> </div>
<div>>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><font face="arial,helvetica,sans-serif">thanks for your suggestion, Daniel.</font></div>
<div><font face="arial,helvetica,sans-serif">I added debug messages inside the db_oracle/res.c module and I was able to find the function ends in error. </font></div>
<div><font face="arial,helvetica,sans-serif">This function is:</font></div>
<div>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font face="arial,helvetica,sans-serif"></font></p></div>
<div>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font face="arial,helvetica,sans-serif"></font> </p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font face="arial,helvetica,sans-serif"><strong>OCIStmtFetch2(_c, con->errhp, 1, OCI_FETCH_LAST, 0, OCI_DEFAULT);</strong></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font face="arial,helvetica,sans-serif"> </font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font face="arial,helvetica,sans-serif">where:</font></p>
<div><font face="arial,helvetica,sans-serif"> </font></div>
<div>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font face="arial,helvetica,sans-serif">OCIStmt* _c;</font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font face="arial,helvetica,sans-serif">ora_con_t* con;</font></p></div></div>
<div><font face="arial,helvetica,sans-serif"> </font></div>
<div><font face="arial,helvetica,sans-serif">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</font><font face="Calibri">. </font></div>
<div><font face="Calibri"></font> </div>
<div><font face="Calibri">Any idea?</font></div>
<div> </div>
<div>Thanks and regards,</div>
<div>laura <br></div>
<div class="gmail_quote"> </div>
<div class="gmail_quote">On Wed, Apr 20, 2011 at 11:32 PM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com">miconda@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div text="#000000" bgcolor="#FFFFFF">Hello,
<div>
<div></div>
<div class="h5"><br><br>On 4/20/11 6:52 PM, laura testi wrote:
<blockquote 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> </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 href="http://kb.asipto.com/kamailio:presence:k31-made-simple" target="_blank"><font face="Calibri" color="#0000ff" 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> </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>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></div></div>"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></div></blockquote>
<div> </div>
<div> </div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div text="#000000" bgcolor="#FFFFFF"><br>Cheers,<br>Daniel<br><font color="#888888"><pre cols="72">--
Daniel-Constantin Mierla
<a href="http://www.asipto.com/" target="_blank">http://www.asipto.com</a></pre></font></div></blockquote></div><br>