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