Hi, I have oracle server set up on non-default port, wanted to have it monitored by zabbix agent2 installed on the same machine, however it always connects to standard 1521.
Macro setup on zabbix server:
{$ORACLE.CONNSTRING}=tcp://localhost:52482
{$ORACLE.USER}=ZABBIX
{$ORACLE.PASSWORD}=<mypassword for ZABBIX oracle user>
{$ORACLE.SERVICE}=kalypso
Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhos t)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORA)(CID =(PROGRAM=zabbix_agent2)(HOST=kalypso)(USER=zabbix )))(CONNECT_TIMEOUT=3)(RETRY_COUNT=0))
TNS-12541: TNS:no listener
agent log: [Oracle] Connection failed: ORA-12541: TNS:no listener.
can anyone help?
spent whole sunday trying to sort it out...
Versions:
Oracle 19
Zabbix 6
CentOS 8
Macro setup on zabbix server:
{$ORACLE.CONNSTRING}=tcp://localhost:52482
{$ORACLE.USER}=ZABBIX
{$ORACLE.PASSWORD}=<mypassword for ZABBIX oracle user>
{$ORACLE.SERVICE}=kalypso
Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhos t)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORA)(CID =(PROGRAM=zabbix_agent2)(HOST=kalypso)(USER=zabbix )))(CONNECT_TIMEOUT=3)(RETRY_COUNT=0))
TNS-12541: TNS:no listener
agent log: [Oracle] Connection failed: ORA-12541: TNS:no listener.
can anyone help?
spent whole sunday trying to sort it out...
Versions:
Oracle 19
Zabbix 6
CentOS 8
Comment