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