xp中oracle 10g数据库启动的问题
在win xp 上安装了oracle 10g,然后将另一台机器的数据文件复制过来，覆盖掉xp机器的数据（两台机器的数据库安装目录结构一样），
数据库可以正常连接，但是不能自动启动，开机后需要sqlplus /nolog
conn / as sysdba
startup
高手看看什么原因
最新回复
xlghr (2008-11-04 21:12:47)
cthclan (2008-11-05 09:51:13)
xlghr (2008-11-05 11:51:47)
QUOTE:
好啊，Dump file c:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log
Wed Nov 05 11:20:41 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:725M/1015M, Ph+PgF:2124M/2442M, VA:1940M/2047M
Wed Nov 05 11:20:41 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 58720256
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
nls_language = SIMPLIFIED CHINESE
nls_territory = CHINA
sga_target = 289406976
control_files = D:\ORACLE\ORCL\CONTROL01.CTL, D:\ORACLE\ORCL\CONTROL02.CTL, D:\ORACLE\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 213909504
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = c:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 95420416
MMAN started with pid=4, OS id=1760
PMON started with pid=2, OS id=1536
DBW0 started with pid=5, OS id=1900
LGWR started with pid=6, OS id=1636
CKPT started with pid=7, OS id=276
SMON started with pid=8, OS id=1816
RECO started with pid=9, OS id=392
CJQ0 started with pid=10, OS id=164
MMON started with pid=11, OS id=352
MMNL started with pid=12, OS id=168
PSP0 started with pid=3, OS id=1584
Wed Nov 05 11:20:52 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Nov 05 11:20:55 2008
alter database mount exclusive
Wed Nov 05 11:21:00 2008
Setting recovery target incarnation to 2
Wed Nov 05 11:21:00 2008
Successful mount of redo thread 1, with mount id 1197804055
Wed Nov 05 11:21:00 2008
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed Nov 05 11:21:00 2008
alter database open
Wed Nov 05 11:21:01 2008
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Wed Nov 05 11:21:02 2008
Started redo scan
Wed Nov 05 11:21:02 2008
Completed redo scan
58 redo blocks read, 32 data blocks need recovery
Wed Nov 05 11:21:02 2008
Started redo application at
Thread 1: logseq 340, block 63
Wed Nov 05 11:21:03 2008
Recovery of Online Redo Log: Thread 1 Group 3 Seq 340 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORCL\REDO03.LOG
Wed Nov 05 11:21:03 2008
Completed redo application
Wed Nov 05 11:21:03 2008
Completed crash recovery at
Thread 1: logseq 340, block 121, scn 461224638
32 data blocks read, 32 data blocks written, 58 redo blocks read
Wed Nov 05 11:21:09 2008
Thread 1 advanced to log sequence 341
Thread 1 opened at log sequence 341
Current log# 1 seq# 341 mem# 0: D:\ORACLE\ORCL\REDO01.LOG
Successful open of redo thread 1
Wed Nov 05 11:21:10 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Nov 05 11:21:10 2008
SMON: enabling cache recovery
Wed Nov 05 11:21:15 2008
Successfully onlined Undo Tablespace 1.
Wed Nov 05 11:21:15 2008
SMON: enabling tx recovery
Wed Nov 05 11:21:18 2008
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=1812
Wed Nov 05 11:21:38 2008
Completed: alter database open
Wed Nov 05 11:21:40 2008
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Nov 05 11:22:02 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j001_1920.trc:
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
Wed Nov 05 11:22:05 2008
DEBUG: Replaying xcb 0x1fa3b5d4, pmd 0x1fbafda8 for failed op 8
Doing block recovery for file 2 block 65
No block recovery was needed
Wed Nov 05 11:22:06 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j001_1920.trc:
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
Wed Nov 05 11:22:08 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j001_1920.trc:
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
Wed Nov 05 11:22:10 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j001_1920.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [4194], [40], [49], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [40], [49], [], [], [], [], []
Wed Nov 05 11:22:58 2008
DEBUG: Replaying xcb 0x1fa3b5d4, pmd 0x1fbafda8 for failed op 8
Doing block recovery for file 2 block 65
No block recovery was needed
Wed Nov 05 11:23:00 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_1536.trc:
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
Wed Nov 05 11:23:03 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_1536.trc:
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
PMON: terminating instance due to error 472
Wed Nov 05 11:23:04 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_psp0_1584.trc:
ORA-00472: PMON 进程因错误而终止
Wed Nov 05 11:23:04 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_ckpt_276.trc:
ORA-00472: PMON 进程因错误而终止
Wed Nov 05 11:23:04 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_q001_1648.trc:
ORA-00472: PMON 进程因错误而终止
Wed Nov 05 11:23:06 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_lgwr_1636.trc:
ORA-00472: PMON 进程因错误而终止
Wed Nov 05 11:23:06 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mman_1760.trc:
ORA-00472: PMON 进程因错误而终止
Wed Nov 05 11:23:06 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_dbw0_1900.trc:
ORA-00472: PMON 进程因错误而终止
Wed Nov 05 11:23:06 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_reco_392.trc:
ORA-00472: PMON 进程因错误而终止
Wed Nov 05 11:23:09 2008
Instance terminated by PMON, pid = 1536
Wed Nov 05 11:23:54 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 58720256
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
nls_language = SIMPLIFIED CHINESE
nls_territory = CHINA
sga_target = 289406976
control_files = D:\ORACLE\ORCL\CONTROL01.CTL, D:\ORACLE\ORCL\CONTROL02.CTL, D:\ORACLE\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 213909504
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = c:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 95420416
PMON started with pid=2, OS id=3776
PSP0 started with pid=3, OS id=1536
MMAN started with pid=4, OS id=360
DBW0 started with pid=5, OS id=988
LGWR started with pid=6, OS id=1328
CKPT started with pid=7, OS id=1352
SMON started with pid=8, OS id=2100
RECO started with pid=9, OS id=1580
CJQ0 started with pid=10, OS id=1612
MMON started with pid=11, OS id=112
MMNL started with pid=12, OS id=900
Wed Nov 05 11:23:54 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Nov 05 11:23:54 2008
ALTER DATABASE MOUNT
Wed Nov 05 11:23:59 2008
Setting recovery target incarnation to 2
Wed Nov 05 11:23:59 2008
Successful mount of redo thread 1, with mount id 1197816266
Wed Nov 05 11:23:59 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Wed Nov 05 11:23:59 2008
ALTER DATABASE OPEN
Wed Nov 05 11:23:59 2008
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Wed Nov 05 11:23:59 2008
Started redo scan
Wed Nov 05 11:24:00 2008
Completed redo scan
119 redo blocks read, 37 data blocks need recovery
Wed Nov 05 11:24:00 2008
Started redo application at
Thread 1: logseq 341, block 3
Wed Nov 05 11:24:00 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 341 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORCL\REDO01.LOG
Wed Nov 05 11:24:00 2008
Completed redo application
Wed Nov 05 11:24:01 2008
Completed crash recovery at
Thread 1: logseq 341, block 122, scn 461264031
37 data blocks read, 37 data blocks written, 119 redo blocks read
Wed Nov 05 11:24:03 2008
Thread 1 advanced to log sequence 342
Thread 1 opened at log sequence 342
Current log# 2 seq# 342 mem# 0: D:\ORACLE\ORCL\REDO02.LOG
Successful open of redo thread 1
Wed Nov 05 11:24:03 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Nov 05 11:24:04 2008
SMON: enabling cache recovery
Wed Nov 05 11:24:04 2008
Successfully onlined Undo Tablespace 1.
Wed Nov 05 11:24:04 2008
SMON: enabling tx recovery
Wed Nov 05 11:24:05 2008
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=3748
Wed Nov 05 11:24:14 2008
Completed: ALTER DATABASE OPEN
Wed Nov 05 11:24:15 2008
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Nov 05 11:24:28 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mmon_112.trc:
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
ORA-24033: 没有消息接收人
Wed Nov 05 11:24:31 2008
ORA-600 encountered when generating server alert SMG-4120
Flush retried for xcb 0x1fa2f9f4, pmd 0x1fb9f194
Doing block recovery for file 2 block 65
No block recovery was needed
Wed Nov 05 11:24:32 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mmon_112.trc:
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
Flush retried for xcb 0x1fa2f9f4, pmd 0x1fb9f194
Doing block recovery for file 2 block 65
No block recovery was needed
Wed Nov 05 11:24:35 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mmon_112.trc:
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
Flush retried for xcb 0x1fa2f9f4, pmd 0x1fb9f194
Doing block recovery for file 2 block 65
No block recovery was needed
Wed Nov 05 11:24:38 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mmon_112.trc:
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
ORA-600 encountered when generating server alert SMG-4121
Flush retried for xcb 0x1fa2f9f4, pmd 0x1fb9f194
Doing block recovery for file 2 block 65
No block recovery was needed
Wed Nov 05 11:24:42 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mmon_112.trc:
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
Wed Nov 05 11:24:44 2008
ORA-600 encountered when generating server alert SMG-4121
Wed Nov 05 11:25:00 2008
Flush retried for xcb 0x1fa2f9f4, pmd 0x1fb9f194
Doing block recovery for file 2 block 65
No block recovery was needed
Wed Nov 05 11:25:01 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mmon_112.trc:
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
Flush retried for xcb 0x1fa2f9f4, pmd 0x1fb9f194
Doing block recovery for file 2 block 65
No block recovery was needed
Wed Nov 05 11:25:07 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mmon_112.trc:
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
ORA-600 encountered when generating server alert SMG-4121
Flush retried for xcb 0x1fa2f9f4, pmd 0x1fb9f194
Doing block recovery for file 2 block 65
No block recovery was needed
Wed Nov 05 11:25:11 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mmon_112.trc:
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
Wed Nov 05 11:25:14 2008
ORA-600 encountered when generating server alert SMG-4121
Wed Nov 05 11:25:17 2008
Flush retried for xcb 0x1fa2f9f4, pmd 0x1fb9f194
Doing block recovery for file 2 block 65
No block recovery was needed
Wed Nov 05 11:25:17 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2100.trc:
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
Wed Nov 05 11:25:19 2008
Flush retried for xcb 0x1fa2f9f4, pmd 0x1fb9f194
Wed Nov 05 11:25:19 2008
Non-fatal internal error happenned while SMON was doing shrinking of rollback segments.
SMON encountered 1 out of maximum 100 non-fatal internal errors.
Wed Nov 05 11:25:19 2008
Doing block recovery for file 2 block 65
No block recovery was needed
Wed Nov 05 11:25:20 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_dbw0_988.trc:
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
Wed Nov 05 11:25:22 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_dbw0_988.trc:
ORA-00600: 内部错误代码, 参数: [4194], [40], [49], [], [], [], [], []
DBW0: terminating instance due to error 471
Wed Nov 05 11:25:22 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_q001_392.trc:
ORA-00471: DBWR 进程因错误而终止
Wed Nov 05 11:25:22 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_3776.trc:
ORA-00471: DBWR 进程因错误而终止
Wed Nov 05 11:25:22 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_lgwr_1328.trc:
ORA-00471: DBWR 进程因错误而终止
Wed Nov 05 11:25:22 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j001_3976.trc:
ORA-00449: 后台进程 'LGWR' 因错误 471 异常终止
ORA-00471: DBWR 进程因错误而终止
ORA-00471: DBWR 进程因错误而终止
Wed Nov 05 11:25:23 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j001_3976.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00449: background process 'LGWR' unexpectedly terminated with error 471
ORA-00471: DBWR process terminated with error
ORA-00471: DBWR process terminated with error
Wed Nov 05 11:25:24 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_psp0_1536.trc:
ORA-00471: DBWR 进程因错误而终止
Wed Nov 05 11:25:24 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mman_360.trc:
ORA-00471: DBWR 进程因错误而终止
Wed Nov 05 11:25:24 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_ckpt_1352.trc:
ORA-00471: DBWR 进程因错误而终止
Wed Nov 05 11:25:25 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_reco_1580.trc:
ORA-00471: DBWR 进程因错误而终止
Wed Nov 05 11:25:25 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2100.trc:
ORA-00471: DBWR 进程因错误而终止
Instance terminated by DBW0, pid = 988
(2008-11-05 11:51:47, Size: 3.19 KB, Downloads: 5)
zzWind (2008-11-07 18:16:29)