Ad Widget

Collapse

zabbix agent2 oracle monitoring always connects to oracle 1521 (default) port

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bartek.sojka@rebit.pl
    Junior Member
    • Jan 2022
    • 3

    #1

    zabbix agent2 oracle monitoring always connects to oracle 1521 (default) port

    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
  • bartek.sojka@rebit.pl
    Junior Member
    • Jan 2022
    • 3

    #2
    finally managed to have it working, case closed

    Comment

    • cyber
      Senior Member
      Zabbix Certified SpecialistZabbix Certified Professional
      • Dec 2006
      • 4807

      #3
      And the problem was... ? You could help someone else with describing your solution...

      Comment

      • bartek.sojka@rebit.pl
        Junior Member
        • Jan 2022
        • 3

        #4
        i was configuring macros for oracle on server instead of host, i.e. in Administration->General->Macros menu. When i set those up in host definitions (Macros tab) everything started to work perfectly

        Comment

        Working...