我的出错信息如下:BDUMP中的ALTER_TEST.LOG
Dump file d:\oracle\admin\test\bdump\alert_test.log
Mon May 10 15:59:49 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Mon May 10 15:59:49 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
shared_pool_size = 12582912
control_files = D:\ORACLE\ORADATA\TEST\CONTROL01.CTL
db_block_size = 2048
db_cache_size = 8388608
log_buffer = 32768
undo_management = AUTO
undo_tablespace = UNDOTBS
instance_name = TEST
background_dump_dest = D:\ORACLE\ADMIN\TEST\BDUMP
user_dump_dest = D:\ORACLE\ADMIN\TEST\UDUMP
db_name = TEST
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Mon May 10 15:59:58 2004
CREATE DATABASE TEST
MAXINSTANCES 1
MAXLOGHISTORY 50
MAXLOGFILES 32
MAXLOGMEMBERS 5
MAXDATAFILES 100
LOGFILE
GROUP 1 ('D:\ORACLE\ORADATA\TEST\REDO_A01.LOG') SIZE 1M,
GROUP 2 ('D:\ORACLE\ORADATA\TEST\REDO_B01.LOG') SIZE 1M
DATAFILE 'D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF' SIZE 150M AUTOEXTEND ON NEXT 10M
UNDO TABLESPACE UNDOTBS
DATAFILE 'D:\ORACLE\ORADATA\TEST\UNDOTBS1.DBF' SIZE 10M
DEFAULT TEMPORARY TABLESPACE TEMP
TEMPFILE 'D:\ORACLE\ORADATA\TEST\TEMP.DBF' SIZE 10M
CHARACTER SET ZHS16GBK
Mon May 10 16:00:00 2004
Database mounted in Exclusive Mode.
Mon May 10 16:00:02 2004
Successful mount of redo thread 1, with mount id 1824004862.
Assigning activation ID 1824004862 (0x6cb81afe)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_A01.LOG
Successful open of redo thread 1.
Mon May 10 16:00:02 2004
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon May 10 16:00:02 2004
SMON: enabling cache recovery
Mon May 10 16:00:02 2004
WARNING: Default passwords for SYS and SYSTEM will be used.
Please change the passwords.
Mon May 10 16:00:02 2004
create tablespace SYSTEM datafile 'D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF' SIZE 150M AUTOEXTEND ON NEXT 10M
default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY onlineMon May 10 16:00:19 2004
Completed: create tablespace SYSTEM datafile 'D:\ORACLE\ORAD
Mon May 10 16:00:19 2004
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)Completed: create rollback segment SYSTEM tablespace SYSTEM
Mon May 10 16:00:24 2004
Thread 1 advanced to log sequence 2
Current log# 2 seq# 2 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_B01.LOG
Thread 1 cannot allocate new log, sequence 3
Checkpoint not complete
Current log# 2 seq# 2 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_B01.LOG
Thread 1 advanced to log sequence 3
Current log# 1 seq# 3 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_A01.LOG
Thread 1 cannot allocate new log, sequence 4
Checkpoint not complete
Current log# 1 seq# 3 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_A01.LOG
Thread 1 advanced to log sequence 4
Current log# 2 seq# 4 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_B01.LOG
Thread 1 cannot allocate new log, sequence 5
Checkpoint not complete
Current log# 2 seq# 4 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_B01.LOG
Thread 1 advanced to log sequence 5
Current log# 1 seq# 5 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_A01.LOG
Thread 1 cannot allocate new log, sequence 6
Checkpoint not complete
Current log# 1 seq# 5 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_A01.LOG
Thread 1 advanced to log sequence 6
Current log# 2 seq# 6 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_B01.LOG
Thread 1 cannot allocate new log, sequence 7
Checkpoint not complete
Current log# 2 seq# 6 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_B01.LOG
Thread 1 advanced to log sequence 7
Current log# 1 seq# 7 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_A01.LOG
Thread 1 cannot allocate new log, sequence 8
Checkpoint not complete
Current log# 1 seq# 7 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_A01.LOG
Thread 1 advanced to log sequence 8
Current log# 2 seq# 8 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_B01.LOG
Thread 1 cannot allocate new log, sequence 9
Checkpoint not complete
Current log# 2 seq# 8 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_B01.LOG
Thread 1 advanced to log sequence 9
Current log# 1 seq# 9 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_A01.LOG
Thread 1 cannot allocate new log, sequence 10
Checkpoint not complete
Current log# 1 seq# 9 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_A01.LOG
Thread 1 advanced to log sequence 10
Current log# 2 seq# 10 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_B01.LOG
Mon May 10 16:00:51 2004
CREATE UNDO TABLESPACE UNDOTBS DATAFILE 'D:\ORACLE\ORADATA\TEST\UNDOTBS1.DBF' SIZE 10MMon May 10 16:00:52 2004
ORA-406 signalled during: CREATE UNDO TABLESPACE UNDOTBS DATAFILE 'D:\ORACL...
Mon May 10 16:00:52 2004
Errors in file d:\oracle\admin\test\udump\test_ora_1916.trc:
ORA-00604: ?? SQL ? 1 ????
ORA-00406: COMPATIBLE ????? 9.0.0.0.0 ???Mon May 10 16:00:52 2004
Errors in file d:\oracle\admin\test\udump\test_ora_1916.trc:
ORA-01501: CREATE DATABASE ??
ORA-01519: ?????'%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ'????5161???
ORA-00604: ?? SQL ? 1 ????
ORA-00406: COMPATIBLE ????? 9.0.0.0.0 ???Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 1916
ORA-1092 signalled during: CREATE DATABASE TEST
MAXINSTANCES 1
MAXLOGHIST...
Dump file d:\oracle\admin\test\bdump\alert_test.log
Mon May 10 15:59:49 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Mon May 10 15:59:49 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
shared_pool_size = 12582912
control_files = D:\ORACLE\ORADATA\TEST\CONTROL01.CTL
db_block_size = 2048
db_cache_size = 8388608
log_buffer = 32768
undo_management = AUTO
undo_tablespace = UNDOTBS
instance_name = TEST
background_dump_dest = D:\ORACLE\ADMIN\TEST\BDUMP
user_dump_dest = D:\ORACLE\ADMIN\TEST\UDUMP
db_name = TEST
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Mon May 10 15:59:58 2004
CREATE DATABASE TEST
MAXINSTANCES 1
MAXLOGHISTORY 50
MAXLOGFILES 32
MAXLOGMEMBERS 5
MAXDATAFILES 100
LOGFILE
GROUP 1 ('D:\ORACLE\ORADATA\TEST\REDO_A01.LOG') SIZE 1M,
GROUP 2 ('D:\ORACLE\ORADATA\TEST\REDO_B01.LOG') SIZE 1M
DATAFILE 'D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF' SIZE 150M AUTOEXTEND ON NEXT 10M
UNDO TABLESPACE UNDOTBS
DATAFILE 'D:\ORACLE\ORADATA\TEST\UNDOTBS1.DBF' SIZE 10M
DEFAULT TEMPORARY TABLESPACE TEMP
TEMPFILE 'D:\ORACLE\ORADATA\TEST\TEMP.DBF' SIZE 10M
CHARACTER SET ZHS16GBK
Mon May 10 16:00:00 2004
Database mounted in Exclusive Mode.
Mon May 10 16:00:02 2004
Successful mount of redo thread 1, with mount id 1824004862.
Assigning activation ID 1824004862 (0x6cb81afe)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_A01.LOG
Successful open of redo thread 1.
Mon May 10 16:00:02 2004
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon May 10 16:00:02 2004
SMON: enabling cache recovery
Mon May 10 16:00:02 2004
WARNING: Default passwords for SYS and SYSTEM will be used.
Please change the passwords.
Mon May 10 16:00:02 2004
create tablespace SYSTEM datafile 'D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF' SIZE 150M AUTOEXTEND ON NEXT 10M
default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY onlineMon May 10 16:00:19 2004
Completed: create tablespace SYSTEM datafile 'D:\ORACLE\ORAD
Mon May 10 16:00:19 2004
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)Completed: create rollback segment SYSTEM tablespace SYSTEM
Mon May 10 16:00:24 2004
Thread 1 advanced to log sequence 2
Current log# 2 seq# 2 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_B01.LOG
Thread 1 cannot allocate new log, sequence 3
Checkpoint not complete
Current log# 2 seq# 2 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_B01.LOG
Thread 1 advanced to log sequence 3
Current log# 1 seq# 3 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_A01.LOG
Thread 1 cannot allocate new log, sequence 4
Checkpoint not complete
Current log# 1 seq# 3 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_A01.LOG
Thread 1 advanced to log sequence 4
Current log# 2 seq# 4 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_B01.LOG
Thread 1 cannot allocate new log, sequence 5
Checkpoint not complete
Current log# 2 seq# 4 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_B01.LOG
Thread 1 advanced to log sequence 5
Current log# 1 seq# 5 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_A01.LOG
Thread 1 cannot allocate new log, sequence 6
Checkpoint not complete
Current log# 1 seq# 5 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_A01.LOG
Thread 1 advanced to log sequence 6
Current log# 2 seq# 6 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_B01.LOG
Thread 1 cannot allocate new log, sequence 7
Checkpoint not complete
Current log# 2 seq# 6 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_B01.LOG
Thread 1 advanced to log sequence 7
Current log# 1 seq# 7 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_A01.LOG
Thread 1 cannot allocate new log, sequence 8
Checkpoint not complete
Current log# 1 seq# 7 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_A01.LOG
Thread 1 advanced to log sequence 8
Current log# 2 seq# 8 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_B01.LOG
Thread 1 cannot allocate new log, sequence 9
Checkpoint not complete
Current log# 2 seq# 8 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_B01.LOG
Thread 1 advanced to log sequence 9
Current log# 1 seq# 9 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_A01.LOG
Thread 1 cannot allocate new log, sequence 10
Checkpoint not complete
Current log# 1 seq# 9 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_A01.LOG
Thread 1 advanced to log sequence 10
Current log# 2 seq# 10 mem# 0: D:\ORACLE\ORADATA\TEST\REDO_B01.LOG
Mon May 10 16:00:51 2004
CREATE UNDO TABLESPACE UNDOTBS DATAFILE 'D:\ORACLE\ORADATA\TEST\UNDOTBS1.DBF' SIZE 10MMon May 10 16:00:52 2004
ORA-406 signalled during: CREATE UNDO TABLESPACE UNDOTBS DATAFILE 'D:\ORACL...
Mon May 10 16:00:52 2004
Errors in file d:\oracle\admin\test\udump\test_ora_1916.trc:
ORA-00604: ?? SQL ? 1 ????
ORA-00406: COMPATIBLE ????? 9.0.0.0.0 ???Mon May 10 16:00:52 2004
Errors in file d:\oracle\admin\test\udump\test_ora_1916.trc:
ORA-01501: CREATE DATABASE ??
ORA-01519: ?????'%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ'????5161???
ORA-00604: ?? SQL ? 1 ????
ORA-00406: COMPATIBLE ????? 9.0.0.0.0 ???Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 1916
ORA-1092 signalled during: CREATE DATABASE TEST
MAXINSTANCES 1
MAXLOGHIST...
已连接到空闲例程。
ORACLE 例程已经启动。Total System Global Area 59316748 bytes
Fixed Size 453132 bytes
Variable Size 50331648 bytes
Database Buffers 8388608 bytes
Redo Buffers 143360 bytes
原值 1: CREATE DATABASE &ORACLE_SID
新值 1: CREATE DATABASE TEST
原值 8: GROUP 1 ('&ORACLE_DATA\REDO_A01.LOG') SIZE 1M,
新值 8: GROUP 1 ('D:\ORACLE\ORADATA\TEST\REDO_A01.LOG') SIZE 1M,
原值 9: GROUP 2 ('&ORACLE_DATA\REDO_B01.LOG') SIZE 1M
新值 9: GROUP 2 ('D:\ORACLE\ORADATA\TEST\REDO_B01.LOG') SIZE 1M
原值 10: DATAFILE '&ORACLE_DATA\SYSTEM01.DBF' SIZE 150M AUTOEXTEND ON NEXT 10M
新值 10: DATAFILE 'D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF' SIZE 150M AUTOEXTEND ON NEXT 10M
原值 12: DATAFILE '&ORACLE_DATA\UNDOTBS1.DBF' SIZE 10M
新值 12: DATAFILE 'D:\ORACLE\ORADATA\TEST\UNDOTBS1.DBF' SIZE 10M
原值 14: TEMPFILE '&ORACLE_DATA\TEMP.DBF' SIZE 10M
新值 14: TEMPFILE 'D:\ORACLE\ORADATA\TEST\TEMP.DBF' SIZE 10M
CREATE DATABASE TEST
*
ERROR 位于第 1 行:
ORA-01092: ORACLE 例程终止。强行断开连接
Dump file d:\oracle\admin\test\udump\test_ora_1916.trc
Mon May 10 16:00:52 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: testRedo thread mounted by this instance: 1Oracle process number: 8Windows thread id: 1916, image: ORACLE.EXE
*** SESSION ID:(7.1) 2004-05-10 16:00:52.000
ORA-00604: ?? SQL ? 1 ????
ORA-00406: COMPATIBLE ????? 9.0.0.0.0 ???
Offending statement at line 5161
CREATE UNDO TABLESPACE UNDOTBS DATAFILE 'D:\ORACLE\ORADATA\TEST\UNDOTBS1.DBF' SIZE 10M
ORA-01501: CREATE DATABASE ??
ORA-01519: ?????'%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ'????5161???
ORA-00604: ?? SQL ? 1 ????
ORA-00406: COMPATIBLE ????? 9.0.0.0.0 ???
顺便问一句:为什么我的出错信息中有一些问号呢,我的版本是刚从OTN上下载的R2呀!
COMPATIBLE = 9.0.2.0.0
请问这个参数是否9I的必设参数!