[sr-dev] ORACLE_DB module Problem

[laura testi]

Hello,

>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.

thanks for your suggestion, Daniel.
I added debug messages inside the db_oracle/res.c module and I was able to
find the function ends in error.
This function is:



*OCIStmtFetch2(_c, con->errhp, 1, OCI_FETCH_LAST, 0, OCI_DEFAULT);*



where:


OCIStmt* _c;

ora_con_t* con;

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.

Any idea?

Thanks and regards,
laura

On Wed, Apr 20, 2011 at 11:32 PM, Daniel-Constantin Mierla <
miconda at gmail.com> wrote:

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


>
> Cheers,
> Daniel
>
> --
> Daniel-Constantin Mierlahttp://www.asipto.com
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20110421/c9448c14/attachment.htm>