Exforsys.com
 
Home Tutorials Oracle 10g
 

Oracle Database Startup using SQL Plus and Enterprise Manager

 

Oracle Database Startup using SQL Plus and Enterprise Manager - Page 2

Page 2 of 2



You can click on Show Sql button to actually see the sql executed by EM in order to startup the database.



Figure 20. EM Startup Database SQL window


If you click on advance options button in figure, you will see the screen below.



Figure 21. EM Startup Database Advance Options window


Startup mode

Start the instance - This does not allow access to the database and usually would be done only for database creation or the re-creation of control files.

Mount the database - This state allows for certain DBA activities, but does not allow general access to the database.

Open the database - This can be done in unrestricted mode, allowing access to all users, or in restricted mode, allowing access for database administrators only.


Initialization Parameter – You can either accept the default values or provide the parameter file.


You can start the database either in restrict access mode or in normal mode. Also you can use the force database startup if there is any problem in shutting down the database.


Figure 22. EM Startup Database Progress window


Once the database is started, you will see the screen below.




Figure 23. EM Database Started window


That completed the Database Startup, in the next tutorial we will learn how to stop the Database.


 














First Page: Oracle Database Startup using SQL Plus and Enterprise Manager


Read Next: Oracle Database Shutdown using SQL Plus and Enterprise Manager



 

 

Comments


shagor said:

  still i can`t open the database.every thing is ok
except it shows the startup page (the first one) instead of the last one you maintion (the login page) plz help as soon as possible.
January 22, 2007, 12:10 am

sammason said:

  in the "Look in" field ,i can not find the local workstation/server among the list. solution?

Is it possible to create a user that is part of the sysdba group and give it the "Logon as Batch Job" privilege and solve the problem of the host credentials
April 20, 2009, 2: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 - 2009 exforsys.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape