今天我发现了一个有奇怪的问题,以前从来没有遇到过的。ORACLE 10G 它居然会自动停止? 我在网上收了下,说是要看看日志文件,说实话我看不懂!!想请各位大侠看看,帮帮我!!
Dump file c:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log
Mon May 18 09:13:29 2009
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1137M/2046M, Ph+PgF:2958M/3938M, VA:1940M/2047M
Mon May 18 09:13:29 2009
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 = 180355072
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 612368384
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 415236096
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 = 203423744
PMON started with pid=2, OS id=1540
PSP0 started with pid=3, OS id=3524
MMAN started with pid=4, OS id=2704
DBW0 started with pid=5, OS id=4076
LGWR started with pid=6, OS id=3616
CKPT started with pid=7, OS id=3436
SMON started with pid=8, OS id=2864
RECO started with pid=9, OS id=3676
CJQ0 started with pid=10, OS id=548
MMON started with pid=11, OS id=2468
Mon May 18 09:13:30 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=3168
Mon May 18 09:13:30 2009
starting up 1 shared server(s) ...
Mon May 18 09:13:30 2009
alter database mount exclusive
Mon May 18 09:13:34 2009
Setting recovery target incarnation to 2
Mon May 18 09:13:34 2009
Successful mount of redo thread 1, with mount id 1214981562
Mon May 18 09:13:34 2009
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon May 18 09:13:34 2009
alter database open
Mon May 18 09:13:35 2009
Thread 1 opened at log sequence 6
Current log# 2 seq# 6 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1
Mon May 18 09:13:35 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon May 18 09:13:35 2009
SMON: enabling cache recovery
Mon May 18 09:13:36 2009
Successfully onlined Undo Tablespace 1.
Mon May 18 09:13:36 2009
SMON: enabling tx recovery
Mon May 18 09:13:36 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=2600
Mon May 18 09:13:42 2009
Completed: alter database open
Mon May 18 09:13:42 2009
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.
Mon May 18 09:13:49 2009
Starting background process EMN0
EMN0 started with pid=21, OS id=3116
Mon May 18 09:13:49 2009
Shutting down instance: further logons disabled
Mon May 18 09:13:49 2009
Stopping background process QMNC
Mon May 18 09:13:49 2009
Stopping background process CJQ0
Mon May 18 09:13:54 2009
Stopping background process MMNL
Mon May 18 09:13:55 2009
Stopping background process MMON
Mon May 18 09:13:56 2009
Shutting down instance (immediate)
License high water = 2
Mon May 18 09:13:56 2009
Stopping Job queue slave processes
Mon May 18 09:13:56 2009
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Mon May 18 09:14:04 2009
alter database close normal
Mon May 18 09:14:04 2009
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon May 18 09:14:04 2009
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 6
Successful close of redo thread 1
Mon May 18 09:14:05 2009
Completed: alter database close normal
Mon May 18 09:14:05 2009
alter database dismount
Completed: alter database dismount
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
我想知道到底是因为什么导致数据库自动停止?谢谢各位了。
Dump file c:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log
Mon May 18 09:13:29 2009
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1137M/2046M, Ph+PgF:2958M/3938M, VA:1940M/2047M
Mon May 18 09:13:29 2009
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 = 180355072
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 612368384
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 415236096
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 = 203423744
PMON started with pid=2, OS id=1540
PSP0 started with pid=3, OS id=3524
MMAN started with pid=4, OS id=2704
DBW0 started with pid=5, OS id=4076
LGWR started with pid=6, OS id=3616
CKPT started with pid=7, OS id=3436
SMON started with pid=8, OS id=2864
RECO started with pid=9, OS id=3676
CJQ0 started with pid=10, OS id=548
MMON started with pid=11, OS id=2468
Mon May 18 09:13:30 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=3168
Mon May 18 09:13:30 2009
starting up 1 shared server(s) ...
Mon May 18 09:13:30 2009
alter database mount exclusive
Mon May 18 09:13:34 2009
Setting recovery target incarnation to 2
Mon May 18 09:13:34 2009
Successful mount of redo thread 1, with mount id 1214981562
Mon May 18 09:13:34 2009
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon May 18 09:13:34 2009
alter database open
Mon May 18 09:13:35 2009
Thread 1 opened at log sequence 6
Current log# 2 seq# 6 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1
Mon May 18 09:13:35 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon May 18 09:13:35 2009
SMON: enabling cache recovery
Mon May 18 09:13:36 2009
Successfully onlined Undo Tablespace 1.
Mon May 18 09:13:36 2009
SMON: enabling tx recovery
Mon May 18 09:13:36 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=2600
Mon May 18 09:13:42 2009
Completed: alter database open
Mon May 18 09:13:42 2009
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.
Mon May 18 09:13:49 2009
Starting background process EMN0
EMN0 started with pid=21, OS id=3116
Mon May 18 09:13:49 2009
Shutting down instance: further logons disabled
Mon May 18 09:13:49 2009
Stopping background process QMNC
Mon May 18 09:13:49 2009
Stopping background process CJQ0
Mon May 18 09:13:54 2009
Stopping background process MMNL
Mon May 18 09:13:55 2009
Stopping background process MMON
Mon May 18 09:13:56 2009
Shutting down instance (immediate)
License high water = 2
Mon May 18 09:13:56 2009
Stopping Job queue slave processes
Mon May 18 09:13:56 2009
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Mon May 18 09:14:04 2009
alter database close normal
Mon May 18 09:14:04 2009
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon May 18 09:14:04 2009
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 6
Successful close of redo thread 1
Mon May 18 09:14:05 2009
Completed: alter database close normal
Mon May 18 09:14:05 2009
alter database dismount
Completed: alter database dismount
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
我想知道到底是因为什么导致数据库自动停止?谢谢各位了。
Shutting down instance: further logons disabled 应该是被人工关闭的。
然后我没有任何的操作!! 它就关闭了!!
Mon May 18 09:14:04 2009
alter database close normal
我什么操作也没有,它就自动停止了实例!!
connnect /as sysdba
startup nomount
alter database mount
alter database open;启动一下,看看alert中的日志是什么,再粘出来.
根据你的指示,我打了所有的命令,这是日志文件。
Dump file c:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log
Mon May 18 10:01:40 2009
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1150M/2046M, Ph+PgF:2884M/3938M, VA:1940M/2047M
Mon May 18 10:01:40 2009
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 = 184549376
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 612368384
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 411041792
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 = 203423744
PMON started with pid=2, OS id=2908
PSP0 started with pid=3, OS id=3956
MMAN started with pid=4, OS id=3832
DBW0 started with pid=5, OS id=1684
LGWR started with pid=6, OS id=2256
CKPT started with pid=7, OS id=3020
SMON started with pid=8, OS id=2784
RECO started with pid=9, OS id=332
CJQ0 started with pid=10, OS id=2176
MMON started with pid=11, OS id=3328
Mon May 18 10:01:41 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2796
Mon May 18 10:01:41 2009
starting up 1 shared server(s) ...
Mon May 18 10:01:41 2009
alter database mount exclusive
Mon May 18 10:01:45 2009
Setting recovery target incarnation to 2
Mon May 18 10:01:45 2009
Successful mount of redo thread 1, with mount id 1214957829
Mon May 18 10:01:45 2009
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon May 18 10:01:46 2009
alter database open
Mon May 18 10:01:46 2009
Thread 1 opened at log sequence 6
Current log# 2 seq# 6 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1
Mon May 18 10:01:46 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon May 18 10:01:46 2009
SMON: enabling cache recovery
Mon May 18 10:01:48 2009
Successfully onlined Undo Tablespace 1.
Mon May 18 10:01:48 2009
SMON: enabling tx recovery
Mon May 18 10:01:48 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=1660
Mon May 18 10:01:54 2009
Completed: alter database open
Mon May 18 10:01:54 2009
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.
Mon May 18 10:01:57 2009
Starting ORACLE instance (normal)
Mon May 18 10:02:07 2009
Starting ORACLE instance (normal)
Mon May 18 10:02:12 2009
alter database open
ORA-1531 signalled during: alter database open...
Mon May 18 10:02:19 2009
alter database mount
Mon May 18 10:02:19 2009
ORA-1100 signalled during: alter database mount...
Mon May 18 10:02:22 2009
alter database open
ORA-1531 signalled during: alter database open...
Mon May 18 10:02:50 2009
Starting background process EMN0
EMN0 started with pid=21, OS id=3180
Mon May 18 10:02:50 2009
Shutting down instance: further logons disabled
Mon May 18 10:02:50 2009
Stopping background process QMNC
Mon May 18 10:02:51 2009
Stopping background process CJQ0
Mon May 18 10:02:52 2009
Stopping background process MMNL
Mon May 18 10:02:53 2009
Stopping background process MMON
Mon May 18 10:02:54 2009
Shutting down instance (immediate)
License high water = 3
Mon May 18 10:02:54 2009
Stopping Job queue slave processes
Mon May 18 10:02:54 2009
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Mon May 18 10:02:59 2009
PMON failed to acquire latch, see PMON dump
Mon May 18 10:03:02 2009
alter database close normal
Mon May 18 10:03:02 2009
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon May 18 10:03:02 2009
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 6
Successful close of redo thread 1
Mon May 18 10:03:03 2009
Completed: alter database close normal
Mon May 18 10:03:03 2009
alter database dismount
Completed: alter database dismount
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
然后还出现了一些错误,我打出来。
startup mount
无法启动已经运行的ORACLE - 请先关闭它
alter database mount
第一行出现错误:数据库已装载
alter database open
第一行出现错误:实例已打开数据库
根据你的指示,我打了所有的命令,这是日志文件。
Dump file c:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log
Mon May 18 10:01:40 2009
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1150M/2046M, Ph+PgF:2884M/3938M, VA:1940M/2047M
Mon May 18 10:01:40 2009
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 = 184549376
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 612368384
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 411041792
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 = 203423744
PMON started with pid=2, OS id=2908
PSP0 started with pid=3, OS id=3956
MMAN started with pid=4, OS id=3832
DBW0 started with pid=5, OS id=1684
LGWR started with pid=6, OS id=2256
CKPT started with pid=7, OS id=3020
SMON started with pid=8, OS id=2784
RECO started with pid=9, OS id=332
CJQ0 started with pid=10, OS id=2176
MMON started with pid=11, OS id=3328
Mon May 18 10:01:41 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2796
Mon May 18 10:01:41 2009
starting up 1 shared server(s) ...
Mon May 18 10:01:41 2009
alter database mount exclusive
Mon May 18 10:01:45 2009
Setting recovery target incarnation to 2
Mon May 18 10:01:45 2009
Successful mount of redo thread 1, with mount id 1214957829
Mon May 18 10:01:45 2009
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon May 18 10:01:46 2009
alter database open
Mon May 18 10:01:46 2009
Thread 1 opened at log sequence 6
Current log# 2 seq# 6 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1
Mon May 18 10:01:46 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon May 18 10:01:46 2009
SMON: enabling cache recovery
Mon May 18 10:01:48 2009
Successfully onlined Undo Tablespace 1.
Mon May 18 10:01:48 2009
SMON: enabling tx recovery
Mon May 18 10:01:48 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=1660
Mon May 18 10:01:54 2009
Completed: alter database open
Mon May 18 10:01:54 2009
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.
Mon May 18 10:01:57 2009
Starting ORACLE instance (normal)
Mon May 18 10:02:07 2009
Starting ORACLE instance (normal)
Mon May 18 10:02:12 2009
alter database open
ORA-1531 signalled during: alter database open...
Mon May 18 10:02:19 2009
alter database mount
Mon May 18 10:02:19 2009
ORA-1100 signalled during: alter database mount...
Mon May 18 10:02:22 2009
alter database open
ORA-1531 signalled during: alter database open...
Mon May 18 10:02:50 2009
Starting background process EMN0
EMN0 started with pid=21, OS id=3180
Mon May 18 10:02:50 2009
Shutting down instance: further logons disabled
Mon May 18 10:02:50 2009
Stopping background process QMNC
Mon May 18 10:02:51 2009
Stopping background process CJQ0
Mon May 18 10:02:52 2009
Stopping background process MMNL
Mon May 18 10:02:53 2009
Stopping background process MMON
Mon May 18 10:02:54 2009
Shutting down instance (immediate)
License high water = 3
Mon May 18 10:02:54 2009
Stopping Job queue slave processes
Mon May 18 10:02:54 2009
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Mon May 18 10:02:59 2009
PMON failed to acquire latch, see PMON dump
Mon May 18 10:03:02 2009
alter database close normal
Mon May 18 10:03:02 2009
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon May 18 10:03:02 2009
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 6
Successful close of redo thread 1
Mon May 18 10:03:03 2009
Completed: alter database close normal
Mon May 18 10:03:03 2009
alter database dismount
Completed: alter database dismount
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
然后还出现了一些错误,我打出来。
startup mount
无法启动已经运行的ORACLE - 请先关闭它
alter database mount
第一行出现错误:数据库已装载
alter database open
第一行出现错误:实例已打开数据库
但是实例却已经关闭了,不关是数据库连接不上,也不能连接PL/SQL
你这是在你所说的oracle自动关闭前,执行的命令,还是之后这里的提示应该是oracle实例已经打开了,所以有可能是这时候还没有自动关闭吧。
看你的日志原因应该在这里。说一个远程的会话不可用,看是不是有服务有问题啊
先shutdown abort;
再startup mount;
alter database open;
把这一段日志拿出来看下从你的日志看不到什么错误啊。