Starting and Stopping Databases
On occasion, DBAs may need to either start up or shut down their databases. Sometimes it’s to forcibly clean up hung or locked server processes. Other times it’s to simply effect INIT.ORA parameter file modifications. And some DBAs just like to cycle their databases every now and then because they believe it’s good preventive medicine. Whatever the reasons, TOAD can do both database startups and shutdowns via the Instance Manager screen accessible from the main menu at DBA|Instance Manager (this screen was also covered in the preceding chapter for the monitoring of your databases).
Figure 6.8 shows TOAD being utilized to shut down a database. One thing happening behind the scenes that later seems to cause some ...
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.
