dears the problem solved after updating the LD_LIBRARY_PATH
now  i need to find the correct Syntax for 
modparam("sqlops","sqlcon","rbt=>oracle://ring:ring@ORCL/orcl")
and i didn't find any reference about the correct one :\  
so is there any reference ? 

B.A 
Eyas 

From: sr-users <sr-users-bounces@lists.kamailio.org> on behalf of eyas barhouk <eyas37@hotmail.com>
Sent: Thursday, February 14, 2019 10:17 PM
To: sr-users@lists.kamailio.org
Subject: [SR-Users] kamailio with oracle database
 
hello dears 

i'm trying to run kamailio 5.1.7 with Oracle database 
and after building it from source with the needed module and  installing  Oracle Instant Client
when i'm trying to run kamailio i get the following Error : 

ERROR: <core> [core/sr_module.c:498]: load_module(): could not open module </usr/local/lib64/kamailio/modules/db_oracle.so>: libclntsh.so.12.1: cannot open shared object file: No such file or directory

so is there any way to make the libclntsh.so.12.1 open shared object ??

best regards 
Eyas