[ZBX-19546] Oracle by Zabbix Agent 2 Created: 2021 Jun 11  Updated: 2021 Aug 05  Resolved: 2021 Aug 05

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Templates (T)
Affects Version/s: None
Fix Version/s: None

Type: Incident report Priority: Trivial
Reporter: Marvin Assignee: Edgar Akhmetshin
Resolution: Won't fix Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

https://www.zabbix.com/ru/integrations/oracle


 Description    
# zabbix_get -s SERVER -k oracle.ping["tcp://fqdn_server_name:1530","ZABBIX","password","work"]


2021/06/11 10:41:39.031619 [1] created direct exporter task for plugin 'Oracle' itemid:0 key 'oracle.redolog.info["tcp://localhost:1530","zabbix","password","work"]'
2021/06/11 10:41:39.031649 executing direct exporter task for key 'oracle.redolog.info["tcp://localhost:1530","zabbix","password","work"]'
2021/06/11 10:41:39.032017 [Oracle] Connection failed: ORA-01804: Error while trying to retrieve text for error ORA-01804.
2021/06/11 10:41:39.032030 failed to execute direct exporter task for key 'oracle.redolog.info["tcp://localhost:1530","zabbix","password","work"]' error: 'Connection failed: ORA-01804: Error while trying to retrieve text for error ORA-01804.'
2021/06/11 10:41:39.032082 sending passive check response: ZBX_NOTSUPPORTED: 'Connection failed: ORA-01804: Error while trying to retrieve text for error ORA-01804.' to '192.168.162.9'


 Comments   
Comment by Edgar Akhmetshin [ 2021 Jun 11 ]

Hello,

Please provide:

  • Agent version, OS name and version;
  • Oracle version;
  • Settings done to configure Agent/Oracle and host;

Regards,
Edgar

Comment by Marvin [ 2021 Jun 11 ]

1. zabbix-agent2-5.4.1-1.el7.x86_64

Oracle Linux Server release 7.8

2. Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

3. Template settings

{$ORACLE.CONNSTRING} as tcp://fqdn_server_name:1530 or localhost:1530

{$ORACLE.USER} as zabbix

{$ORACLE.SERVICE} as work

grant permissions as this article https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/src/go/plugins/oracle/README.md

 

Comment by Edgar Akhmetshin [ 2021 Jun 14 ]

Did you install Oracle Instant Client >= 12 ?
ORA-01804 is about incorrect Client settings, please check TNS_ADMIN variable.

Comment by Marvin [ 2021 Jun 15 ]

I already have oracle monitoring via odbc and its work perfect.  Environment setting from zabbix-server:

 

# cat /etc/default/zabbix-server
# defaults file for zabbix-server-mysql# Start the Zabbix server from the init.d script?
# (Possible values: "yes" or "no")
#
# This is by default set to "no" because a MySQL database needs to be prepared
# and configured before you can start the Zabbix server for the first time.
#
# Instructions on how to set up the database can be found in
# /usr/share/doc/zabbix-server-mysql/README.Debian
START=yesORACLE_HOME=/usr/lib/oracle/12.2/client64
LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib:/usr/lib:$LD_LIBRARY_PATH
TNS_ADMIN=/usr/lib/oracle/12.2/client64/network/admin
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/usr/lib/oracle/12.2/client64/lib
PATH=$PATH:/usr/lib/oracle/12.2/client64/binexport ORACLE_HOME
export LD_LIBRARY_PATH
export TNS_ADMIN
export PATH
Comment by Edgar Akhmetshin [ 2021 Jun 15 ]

This env is set for Zabbix Server, not agent.

Comment by Marvin [ 2021 Jun 15 ]

Should I set up zabbix env for agent on Oracle server? Can I have an instruction?

Comment by Edgar Akhmetshin [ 2021 Jun 15 ]

Oracle env should be set for the system user named zabbix (user name in your case can be different, it depends on the settings used to start agent) according to the Oracle documentation.

Comment by Marvin [ 2021 Jun 15 ]

Thank you. Now all seems good

Comment by Edgar Akhmetshin [ 2021 Aug 05 ]

Closing as Won't fix since this is not a Zabbix issue. Thank you.

Generated at Sat May 31 03:40:28 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.