新手,看不大懂,贴上求指教一二,多谢!Dump file e:\admin\test1\bdump\alert_test1.log Wed Feb 13 16:42:51 2008 ORACLE V10.1.0.2.0 - Production vsnsta=0 vsnsql=13 vsnxtr=3 Windows XP Version V5.1 Service Pack 1 CPU : 1 - type 586 Process Affinity: 0x00000000 Memory (A/P) : PH:450M/765M, PG:1659M/1877M, VA:1958M/2047M Wed Feb 13 16:42:51 2008 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Shared memory segment for instance monitoring created Picked latch-free SCN scheme 2 KCCDEBUG_LEVEL = 0 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. Dynamic strands is set to TRUE Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE IMODE=BR ILAT =18 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 10.1.0.2.0. System parameters with non-default values: processes = 150 shared_pool_size = 83886080 large_pool_size = 8388608 java_pool_size = 50331648 control_files = E:\ORADATA\TEST1\CONTROL01.CTL, E:\ORADATA\TEST1\CONTROL02.CTL, E:\ORADATA\TEST1\CONTROL03.CTL db_block_size = 8192 db_cache_size = 25165824 compatible = 10.1.0.2.0 db_file_multiblock_read_count= 16 db_recovery_file_dest = E:\flash_recovery_area db_recovery_file_dest_size= 2147483648 undo_management = AUTO undo_tablespace = UNDOTBS1 remote_login_passwordfile= EXCLUSIVE db_domain = local dispatchers = (PROTOCOL=TCP) (SERVICE=test1XDB) job_queue_processes = 10 background_dump_dest = E:\ADMIN\TEST1\BDUMP user_dump_dest = E:\ADMIN\TEST1\UDUMP core_dump_dest = E:\ADMIN\TEST1\CDUMP sort_area_size = 65536 db_name = test1 open_cursors = 300 pga_aggregate_target = 25165824 PMON started with pid=2, OS id=2728 MMAN started with pid=3, OS id=2732 DBW0 started with pid=4, OS id=2736 LGWR started with pid=5, OS id=2740 CKPT started with pid=6, OS id=2744 SMON started with pid=7, OS id=2748 RECO started with pid=8, OS id=2752 CJQ0 started with pid=9, OS id=2756 Wed Feb 13 16:42:51 2008 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... Wed Feb 13 16:42:52 2008 CREATE DATABASE "test1" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE 'E:\oradata\test1\system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE 'E:\oradata\test1\sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'E:\oradata\test1\temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED UNDO TABLESPACE "UNDOTBS1" DATAFILE 'E:\oradata\test1\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED CHARACTER SET ZHS16GBK NATIONAL CHARACTER SET AL16UTF16 LOGFILE GROUP 1 ('E:\oradata\test1\redo01.log') SIZE 10240K, GROUP 2 ('E:\oradata\test1\redo02.log') SIZE 10240K, GROUP 3 ('E:\oradata\test1\redo03.log') SIZE 10240K USER SYS IDENTIFIED BY *USER SYSTEM IDENTIFIED BY Wed Feb 13 16:42:53 2008 Controlfile identified with block size 16384 Wed Feb 13 16:42:53 2008 Controlfile created with 174 blocks of size 16384 bytes Wed Feb 13 16:42:53 2008 Published database character set on system events channel Database mounted in Exclusive Mode. Wed Feb 13 16:42:57 2008 Successful mount of redo thread 1, with mount id 1023621453 Assigning activation ID 1023621453 (0x3d03394d) Maximum redo generation record size = 120832 bytes Maximum redo generation change vector size = 116476 bytes Private_strands 7 at log switch Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: E:\ORADATA\TEST1\REDO01.LOG Successful open of redo thread 1 Wed Feb 13 16:42:57 2008 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Feb 13 16:42:57 2008 All processes have switched to database character set Wed Feb 13 16:42:57 2008 SMON: enabling cache recovery Wed Feb 13 16:42:57 2008 create tablespace SYSTEM datafile 'E:\oradata\test1\system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL onlineWed Feb 13 16:43:11 2008 Completed: create tablespace SYSTEM datafile 'E:\oradata\tes Wed Feb 13 16:43:11 2008 create rollback segment SYSTEM tablespace SYSTEM storage (initial 50K next 50K)Completed: create rollback segment SYSTEM tablespace SYSTEM
Wed Feb 13 16:43:15 2008 Errors in file e:\admin\test1\udump\test1_ora_2768.trc: ORA-00604: ?? SQL ?? 1 ???? ORA-00988: ???????Wed Feb 13 16:43:15 2008 Errors in file e:\admin\test1\udump\test1_ora_2768.trc: ORA-01501: CREATE DATABASE ?? ORA-01519: ????? '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' ???? 2356 ??? ORA-00604: ?? SQL ?? 1 ???? ORA-00988: ???????Error 1519 happened during db open, shutting down database USER: terminating instance due to error 1519 Wed Feb 13 16:43:15 2008 Errors in file e:\admin\test1\bdump\test1_reco_2752.trc: ORA-01519: error while processing file '' near line Wed Feb 13 16:43:15 2008 Errors in file e:\admin\test1\bdump\test1_smon_2748.trc: ORA-01519: error while processing file '' near line Wed Feb 13 16:43:15 2008 Errors in file e:\admin\test1\bdump\test1_ckpt_2744.trc: ORA-01519: error while processing file '' near line Wed Feb 13 16:43:15 2008 Errors in file e:\admin\test1\bdump\test1_lgwr_2740.trc: ORA-01519: error while processing file '' near line Wed Feb 13 16:43:15 2008 Errors in file e:\admin\test1\bdump\test1_dbw0_2736.trc: ORA-01519: error while processing file '' near line Wed Feb 13 16:43:15 2008 Errors in file e:\admin\test1\bdump\test1_mman_2732.trc: ORA-01519: error while processing file '' near line Instance terminated by USER, pid = 2768 ORA-1092 signalled during: CREATE DATABASE "test1" MAXINSTANCES 8 MAXLOGHISTO...
察看一下 alert 文件,看是什么原因没起来。
Wed Feb 13 16:42:51 2008
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows XP Version V5.1 Service Pack 1
CPU : 1 - type 586
Process Affinity: 0x00000000
Memory (A/P) : PH:450M/765M, PG:1659M/1877M, VA:1958M/2047M
Wed Feb 13 16:42:51 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 50331648
control_files = E:\ORADATA\TEST1\CONTROL01.CTL, E:\ORADATA\TEST1\CONTROL02.CTL, E:\ORADATA\TEST1\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = E:\flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain = local
dispatchers = (PROTOCOL=TCP) (SERVICE=test1XDB)
job_queue_processes = 10
background_dump_dest = E:\ADMIN\TEST1\BDUMP
user_dump_dest = E:\ADMIN\TEST1\UDUMP
core_dump_dest = E:\ADMIN\TEST1\CDUMP
sort_area_size = 65536
db_name = test1
open_cursors = 300
pga_aggregate_target = 25165824
PMON started with pid=2, OS id=2728
MMAN started with pid=3, OS id=2732
DBW0 started with pid=4, OS id=2736
LGWR started with pid=5, OS id=2740
CKPT started with pid=6, OS id=2744
SMON started with pid=7, OS id=2748
RECO started with pid=8, OS id=2752
CJQ0 started with pid=9, OS id=2756
Wed Feb 13 16:42:51 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Feb 13 16:42:52 2008
CREATE DATABASE "test1"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'E:\oradata\test1\system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'E:\oradata\test1\sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'E:\oradata\test1\temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'E:\oradata\test1\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('E:\oradata\test1\redo01.log') SIZE 10240K,
GROUP 2 ('E:\oradata\test1\redo02.log') SIZE 10240K,
GROUP 3 ('E:\oradata\test1\redo03.log') SIZE 10240K
USER SYS IDENTIFIED BY *USER SYSTEM IDENTIFIED BY
Wed Feb 13 16:42:53 2008
Controlfile identified with block size 16384
Wed Feb 13 16:42:53 2008
Controlfile created with 174 blocks of size 16384 bytes
Wed Feb 13 16:42:53 2008
Published database character set on system events channel
Database mounted in Exclusive Mode.
Wed Feb 13 16:42:57 2008
Successful mount of redo thread 1, with mount id 1023621453
Assigning activation ID 1023621453 (0x3d03394d)
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 7 at log switch
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: E:\ORADATA\TEST1\REDO01.LOG
Successful open of redo thread 1
Wed Feb 13 16:42:57 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Feb 13 16:42:57 2008
All processes have switched to database character set
Wed Feb 13 16:42:57 2008
SMON: enabling cache recovery
Wed Feb 13 16:42:57 2008
create tablespace SYSTEM datafile 'E:\oradata\test1\system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL onlineWed Feb 13 16:43:11 2008
Completed: create tablespace SYSTEM datafile 'E:\oradata\tes
Wed Feb 13 16:43:11 2008
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)Completed: create rollback segment SYSTEM tablespace SYSTEM
Wed Feb 13 16:43:15 2008
Errors in file e:\admin\test1\udump\test1_ora_2768.trc:
ORA-00604: ?? SQL ?? 1 ????
ORA-00988: ???????Wed Feb 13 16:43:15 2008
Errors in file e:\admin\test1\udump\test1_ora_2768.trc:
ORA-01501: CREATE DATABASE ??
ORA-01519: ????? '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' ???? 2356 ???
ORA-00604: ?? SQL ?? 1 ????
ORA-00988: ???????Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Wed Feb 13 16:43:15 2008
Errors in file e:\admin\test1\bdump\test1_reco_2752.trc:
ORA-01519: error while processing file '' near line Wed Feb 13 16:43:15 2008
Errors in file e:\admin\test1\bdump\test1_smon_2748.trc:
ORA-01519: error while processing file '' near line Wed Feb 13 16:43:15 2008
Errors in file e:\admin\test1\bdump\test1_ckpt_2744.trc:
ORA-01519: error while processing file '' near line Wed Feb 13 16:43:15 2008
Errors in file e:\admin\test1\bdump\test1_lgwr_2740.trc:
ORA-01519: error while processing file '' near line Wed Feb 13 16:43:15 2008
Errors in file e:\admin\test1\bdump\test1_dbw0_2736.trc:
ORA-01519: error while processing file '' near line Wed Feb 13 16:43:15 2008
Errors in file e:\admin\test1\bdump\test1_mman_2732.trc:
ORA-01519: error while processing file '' near line Instance terminated by USER, pid = 2768
ORA-1092 signalled during: CREATE DATABASE "test1"
MAXINSTANCES 8
MAXLOGHISTO...