脚本:
CREATE DATABASE yun
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/yun/redo01.log' SIZE 50M,
GROUP 2 '/u01/app/oracle/oradata/yun/redo02.log' SIZE 50M,
GROUP 3 '/u01/app/oracle/oradata/yun/redo03.log' SIZE 50M
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
-- STANDBY LOGFILE
DATAFILE '/u01/app/oracle/oradata/yun/system01.dbf' SIZE 325m REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/app/oracle/oradata/yun/sysaux01.dbf' SIZE 325m REUSE
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/u01/app/oracle/oradata/yun/temp01.dbf' SIZE 20M REUSE
DEFAULT TABLESPACE users DATAFILE '/u01/app/oracle/oradata/yun/users01.dbf' SIZE 20m REUSE
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
UNDO TABLESPACE undotbs DATAFILE '/u01/app/oracle/oradata/yun/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
alert日志中报错:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 5799
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 3650
在警告日志中报的是undotbs1而不是我在脚本中写的undotbs 一致,所以报错,原因:在参数文件中的名称是undotbs1,所以必须保持一致。
顺便提一句:?/rdbms/admin/sql.bsq'这个脚本是在system rollback创建之后,创建基表的,可以修改创建个性数据库,但是不建议这么做,因为很多挖掘工具是依据该脚本写的,修改后对应的工具将无法使用。