orabbix部署在DG 环境中报错:ORA-00600: internal error code, arguments: [psdnop-1], [8181], [], [], [], [], [], [], [], [], [], []

2017-02-06 15:05:44,784 [pool-1-thread-20] WARN Orabbix – Error while executing ->dbversion- on database ->DB- Exception received ORA-00600: internal error code, arguments: [psdnop-1], [8181], [], [], [], [], [], [], [], [], [], []
ORA-08181: specified number is not a valid system change number
ORA-06512: at “SYS.UTL_INADDR”, line 4
ORA-06512: at “SYS.UTL_INADDR”, line 35
ORA-06512: at line 1

2017-02-06 15:05:44,784 [pool-1-thread-20] ERROR Orabbix – Error on DBEnquiry on query=dbversion on database=DB Error returned is java.lang.IllegalArgumentException: null value for key ‘dbversion’
2017-02-06 15:05:44,784 [pool-1-thread-20] WARN Orabbix – Error while executing ->hitratio_body- on database ->DB- Exception received Closed Connection
2017-02-06 15:05:44,784 [pool-1-thread-20] ERROR Orabbix – Error on DBEnquiry on query=hitratio_body on database=DB Error returned is java.lang.IllegalArgumentException: null value for key ‘hitratio_body’
2017-02-06 15:05:44,784 [pool-1-thread-20] WARN Orabbix – Error while executing ->hitratio_sqlarea- on database ->DB- Exception received Closed Connection
2017-02-06 15:05:44,784 [pool-1-thread-20] ERROR Orabbix – Error on DBEnquiry on query=hitratio_sqlarea on database=DB Error returned is java.lang.IllegalArgumentException: null value for key ‘hitratio_sqlarea’
2017-02-06 15:05:44,785 [pool-1-thread-20] WARN Orabbix – Error while executing ->hitratio_table_proc- on database ->DB- Exception received Closed Connection
2017-02-06 15:05:44,785 [pool-1-thread-20] ERROR Orabbix – Error on DBEnquiry on query=hitratio_table_proc on database=DB Error returned is java.lang.IllegalArgumentException: null value for key ‘hitratio_table_proc’
2017-02-06 15:05:44,785 [pool-1-thread-20] WARN Orabbix – Error while executing ->lio_current_read- on database ->DB- Exception received Closed Connection

主库进行授权: grant execute on utl_inaddr to zabbix;

如还有问题,则遇到BUG

Bug 9238835 :SELECT UTL_INADDR.GET_HOST_ADDRESS (…) FROM DUAL CAUSES ERRORS IN ALERT LOG

Bug 16369529 : SCN_TO_TIMESTAMP RAISES ORA-8181 ON STANDBY DATABASE

发表回复

您的电子邮箱地址不会被公开。 必填项已用 * 标注