solaris8、oracle8.1.7
环境:
ORACLE_SID=ora8i
ORACLE_BASE=$HOME
ORACLE_HOME=$ORACLE_BASE/products/8.1.7
NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
LD_LIBRARY_PATH=/usr/lib:/usr/dt/lib:/usr/openwin/lib:$ORACLE_HOME/lib
PATH=$PATH:/usr/dt/bin:/usr/openwin/bin:$ORACLE_HOME/bin
export ORACLE_BASE ORACLE_HOME ORACLE_SID NLS_LANG LD_LIBRARY_PATH PATH
v$nls_parameters的内容:
'PARAMETER','VALUE'
'NLS_LANGUAGE','SIMPLIFIED CHINESE'
'NLS_TERRITORY','CHINA'
'NLS_CURRENCY','RMB'
'NLS_ISO_CURRENCY','CHINA'
'NLS_NUMERIC_CHARACTERS','.,'
'NLS_CALENDAR','GREGORIAN'
'NLS_DATE_FORMAT','DD-MON-RR'
'NLS_DATE_LANGUAGE','SIMPLIFIED CHINESE'
'NLS_CHARACTERSET','US7ASCII'
'NLS_SORT','BINARY'
'NLS_TIME_FORMAT','HH.MI.SSXFF AM'
'NLS_TIMESTAMP_FORMAT','DD-MON-RR HH.MI.SSXFF AM'
'NLS_TIME_TZ_FORMAT','HH.MI.SSXFF AM TZH:TZM'
'NLS_TIMESTAMP_TZ_FORMAT','DD-MON-RR HH.MI.SSXFF AM TZH:TZM'
'NLS_DUAL_CURRENCY','RMB'
'NLS_NCHAR_CHARACTERSET','US7ASCII'
'NLS_COMP','BINARY'
字符集是US7ASCII,怎样设置为ZHS16GBK(是否这样写)呢?
请大家帮帮忙吧,多谢了
---------------------------------------------------------------
c:>svrmgrl
在svrmgrl中执行:
shutdown
startup mount
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
update props$ set value$='ZHS16GB' WHERE NAME='NLS_CHARACTERSET';
update props$ set value$='ZHS16GB' WHERE NAME='NLS_NCHAR_CHARACTERSET';
先申明此法很危险,
如果改错了值可能会导致数据库无法打开。
×××××××××××××
修改字符集的步骤:
c:>svrmgrl
在svrmgrl中执行:
connect internal/oracle[@dbname];
shutdown immediate;
startup restrict;
ALTER DATABAE [dbname] CHARACTER SET [SIMPLIFIED CHINESE_CHINA.]ZHS16GBK ;
ALTER DATABAE [dbname] NATIONAL CHARACTER SET [SIMPLIFIED CHINESE_CHINA.]ZHS16GBK ;
alter database [dbname] open;
--shutdown immediate;
--startup;