alt
Advertisement
Sponsored links
Online Training
Career Series
Exforsys
Exforsys arrow Tutorials arrow Oracle 10g arrow Oracle Database Shutdown using SQL Plus and Enterprise Manager
Site Search


Oracle Database Shutdown using SQL Plus and Enterprise Manager
Article Index
Oracle Database Shutdown using SQL Plus and Enterprise Manager
Page 2
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 ://:5500/em

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



 
< Prev   Next >
Exforsys Offers
© 2008 Exforsys.com
Joomla! is Free Software released under the GNU/GPL License.
Page copy protected against web site content infringement by Copyscape