oracle管理员账号被锁定Oracle更改字符集

1. 查看字符集

select userenv(‘language’) from dual;

2. 修改字符集(逐条执行即可)

sqlplus "/as sysdba";

shutdown immediate;oracle账号

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 AL32UTF8;

shutdown immediate;

startup;

至此修改成功。