Shutting Down and Starting Up the Database
Purpose
This module describes how to startup and shutdown the database.
Topics
This module will discuss the following:
 |
||
|
||
Print this Lesson
Move your mouse over this icon to show all screenshots
then print lesson
Shutting Down and Starting Up the Database
There are two ways to shutdown and startup your database instance: using SQL*Plus or Enterprise Manager. In this lesson, you will shutdown the database using SQL*Plus and then use Enterprise Manager to startup the database that you just shutdown.
Using SQL*Plus on Windows
Perform the following steps to shutdown the database:
| 1. |
Select Start > Programs > Oracle > OraHome92 > Application Development > SQL*Plus. Enter /nolog in the User Name field and click OK.
|
| 2. |
Once logged in to SQL*Plus enter the following command: shutdown
|
You can also perform a shutdown using Enterprise Manager.
Using Enterprise Manager
Perform the following steps to startup the database:
| 1. |
Select Start > Programs > Oracle > OraHome92 > Enterprise Manager Console. Select Launch Standalone and click OK.
|
| 2. |
Expand Databases and then your database name.
|
| 3. |
Login as sys/<password> and select SYSDBA as the Connect As: Then click OK.
|
| 4. |
Expand Instance and select Configuration. Click Open and then Apply.
|
| 5. |
Click OK to accept the defaults and startup the database
|
| 6. |
Once the database has started, click Close.
|
| 7. |
You now see that the database has been started.
|
You can also perform a startup using SQL*Plus by issuing the startup command.
Move your mouse over this icon to hide all screenshots