-
Problem report
-
Resolution: Won't fix
-
Trivial
-
None
-
6.0.30
- web error on this picture:
2.with odbc Monitor Configuration Below:
[root@Ora ~]# rpm -qa |grep ODBC
unixODBC-devel-2.3.7-3.oe2203sp2.x86_64
unixODBC-2.3.7-3.oe2203sp2.x86_64
[root@Ora ~]# odbcinst -j
unixODBC 2.3.7
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
[root@Ora ~]#
[root@Ora ~]# cat /etc/odbc.ini
[audit]
Driver = Oracle
ServerName = xxxxxxxxxx:1521/audit
UserID = xxx
Password = xxxx
[root@Ora ~]# cat /etc/odbcinst.ini
[Oracle]
Driver=/usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
[root@Ora ~]# isql -v audit
---------------------------------------
Connected! |
sql-statement |
help [tablename] |
quit |
---------------------------------------
SQL> select status from gv$instance;
-------------
STATUS |
-------------
OPEN |
OPEN |
-------------
SQLRowCount returns -1
2 rows fetched
SQL>
3. user zabbix and root ldd output Below :
[root@Ora zabbix]# chmod 777 -R /usr/lib/oracle
[root@Ora zabbix]# ls -l /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
-rwxrwxrwx 1 root root 1003582 Aug 25 2013 /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
[root@Ora ~]# ldd /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
linux-vdso.so.1 (0x00007ffd787d3000)
libdl.so.2 => /usr/lib64/libdl.so.2 (0x00007f55efee9000)
libm.so.6 => /usr/lib64/libm.so.6 (0x00007f55efe0e000)
libpthread.so.0 => /usr/lib64/libpthread.so.0 (0x00007f55efe0b000)
libnsl.so.1 => /usr/lib64/libnsl.so.1 (0x00007f55efdf1000)
libclntsh.so.11.1 => /usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1 (0x00007f55ed482000)
libodbcinst.so.1 => /usr/lib64/libodbcinst.so.1 (0x00007f55ed468000)
libc.so.6 => /usr/lib64/libc.so.6 (0x00007f55ed267000)
/lib64/ld-linux-x86-64.so.2 (0x00007f55f00b0000)
libnnz11.so => /usr/lib/oracle/11.2/client64/lib/libnnz11.so (0x00007f55ece9a000)
libaio.so.1 => /usr/lib64/libaio.so.1 (0x00007f55ece95000)
libltdl.so.7 => /usr/lib64/libltdl.so.7 (0x00007f55ece89000)
[root@Ora zabbix]# env
SHELL=/bin/bash
HISTCONTROL=ignoredups
HISTSIZE=5
HOSTNAME=Ora
JAVA_HOME=/usr/local/jdk1.8.0_141
PWD=/usr/local/zabbix
LOGNAME=root
MOTD_SHOWN=pam
HOME=/root
LANG=en_US.UTF-8
ORACLE_HOME=/usr/lib/oracle/11.2/client64
TERM=xterm
USER=root
NLS_LANG=simplified chinese_china.ZHS16GBK
SHLVL=1
CLASSPATH=.:/usr/local/jdk1.8.0_141/jre/lib/rt.jar:/usr/local/jdk1.8.0_141/lib/dt.jar:/usr/local/jdk1.8.0_141/lib/tools.jar
LD_LIBRARY_PATH=/usr/lib64:/usr/lib/oracle/11.2/client64/lib
TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/admin
PATH=/usr/lib/oracle/11.2/client64/bin:/usr/local/jdk1.8.0_141/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/usr/lib/oracle/11.2/client64/lib
MAIL=/var/spool/mail/root
SSH_TTY=/dev/pts/0
OLDPWD=/usr/local
_=/usr/bin/env
4. zabbix_server path with Binary compilation:
[root@Ora zabbix]# pwd
/usr/local/zabbix
[root@Ora zabbix]#
[root@Ora zabbix]# ls
alertscripts bin etc externalscripts html lib log sbin share
5.Find a closer solution on the official website,But there is no process environment variable associated with Oracle
[root@Ora zabbix]# cat /etc/sysconfig/zabbix-server
ORACLE_HOME=/usr/lib/oracle/11.2/client64
LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib:/usr/lib64
TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/admin
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/usr/lib/oracle/11.2/client64/lib
export ORACLE_HOME
export LD_LIBRARY_PATH
export TNS_ADMIN
export PATH
[root@Ora zabbix]# systemctl restart zabbix_server
[root@Ora zabbix]# ps -ef |grep zabbix
zabbix 1376564 1 0 May30 ? 00:00:00 /usr/local/zabbix/sbin/zabbix_agentd
[root@Ora diag]# strings -a /proc/1376564/environ
LANG=en_US.UTF-8
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
INVOCATION_ID=24630e794f684037bc7f4d2af81c340d
JOURNAL_STREAM=8:297078272
SYSTEMD_EXEC_PID=2437294
How to make the main process with oracle environment variables ?Or deal with the problem of not finding the file ”libsqora.so.11.1“