월요일, 3월 17

oracle server start/shutdown

Oracle server start/shutdown
1. listener stop
$lsnrctl stop

2. 'sysdba' connect
$sqlplus "/as sysdba"

3. Oracle terminate
SQL>shutdown
SQL>shutdown abort
SQL>shutdown immediate
※Another method : first 'shutdown immediate' and create new window run 'shutdown abort'

4. Restart
SQL>startup

5. Listener Restart
$lsnrctl start

* Case by 8i
$sqlplus /nolog
SQL>connect / as sysdba
SQL>shutdown immediate;
SQL>startup