Issue/Symptom/Question

How to Stop and Start a Database

Applies To

Oracle Databases

DBA privileges

Resolution/Fix/Answer

Stopping a Database

Log in to the Linux server as the 'oracle' user.
- You will be prompted for the ORACLE_SID as you see below. You can either accept the default, which in this case is PROD, or type in the database you wish to stop.
- Be sure you use uppercase letters. As you can see, I typed in TEST.

SIDs on this machine are X11230 TRAIN TRAIN_H TEST TEST_H PROD PROD_H
ORACLE_SID = [PROD] ? TEST
The Oracle base remains unchanged with value /u01/app/oracle
oracle@penta-db ~$ sqlplus

SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 10 10:40:13 2015

Enter user-name: / as sysdba

Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

SQL> select name from v$database; (to verify you are connected to the correct database)

NAME
---------
TEST

SQL> shutdown immediate

Starting a Database

Log in to the Linux server as the 'oracle' user.
- You will be prompted for the ORACLE_SID as you see below. You can either accept the default, which in this case is PROD, or type in the database you wish to start.
- Be sure you use uppercase letters. As you can see, I typed in TEST.

SIDs on this machine are X11230 TRAIN TRAIN_H TEST TEST_H PROD PROD_H
ORACLE_SID = [PROD] ? TEST
The Oracle base remains unchanged with value /u01/app/oracle
oracle@penta-db ~$ sqlplus

SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 10 10:40:13 2015

Enter user-name: / as sysdba

Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

SQL> startup

Starting or Stopping all Databases on the server

Log in to the Linux server as the 'oracle' user
At the command prompt type:
- dbstart to start all databases
- dbshut to stop all databases