collectd 4.6.2<br>Oracle 10g<br>Linux centos 5.3<br><br>Trying out the oracle plugin. When the database is down it causes collectd to exit or crash (i'm guessing exit).<br><br>Last syslogs:<br><br>Apr 20 00:06:29 crushdb collectd[6553]: oracle plugin: o_read_database_query: OCIStmtExecute failed: ORA-03113: end-of-file on communication channel<br>
Apr 20 00:06:29 crushdb collectd[6553]: oracle plugin: o_read_database_query: Failing statement was: select sum(vf.PHYBLKRD)*8192 as PHY_BLK_R, sum(vf.PHYBLKWRT)*8192 as PHY_BLK_W, 'tablespace' AS i_prefix, dt.tablespace_name from ((dba_data_files dd join v$filestat vf on dd.file_id = vf.file# ) join dba_tablespaces dt on dd.tablespace_name = dt.tablespace_name) group by dt.tablespace_name <br>
Apr 20 00:06:29 crushdb collectd[6553]: oracle plugin: o_read_database_query: OCIStmtExecute failed: ORA-03114: not connected to ORACLE<br>Apr 20 00:06:29 crushdb collectd[6553]: oracle plugin: o_read_database_query: Failing statement was: select round(sum(decode(METRIC_NAME, 'Database Wait Time Ratio', value)),2) as DATABASE_WAIT_TIME_RATIO, round(sum(decode(METRIC_NAME, 'Database CPU Time Ratio', value)),2) as DATABASE_CPU_TIME_RATIO, 'DB_EFFICIENCY' AS DB_EFFICIENCY from SYS.V_$SYSMETRIC where METRIC_NAME IN ('Database CPU Time Ratio', 'Database Wait Time Ratio') AND INTSIZE_CSEC = (select max(INTSIZE_CSEC) from SYS.V_$SYSMETRIC) <br>
<br>Where else should I look?<br><br>Bob<br>