sqlplus /nolog
conn /as sysdba
shutdown immediate;
startup mount;
alter system enable restricted session;
alter system set JOB_QUEUE_PROCESSES=0;
alter system set AQ_TM_PROCESSES=0;
alter database open;
alter database character set INTERNAL_USE ZHS16GBK;
startup;
select userenv('language') from dual;
1)进入HKEY_LOCAL_MACHINE --> SOFTWARE --> Wow6432Node --> Oracle --> KEY_OraDb11g_home1 -->
NLS_LANG
,更改值为:如果要设置为中英文语言,即设置为:
AMERICAN_AMERICA.ZHS16GBK
,也可以设置成中文字符集:
SIMPLIFIED CHINESE_CHINA.ZHS16GBK