非dbca静默安装~字符集设定

./runInstaller -silent -ignorePrereq -responseFile

db_name=yqzldb
control_files=/data/app/oracle/oradata/control01.ctl,/data/app/oracle/oradata/control02.ctl

CREATE DATABASE yqzldb
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 (‘/data/app/oracle/oradata/redo01.log’) SIZE 100M BLOCKSIZE 512,
GROUP 2 (‘/data/app/oracle/oradata/redo02.log’) SIZE 100M BLOCKSIZE 512,
GROUP 3 (‘/data/app/oracle/oradata/redo03.log’) SIZE 100M BLOCKSIZE 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE ‘/data/app/oracle/oradata/system01.dbf’ SIZE 30G REUSE
SYSAUX DATAFILE ‘/data/app/oracle/oradata/sysaux01.dbf’ SIZE 30G REUSE
DEFAULT TABLESPACE users
DATAFILE ‘/data/app/oracle/oradata/users01.dbf’
SIZE 30G REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE ‘/data/app/oracle/oradata/temp01.dbf’
SIZE 10G REUSE
UNDO TABLESPACE undo
DATAFILE ‘/data/app/oracle/oradata/undotbs01.dbf’
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16