|
Some administration tasks require shutting down and then restarting the database. These include changing the values of some initialization parameters and changing memory settings for the instance. Oracle Database XE can be shut down and restarted using the following methods: |
 |
- Shut down the database using the graphical desktop
To shut down the database using the graphical desktop, do one of the following:
Windows
- Log in to the Oracle Database XE host computer as a Windows administrator.
- Click Start, and then select Programs > Oracle Database 10g Express Edition > Stop Database.
.
Linux
- Log in to the Oracle Database XE host computer as a user who can be authenticated with operating system authentication.
- Stop the database.
- On Linux with Gnome: In the Applications menu, select Oracle Database 10g Express Edition > Stop Database.
- On Linux with KDE: Click the icon for the K Menu, and then select Oracle Database 10g Express Edition > Stop Database.
|
|
- Shut down the database using SQL*Plus
You must use a local connection to the database to shut it down with SQL*Plus.
To shut down the database using SQL*Plus:
-
Log in to the Oracle Database XE host computer as a user who is a member of an operating system administrative user group.
-
If it is 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:
- sqlplus / as sysdba
Note that you do not need to supply a database username and password because you already provided database administrator credentials to the operating system.
-
At the SQL*Plus 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.
|
|
- Start up the database using the graphical desktop
To start up the database using the graphical desktop:
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). This is normally the user oraclexe.
Click Start, and then select Programs > Oracle Database 10g Express Edition > Start Database.
Linux
Log in to the Oracle Database XE host computer as a user who can be authenticated with operating system authentication.
On Linux with Gnome: In the Applications menu, select Oracle Database 10g Express Edition, and then select Start Database.
On Linux with KDE: Click the icon for the K Menu, and then select Oracle Database 10g Express Edition > Start Database.
|
|
- Start up the database using SQL*Plus
To start up the database using SQL*Plus:
- Log in to the Oracle Database XE host computer as a user who is a member of an operating system user group. With Linux, this is normally the oraclexe user. With Windows, it is normally the user who installed Oracle Database XE.
- If it is 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: sqlplus / as sysdba
- At the SQL*Plus prompt, enter the following command:
startup
If the command is successful, it displays the following output:
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.
Note: System Global Area sizes vary depending on the amount of physical memory on your Oracle Database XE host computer. |
|
|