如题所述
æ¥çåä¿®æ¹oracleç¼ç æ ¼å¼æ¹æ³ï¼
1ãæ¥çoracleæ°æ®åºå符éï¼
select userenv('language') from dual;
æ¥è¯¢ç»æï¼
SIMPLIFIED CHINESE_CHINA.AL32UTF8
2ãä¿®æ¹oracleæ°æ®åºå符éï¼ï¼å¨SQL Plusä¸ï¼
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 UTF8
ããsql> shutdown immediate;
ããsql> startup;
1ãæ¥çoracleæ°æ®åºå符éï¼
select userenv('language') from dual;
æ¥è¯¢ç»æï¼
SIMPLIFIED CHINESE_CHINA.AL32UTF8
2ãä¿®æ¹oracleæ°æ®åºå符éï¼ï¼å¨SQL Plusä¸ï¼
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 UTF8
ããsql> shutdown immediate;
ããsql> startup;
温馨提示:答案为网友推荐,仅供参考