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:
Thanks in advance for your effort in helping me to solve this.
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.