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 Data base 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:

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.

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 Databas e 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:

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.

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

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

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

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

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

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

(Optional) Enter the following SQL query to verify that the database started up properly:

The query results should look similar to the following:

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

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:

Shut ting 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:

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.

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 .

Shutti ng 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:

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.

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

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

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

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

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

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

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:

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:

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

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

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 SQL Command Line (SQL*Plus). Each of these methods is described in the following sections:

Starting Up the Data base 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 SQL Command Line. See «Starting Up the Database Using SQL Command Line» for instructions.

To start up the database using the desktop:

Do one of the following:

On Windows: Log in to the Oracle Database XE host computer 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 a user who is a member of the dba user group. This is typically the user oracle . See «Operating System Authentication» for more information.

Do one of the following:

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

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

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

Starting Up the Databas e Using SQL Command Line

When you start up the database with SQL Command Line, you must run 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 SQL Command Line:

Do one of the following:

On Windows: Log in to the Oracle Database XE host computer as a user who is a member of the ORA_DBA user group. This is typically the user that installed Oracle Database XE.

On Linux: Log in to the Oracle Database XE host computer as a user who is a member of the dba user group. This is typically the oracle user.

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

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

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

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

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

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

(Optional) Enter the following SQL query to verify that the database started up properly:

The query results should look similar to the following:

Enter the following command to exit SQL Command Line:

Shutting Down the Database

Oracle Database Express Edition (Oracle Database XE) shuts down automatically when you shut down the computer that hosts it.

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 SQL Command Line (SQL*Plus). Each of these methods is described in the following sections:

Shut ting 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 SQL Command Line.

To shut down the database using the desktop:

Do one of the following:

On Windows: Log in to the Oracle Database XE host computer 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 a user who is a member of the dba user group. This is typically the user oracle . See «Operating System Authentication» for more information.

Do one of the following:

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

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

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

Shutti ng Down the Database Using SQL Command Line

When you shut down the database with SQL Command Line, you must run 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 SQL Command Line:

Do one of the following:

On Windows: Log in to the Oracle Database XE host computer as a user who is a member of the ORA_DBA user group. This is typically the user that installed Oracle Database XE.

On Linux: Log in to the Oracle Database XE host computer as a user who is a member of the dba user group. This is typically the oracle user.

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

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

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

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

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

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

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:

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:

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

Enter the following command to exit SQL Command Line: