- 论坛徽章:
- 0
|
大概环境:rac10g r2 aix5.3.05 ocr安装没有报错。crs_stat -t显示正常。
CreateDB.sql的脚本如下:
connect "SYS"/"&&sysPassword" as SYSDBA
set echo on
spool /home/db/oracle/app/admin/test/scripts3/CreateDB.log
startup nomount pfile="/home/db/oracle/app/admin/test/scripts3/init.ora";
CREATE DATABASE "test"
CONTROLFILE REUSE
MAXINSTANCES 32
MAXLOGHISTORY 1
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
DATAFILE '/home/db/oracle/app/oradata/test/system' SIZE 500M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/home/db/oracle/app/oradata/test/sysaux' SIZE 500M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/home/db/oracle/app/oradata/test/temp' SIZE 200M AUTOEXTEND ON NEXT 640K MAXS
IZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/home/db/oracle/app/oradata/test/undotbs21' SIZE 500M AUTOEXTEND ON NEXT 5120K MAXSI
ZE UNLIMITED, '/home/db/oracle/app/oradata/test/undotbs22' SIZE 500M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/home/db/oracle/app/oradata/test/redo2_1') SIZE 200M,
GROUP 2 ('/home/db/oracle/app/oradata/test/redo2_2') SIZE 200M
USER SYS IDENTIFIED BY "&&sysPassword" USER SYSTEM IDENTIFIED BY "&&systemPassword";
spool off
但运行报错:
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01618: redo thread 2 is not enabled - cannot mount
请问是否需要改脚本的东西?多折腾好几天了。郁闷。谢谢。 |
|