Oracle® Database Express Edition 2 Day DBA 10g Release 2 (10.2) Part Number B25107-01 |
|
|
View PDF |
This section describes how to start up and shut down Oracle Database Express Edition. It contains the following topics:
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:
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.
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.
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.
See "Setting Environment Variables on the Linux Platform" for details.
At the operating system prompt, enter the following command to start SQL Command Line and connect to the database:
SQLPLUS / AS SYSDBA
The slash (/) indicates that the database should authenticate you with operating system authentication.
At the SQL Command Line prompt, enter the following command:
STARTUP
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.)
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.
(Optional) Enter the following SQL query to verify that the database started up properly:
select count(*) from hr.employees;
The query results should look similar to the following:
COUNT(*) ---------- 107
Enter the following command to exit SQL Command Line:
EXIT
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:
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.
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.
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.
See "Setting Environment Variables on the Linux Platform" for details.
At the operating system prompt, enter the following command to start SQL Command Line and connect to the database:
SQLPLUS / AS SYSDBA
The slash (/) indicates that the database should authenticate you with operating system authentication.
At the SQL Command Line prompt, enter the following command:
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:
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:
STARTUP SHUTDOWN IMMEDIATE
See Oracle Database Administrator's Guide for information on the SHUTDOWN
ABORT
command.
Enter the following command to exit SQL Command Line:
EXIT