本帖最後由 aries19900409 于 2012-8-7 17:13 編輯
oracle 資料庫一直自動關閉，别人告訴我的說看一下 alert.log
内容如下：
Tue Aug 07 16:45:35 2012
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=21, OS id=3512
Tue Aug 07 16:45:41 2012
Completed: ALTER DATABASE OPEN
Tue Aug 07 16:46:55 2012
Starting background process EMN0
EMN0 started with pid=25, OS id=3144
Tue Aug 07 16:46:55 2012
Shutting down instance: further logons disabled
Tue Aug 07 16:46:55 2012
Stopping background process QMNC
Tue Aug 07 16:46:56 2012
Stopping background process CJQ0
Tue Aug 07 16:46:56 2012
Stopping background process MMNL
Tue Aug 07 16:46:57 2012
Stopping background process MMON
Tue Aug 07 16:46:58 2012
Shutting down instance (immediate)
License high water mark = 4
Tue Aug 07 16:46:58 2012
Stopping Job queue slave processes
Tue Aug 07 16:46:58 2012
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Tue Aug 07 16:47:12 2012
alter database close
Tue Aug 07 16:47:13 2012
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Aug 07 16:47:13 2012
Shutting down archive processes
Archiving is disabled
Tue Aug 07 16:47:18 2012
ARCH shutting down
ARC2: Archival stopped
Tue Aug 07 16:47:23 2012
ARCH shutting down
ARC1: Archival stopped
Tue Aug 07 16:47:28 2012
ARCH shutting down
ARC0: Archival stopped
Tue Aug 07 16:47:29 2012
Thread 1 closed at log sequence 52
Successful close of redo thread 1
Tue Aug 07 16:47:29 2012
Completed: alter database close
Tue Aug 07 16:47:29 2012
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
Tue Aug 07 16:48:13 2012
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 = 444596224
__large_pool_size = 8388608
__java_pool_size = 8388608
__streams_pool_size = 0
nls_language = SIMPLIFIED CHINESE
nls_territory = CHINA
sga_target = 1174405120
control_files = E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 704643072
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = E:\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 = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 176160768
PMON started with pid=2, OS id=3628
PSP0 started with pid=3, OS id=2144
MMAN started with pid=4, OS id=1176
DBW0 started with pid=5, OS id=3912
LGWR started with pid=6, OS id=2548
CKPT started with pid=7, OS id=2808
SMON started with pid=8, OS id=3340
RECO started with pid=9, OS id=252
CJQ0 started with pid=10, OS id=3428
MMON started with pid=11, OS id=3992
Tue Aug 07 16:48:13 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Aug 07 16:48:13 2012
starting up 1 shared server(s) ...
Tue Aug 07 16:48:14 2012
alter database mount
MMNL started with pid=12, OS id=1336
Tue Aug 07 16:48:18 2012
Setting recovery target incarnation to 1
Tue Aug 07 16:48:18 2012
Successful mount of redo thread 1, with mount id 1318482254
Tue Aug 07 16:48:18 2012
Database mounted in Exclusive Mode
Completed: alter database mount
Tue Aug 07 16:48:31 2012
alter database mount
Tue Aug 07 16:48:31 2012
ORA-1100 signalled during: alter database mount...
Tue Aug 07 16:49:54 2012
Starting ORACLE instance (normal)
有什麼方法可以解決的...線上等...