Shutting Down and Starting Up 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 the illustration hp-shutdown-r2.gif
   
   

   The Startup/Shutdown Credentials page appears.

   
   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. Accept the Connect As default of SYSDBA.

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 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.