DB Connectivity issue

[aprakash]

Hi Team,
I have installed zabbix server by Enabling Oracle with below options
./configure --prefix=/tools/appsw/oracle/zabbix --enable-server --enable-agent --with-oracle=yes --with-oracle-include=/tools/utilsw/oracle/11gclient/rdbms/public --with-oracle-lib=/tools/utilsw/oracle/11gclient/lib
I have configured DB parameters in configuration file "zabbix_server.conf"
Below parameters are configured
ListenPort=10051
DBName=DDDD
DBHost=hostanme.xxxx.com
DBSchema=ZABBIXPOC
DBPassword=password#
DBPort=1521
while i trying to start the server.. i am getting below error in log
30051:20170301:102041.103 In zbx_db_get_database_type()
30051:20170301:102041.103 In DBconnect() flag:0
30051:20170301:102041.127 [Z3001] connection to database '//hostanme.xxxx.com:1521/DDDD' failed: [-1]
30051:20170301:102041.127 Cannot connect to the database. Exiting...
Please advise on this..

[Atsushi]

Please check the information in the following URL.

https://www.zabbix.com/forum/showthread.php?t=49925

[aprakash]

I have set only below one

export LD_LIBRARY_PATH=/tools/utilsw/oracle/11gclient/lib

Through which my zabbix server is trying to connect to Oracle database which is running on remote server.

Host1: Zabbix server
Host2: Oracle Database server

Host1 is having oracle client. Please let me know still i need install Oracle in my host1 server where zabbix server is running

[aprakash]

Please check the information in the following URL.
https://www.zabbix.com/forum/showthread.php?t=49925

How to define ORACLE_HOME in my Zabbix server, if DB is running in different host ?
export ORACLE_BASE=
export ORACLE_HOME=
export ORACLE_SID=

e.g:
1) Zabbix serer is installed in host1
2)Oracle DB is running in host1