Re: database monitoring tools - what is your short list of requirements?
From: John Kanagaraj <john.kanagaraj_at_gmail.com>
Date: Mon, 6 Apr 2009 20:59:23 -0700
Message-ID: <2ead3a60904062059ta2acd9ale54f5612f52f0d5_at_mail.gmail.com>
> OID and Oracle Names would be good to monitor.
> Any specific suggestions as to what to monitor?
Date: Mon, 6 Apr 2009 20:59:23 -0700
Message-ID: <2ead3a60904062059ta2acd9ale54f5612f52f0d5_at_mail.gmail.com>
> OID and Oracle Names would be good to monitor.
> Any specific suggestions as to what to monitor?
I would monitor name resolution (via ONAMES or OiD) a list of important TNS entries. I did have a script to do this but that was at my last job. I set TNS_ADMIN to a directory that had a SQLNET.ORA that pointed to one name res source only, one at a time, and just TNSPING'ed a set of known TNS entries and parsed the result for errors. This has caught a ONAMES failure that was the result of a malformed TNS request from a specific MS client.
-- John Kanagaraj <>< http://www.linkedin.com/in/johnkanagaraj http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!) ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 06 2009 - 22:59:23 CDT