Skip Headers
Oracle® Database 2 Day DBA
11g Release 1 (11.1)

Part Number B28301-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

Shutting Down and Starting Up the Oracle Instance

This section provides instructions about two methods you can use to start up or shut down the Oracle instance:

Shutting Down and Starting Up Using Oracle Enterprise Manager Database Control

You can shut down and start up the Oracle instance from the Database Home page of Oracle Enterprise Manager Database Control (Database Control).

To shut down and start up the Oracle instance using Database Control:

  1. Go to the Database Home page.

    See "Accessing the Database Home Page".

  2. In the General section of the Database Home page, click Shutdown.

    Description of hp-shutdown-r2.gif follows
    Description of the illustration hp-shutdown-r2.gif

    The Startup/Shutdown Credentials page appears.

    Description of shutdown_credentials.gif follows
    Description of the illustration shutdown_credentials.gif

  3. Enter credentials as follows:

    1. Enter the host computer credentials of the user who installed Oracle Database, or of any user who is authorized to use SQL*Plus.

    2. Enter the database credentials consisting of the user name SYS and the password that you assigned to SYS during the installation.

    3. In the Connect As list, choose the value SYSOPER.

  4. (Optional) Select the Save as Preferred Credential option if you want these credentials to be automatically filled in for you the next time that this page appears.

  5. Click OK.

    A confirmation page appears.

  6. Click Yes.

    The Startup/Shutdown: Activity Information page appears, informing you that the database is being shut down.

  7. After a short period of time, click Refresh to be returned to the Database Home page.

    The Database Home page indicates that the database instance status is Down.

    Description of database_down.gif follows
    Description of the illustration database_down.gif

  8. Click Startup to start up the database.

    The Startup/Shutdown Credential page appears again.

  9. Enter the credentials, and then click OK.

    A confirmation page appears.

  10. Click Yes.

    The Startup/Shutdown: Activity Information page appears, indicating that the database is being started up. When startup is complete, the Login page appears.

  11. Log in to the database (and to Database Control).

    The Database Home page appears indicating that the database instance status is Up.

Shutting Down and Starting Up Using the Windows Services Program

On Microsoft Windows, you can also start up and shut down your Oracle database using the Services program in Control Panel. You must start or stop the following services:

  • OracleServiceSID, which is your Oracle instance.

  • OracleOracle_homeTNSListener, which is your listener. The listener is required for clients to connect to your database.

  • OracleDBConsoleSID, which enables clients to connect to Oracle Enterprise Manager Database Control.

In the preceding service names, SID refers to the system identifier for the instance and Oracle_home refers to the Oracle home name.

To start or stop Oracle Database services:

  1. Do one of the following:

    • On Windows XP and Windows Server 2003, click Start, and then select Control Panel.

    • On Windows 2000 Server, click Start, select Settings, and then select Control Panel.

    The Control Panel window opens.

  2. Double-click the Administrative Tools icon, and then double-click the Services icon.

    The Services window opens, displaying all Windows services that are available on your system.

  3. Locate the Oracle Database services listed at the beginning of this section. For example, if your SID is orcl, then locate the following services:

    • OracleServiceORCL

    • OracleOraDb11g_home1TNSListener

    • OracleDBConsoleorcl

  4. Start or stop all three services, using the following steps for each service:

    1. Select the service name.

    2. In the Action menu, click Start or Stop.