OracleDBA之路之Create Database(六)

一个简单的数据库创建脚本

spool dbcreate.log;

CREATE DATABASE "db01"
 USER SYS IDENTIFIED BY oracle
   USER SYSTEM IDENTIFIED BY oracle
 LOGFILE GROUP 1 ('/u01/oradata/db01/redo01a.log','/u01/oradata/db01/redo01b.log') SIZE 100M BLOCKSIZE 512,
            GROUP 2 ('/u01/oradata/db01/redo02a.log','/u01/oradata/db01/redo02b.log') SIZE 100M BLOCKSIZE 512,
           GROUP 3 ('/u01/oradata/db01/redo03a.log','/u01/oradata/db01/redo03b.log') SIZE 100M BLOCKSIZE 512
 MAXLOGFILES 32
 MAXLOGMEMBERS 5
 MAXLOGHISTORY 1
 MAXDATAFILES 500
 CHARACTER SET "UTF-8"
 NATIONAL CHARACTER SET AL16UTF16
 EXTENT MANAGEMENT LOCAL
 ARCHIVELOG
 DATAFILE '/u01/oradata/db01/system01.dbf' SIZE 300M REUSE
 SYSAUX DATAFILE '/u01/oradata/db01/sysaux01.dbf' SIZE 325M REUSE
 DEFAULT TEMPORARY TABLESPACE tempts1
  TEMPFILE '/u01/oradata/db01/temp01.dbf' SIZE 20M REUSE
 UNDO TABLESPACE "UNDOTBS1"
        DATAFILE '/u01/oradata/db01/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
spool off;

 

 

创建数据库之前需要穿件一个

$ORACLE_HOEM/dbs/

orapwd file=orapwdb01 password=oracle entries=10

创建时遇到

 NATIONAL CHARACTER SET AL16UTF16
这句报如下错误

ORA-12701: CREATE DATABASE character set is not known

根据官方提示需要 在11g版本中需要设置

ORA_NLS10 = $ORACLE_HOME/nls/data

我设置了还是不无法成功创建数据库

该问题正在解决ing