Oracle environment variable configuration Character set encoding configuration

environment variable configuration for character encoding:

Http://jingyan.baidu.com/article/e73e26c0c20f1a24adb6a73e.html

(1). Database server Character Set
SELECT * FROM Nls_database_parameters  

(2). Client Character Set Environment
SELECT * FROM Nls_instance_parameters

Steps:
Sql>conn/as SYSDBA

Sql>shutdown immediate;

Sql>startup Mount

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 CHARACTER SET UTF8;

ALTER DATABASE CHARACTER SET zhs16gbk ERROR at line 1:

Ora-12712:new character set must be a superset of the old character set

Sql>alter DATABASE Character set Internal_use UTF8;

Sql>select * from V$nls_parameters;

The exception that runs when the Sqlplus user logs on:

Unable to locate program input point longjmp on dynamic link library Orauts.dll

Workaround:

Put the F:\app\Administrator\product\11.2.0\dbhome_1\BIN on the front line.

For example:
F:\app\Administrator\product\11.2.0\dbhome_1\BIN; F:\oracle\product\10.2.0\client_1\bin;%java_home%\bin;%java_home%\jre\bin; F:\mysql\mysqlserve\bin;%commonprogramfiles%\microsoft shared\windows Live; C:\Program Files (x86) \intel\icls client\; C:\Program Files\intel\icls;%systemroot%\system32;%systemroot%;%systemroot%\system32\wbem

Oracle environment variable configuration Character set encoding configuration