On this release I’ve done just some minor changes in particular I’ve added a better exception management, and now Orabbix’s log is even more detailed.
- MaxWait
- MaxIdle
- MaxActive
- OrabbixDaemon.Sleep
- OrabbixDaemon.MaxThreadNumber (this one is calculated and based from number of monitored databases)
- you can specify for each database different values of:
- MaxWait
- MaxIdle
- MaxActive
- Added more information on error that should be really appreciate in case of problem with configuration files,logfiles are more verbose, or better should be easily understandable.
- Added a features that send “0” (zero) or the values NoDataFound when a database is not available so you will see HIT/Ratio and other graps that fall down to zero and don’t continue to show a value that is not real.
Tags: linkedin, monitoring, orabbix, oracle
the patch is a modify on line 747 of “include/blocks.inc.php”
| $menus.= “[‘”.S_LATEST_DATA.”‘,\”javascript : redirect(‘latest.php?groupid=0&hostid=”.$trigger[‘hostid’].”‘)\”, null,{‘outer’ : [‘pum_o_item’],’inner’ : [‘pum_i_item’]}],”; $menus = rtrim($menus,’,’); |
and just add this line:
$menus.= “[‘”.S_INVENTORY.”‘,\”javascript : redirect(‘hostprofiles.php?hostid=”.$trigger[‘hostid’].”‘)\”, null,{‘outer’ : [‘pum_o_item’],’inner’ : [‘pum_i_item’]}],”;
so your file will be so:
| $menus.= “[“.zbx_jsvalue(S_LINKS).”,null,null,{‘outer’ : [‘pum_oheader’],’inner’ : [‘pum_iheader’]}],”; $menus.= “[‘”.S_LATEST_DATA.”‘,\”javascr ipt : redirect(‘latest.php?groupid=0&hostid=”.$trigger[‘hostid’].”‘)\”, null,{‘outer’ : [‘pum_o_item’],’inner’ : [‘pum_i_item’]}],”; |
the result is
like in picture:
on a .bat program
set ORACLE_SID=
set NLS_DATE_FORMAT=YYYY/MM/DD HH24:MI:SS
rman target / nocatalog @rman_check_logical_database.rms msglog rman_check_logical_database.log
and the rman script is:
run {
# Andrea Dalle Vacche
# BACKUP VALIDATE ver. 1.0 19/07/2010
#
backup validate check logical database;
}
exit;
I’ve put this “.bat” on a scheduled task that run every day and after i execute this query on standby:
select * FROM v$database_block_corruption;
So if the query don’t return rows is everything right, otherwise you’ll get the block/blocks that is/are corrupted.
