oracle数据库创建账号oracle编码修改

oracle编码修改

 

SQL> shutdown immediate; 

Database closed.   www.2cto.com  

Database dismounted. 

ORACLE instance shut down. 

SQL>  startup mount; 

ORACLE instance started. 

 

Total System Global Area  849530880 bytes 

Fixed Size                  1339824 bytes 

Variable Size             499125840 bytes 

Database Buffers          343932928 bytes 

Redo Buffers                5132288 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 UTF8 ; 

 

Database altered. 

 

SQL> shutdown immediate; 

Database closed. 

Database dismounted. 

ORACLE inoracle账号stance shut down. 

 

select userenv('language') from dual —查看编码 

 

oraacle clinet  编码设置 

 

打开注册表HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1 

将NLS_LANG 修改为 

select userenv('language') from dual  查询的值