Oracle Database shutdown and start up Commands

Sometimes, Programmers may have to go through some Database Administrative Tasks on Oracle Development Database. Here, I tried to put together Some Linux/Oracle Commands useful to shutdown and start up Oracle Database.

First of all, Log on to System(Linux) as “oracle” user or su to “oracle” using the following command.

$ su - oracle

Connect to sqlplus as sysdba.

$ sqlplus /nolog

SQL> conn / as sysdba

Execute the following SQL Command to check out status of Database.

SQL> select * from V$INSTANCE

Execute startup Command to start the Database.

SQL> startup
ORACLE instance started.

Total System Global Area  812529152 bytes
Fixed Size                  2264280 bytes
Variable Size             960781800 bytes
Database Buffers           54654432 bytes
Redo Buffers                3498640 bytes
Database mounted.
Database opened.

This is Normal Shutdown, Database will not shutdown until all active users disconnect their sessions.

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

If "shutdown immediate" command is used, Database will forcefully disconnect all active users and Rollback all active Uncommitted Transactions.

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

"shutdown abort" is the last treatment. If this is used, Database will terminate all user session immediately and Uncommitted Transactions will not be rolled-back.

SQL> shutdown abort
ORACLE instance shut down.

A Rahim khan

  1. Heya! I just wanted to ask if you ever have any issues with hackers?
    My last blog (wordpress) was hacked and I ended up losing many months of hard work due to
    no back up. Do you have any solutions to prevent hackers?

    • I have never consider this factor. There must be some way to take backup, I got to look into this.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: