취미로하는개발

netsh interface portproxy add v4tov4 listenaddress=10.40.28.36 listenport= 8629 connectaddress=10.182.55.76 connectport=8629

C:\>sqlplus /nolog

SQL>conn /as sysdba;

--KO16MSWIN949
SQL>update sys.props$ set value$='KO16MSWIN949' where name='NLS_CHARACTERSET';
SQL>update sys.props$ set value$='KO16MSWIN949' where name='NLS_NCHAR_CHARACTERSET';
SQL>update sys.props$ set value$='AMERICAN_AMERICA.KO16MSWIN949' where name='NLS_LANGUAGE';

SQL>commit;

SQL>SHUTDOWN IMMEDIATE;

-- DATA Base CharSet 변경
SQL>STARTUP MOUNT;
SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL>ALTER DATABASE OPEN;
SQL>ALTER DATABASE CHARACTER SET KO16MSWIN949;
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP;