Oracle字符集查看及修改

一、Oracle服务器端字符集的查询:

 

select * from V$NLS_PARAMETERS where parameter = 'NLS_CHARACTERSET';

 

二、Oracle服务器端字符集的设置:

 

    用户sys 以sysdba的身份登录oracle

 

su - oracle
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; 
SHUTDOWN IMMEDIATE; 
STARTUP ;