Before You Begin

This 5-minute tutorial shows you how to start and shut down the database instance. 

Select the Oracle Database release:

Background

An Oracle database system consists of an Oracle database and an Oracle instance. An Oracle instance (also known as a database instance) contains the set of Oracle Database background processes that operate on the stored data and the shared allocated memory that those processes use to do their work. In this tutorial you learn how to manage your Oracle Database instance.

What Do You Need?

•  Install Oracle Database 18c19c
•  Configure the HTTPS port for Enterprise Manager Database Express

Start up and Shut down the Oracle Database Instance

You may need to shut down the database instance to perform certain administrative tasks. To shut down and restart the database instance, perform the following steps:

1. Open a terminal window as the oracle user. Execute the oraenv command to set the environment variables.

   $  . oraenv
   ORACLE_SID = [oracle] ? orcl
   The Oracle base has been set to /scratch/u01/app/oracle

2. Log in to SQL*Plus as the SYSDBA user.

   # sqlplus / as sysdba

                     SQL*Plus: Release 18.0.0.0.0 - Production on Tue Mar 5 01:59:50 2019 Version 18.3.0.0.0
   Copyright (c) 1982, 2018, Oracle.  All rights reserved.
   Connected to:
   Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
   Version 18.3.0.0.0 SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 15 01:08:39 2019
   Version 19.3.0.0.0
   
   Copyright (c) 1982, 2019, Oracle.  All rights reserved.
   
   Connected to:
   Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
   Version 19.3.0.0.0

3. Issue the SHUTDOWN command to close the database and shut down the instance.

   SQL>  shutdown

   Database closed.
   Database dismounted.
   ORACLE instance shut down.

4. Issue the STARTUP command to start the instance and open the database.

SQL> startup

ORACLE instance started.

Total System Global Area 3355443200 bytes
Fixed Size                  8791392 bytes
Variable Size            1929382560 bytes
Database Buffers         1409286144 bytes
Redo Buffers                7983104 bytes
Database mounted.
Database opened.