oracle10g数据库测试失败,今天手工创建10G数据库失败，报ORA-12701错误

SQL> CREATE DATABASE oam

2 USER SYS IDENTIFIED BY ORACLE

3 USER SYSTEM IDENTIFIED BY oracle

4 CONTROLFILE REUSE

5 logfile group 1 ('/ocs/oracle/ocs/oracle/oradata/oam/redo1.log') size 200M,

6 group 2 ('/ocs/oracle/ocs/oracle/oradata/oam/redo2.log') size 200M,

7 group 3 ('/ocs/oracle/ocs/oracle/oradata/oam/redo3.log') size 200M

8 MAXLOGFILES 5

9 MAXLOGMEMBERS 5

10 MAXLOGHISTORY 1

11 MAXDATAFILES 100

12 MAXINSTANCES 1

13 CHARACTER SET ZHS16GBK

14 NATIONAL CHARACTER SET AL16UTF16

15 datafile '/ocs/oracle/ocs/oracle/oradata/oam/system.dbf'

16 size 2048M autoextend on extent management local

17 sysaux datafile '/ocs/oracle/ocs/oracle/oradata/oam/sysaux.dbf'

18 size 2048M autoextend on

19 undo tablespace undotbs1

20 datafile '/ocs/oracle/ocs/oracle/oradata/oam/undo.dbf' size 2048M

21 default temporary tablespace temp

22 tempfile '/ocs/oracle/ocs/oracle/oradata/oam/temp.dbf' size 2048M;

NATIONAL CHARACTER SET AL16UTF16

*

ERROR at line 14:

ORA-12701: CREATE DATABASE character set is not known

检查发现是环境变量ORA_NLS10设置错误导致：

[@more@]

查询视图v$nls_valid_values，发现支持的字符集只有US7ASCII，显然不可能，进一步检查发现环境变量ORA_NLS10设置错误，修改后错误没有再出现。

ORA_NLS10=$ORACLE_HOME/nls/data