[DB 구현] 16. Parameter 관리 및 DB 시작 / 종료 - Database 시작

lsnrctl start

sqlplus /nolog

conn sys/oracle as sysdba

startup

1

startup

cs

shut abort

startup nomount

select status
from v$instance;

alter database mount;

1 2

select status from v$instance;

cs

alter database open;

1 2

select status from v$instance;

cs

shut abort

conn sys/oracle as sysdba

1

shut abort

cs

1

startup

cs

shut immediate

startup

show user

다른 터미널 창 켜기

sqlplus /nolog

conn hr/hr

1

show user

cs

p. 85 실습하기