Emeralit Miner is a fast deployment Oracle environment monitoring utility acrossing platforms.
Document
Emeralit Miner Deployment Guide Sep-19-2020
Miner Framework Development Guide Oct-20-2020
Miner Monitoring Logic of each Component Nov-03-2020
Bug Fix
Python 3.4.4 installer got removed from msc/python folder. All current package will base on version 3.5.1.
Fixed
version 1.0.0
bin_console_scheduler.html - smtp interval default value got changed to 12 hours. 2 emails per day.
Fixed
version 1.0.0
version 1.0.0
bin_console_thresholds.html - smtp monitoring email target changed to 'proactive_smtp_support@micoresolutions.com' in html console
Fixed
version 1.0.0
mnr_components - critical should not use ENV_PROACTIVE_SMTP_EMAIL instead of ENV_CRITICAL_EMAIL
Fixed
version 1.0.0
bin_console_scheduler - mnr_rmt interval from 2 changed to 5
Fixed
version 1.0.0
Clean up the /diag folder in the package
Fixed
version 1.0.0
bin_console_scheduler - mnr_db_avl interval from 30 changed to 2.
Fixed
version 1.0.0
mnr_disk, logic correct, usage percent should be (total - free)/total, instead of free/total.
Fixed
version 1.0.0
mnr_disk, logic correct, usage percent should be (total - free)/total, instead of free/total.mnr_disk, logic correct, usage percent should be (total - free)/total, instead of free/total.mnr_disk, logic correct, usage percent should be (total - free)/total, instead of free/total.
Fixed
version 1.0.0
mnr_alt default ignore errors list.
Fixed
version 1.0.0
alert email target, multiplex.
Fixed
version 1.0.0
mnr_tbs, only email the lines beyond threshold.
Fixed
version 1.0.0
mnr_db_avl, sqlnet.ora got generated when database is not available. Oracle level setting, delete via command as work around.
Fixed
version 1.0.0
mnr_env.py should not be included enclosed within the package by default.
Fixed
version 1.0.0
mnr_lsnr.py, listener name got added enclosed lsnrctl status command, and added TNS error detected in summary checking if condition.
Fixed
version 1.0.0
version 1.0.0
Alert output column name in bold font, seperated emails, subject with instance name, column name top, set feedback off, moblie output.
Fixed
version 1.0.0
monitor component alert output catalog column name 'vertical-align: top;'.
Fixed
version 1.0.0
mnr_db_avl: column name bold font.
Fixed
version 1.0.0
mnr_db_avl: multiple database seperated emails.
Fixed
version 1.0.0
mnr_db_avl: email subject did not contain instance names.
Fixed
version 1.0.0
mnr_tbs: query contains '8 rows selected', and added 'set feedback off'.
Fixed
version 1.0.0
mnr_tbs: moblie email mess up.
Fixed
version 1.0.0
miner_home/bin: deployment webpage html name with step naming convention.
Fixed
version 1.0.0
mnr_db_avl, sqlnet.log does not exist, and can not be deleted since first time deployment.
Fixed
version 1.0.0
HTML version can not run by task scheduler.
Fixed
version 1.0.0
Each component alert output contains source script name.
Fixed
version 1.0.0
Deployment page navigation bar across platform.
Fixed
version 1.0.0
Log should be created immediately since script start running.
Fixed
version 1.0.0
Version upgrade optimized.
Fixed
version 1.0.0
File can not be download from IE. Alert will pop up for IE browser.
Fixed
version 1.0.0
mnr_tbs: check database status before and after usage query, since the query is long, and database might be shutdown in the middle.
Fixed
version 1.0.0
mnr_alt: read by last line.
Fixed
version 1.0.0
mnr_alt: deployment HTML page for mnr_alt related. ENV(Step2 - 3).
Fixed
version 1.0.0
mnr_wait: email alert cell white frame is not display since SID is NULL, case when to_char data type match.
Fixed
version 1.0.0
mnr_asm: no row selected via second query replace '>' with '>='.
Fixed
version 1.0.0
mnr_wait: mess up alert email output. Double check database status before and after query fetching blocking detail.
Fixed
version 1.0.0
mnr_wait: cmd double database status check. no blocking session alert found or database not open.
Fixed
version 1.0.0
mnr_rmt: trial revised to remain to make more sense.
Fixed
version 1.0.0
mnr_wait: second database open status check, and log output changed, only indicates no blocking session without database status.
Fixed
version 1.0.0
mnr_lsnr: email listener and detail should in bold font.
Fixed
version 1.0.0
mnr_disk: >= for proactive switch.
Fixed
version 1.0.0
mnr_tbs: round >=.
Fixed
version 1.0.0
mnr_clr: all the features within the component are developed.
Fixed
version 1.0.0