ORA-13504: No SYSAUX datafile clause specified

来源：互联网发布：java书籍借阅编辑：程序博客网时间：2024/06/05 17:22

ORA-01990: error opening password file '/app/oracle/dbs/orapw'

cd $ORACLE_HOME/dbs

orapwd file=orapwbbk password=oracle entries=10

ORA-13504: No SYSAUX datafile clause specified
ORACLE 10g和11g手工创建数据库的时候，必须创建SYSAUX DATAFILE，否则报错。

SYSAUX DATAFILE '/app/oracle/oradata/bbk/sysaux01.dbf' size 300M

cd $ORACLE_HOME/dbs

vi crdb01.sql 编写CREATE DATABASE的脚本

spool dbcreate.log;

CREATE DATABASE "bbk"
        MAXDATAFILES 500
        MAXINSTANCES 8
        MAXLOGFILES  32
        CHARACTER SET "UTF8"
        NATIONAL CHARACTER SET AL16UTF16
        SYSAUX DATAFILE '/app/oracle/oradata/bbk/sysaux01.dbf' size 300M
        ARCHIVELOG
        DATAFILE
                '/app/oracle/oradata/bbk/system01.dbf' size 300M
        EXTENT MANAGEMENT LOCAL
        DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/app/oracle/oradata/bbk/tempts01.dbf' SIZE 100M EXTENT MANAGEMENT LOCAL
        UNDO TABLESPACE "UNDOTBS1"
        DATAFILE '/app/oracle/oradata/bbk/undotbs01.dbf' SIZE 200M
        LOGFILE
  GROUP 1 (
        '/app/oracle/oradata/bbk/redo01a.rdo',
        '/app/oracle/oradata/bbk/redo01b.rdo'
        ) SIZE 100M,
  GROUP 2 (
        '/app/oracle/oradata/bbk/redo02a.rdo',
        '/app/oracle/oradata/bbk/redo02b.rdo'
        ) SIZE 100M,
  GROUP 3 (
        '/app/oracle/oradata/bbk/redo03a.rdo',
        '/app/oracle/oradata/bbk/redo03b.rdo'
        ) SIZE 100M
;

spool off

用sqlplus /nolog 进入数据库

conn / as sysdba

SQL> create spfile from pfile

SQL> startup nomount

SQL> @$ORACLE_HOME/dbs/crdb01.sql; 执行创建数据库的脚本

Database created.

转自：http://blog.sina.com.cn/s/blog_a57562c80101502x.html