[求助]关于手动创建数据库的问题

woodwalker

linux下,我按照网上的一些教程
1)创建相应文件夹
$mkdir  /u01/app/oracle/admin/test/adump
$mkdir  /u01/app/oracle/admin/test/bdump
$mkdir  /u01/app/oracle/admin/test/cdump
$mkdir  /u01/app/oracle/admin/test/udump
$mkdir  /u01/app/oracle/admin/test/pfile
$mkdir  /u01/app/oracle/oradata/test
2)创建密码文件
/u01/app/oracle/product/10.2.0/db_1/bin/orapwd file=//u01/app/oracle/product/10.2.0/db_1/dbs/orapwtest password=test
3）初始化参数
$sqlplus /nolog
sql>conn / as sysdba
sql>create pfile='/u01/app/oracle/product/10.2.0/db_1/dbs/inittest.ora' from
  2 spfile='/u01/app/oracle/product/10.2.0/db_1/dbs/spfileorcl.ora'
File created.

$vi inittest.ora
test.__db_cache_size=192937984
test.__java_pool_size=4194304
test.__large_pool_size=4194304
test.__shared_pool_size=79691776
test.__streams_pool_size=0
*._awr_flush_threshold_metrics=FALSE
*.audit_file_dest='/u01/app/oracle/admin/test/adump'
*.background_dump_dest='/u01/app/oracle/admin/test/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oradata/test/control01.ctl','/u01/app/oracle/oradata/test/control02.ctl','/u01/app/oracle/oradata/o
rcl/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/test/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='test'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=94371840
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=285212672
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/test/udump'
4)
SQL> create spfile='/u01/app/oracle/product/10.2.0/db_1/dbs/spfiletest.ora'
  2   from pfile='/u01/app/oracle/product/10.2.0/db_1/dbs/inittest.ora';   

File created.

5)设置SID实例
$ORACLE_SID=test
$export ORACLE_SID
6)启动实例
[oracle@oracle dbs]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 11 01:44:54 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1218992 bytes
Variable Size              96470608 bytes
Database Buffers          184549376 bytes
Redo Buffers                2973696 bytes

7）创建数据库
$sqlplus /NOLOG
sql>conn sys/password as sysdba
sql>starup nomount
sql>create DATABASE test
       MAXINSTANCES 1
       MAXLOGHISTORY 216
       MAXLOGFILES 50
       MAXLOGMEMBERS 5
sysaux DATAFILE '/u01/app/oracle/oradata/test/system01.dbf' SIZE 500m
AUTOEXTEND ON NEXT 100m MAXSIZE UNLIMITED
LOGFILE
       GROUP 1('/u01/app/oracle/oradata/test/log1.log') SIZE 10m,
       GROUP 2('/u01/app/oracle/oradata/test/log2.log') SIZE 10m,
       GROUP 3('/u01/app/oracle/oradata/test/log3.log') SIZE 10m,
Undo TABLESPACE UNDOTBS1 DATAFILE
'/u01/app/oracle/oradata/test/undotbs01.dbf' size 200m
AUTOEXTEND ON NEXT 100m MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE
'/u01/app/oracle/oradata/test/temp01.dbf' size 325m
AUTOEXTEND ON NEXT 100m MAXSIZE UNLIMITED
DEFAULT TABLESPACE users DATAFILE
'/u01/app/oracle/oradata/test/usertbs01.dbf' size 1000m
CHARACTER SET ZHS16GBK;
create DATABASE test
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01505: error in adding log files
ORA-01184: logfile group 1 already exists

请问这是怎么回事?

[ 本帖最后由 woodwalker 于 2008-4-20 22:17 编辑 ]

woodwalker

sorry,原来是多一个逗号