Checking an Instance’s Alert Log File
Just because the DBA’s database servers, listeners, and instances are up does not mean that all is perfectly well. Problems might very well exist that should be addressed. For example, one of the Oracle background processes may have improperly terminated, yet people can still successfully connect to the database. Thus the Instance Manager screen gives the Oracle DBA a fifty-thousand-foot view, for it merely performs simple tests such as ping and tnsping and connects to the database. So the DBA should dig a bit deeper to be sure that all is really well.
Unfortunately, there is no quick and easy screen within TOAD to perform such detailed checks. Nonetheless, you still can utilize TOAD to find out where that ...
Get TOAD® Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
