오라클 CHARACTERSET 변경

오라클을 기본으로 깔았더니 한글이 깨졌다. 
그래서 구글링 해서 적용한 과정을 정리했다.
 

[oracle@www ~]$ sqlplus sys/비밀번호 as sysdba

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

SQL> alter system enable restricted session;

System altered.

SQL> alter system set JOB_QUEUE_PROCESSES=0;

System altered.

SQL> alter system set AQ_TM_PROCESSES=0;

System altered.

SQL> alter database open;

Database altered.

SQL> alter database character set internal_use KO16KSC5601;

Database altered.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup