ORA-00942: table or view does not exist

XMLWordPrintable

    • Type: Change Request
    • Resolution: Won't fix
    • Priority: Trivial
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Environment:
      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

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

              Created:
              Updated:
              Resolved: