Problem asterisk odbc oracle

Asterisk Asterisk Support
1

hello all,
I would like to use asterisk realtime with oracle and SIP , extensions tables.
my OS is CENTOS 6.5 x64
Asterisk 11

I installed
oracle-instantclient12.1-odbc-12.1.0.1.0-1.x86_64.rpm
oracle-instantclient12.1-sqlplus-12.1.0.1.0-1.x86_64.rpm
oracle-instantclient12.1-basic-12.1.0.1.0-1.x86_64.rpm

my configuration:

“cd /etc/odbcinst.ini”:

[OracleODBC-12.1]
Description = Oracle ODBC driver for Oracle
Driver = /usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1
Setup = /usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1
FileUsage = 1
Driver Logging = 7

“cd /etc/odbc.ini”:

[asteriskrealtime]
Application Attributes = T
Attributes = W
BatchAutocommitMode = IfAllSuccessful
BindAsFLOAT = F
CloseCursor = F
DisableDPM = F
DisableMTS = T
Driver = OracleODBC-12.1
DSN = asteriskrealtime
EXECSchemaOpt =
EXECSyntax = T
Failover = T
FailoverDelay = 10
FailoverRetryCount = 10
FetchBufferSize = 64000
ForceWCHAR = F
Lobs = T
Longs = T
MetadataIdDefault = F
QueryTimeout = T
ResultSets = T
ServerName = //XX.XX.XX.XX:1522/DBast
SQLGetData extensions = F
Translation DLL =
Translation Option = 0
DisableRULEHint = T
UserID = asterisk
Password = asterisk
Port = 1522

“cd /etc/asterisk/res_odbc.conf”:

[ENV]
ORACLE_HOME => /usr/lib/oracle/12.1/client64
LD_LIBRARY_PATH => /usr/lib/oracle/12.1/client64/lib
TWO_TASK => //XX.XX.XX.XX:1522/DBast

[asteriskrealtime]
enabled => yes
dsn => asteriskrealtime
username => asterisk
password => asterisk

Connection test:

isql -v asteriskrealtime

±--------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
±--------------------------------------+
SQL>

PROBLEM IS :

asterisk -rvvv

[May 26 13:47:16] NOTICE[19944]: res_odbc.c:793 load_odbc_config: Adding ENV var: ORACLE_HOME=/usr/lib/oracle/12.1/client64
[May 26 13:47:16] NOTICE[19944]: res_odbc.c:793 load_odbc_config: Adding ENV var: LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib
[May 26 13:47:16] NOTICE[19944]: res_odbc.c:793 load_odbc_config: Adding ENV var: TWO_TASK=//78.192.180.239:1522/DBast
[May 26 13:47:16] NOTICE[19944]: res_odbc.c:1537 odbc_obj_connect: Connecting asteriskrealtime
[May 26 13:47:16] WARNING[19944]: res_odbc.c:1562 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Can’t open lib ‘/usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1’ : file not found

how I can resolve this problem with “libsqora.so.12.1”

thank you

HESNAUX

2

This would probably be a problem with access rights.
If You can connect from the console using isql but not within the asterisk-process You should check which user the asterisk-instance is running as and whether this user has the necessary rights for libraries needed to connect to Oracle via ODBC.