Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-3733

ORA-00942: table or view does not exist

XMLWordPrintable

    • Icon: Change Request Change Request
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • None
    • None
    • None
    • POC

      Hi Team,

      We are using oracle DB for Zabbix server.

      While trying to start Zabbix server, we are getting below error
      27703:20170306:084424.889 In zbx_db_get_database_type()
      27703:20170306:084424.889 In DBconnect() flag:0
      27703:20170306:084424.936 query without transaction detected
      27703:20170306:084424.936 query [txnlev:0] [alter session set nls_numeric_characters='. ']
      27703:20170306:084424.937 End of DBconnect():0
      27703:20170306:084424.937 query [txnlev:0] [select * from (select userid from users) where rownum<=1]
      27703:20170306:084424.939 [Z3005] query failed: [-1] ORA-00942: table or view does not exist [select * from (select userid from users) where rownum<=1]
      27703:20170306:084424.939 cannot select records from "users" table
      27703:20170306:084424.940 End of zbx_db_get_database_type():ZBX_DB_UNKNOWN
      27703:20170306:084424.940 cannot use database "OMSALD": database is not a Zabbix database

      Please let us know whether we need to create any table in DB End before start the zabbix server.

      From DB End, we just created schema alone

      Thanks,
      Antony

            Unassigned Unassigned
            aprakash Antony Prakash
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: