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. SQL>
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. SQL>
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. SQL>
"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. SQL>
A Rahim khan