手工建库问题

DBCA建 库没问题,可是手工建失败
建 库语句如下
create database test
logfile
group 1 ('/home/oracle/oradata/test/log_01_test.rdo') size 15M,
group 2 ('/home/oracle/oradata/test/log_02_test.rdo') size 15M,
group 3 ('/home/oracle/oradata/test/log_03_test.rdo') size 15M
datafile '/home/oracle/oradata/test/system_01_test.dbf' size 100M
undo tablespace UNDO
datafile '/home/oracle/oradata/test/undo_01_test.dbf' size 20M
default temporary tablespace TEMP
tempfile '/home/oracle/oradata/test/temp_01_test.dbf' size 10M
extent management local uniform size 128k
national character set AL16UTF16
set time_zone='America/New_York'
错误如下
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /home/oracle/product/9.2.0
System name:    Linux
Node name:      linux
Release:        2.6.13-15-default
Version:        #1 Tue Sep 13 14:56:15 UTC 2005
Machine:        i686
Instance name: test
Redo thread mounted by this instance: 1
Oracle process number: 8
Unix process pid: 5866, image: oracle@linux (TNS V1-V3)

*** SESSION ID:(7.1) 2006-09-01 07:30:26.719
ORA-00604: error occurred at recursive SQL level 1
ORA-00406: COMPATIBLE parameter needs to be 9.0.0.0.0 or greater
Offending statement at line 5166
CREATE UNDO TABLESPACE UNDO DATAFILE  '/home/oracle/oradata/test/undo_01_test.dbf' size 20M
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 5166
ORA-00604: error occurred at recursive SQL level 1
ORA-00406: COMPATIBLE parameter needs to be 9.0.0.0.0 or greater

用oracle用户手工touch一个文件试试看：
touch /home/oracle/oradata/test/undo_01_test.dbf

不行呀,老大

一开始提示 'operation only supported in Automatic Undo Management mode'
在init文件中加入了undo_management=auto后出的这个错
再就不知道怎么搞了,哪位朋友在帮着出个主意

修改initSID.ora中的参数COMPATIBLE

怎么改,这个参数是被注释掉了

#compatible = 8.1.0
undo_management=auto

为什么我不能成功增加控制文件

SQL> l
  1  alter system set control_files=
  2  '/home/oracle/oradata/hxfund/control01.ctl',
  3  '/home/oracle/oradata/hxfund/control02.ctl',
  4  '/home/oracle/oradata/hxfund/control03.ctl,,
  5* '/home/oracle/oradata/test/control04.ctl' scope=spfile
SQL> /
alter system set control_files=
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

[quote]原帖由 [i]mybj[/i] 于 2006-9-4 14:10 发表
#compatible = 8.1.0
undo_management=auto [/quote]

compatible = 9.2.0.0.0

重启

成功了

谢谢版主