1 进入安装oralce的用户
2 登入数据库
sqlplus 用户名/密码 as sysdba
3 如果登录不了,可以执行以下命令刷新环境变量
cd ~
source ~/.bash_profile
4 查看oracle数据库的编码
select * from nls_database_parameters where parameter ='NLS_CHARACTERSET';
5 执行以下命令修改oracle编码为ZHS16GBK
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
6执行以下命令查看是否生效
select name,value$ from props$ where name like '%CHARACTER%';