手动创建数据库脚本以及报错处理：ORA-01519ORA-00604ORA-30012

来源：互联网发布：手机淘宝掌柜热卖在哪编辑：程序博客网时间：2024/05/17 02:18

脚本：

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创建之后，创建基表的，可以修改创建个性数据库，但是不建议这么做，因为很多挖掘工具是依据该脚本写的，修改后对应的工具将无法使用。

0 0