我用10g undo tablespace改了 SYSAUX 也添加啦 但是依然出现这个错误 为什么啊!!!
SQL> CREATE DATABASE TEST
2 logfile group 1 ('E:\oracle\product\10.1.0\oradata\TEST\redo01a.log',
3 'E:\oracle\product\10.1.0\oradata\TEST\redo01b.log') size
5M,
4 group 2 ('E:\oracle\product\10.1.0\oradata\TEST\redo02a.log',
5 'E:\oracle\product\10.1.0\oradata\TEST\redo02b.log') siz
e 5M,
6 group 3 ('E:\oracle\product\10.1.0\oradata\TEST\redo03a.log',
7 'E:\oracle\product\10.1.0\oradata\TEST\redo03b.log') siz
e 5M
8 MAXLOGFILES 32
9 MAXLOGMEMBERS 2
10 MAXLOGHISTORY 1
11 MAXDATAFILES 254
12 MAXINSTANCES 1
13 DATAFILE 'E:\oracle\product\10.1.0\oradata\TEST\system01.dbf' SIZE 100M REU
SE AUTOEXTEND ON NEXT 10M maxsize unlimited
14 UNDO TABLESPACE UNDOTBS DATAFILE 'E:\oracle\product\10.1.0\oradata\TEST\und
otbs01.dbf' size 200M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED SYSAUX DATA
FILE 'E:\oracle\product\10.1.0\oradata\TEST\sysaux01.dbf' SIZE 120M REUSE AUTOEX
TEND ON NEXT 10240K MAXSIZE UNLIMITED
15 DEFAULT temporary tablespace temp tempfile 'E:\oracle\product\10.1.0\oradat
a\TEST\temp01.dbf' size 40M reuse
16 autoextend on next 1280K maxsize unlimited CHARACTER SET ZHS16GBK NATIONAL
CHARACTER SET AL16UTF16;
CREATE DATABASE TEST
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> CREATE DATABASE TEST
2 logfile group 1 ('E:\oracle\product\10.1.0\oradata\TEST\redo01a.log',
3 'E:\oracle\product\10.1.0\oradata\TEST\redo01b.log') size
5M,
4 group 2 ('E:\oracle\product\10.1.0\oradata\TEST\redo02a.log',
5 'E:\oracle\product\10.1.0\oradata\TEST\redo02b.log') siz
e 5M,
6 group 3 ('E:\oracle\product\10.1.0\oradata\TEST\redo03a.log',
7 'E:\oracle\product\10.1.0\oradata\TEST\redo03b.log') siz
e 5M
8 MAXLOGFILES 32
9 MAXLOGMEMBERS 2
10 MAXLOGHISTORY 1
11 MAXDATAFILES 254
12 MAXINSTANCES 1
13 DATAFILE 'E:\oracle\product\10.1.0\oradata\TEST\system01.dbf' SIZE 100M REU
SE AUTOEXTEND ON NEXT 10M maxsize unlimited
14 UNDO TABLESPACE UNDOTBS DATAFILE 'E:\oracle\product\10.1.0\oradata\TEST\und
otbs01.dbf' size 200M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED SYSAUX DATA
FILE 'E:\oracle\product\10.1.0\oradata\TEST\sysaux01.dbf' SIZE 120M REUSE AUTOEX
TEND ON NEXT 10240K MAXSIZE UNLIMITED
15 DEFAULT temporary tablespace temp tempfile 'E:\oracle\product\10.1.0\oradat
a\TEST\temp01.dbf' size 40M reuse
16 autoextend on next 1280K maxsize unlimited CHARACTER SET ZHS16GBK NATIONAL
CHARACTER SET AL16UTF16;
CREATE DATABASE TEST
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货