oracle ÖÐÎÄÂÒÂë - Oracle / ·Ç¼¼ÊõÇø

ÔÚliunx redhat5.4 ÐéÄâ»úÉÏ°²×°oracle9i °²×°ºÃºó
ʹÓà sqlplus "/ as sysdba" µÇ½ʱ ºº×Ö²¿·ÖÏÔʾ³ÉÂÒÂë
Ôõô½â¾ö

---

sqlplusÇ°£¬ÏÈ£º

#export NLS_LANG=american_america.zhs16gbk

---

ÒýÓÃ

sqlplusÇ°£¬ÏÈ£º

#export NLS_LANG=american_america.zhs16gbk

ÒªÉèÖÃÓïÑÔ»·¾³

---

Èç¹ûÔÚ²éѯµÄ±íÖÐÓÐÖÐÎĵÄʱºò³öÏÖÂÒÂ룬¾ÍÊÇÄã´´½¨Êý¾Ý¿âµÄÅäÖÃÎļþÉèÖõÄÎÊÌ⣬

¿ÉÒÔÓÃÒÔÏÂÃüÁîÀ´½â¾ö£º

SQL>SHUTDOWN IMMEDIATE;

SQL>STARTUP MOUNT EXCLUSIVE;

SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;

SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;

SQL>ALTER DATABASE OPEN;

SQL>alter database national character set internal_use utf8;

SQL>alter database character set internal_use zhs16gbk;

SQL>SHUTDOWN immediate;

SQL>startup;

---

http://blog.csdn.net/java3344520/archive/2010/04/10/5469843.aspx
ÐÞ¸Ä×Ö·û¼¯,¿ÉÒԲο¼ÎÒµÄBLOG

---

ÎÒµÄÎÊÌâÒѽâ¾ö£¬Ð»Ð»´ó¼Ò 
ÔÚLinux ϵͳÏÂ
#export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
²¢½«
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
¼ÓÈëµ½ .bash_profile ÎļþÖÐ