oracle数据库修改字符集

linux服务器上以dba身份进入(如果登录失败,查看SID是否设置):
sqlplus / 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 utf8;
shutdown immediate;
startup;


查看数据库字符集,看是否已经修改过来:
select userenv('language') from dual;

ps:执行以上遇到的问题处理

问题一:SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/product/10g/dbs/initorc1.ora'

解决:cp $ORACLE_BASE/admin/$ORACLE_SID/pfile/init.ora.10102009132131    /oracle/product/12c/dbs/initorc1.ora    注initora文件可能名字不一样

问题二:linux服务器上启动oracle报错:ORA-27125:unable to create shared memory segment

解决:查询oracle用户id,命令:id oracle,在该文件添加uid,echo 1001 > /proc/sys/vm/hugetlb_shm_group,或者在/etc/sysctl.conf文件中添加:vm.hugetlb_shm_group = 1001

 

 

 

 

原文地址:https://www.cnblogs.com/ZhaoHS/p/12552605.html