Startup and Shutdown Instance Oracle

10 Nov 2013 Tinggalkan komentar

by bahrie in Database 

$ set ORACLE_SID=EXAMPLEORACLE
$ sqlplus /nolog
SQL> conn / as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1610612736 bytes
Fixed Size                  2040952 bytes
Variable Size            1040194440 bytes
Database Buffers          553648128 bytes
Redo Buffers               14729216 bytes
Database mounted.
Database opened.
SQL> exit