手动创建数据失败，日志出如下错误ORA-00604,ORA-00406

Thu Aug 19 06:15:24 2010
ORA-406 signalled during: CREATE UNDO TABLESPACE UNDOTBS DATAFILE  '/moracle...
Thu Aug 19 06:15:24 2010
Errors in file /moracle/92/rdbms/log/moracle_ora_4081.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00406: COMPATIBLE parameter needs to be 9.0.0.0.0 or greater
Thu Aug 19 06:15:24 2010
Errors in file /moracle/92/rdbms/log/moracle_ora_4081.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 5166
ORA-00604: error occurred at recursive SQL level 1
ORA-00406: COMPATIBLE parameter needs to be 9.0.0.0.0 or greater
Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 4081
ORA-1092 signalled during: create database moracle
 MAXINSTANCES 1
  MAXLOGHI...

 

 

-------------------------------------------------------------------

创建数据的脚本：

create database moracle
 MAXINSTANCES 1
  MAXLOGHISTORY 1
  MAXLOGFILES 5
  MAXLOGMEMBERS 5
  MAXDATAFILES 100
  DATAFILE '/moracle/oradata/moracle/system.dbf' size 50M
  UNDO TABLESPACE undotbs DATAFILE '/moracle/oradata/moracle/undotbs.dbf'  SIZE 50M
  AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
  DEFAULT TEMPORARY TABLESPACE tempts
  CHARACTER SET ZHS16GBK
  NATIONAL CHARACTER SET AL16UTF16
  LOGFILE GROUP 1 ('/moracle/oradata/moracle/redo01.log') SIZE 100M,
  GROUP 2 ('/moracle/oradata/moracle/redo02.log') SIZE 100M,
  GROUP 3 ('/moracle/oradata/moracle/redo03.log') SIZE 100M