Exforsys.com
 
Home Tutorials Oracle 10g
 

Oracle Database Shutdown using SQL Plus and Enterprise Manager

 

Oracle Database Shutdown using SQL Plus and Enterprise Manager

Page 1 of 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 ://


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



Next Page: Oracle Database Shutdown using SQL Plus and Enterprise Manager - Page 2


Read Next: Oracle 10g Tutorials: Overview of Schemas and Common Schema Objects



 

 

Comments


sam said:

  How to create an operating system user for windows XP pack 2 to use it as the host credentials in enterprise manager.
April 19, 2009, 12:17 am

Post Your Comment:

Members Please Login
Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe    

Sponsored Links

 

Subscribe via RSS


Get Daily Updates via Subscribe to Exforsys Free Training via email


Get Latest Free Training Updates delivered directly to your Inbox...

Enter your email address:


 

Subscribe to Exforsys Free Training via RSS
 

 
Partners -  Privacy and Legal Policy -  Site News -  Contact   Sitemap  

Copyright © 2000 - 2010 exforsys.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape