Chinaunix

标题: 10g rac 建库错误。 [打印本页]

作者: know217 时间: 2008-06-25 09:12
标题: 10g rac 建库错误。
大概环境：rac10g r2 aix5.3.05 ocr安装没有报错。crs_stat -t显示正常。\r\nCreateDB.sql的脚本如下：\r\nconnect \"SYS\"/\"&&sysPassword\" as SYSDBA\r\nset echo on\r\nspool /home/db/oracle/app/admin/test/scripts3/CreateDB.log\r\nstartup nomount pfile=\"/home/db/oracle/app/admin/test/scripts3/init.ora\";\r\nCREATE DATABASE \"test\"\r\nCONTROLFILE REUSE\r\nMAXINSTANCES 32\r\nMAXLOGHISTORY 1\r\nMAXLOGFILES 192\r\nMAXLOGMEMBERS 3\r\nMAXDATAFILES 1024\r\nDATAFILE \'/home/db/oracle/app/oradata/test/system\' SIZE 500M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED\r\nEXTENT MANAGEMENT LOCAL\r\nSYSAUX DATAFILE \'/home/db/oracle/app/oradata/test/sysaux\' SIZE 500M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED\r\nSMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE \'/home/db/oracle/app/oradata/test/temp\' SIZE 200M AUTOEXTEND ON NEXT 640K MAXS\r\nIZE UNLIMITED\r\nSMALLFILE UNDO TABLESPACE \"UNDOTBS1\" DATAFILE \'/home/db/oracle/app/oradata/test/undotbs21\' SIZE 500M AUTOEXTEND ON NEXT 5120K MAXSI\r\nZE UNLIMITED, \'/home/db/oracle/app/oradata/test/undotbs22\' SIZE 500M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED\r\nCHARACTER SET ZHS16GBK\r\nNATIONAL CHARACTER SET AL16UTF16\r\nLOGFILE GROUP 1 (\'/home/db/oracle/app/oradata/test/redo2_1\') SIZE 200M,\r\nGROUP 2 (\'/home/db/oracle/app/oradata/test/redo2_2\') SIZE 200M\r\nUSER SYS IDENTIFIED BY \"&&sysPassword\" USER SYSTEM IDENTIFIED BY \"&&systemPassword\";\r\nspool off\r\n\r\n\r\n但运行报错:\r\nERROR at line 1:\r\nORA-01501: CREATE DATABASE failed\r\nORA-01618: redo thread 2 is not enabled - cannot mount \r\n\r\n请问是否需要改脚本的东西？多折腾好几天了。郁闷。谢谢。

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)