注册

dmhs源端Oracle端isql检测连接失败

cesar 2023/07/09 969 2 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:v8
【操作系统】:红帽7
【CPU】:
【问题描述】*:[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect

依赖存在
ldd /opt/11g/product/11.2.0/dbhome_1/lib/libsqora.so.11.1
ldd: warning: you do not have execution permission for `/opt/11g/product/11.2.0/dbhome_1/lib/libsqora.so.11.1'
linux-vdso.so.1 => (0x00007ffe6c9f5000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f8dd6983000)
libm.so.6 => /lib64/libm.so.6 (0x00007f8dd6681000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f8dd6465000)
libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f8dd624b000)
libclntsh.so.11.1 => /lib64/libclntsh.so.11.1 (0x00007f8dd37e1000)
libodbcinst.so.1 => /lib64/libodbcinst.so.1 (0x00007f8dd35cf000)
libc.so.6 => /lib64/libc.so.6 (0x00007f8dd3202000)
/lib64/ld-linux-x86-64.so.2 (0x00007f8dd6b87000)
libnnz11.so => /opt/11g/product/11.2.0/dbhome_1/lib/libnnz11.so (0x00007f8dd2e35000)
libaio.so.1 => /lib64/libaio.so.1 (0x00007f8dd2c33000)
libltdl.so.7 => /lib64/libltdl.so.7 (0x00007f8dd2a29000)

odbc安装了
odbcinst -j
unixODBC 2.3.1
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

cat /etc/odbcinst.ini
[Oracle in OraDb11g_home1]
Description = ODBC DRIVER FOR ORACLE
Driver = /opt/11g/product/11.2.0/dbhome_1/lib/libsqora.so.11.1
Threading = 0

ls /opt/11g/product/11.2.0/dbhome_1/lib/libsqora.so.11.1
/opt/11g/product/11.2.0/dbhome_1/lib/libsqora.so.11.1

cat /etc/odbc.ini
[DMHS]
Description = ORACLE ODBC DSN
Driver = Oracle in OraDb11g_home1
SERVER = 10.10.180.19
UID = dmhs
PWD = dmhs
Servername = blg0102
PORT = 2350

Oracle用户登录的
isql -v blg0102 dmhs dmhs
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect

回答 0
暂无回答
扫一扫
联系客服