Skip Headers
Oracle® Database Express Edition 2 Day DBA
11g Release 2 (11.2)

E18804-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

2 Starting Up and Shutting Down

This section describes how to start up and shut down Oracle Database Express Edition. It contains the following topics:

Starting Up the Database

Oracle Database Express Edition (Oracle Database XE) starts up automatically immediately after installation and after each system restart. Thus, there is no need to start up the database unless you previously shut it down.

You can start up the database from the desktop or with the SQL Command Line (SQL*Plus). Each of these methods is described in the following sections:

Starting Up the Database from the Desktop

This section explains how to start up the database from the desktop in Windows and in the following two Linux windowing managers: KDE and Gnome. If your Linux computer is not running a windowing manager, or is running a windowing manager other than KDE or Gnome, you must start the database with the SQL Command Line. See "Starting Up the Database Using the SQL Command Line" for instructions.

To start up the database using the desktop:

  1. Do one of the following:

    • On Windows: Log in to the Oracle Database XE host computer as the user that installed Oracle Database XE or as a Windows administrator—that is, as a user who is a member of the Administrator group.

    • On Linux: Log in to the Oracle Database XE host computer as the user that installed Oracle Database XE or as a user who is a member of the dba user group. This is typically the user oracle. See "Operating System Authentication" for more information.

  2. Do one of the following:

    • On Windows: Click Start, point to Programs (or All Programs), point to Oracle Database 11g Express Edition, and then select Start Database.

    • On Linux with Gnome: In the Applications menu, point to Oracle Database 11g Express Edition, and then select Start Database.

    • On Linux with KDE: Click the icon for the K Menu, point to Oracle Database 11g Express Edition, and then select Start Database.

Starting Up the Database Using the SQL Command Line

When you start up the database with the SQL Command Line, you must run the SQL Command Line on the same computer where you installed Oracle Database XE (the "Oracle Database XE host computer").

To start up the database using the SQL Command Line:

  1. Do one of the following:

    • On Windows: Log in to the Oracle Database XE host computer as the user that installed Oracle Database XE or as a Windows administrator—that is, as a user who is a member of the Administrator group.

    • On Linux: Log in to the Oracle Database XE host computer as the user that installed Oracle Database XE or as a user who is a member of the dba user group. This is typically the user oracle. See "Operating System Authentication" for more information.

  2. If not already opened, open a terminal session or command window.

  3. Linux platform only: Ensure that environment variables are set properly.

    See "Setting Environment Variables on the Linux Platform" for details.

  4. At the operating system prompt, enter the following command to start the SQL Command Line and connect to the database:

    sqlplus / as sysdba
    

    The slash (/) indicates that the database should authenticate you with operating system authentication.

  5. At the SQL Command Line prompt, enter the following command:

    SQL> STARTUP
    

    If the command is successful, it displays output similar to the following. (System global area sizes will vary depending on the amount of physical memory in your Oracle Database XE host computer.)

    ORACLE instance started.
     
    Total System Global Area  599785472 bytes
    Fixed Size                  1220804 bytes
    Variable Size             180358972 bytes
    Database Buffers          415236096 bytes
    Redo Buffers                2969600 bytes
    Database mounted.
    Database opened.
    
  6. (Optional) Enter the following SQL query to verify that the database started up properly:

    SQL> select count(*) from hr.employees;
    

    The query results should look similar to the following:

      COUNT(*)
    ----------
           107
    
  7. To exit the SQL Command Line. enter the following command:

    SQL> EXIT
    

Shutting Down the Database

Oracle Database Express Edition (Oracle Database XE) shuts down automatically when you shut down the computer that hosts it. However, you can also shut Oracle Database XE down manually whenever you want, such as to reduce the overall system processing overhead when you do not need to use the database.

Before shutting down Oracle Database XE, it is best to ensure that all users and applications have completed their work and logged out. See "Monitoring Sessions" for information on how to view current database sessions.

If users or applications are still logged in when you begin a shutdown operation, the shutdown proceeds under the following conditions:

  • No new connections are permitted, and no new transactions are allowed to be started.

  • Any uncommitted transactions are rolled back.

  • All users and applications are immediately disconnected.

You can shut down the database with the desktop or with the SQL Command Line (SQL*Plus). Each of these methods is described in the following sections:

Shutting Down the Database from the Desktop

This section explains how to shut down the database from the desktop in Windows and in the following two Linux windowing managers: KDE and Gnome. If your Linux computer is not running a windowing manager, or is running a windowing manager other than KDE or Gnome, you must shut down the database with the SQL Command Line.

To shut down the database using the desktop:

  1. Do one of the following:

    • On Windows: Log in to the Oracle Database XE host computer as the user that installed Oracle Database XE or as a Windows administrator—that is, as a user who is a member of the Administrator group.

    • On Linux: Log in to the Oracle Database XE host computer as the user that installed Oracle Database XE or as a user who is a member of the dba user group. This is typically the user oracle. See "Operating System Authentication" for more information.

  2. Do one of the following:

    • On Windows: Click Start, point to Programs (or All Programs), point to Oracle Database 11g Express Edition, and then select Stop Database.

    • On Linux with Gnome: In the Applications menu, point to Oracle Database 11g Express Edition, and then select Stop Database.

    • On Linux with KDE: Click the icon for the K Menu, point to Oracle Database 11g Express Edition, and then select Stop Database.

Shutting Down the Database Using the SQL Command Line

When you shut down the database with the SQL Command Line, you must run the SQL Command Line on the same computer where you installed Oracle Database XE (the "Oracle Database XE host computer").

To shut down the database using the SQL Command Line:

  1. Do one of the following:

    • On Windows: Log in to the Oracle Database XE host computer as the user that installed Oracle Database XE or as a Windows administrator—that is, as a user who is a member of the Administrator group.

    • On Linux: Log in to the Oracle Database XE host computer as the user that installed Oracle Database XE or as a user who is a member of the dba user group. This is typically the user oracle. See "Operating System Authentication" for more information.

  2. If not already opened, open a terminal session or command window.

  3. Linux platform only: Ensure that environment variables are set properly.

    See "Setting Environment Variables on the Linux Platform" for details.

  4. At the operating system prompt, enter the following command to start the SQL Command Line and connect to the database:

    sqlplus / as sysdba
    

    The slash (/) indicates that the database should authenticate you with operating system authentication.

  5. At the SQL Command Line prompt, enter the following command:

    SQL> SHUTDOWN IMMEDIATE
    

    Note that this command may take a short while to complete. If the command is successful, it displays the following output:

    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    

    If the command displays no output after a number of minutes, indicating that the shutdown operation is not proceeding, you can press CTRL-C to interrupt the command, and then enter the following command:

    SQL> SHUTDOWN ABORT
    

    The database must go through a recovery process when it starts up after a SHUTDOWN ABORT command. It is recommended that you enable the recovery process to take place immediately, after which you can shut down the database normally. To do this, enter the following commands when the SHUTDOWN ABORT completes:

    SQL> STARTUP
    SQL> SHUTDOWN IMMEDIATE
    

    See Oracle Database Administrator's Guide for information on the SHUTDOWN ABORT command.

  6. To exit the SQL Command Line. enter the following command:

    SQL> EXIT