Ad Widget

Collapse

Zabbix 2.0.9 and Orabbix 1.2.3 - ORA-00942: table or view does not exist

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pxsh
    Junior Member
    • Oct 2013
    • 14

    #1

    Zabbix 2.0.9 and Orabbix 1.2.3 - ORA-00942: table or view does not exist

    EDIT: Posted in wrong forum, sorry for that. Kindly close this one.

    Hi,
    I´ve recently setup Orabbix to monitor some Oracle instances, beginning with a stage server but I´m running into ORA-00942 errors: table or view does not exist.
    No data is shown in "Latest data" for the Orabbix items.

    Oracle server have XML DB installed and privileges have been set according to official install guide.

    Oracle server version is 11.2.0.2.0.

    Logs of Orabbix startup/usage:
    Code:
     
     2013-12-19 16:12:12,760 [main] INFO  Orabbix - Starting Orabbix Version 1.2.3
     2013-12-19 16:12:12,810 [main] INFO  Orabbix - Orabbix started with pid:1934
     2013-12-19 16:12:12,810 [main] INFO  Orabbix - PidFile -> ./logs/orabbix.pid
     2013-12-19 16:12:13,138 [main] INFO  Orabbix - DB Pool created: org.apache.commons.dbcp.datasources.SharedPoolDataSource@1be1a409
     2013-12-19 16:12:13,138 [main] INFO  Orabbix - URL=jdbc:oracle:thin:@[IP]:[PORT]:[DBNAME]
     2013-12-19 16:12:13,138 [main] INFO  Orabbix - maxPoolSize=10
     2013-12-19 16:12:13,138 [main] INFO  Orabbix - maxIdleSize=1
     2013-12-19 16:12:13,139 [main] INFO  Orabbix - maxIdleTime=1800000ms
     2013-12-19 16:12:13,139 [main] INFO  Orabbix - poolTimeout=100
     2013-12-19 16:12:13,139 [main] INFO  Orabbix - timeBetweenEvictionRunsMillis=-1
     2013-12-19 16:12:13,139 [main] INFO  Orabbix - numTestsPerEvictionRun=3
     2013-12-19 16:12:14,764 [main] INFO  Orabbix - Connected as [ZABBIX_USER]
     2013-12-19 16:12:14,771 [main] INFO  Orabbix - --------- on Database -> [DBNAME]
     2013-12-19 16:12:14,953 [pool-1-thread-1] WARN  Orabbix - Error while executing ->archive- on database ->DB_stage1- Exception received ORA-00942: table or view does not exist
    
     2013-12-19 16:12:14,953 [pool-1-thread-1] ERROR Orabbix - Error on DBEnquiry on query=archive on database=DB_stage1 Error returned is java.lang.IllegalArgumentException: null value for key 'archive'
     2013-12-19 16:12:15,046 [pool-1-thread-1] WARN  Orabbix - Error while executing ->locks- on database ->DB_stage1 - Exception received ORA-00942: table or view does not exist
    
     2013-12-19 16:12:15,162 [pool-1-thread-1] WARN  Orabbix - Error while executing ->session_active- on database ->DB_stage1 - Exception received ORA-00942: table or view does not exist
    
     2013-12-19 16:12:15,162 [pool-1-thread-1] ERROR Orabbix - Error on DBEnquiry on query=session_active on database=DB_stage1 Error returned is java.lang.IllegalArgumentException: null value for key 'session_active'
     2013-12-19 16:12:15,168 [pool-1-thread-1] WARN  Orabbix - Error while executing ->session_inactive- on database ->DB_stage1 - Exception received ORA-00942: table or view does not exist
    
     2013-12-19 16:12:15,168 [pool-1-thread-1] ERROR Orabbix - Error on DBEnquiry on query=session_inactive on database=DB_stage1 Error returned is java.lang.IllegalArgumentException: null value for key 'session_inactive'
     2013-12-19 16:12:15,174 [pool-1-thread-1] WARN  Orabbix - Error while executing ->session- on database ->DB_stage1 - Exception received ORA-00942: table or view does not exist
    
     2013-12-19 16:12:15,174 [pool-1-thread-1] ERROR Orabbix - Error on DBEnquiry on query=session on database=DB_stage1 Error returned is java.lang.IllegalArgumentException: null value for key 'session'
     2013-12-19 16:12:15,179 [pool-1-thread-1] WARN  Orabbix - Error while executing ->session_system- on database ->DB_stage1 - Exception received ORA-00942: table or view does not exist
    
     2013-12-19 16:12:15,180 [pool-1-thread-1] ERROR Orabbix - Error on DBEnquiry on query=session_system on database=DB_stage1 Error returned is java.lang.IllegalArgumentException: null value for key 'session_system'
     2013-12-19 16:12:15,234 [pool-1-thread-1] WARN  Orabbix - Error while executing ->tbl_space- on database ->DB_stage1 - Exception received ORA-00942: table or view does not exist
    
     2013-12-19 16:12:15,240 [pool-1-thread-1] WARN  Orabbix - Error while executing ->userconn- on database ->DB_stage1 - Exception received ORA-00942: table or view does not exist
    
     2013-12-19 16:12:15,240 [pool-1-thread-1] ERROR Orabbix - Error on DBEnquiry on query=userconn on database=DB_stage1 Error returned is java.lang.IllegalArgumentException: null value for key 'userconn'
     2013-12-19 16:12:15,593 [pool-1-thread-1] INFO  Orabbix - Done with dbJob on database DB_stage1 QueryList elapsed time 673 ms

    Thanks in advance for your effort in helping me to solve this.
    Last edited by pxsh; 19-12-2013, 18:30.
Working...