now email has become an important mail service. every body need it. from general employee until level managerial. using email, all kind of file (image, document, plain text, html, movie, etc ) can be send into one or more account. email not only used for those thing if we can see the other function from that basic. we can expand its function with another system, so it will be alternative way of data transport and system communication. in the dba's world, communication is the important thing, very important, when dba is not in server place, automatically he/she don't know whenever the database is in corrupt or got error. mean while transaction is still running and database have to be fixed, so transaction can continue as soon as possible.
Stark is trying to combinate function of mail and the database system. java has a class that can be used for send and receive an email, it is in javax.mail class. using that tools we are trying to develop a grid control, the first, with a concept that dba can login into several database in single apps and can be notified to dba anytime (in PROGRESS).
we called this project DBAS (Database Alert System). the features are:
-scheduled command
-connect into oracle(10g,9i), mysql(5.0 and lattes), SQL Server(2000, 2005, 2008)
-store PL/SQL(oracle version),T-SQL(SQL Server version)
-store only 1 account as standby and 1 as primary mail in each database.
-store 2 account in each database email direction.
-monitor error (main).
next features:
-monitor performance
-monitor workload
-monitor instance.
-monitor cluster.
-monitor data guard (Oracle and SQL Server).
-monitor replication.