Oracle 10g Free Training : Oracle Database Shutdown using SQL Plus and Enterprise Manager. This tutorial explains how you can shutdown the Database using SQL Plus and Enterprise Manager along with step by step screen shots. At the end of this tutorial you will find the FAQ's on Controlling the Database.
Shutdown database through SQL Plus
Please connect to sqlplus as sysdba or sysoper as shown in the window below.
Figure 24. SQLPLUS login SysDBA window
Execute SHUTDOWN immediate command on sqlplus
Figure 25. SQLPLUS Shutdown window
Shutdown database through EM
Open EM using following URL
http ://
Figure 26. EM Home window
Click on the Shutdown button in the above window to shutdown the database.
Following window will appear in front of you. You will be required to give the host username and password and also the database credentials.
You might receive following error after clicking OK Button.
Figure 27. EM Database Shutdown login window
Once you click OK following window will appear.
Figure 28. EM Database Shutdown confirmation window
You can click on Show SQL button to see the command executed by the EM to shutdown the database.
Figure 29. EM Database Shutdown Sql window
Once you click Advance options button in figure . Following window will appear, you can choose the appropriate mode for shutting down the database
Figure 30. EM Database Shutdown Advance Options window
Figure 31. EM Database Shutdown Activity window
Once you click on refresh button following window will appear.
Figure 32. EM Database Shutdown window
Frequently Asked Questions
- Can I start and stop the TNS listener through SQLPLUS?
- How do I stop the agent through Command Prompt?
- When I should use the immediate mode while shutting down the database?
- How do I solve ‘RemoteOperationException ERROR: Wrong password for user ‘ error while trying to shutdown the database through EM?
- What mode is most frequently used while starting the database?
- How do you connect to database without connecting to a particular instance?
