Dirk, It would be great if i could do sql query directly from within a SA-test and evaluate the response. For example: A test with: "select status, DATABASE_STATUS, active_state from gv$instance where INSTANCE_NAME='rac-node1';" and then test for the string "active". Or select tablespace_name,used_percent from dba_tablespace_usage_metrics; and evaluate the percentage returned.
Now I'm running a script every hour but integrated in SA would be great. Nice proposition ;-) Lau -----Original Message----- From: Servers Alive Discussion List [mailto:[email protected]] On Behalf Of Dirk Bulinckx Sent: woensdag 11 december 2013 11:01 To: Servers Alive Discussion List Subject: [SA-list] Database check changes Currently in SA there are several ways to check a database * in SA via the SQL checker (using the old DMO libs) * in SA via the Oracle checker (using the Oracle Windows libs) * external COM check for SQL (2005/2008) using the current SMO libs * external COM check for ODBC * external COM mySQL We are thinking about converting this to 1 type of db check that is based on the "native" client (for Oracle - SQL - Sybase - DB2 - Interbase - SQLBase - mySQL - SQLite - Postgress or ODBC). This would require that you changing your existing db checks (the COM ones would still work, the internal not) and that instead of "just" checking if a database is online (like the current SQL and Oracle check do) we would do execute a SQL statement just as we do in the ODBC checker. The idea is to remove the current MS-SQL and Oracle check from SA and replace it by the above check, other option would be to leave the old checks in it and create a new check (internal or as COM check) I would like some reactions/feedback on this idea.... -- Dirk Bulinckx Servers Alive - http://www.woodstone.nu DNS Hosting on StellarDNS - http://www.stellardns.com To unsubscribe send a message with UNSUBSCRIBE in the subject line to [email protected] If you use auto-responders (like out-of-the-office messages), make sure that they are not sent to the list nor to individual members. Doing so will cause you to be automatically removed from the list. ************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses but we cannot accept responsibility for any loss or damage arising from the use of this email and/or attachment(s). To unsubscribe send a message with UNSUBSCRIBE in the subject line to [email protected] If you use auto-responders (like out-of-the-office messages), make sure that they are not sent to the list nor to individual members. Doing so will cause you to be automatically removed from the list.
