su - oracle 转换用户
sqlplus /nolog 不连接任何数据库
conn 用户名/密码 as sysdba 用sysdba 登陆
shutdown immediate 关闭(shutdown Abort强行关闭)
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;
ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE AL16UTF16;
shutdown immediate
startup
之后会发现已经生效:
SQL> select name,value$ from props$ where name like '%CHARACTER%';
NAME
------------------------------
VALUE$
------------------------------------------------------------------------------
NLS_NUMERIC_CHARACTERS
.,
NLS_CHARACTERSET
ZHS16GBK
NLS_NCHAR_CHARACTERSET
AL16UTF16
)
sqlplus /nolog 不连接任何数据库
conn 用户名/密码 as sysdba 用sysdba 登陆
shutdown immediate 关闭(shutdown Abort强行关闭)
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;
ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE AL16UTF16;
shutdown immediate
startup
之后会发现已经生效:
SQL> select name,value$ from props$ where name like '%CHARACTER%';
NAME
------------------------------
VALUE$
------------------------------------------------------------------------------
NLS_NUMERIC_CHARACTERS
.,
NLS_CHARACTERSET
ZHS16GBK
NLS_NCHAR_CHARACTERSET
AL16UTF16
)