> 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 ** -- //www.freelists.org/webpage/oracle-l