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

Starting Up the Database Using SQL Command Line

Starting Up the Databas e Using SQL Command Line