买了张oracle10g的安装盘,安装的时候,禁止了创建启动数据库,安装完成后,在用DBCA创建数据库时提示ORA-01092:ORACLE instance terminated. 我连续选择几个忽略,又出现ORA-01034:ORACLE not available.错误,这回忽略也过不去了!!!
我是在windows XP xp2下安装的,数据库名我起的是dongfangbai.suo,SID是dongfangbai,以下是alert_dongfangbai.log文件的内容,大家看看究竟是什么原因!!!!
Dump file f:\oracle\product\10.1.0\admin\dongfangbai\bdump\alert_dongfangbai.log
Sat Jun 14 08:28:17 2008
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity: 0x00000000
Memory (A/P) : PH:61M/383M, PG:446M/922M, VA:1958M/2047M
Sat Jun 14 08:28:17 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 2 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 = F:\ORACLE\PRODUCT\10.1.0\ORADATA\DONGFANGBAI\CONTROL01.CTL, F:\ORACLE\PRODUCT\10.1.0\ORADATA\DONGFANGBAI\CONTROL02.CTL, F:\ORACLE\PRODUCT\10.1.0\ORADATA\DONGFANGBAI\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 = F:\oracle\product\10.1.0\flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain = suo
dispatchers = (PROTOCOL=TCP) (SERVICE=dongfangbaiXDB)
job_queue_processes = 10
background_dump_dest = F:\ORACLE\PRODUCT\10.1.0\ADMIN\DONGFANGBAI\BDUMP
user_dump_dest = F:\ORACLE\PRODUCT\10.1.0\ADMIN\DONGFANGBAI\UDUMP
core_dump_dest = F:\ORACLE\PRODUCT\10.1.0\ADMIN\DONGFANGBAI\CDUMP
sort_area_size = 65536
db_name = dongfang
db_unique_name = dongfangbai
open_cursors = 300
pga_aggregate_target = 25165824
PMON started with pid=2, OS id=3380
MMAN started with pid=3, OS id=2116
DBW0 started with pid=4, OS id=3836
LGWR started with pid=5, OS id=3724
CKPT started with pid=6, OS id=464
SMON started with pid=7, OS id=3988
RECO started with pid=8, OS id=3584
Sat Jun 14 08:29:24 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Jun 14 08:29:25 2008
starting up 1 shared server(s) ...
CJQ0 started with pid=9, OS id=2552
Sat Jun 14 08:29:41 2008
CREATE DATABASE "dongfang"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'F:\oracle\product\10.1.0\oradata\dongfangbai\system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'F:\oracle\product\10.1.0\oradata\dongfangbai\sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'F:\oracle\product\10.1.0\oradata\dongfangbai\temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'F:\oracle\product\10.1.0\oradata\dongfangbai\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('F:\oracle\product\10.1.0\oradata\dongfangbai\redo01.log') SIZE 10240K,
GROUP 2 ('F:\oracle\product\10.1.0\oradata\dongfangbai\redo02.log') SIZE 10240K,
GROUP 3 ('F:\oracle\product\10.1.0\oradata\dongfangbai\redo03.log') SIZE 10240K
USER SYS IDENTIFIED BY *USER SYSTEM IDENTIFIED BY
Sat Jun 14 08:29:42 2008
Controlfile identified with block size 16384
Sat Jun 14 08:29:42 2008
Controlfile created with 174 blocks of size 16384 bytes
Sat Jun 14 08:29:42 2008
Published database character set on system events channel
Sat Jun 14 08:29:50 2008
All processes have switched to database character set
Database mounted in Exclusive Mode.
Sat Jun 14 08:29:52 2008
Successful mount of redo thread 1, with mount id 7043253
Assigning activation ID 7043253 (0x6b78b5)
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: F:\ORACLE\PRODUCT\10.1.0\ORADATA\DONGFANGBAI\REDO01.LOG
Successful open of redo thread 1
Sat Jun 14 08:29:53 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Jun 14 08:29:53 2008
SMON: enabling cache recovery
Sat Jun 14 08:29:53 2008
create tablespace SYSTEM datafile 'F:\oracle\product\10.1.0\oradata\dongfangbai\system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL onlineSat Jun 14 08:30:07 2008
Completed: create tablespace SYSTEM datafile 'F:\oracle\prod
Sat Jun 14 08:30:07 2008
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)Completed: create rollback segment SYSTEM tablespace SYSTEM
Sat Jun 14 08:30:09 2008
Errors in file f:\oracle\product\10.1.0\admin\dongfangbai\udump\dongfangbai_ora_3088.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00988: missing or invalid password(s)Sat Jun 14 08:30:09 2008
Errors in file f:\oracle\product\10.1.0\admin\dongfangbai\udump\dongfangbai_ora_3088.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 2356
ORA-00604: error occurred at recursive SQL level 1
ORA-00988: missing or invalid password(s)Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Sat Jun 14 08:30:10 2008
Errors in file f:\oracle\product\10.1.0\admin\dongfangbai\bdump\dongfangbai_reco_3584.trc:
ORA-01519: error while processing file '' near line Sat Jun 14 08:30:10 2008
Errors in file f:\oracle\product\10.1.0\admin\dongfangbai\bdump\dongfangbai_smon_3988.trc:
ORA-01519: error while processing file '' near line Sat Jun 14 08:30:10 2008
Errors in file f:\oracle\product\10.1.0\admin\dongfangbai\bdump\dongfangbai_lgwr_3724.trc:
ORA-01519: error while processing file '' near line Sat Jun 14 08:30:10 2008
Errors in file f:\oracle\product\10.1.0\admin\dongfangbai\bdump\dongfangbai_ckpt_464.trc:
ORA-01519: error while processing file '' near line Sat Jun 14 08:30:10 2008
Errors in file f:\oracle\product\10.1.0\admin\dongfangbai\bdump\dongfangbai_dbw0_3836.trc:
ORA-01519: error while processing file '' near line Sat Jun 14 08:30:10 2008
Errors in file f:\oracle\product\10.1.0\admin\dongfangbai\bdump\dongfangbai_mman_2116.trc:
ORA-01519: error while processing file '' near line Instance terminated by USER, pid = 3088
ORA-1092 signalled during: CREATE DATABASE "dongfang"
MAXINSTANCES 8
MAXLOGHI...
Sat Jun 14 08:30:50 2008
Shutting down instance (abort)
我是在windows XP xp2下安装的,数据库名我起的是dongfangbai.suo,SID是dongfangbai,以下是alert_dongfangbai.log文件的内容,大家看看究竟是什么原因!!!!
Dump file f:\oracle\product\10.1.0\admin\dongfangbai\bdump\alert_dongfangbai.log
Sat Jun 14 08:28:17 2008
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity: 0x00000000
Memory (A/P) : PH:61M/383M, PG:446M/922M, VA:1958M/2047M
Sat Jun 14 08:28:17 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 2 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 = F:\ORACLE\PRODUCT\10.1.0\ORADATA\DONGFANGBAI\CONTROL01.CTL, F:\ORACLE\PRODUCT\10.1.0\ORADATA\DONGFANGBAI\CONTROL02.CTL, F:\ORACLE\PRODUCT\10.1.0\ORADATA\DONGFANGBAI\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 = F:\oracle\product\10.1.0\flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain = suo
dispatchers = (PROTOCOL=TCP) (SERVICE=dongfangbaiXDB)
job_queue_processes = 10
background_dump_dest = F:\ORACLE\PRODUCT\10.1.0\ADMIN\DONGFANGBAI\BDUMP
user_dump_dest = F:\ORACLE\PRODUCT\10.1.0\ADMIN\DONGFANGBAI\UDUMP
core_dump_dest = F:\ORACLE\PRODUCT\10.1.0\ADMIN\DONGFANGBAI\CDUMP
sort_area_size = 65536
db_name = dongfang
db_unique_name = dongfangbai
open_cursors = 300
pga_aggregate_target = 25165824
PMON started with pid=2, OS id=3380
MMAN started with pid=3, OS id=2116
DBW0 started with pid=4, OS id=3836
LGWR started with pid=5, OS id=3724
CKPT started with pid=6, OS id=464
SMON started with pid=7, OS id=3988
RECO started with pid=8, OS id=3584
Sat Jun 14 08:29:24 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Jun 14 08:29:25 2008
starting up 1 shared server(s) ...
CJQ0 started with pid=9, OS id=2552
Sat Jun 14 08:29:41 2008
CREATE DATABASE "dongfang"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'F:\oracle\product\10.1.0\oradata\dongfangbai\system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'F:\oracle\product\10.1.0\oradata\dongfangbai\sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'F:\oracle\product\10.1.0\oradata\dongfangbai\temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'F:\oracle\product\10.1.0\oradata\dongfangbai\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('F:\oracle\product\10.1.0\oradata\dongfangbai\redo01.log') SIZE 10240K,
GROUP 2 ('F:\oracle\product\10.1.0\oradata\dongfangbai\redo02.log') SIZE 10240K,
GROUP 3 ('F:\oracle\product\10.1.0\oradata\dongfangbai\redo03.log') SIZE 10240K
USER SYS IDENTIFIED BY *USER SYSTEM IDENTIFIED BY
Sat Jun 14 08:29:42 2008
Controlfile identified with block size 16384
Sat Jun 14 08:29:42 2008
Controlfile created with 174 blocks of size 16384 bytes
Sat Jun 14 08:29:42 2008
Published database character set on system events channel
Sat Jun 14 08:29:50 2008
All processes have switched to database character set
Database mounted in Exclusive Mode.
Sat Jun 14 08:29:52 2008
Successful mount of redo thread 1, with mount id 7043253
Assigning activation ID 7043253 (0x6b78b5)
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: F:\ORACLE\PRODUCT\10.1.0\ORADATA\DONGFANGBAI\REDO01.LOG
Successful open of redo thread 1
Sat Jun 14 08:29:53 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Jun 14 08:29:53 2008
SMON: enabling cache recovery
Sat Jun 14 08:29:53 2008
create tablespace SYSTEM datafile 'F:\oracle\product\10.1.0\oradata\dongfangbai\system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL onlineSat Jun 14 08:30:07 2008
Completed: create tablespace SYSTEM datafile 'F:\oracle\prod
Sat Jun 14 08:30:07 2008
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)Completed: create rollback segment SYSTEM tablespace SYSTEM
Sat Jun 14 08:30:09 2008
Errors in file f:\oracle\product\10.1.0\admin\dongfangbai\udump\dongfangbai_ora_3088.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00988: missing or invalid password(s)Sat Jun 14 08:30:09 2008
Errors in file f:\oracle\product\10.1.0\admin\dongfangbai\udump\dongfangbai_ora_3088.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 2356
ORA-00604: error occurred at recursive SQL level 1
ORA-00988: missing or invalid password(s)Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Sat Jun 14 08:30:10 2008
Errors in file f:\oracle\product\10.1.0\admin\dongfangbai\bdump\dongfangbai_reco_3584.trc:
ORA-01519: error while processing file '' near line Sat Jun 14 08:30:10 2008
Errors in file f:\oracle\product\10.1.0\admin\dongfangbai\bdump\dongfangbai_smon_3988.trc:
ORA-01519: error while processing file '' near line Sat Jun 14 08:30:10 2008
Errors in file f:\oracle\product\10.1.0\admin\dongfangbai\bdump\dongfangbai_lgwr_3724.trc:
ORA-01519: error while processing file '' near line Sat Jun 14 08:30:10 2008
Errors in file f:\oracle\product\10.1.0\admin\dongfangbai\bdump\dongfangbai_ckpt_464.trc:
ORA-01519: error while processing file '' near line Sat Jun 14 08:30:10 2008
Errors in file f:\oracle\product\10.1.0\admin\dongfangbai\bdump\dongfangbai_dbw0_3836.trc:
ORA-01519: error while processing file '' near line Sat Jun 14 08:30:10 2008
Errors in file f:\oracle\product\10.1.0\admin\dongfangbai\bdump\dongfangbai_mman_2116.trc:
ORA-01519: error while processing file '' near line Instance terminated by USER, pid = 3088
ORA-1092 signalled during: CREATE DATABASE "dongfang"
MAXINSTANCES 8
MAXLOGHI...
Sat Jun 14 08:30:50 2008
Shutting down instance (abort)
手动建库我不会呀,我是新手,就想学学oracle,没想到一开始就,哎!!!