报错操作:在手工创建数据库执行建库脚本时报此错;
SQL> CREATE DATABASE OL64 USER SYS IDENTIFIED BY oracle USER SYSTEM IDENTIFIED BY oracle LOGFILE GROUP 1 ('/u01/app/oracle/oradata/OL64/redo01a.log') SIZE 20M BLOCKSIZE 512, GROUP 2 ('/u01/app/oracle/oradata/OL64/redo02a.log') SIZE 20M BLOCK 2 3 4 5 SIZ E 512, GROUP 3 ('/u01/app/oracle/oradata/OL64/redo03a.log') SIZE 20M BLOCKSIZE 512 MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXLOGHISTORY 1 MAXDATAFILES 100 CHARACTER SET US7ASCII NATIONAL CHARACTER SET AL32UTF8 EXTENT MANAGEMENT LO 6 7 8 9 10 11 12 13 CAL DATAFILE '/u01/app/oracle/oradata/OL64/system01.dbf' SIZE 325M REUSE SYSAUX DATAFILE '/u01/app/oracle/oradata/OL64/sysaux01.dbf' SIZE 325M REUSE DEFAULT TABLESPACE users DATAFILE '/u01/app/oracle/oradata/OL64/users01.dbf' SIZE 50M 14 15 16 17 18 REUSE AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE '/u01/app/oracle/oradata/OL64/temp01.dbf' SIZE 20M REUSE UNDO TABLESPACE UNDOTBS1 19 20 21 22 DATAFILE '/u01/app/oracle/oradata/OL64/undotbs01.dbf' SIZE 50M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED; 23 24 EXTENT MANAGEMENT LOCAL * ERROR at line 13: ORA-12714: invalid national character set specified SQL>
错误原因分析:NATIONAL CHARACTER SET只有2 个选择:AL16UTF16和UTF8一般使用第一个,如需使用第二个直接写“UTF8”不能与以上报错相同使用“AL32UTF8“;
SQL> CREATE DATABASE OL64 USER SYS IDENTIFIED BY oracle USER SYSTEM IDENTIFIED BY oracle LOGFILE GROUP 1 ('/u01/app/oracle/oradata/OL64/redo01a.log') SIZE 20M BLOCKSIZE 512, GROUP 2 ('/u01/app/oracle/oradata/OL64/redo02a.log') SIZE 20M BLOCK 2 3 4 5 SIZ E 512, GROUP 3 ('/u01/app/oracle/oradata/OL64/redo03a.log') SIZE 20M BLOCKSIZE 512 MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXLOGHISTORY 1 MAXDATAFILES 100 CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8 EXTENT MANAGEMENT LOCAL 6 7 8 9 10 11 12 13 14 DATAFILE '/u01/app/oracle/oradata/OL64/system01.dbf' SIZE 325M REUSE SYSAUX DATAFILE '/u01/app/oracle/oradata/OL64/sysaux01.dbf' SIZE 325M REUSE DEFAULT TABLESPACE users DATAFILE '/u01/app/oracle/oradata/OL64/users01.dbf' SIZE 50M REUS 15 16 17 18 E AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE '/u01/app/oracle/oradata/OL64/temp01.dbf' SIZE 20M REUSE UNDO TABLESPACE UNDOTBS1 19 20 21 22 23 DATAFILE '/u01/app/oracle/oradata/OL64/undotbs01.dbf' SIZE 50M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED; 24 Database created. SQL>