Ad Widget

Collapse

Zabbix install issue with Oracle database

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • ysn
    Junior Member
    • Jul 2017
    • 2
    #1

    Zabbix install issue with Oracle database

    Hi,

    I am facing issue while installing zabbix server with oracle database. Please help !!!!. Using source package for installation.

    Followed below link for set-up.
    Private Site
    https://uberdev.wordpress.com/2011/12/07/zabbix-deployment-on-rhel-with-oracle/


    Oracle is DaaS service and running in different server.

    zabbix-3.2.0/database/oracle/schema.sql
    zabbix-3.2.0/database/oracle/images.sql
    zabbix-3.2.0/database/oracle/data.sql

    All Executed without errors.

    2)
    ./configure --enable-server --with-oracle=/opa/zabixmon/oracle/product/client11gR2 --prefix=/opa/zabixmon/instance

    3) etc/zabbix_server.conf
    ListenPort=10051
    LogFile=/opa/zabixmon/instance/zabbix/logs/zabbix_server.log
    LogFileSize=10 #in mb; need to see how verbose this log gets
    DebugLevel=3 #warning level
    PidFile=/opa/zabixmon/instance/zabbix/logs/zabbix_server.pid
    DBHost=hkxxx-scan.hk.standardchartered.com
    DBName=DEV.hk.standardchartered.com
    DBUser=DEV_21
    DBPassword=DEV_21_123
    DBPort=1622

    4) startup issue

    cd /opa/zabixmon/instance/sbin/
    ./zabbix_server

    Error :

    38492:20170714:214327.790 Starting Zabbix Server. Zabbix 3.2.0 (revision 62485).
    38492:20170714:214327.791 ****** Enabled features ******
    38492:20170714:214327.791 SNMP monitoring: NO
    38492:20170714:214327.791 IPMI monitoring: NO
    38492:20170714:214327.791 Web monitoring: NO
    38492:20170714:214327.791 VMware monitoring: NO
    38492:20170714:214327.791 SMTP authentication: NO
    38492:20170714:214327.791 Jabber notifications: NO
    38492:20170714:214327.791 Ez Texting notifications: NO
    38492:20170714:214327.791 ODBC: NO
    38492:20170714:214327.791 SSH2 support: NO
    38492:20170714:214327.791 IPv6 support: NO
    38492:20170714:214327.791 TLS support: NO
    38492:20170714:214327.791 ******************************
    38492:20170714:214327.791 using configuration file: /opa/zabixmon/instance/etc/zabbix_server.conf
    38492:20170714:214327.979 cannot use database "DEV.hk.standardchartered.com": Zabbix server cannot work with a Zabbix proxy database
    Last edited by ysn; 15-07-2017, 05:36. Reason: updated additional info
    Tags: None
    • batchenr
      Senior Member
      • Sep 2016
      • 440
      #2
      Originally posted by ysn
      Hi,

      I am facing issue while installing zabbix server with oracle database. Please help !!!!. Using source package for installation.

      Followed below link for set-up.
      Private Site
      https://uberdev.wordpress.com/2011/12/07/zabbix-deployment-on-rhel-with-oracle/


      Oracle is DaaS service and running in different server.

      zabbix-3.2.0/database/oracle/schema.sql
      zabbix-3.2.0/database/oracle/images.sql
      zabbix-3.2.0/database/oracle/data.sql

      All Executed without errors.

      2)
      ./configure --enable-server --with-oracle=/opa/zabixmon/oracle/product/client11gR2 --prefix=/opa/zabixmon/instance

      3) etc/zabbix_server.conf
      ListenPort=10051
      LogFile=/opa/zabixmon/instance/zabbix/logs/zabbix_server.log
      LogFileSize=10 #in mb; need to see how verbose this log gets
      DebugLevel=3 #warning level
      PidFile=/opa/zabixmon/instance/zabbix/logs/zabbix_server.pid
      DBHost=hkxxx-scan.hk.standardchartered.com
      DBName=DEV.hk.standardchartered.com
      DBUser=DEV_21
      DBPassword=DEV_21_123
      DBPort=1622

      4) startup issue

      cd /opa/zabixmon/instance/sbin/
      ./zabbix_server

      Error :

      38492:20170714:214327.790 Starting Zabbix Server. Zabbix 3.2.0 (revision 62485).
      38492:20170714:214327.791 ****** Enabled features ******
      38492:20170714:214327.791 SNMP monitoring: NO
      38492:20170714:214327.791 IPMI monitoring: NO
      38492:20170714:214327.791 Web monitoring: NO
      38492:20170714:214327.791 VMware monitoring: NO
      38492:20170714:214327.791 SMTP authentication: NO
      38492:20170714:214327.791 Jabber notifications: NO
      38492:20170714:214327.791 Ez Texting notifications: NO
      38492:20170714:214327.791 ODBC: NO
      38492:20170714:214327.791 SSH2 support: NO
      38492:20170714:214327.791 IPv6 support: NO
      38492:20170714:214327.791 TLS support: NO
      38492:20170714:214327.791 ******************************
      38492:20170714:214327.791 using configuration file: /opa/zabixmon/instance/etc/zabbix_server.conf
      38492:20170714:214327.979 cannot use database "DEV.hk.standardchartered.com": Zabbix server cannot work with a Zabbix proxy database
      did you manged yourself to connect from zabbix server to remote db server ?
      with zabbix user and pass?

        Comment

        • ysn
          Junior Member
          • Jul 2017
          • 2
          #3
          Yes.

          Hi,

          Yes i am able to connect to DB using oarcle client from the host where i am trying to install zabbix server. Using the same client, i have installed the DB scripts.

          zabbix-3.2.0/database/oracle/schema.sql
          zabbix-3.2.0/database/oracle/images.sql
          zabbix-3.2.0/database/oracle/data.sql

            Comment

            Previous template Next
            Working...