oracle数据库连接自动关闭,oracle数据库 一直自动关闭，求解决

本帖最后由 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)

有什么方法可以解决的...在线等...