Skip to main content

How to start or stop database using SQLPLUS


Login to sqlplus session either on your command prompt or on sql*plus window using user "/as sysdba" or user SYSTEM.

If you are using user "/as sysdba" then it does not require any password. Check the screenshot below, just enter "/as sysdba" and click ok you will be allowed to login or user SYSTEM user and its password to login.


















Once you have logged in issue an sql*plus command SHUTDOWN.

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

This shutsdown your database.

To start the database you need to login again as
"/as sysdba" and then issue a command STARTUP.

SQL> startup
ORACLE instance started.

Total System Global Area  583008256 bytes
Fixed Size                  1250284 bytes
Variable Size             213912596 bytes
Database Buffers          364904448 bytes
Redo Buffers                2940928 bytes
Database mounted.
Database opened.
SQL>

Screenshot attached for reference.
















To know how to start/stop the database using batch files CLICK HERE

To know how to start/stop using services menu CLICK HERE


Labels:

Comments

Post a Comment

Popular posts from this blog

Basics of RDBMS

Data Small set of information becomes data, this set of information helps make decision. Data is always some useful information. Database Place where you store the data. Database represents some aspect of the real world called "miniworld". A database is designed, built and populated with data for a specific purpose. It has intended group of users and some preconceived applications in which these users are interested. In other words, a database has some source from which data is derived, some degree of interaction with events in the real world and an audience that is actively interested in the contents of the database. Database can also be defined as collection of one or more tables. Ex: Mobile, human brain etc DBMS (Database Management System ) Is a program that stores retrieves and modifies data in the database on request. Study of different techniques of design, development and maintenance of the database Types of DBMS These types are based upon their m...
101 comments
Read more

Installing Oracle 10g Database

Once you have downloaded the software from www.oracle.com/downloads , following steps can be used to install the software. 1. Unzip the dump downloaded from oracle.com 2. Once Unzipped, click on setup.exe to run Oracle Universal Installer Program. This will open a window as shown below.
60 comments
Read more