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.

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 .

Oracle recommends that you configure the system to automatically start Oracle Database when the system starts, and to automatically shut it down when the system shuts down. Automating database shutdown guards against incorrect database shutdown.

To start a database using a file named init2.ora located in C:\app\username\product\11.2.0\admin\orcl\pfile, enter: SQL> STARTUP PFILE=C:\app\username\product\11.2.0\admin\orcl\pfile\init2.ora If no PFILE is specified, then the command looks for an SPFILE in ORACLE_HOME \database .

This chapter describes how to identify Oracle Database processes, and provides basic information about how to stop and restart them. It also describes how to set up automatic startup and shutdown of the Oracle Database. It contains the following sections: Stopping and Starting Oracle Processes. Automating Shutdown and Startup

When Oracle Restart is not in use, you use the SQL*Plus STARTUP command to start up an Oracle Database instance. If your database is being managed by Oracle Restart, Oracle recommends that you use the srvctl start database command.

To start up a database or an instance from the command line, use SQL*Plus to connect to Oracle with administrator privileges and then issue the STARTUP command. You can also use Recovery Manager to execute STARTUP and SHUTDOWN commands.

You can start and stop the database manually or set it to automatically start when the system shuts down or starts.

You can start and stop the database manually, set it to automatically after the system shuts down and starts, or using Enterprise Manager.

Describes about starting and stopping an Oracle database by using any of the following methods: Starting and Stopping the Database with Oracle Administration Assistant for Windows Use this procedure to start or stop the database: