sql>conn / as sysdba
sql>shutdown immediate
database closed.
database dismounted.
oracle instance shut down.
sql>startup mount
oracle instance started.
total system global area 135337420 bytes
fixed size 452044 bytes
variable size 109051904 bytes
database buffers 25165824 bytes
redo buffers 667648 bytes
database mounted.
sql>alter system enable restricted session
system altered.
sql>alter system set job_queue_processes=0
system altered.
sql>alter system set aq_tm_processes=0
system altered.
sql>alter database open
database altered.
sql>alter database character set internal_use CHINESE_CHINA.AL32UTF8
sql>shutdown immediate
sql>startup
备注:具体的编码格式根据实际需要修改即可,推荐UTF-8(默认是GBK)。
-----Window下下查看及更改oracle字符集编码打开注册表--HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMExx\NLS_LANG修改NLS_LANG的键值# 常用中文字符集1)、用SYSTEM登录数据库。2)、执行 UPDATE SYS.PROPS$ SET VALUE$='WE8ISO8859P1' WHERE NAME LIKE 'NLS_CHAR%'语句。
3)、修改注册表,HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0 ,NLS_LANG的值改为AMERICAN_AMERICA.WE8ISO8859P1
4)、重新启动数据库。
如果第2步SYSTEM没有权限执行,可以在sql*plus登录数据库管理员帐号,然后再输入语句“conn /as sysdba”也可。登录完成后再执行UPDATE SYS.PROPS$ SET VALUE$='WE8ISO8859P1' WHERE NAME LIKE 'NLS_CHAR%'
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)