oracle 作业 断开原因,oracle 每隔一段时间就会断开连接咋回事。

本帖最后由 fh2002 于 2012-2-29 10:53 编辑

这机器以前还好好的。最近几天经常出现，oracle运行一段时间之后就连不上了。查询报表的时候报错如下：java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12518)(ERROR_STACK=(ERROR=(CODE=12518)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(BUF='32-bit WindowsError: 233: Unknown error'))))

奇怪的是，登录用户的时候能正常登录，登录之后首页还有一些其它查询表的操作也正常，不会出现上述错误，只有在查询报表的时候会出现上述问题！出现问题之后我用sqlplus、plsql/dev、toda都连接不上数据库，再重启应用系统，也照样连接不上。重启oracle服务之后就一切正常了。我看了一下，数据的DBF文件大小有31G多了。各位帮我看看是什么问题，下面是日志(我昨天重启oracle之后和今天重启oracle时间之间的)：

Tue Feb 28 14:05:20 2012

ksvcreate: Process(m000) creation failed

Tue Feb 28 14:07:23 2012

ksvcreate: Process(m000) creation failed

Tue Feb 28 14:09:23 2012

kkjcre1p: unable to spawn jobq slave process

Tue Feb 28 14:09:23 2012

Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_cjq0_1652.trc:

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       = 88080384

__large_pool_size        = 4194304

__java_pool_size         = 4194304

__streams_pool_size      = 0

spfile                   = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA

sga_target               = 612368384

control_files            = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL

db_block_size            = 8192

__db_cache_size          = 507510784

compatible               = 10.2.0.1.0

db_file_multiblock_read_count= 16

db_recovery_file_dest    = D:\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          = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP

background_dump_dest     = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP

user_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP

core_dump_dest           = D:\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=3600

MMAN started with pid=4, OS id=1612

DBW0 started with pid=5, OS id=3852

DBW1 started with pid=6, OS id=3856

LGWR started with pid=7, OS id=604

CKPT started with pid=8, OS id=1896

SMON started with pid=9, OS id=1208

RECO started with pid=10, OS id=3624

CJQ0 started with pid=11, OS id=972

MMON started with pid=12, OS id=1156

MMNL started with pid=13, OS id=3440

Tue Feb 28 14:11:22 2012

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

starting up 1 shared server(s) ...

Tue Feb 28 14:11:22 2012

alter database mount exclusive

PSP0 started with pid=3, OS id=3528

Tue Feb 28 14:11:27 2012

Setting recovery target incarnation to 2

Tue Feb 28 14:11:27 2012

Successful mount of redo thread 1, with mount id 1304200714

Tue Feb 28 14:11:27 2012

Database mounted in Exclusive Mode

Completed: alter database mount exclusive

Tue Feb 28 14:11:27 2012

alter database open

Tue Feb 28 14:11:27 2012

Beginning crash recovery of 1 threads

parallel recovery started with 11 processes

Tue Feb 28 14:11:28 2012

Started redo scan

Tue Feb 28 14:11:28 2012

Completed redo scan

15 redo blocks read, 3 data blocks need recovery

Tue Feb 28 14:11:28 2012

Started redo application at

Thread 1: logseq 23258, block 66098

Tue Feb 28 14:11:28 2012

Recovery of Online Redo Log: Thread 1 Group 1 Seq 23258 Reading mem 0

Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG

Tue Feb 28 14:11:28 2012

Completed redo application

Tue Feb 28 14:11:28 2012

Completed crash recovery at

Thread 1: logseq 23258, block 66113, scn 511382757

3 data blocks read, 3 data blocks written, 15 redo blocks read

Tue Feb 28 14:11:29 2012

Thread 1 advanced to log sequence 23259

Thread 1 opened at log sequence 23259

Current log# 2 seq# 23259 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG

Successful open of redo thread 1

Tue Feb 28 14:11:29 2012

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Tue Feb 28 14:11:29 2012

SMON: enabling cache recovery

Tue Feb 28 14:11:29 2012

Successfully onlined Undo Tablespace 1.

Tue Feb 28 14:11:29 2012

SMON: enabling tx recovery

Tue Feb 28 14:11:29 2012

Database Characterset is ZHS16GBK

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

QMNC started with pid=28, OS id=608

Tue Feb 28 14:11:32 2012

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.

Tue Feb 28 14:11:33 2012

Completed: alter database open

Tue Feb 28 14:17:58 2012

Memory Notification: Library Cache Object loaded into SGA

Heap size 2201K exceeds notification threshold (2048K)

KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Tue Feb 28 14:17:58 2012

Memory Notification: Library Cache Object loaded into SGA

Heap size 2160K exceeds notification threshold (2048K)

Details in trace file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_112.trc

KGL object name :XDB.XDZynXpO5DTv2jNMI2jLTZZA==

Tue Feb 28 14:53:21 2012

Thread 1 advanced to log sequence 23260

Current log# 3 seq# 23260 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG

Tue Feb 28 14:54:25 2012

Thread 1 advanced to log sequence 23261

Current log# 1 seq# 23261 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG

Tue Feb 28 15:15:08 2012

Thread 1 advanced to log sequence 23262

Current log# 2 seq# 23262 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG

Tue Feb 28 16:03:41 2012

Thread 1 advanced to log sequence 23263

Current log# 3 seq# 23263 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG

Tue Feb 28 18:21:03 2012

Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_ora_652.trc:

ORA-00610: Internal error code

Tue Feb 28 18:42:29 2012

Process J000 died, see its trace file

Tue Feb 28 18:43:09 2012

kkjcre1p: unable to spawn jobq slave process

Tue Feb 28 18:44:29 2012

Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_cjq0_972.trc:

Tue Feb 28 19:01:29 2012

Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_ora_3068.trc:

ORA-00610: Internal error code

Tue Feb 28 19:01:30 2012

Process J000 died, see its trace file

Tue Feb 28 19:01:30 2012

kkjcre1p: unable to spawn jobq slave process

Tue Feb 28 19:01:30 2012

Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_cjq0_972.trc:

Tue Feb 28 21:24:08 2012

Thread 1 advanced to log sequence 23264

Current log# 1 seq# 23264 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG

Tue Feb 28 22:11:39 2012

Thread 1 advanced to log sequence 23265

Current log# 2 seq# 23265 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG

Wed Feb 29 08:04:24 2012

Thread 1 advanced to log sequence 23266

Current log# 3 seq# 23266 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG

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       = 96468992

__large_pool_size        = 4194304

__java_pool_size         = 4194304

__streams_pool_size      = 0

spfile                   = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA

sga_target               = 612368384

control_files            = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL

db_block_size            = 8192

__db_cache_size          = 499122176

compatible               = 10.2.0.1.0

db_file_multiblock_read_count= 16

db_recovery_file_dest    = D:\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          = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP

background_dump_dest     = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP

user_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP

core_dump_dest           = D:\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=3664

MMAN started with pid=4, OS id=3076

DBW0 started with pid=5, OS id=3912

DBW1 started with pid=6, OS id=1712

LGWR started with pid=7, OS id=1244

CKPT started with pid=8, OS id=2508

SMON started with pid=9, OS id=3772

RECO started with pid=10, OS id=2812

CJQ0 started with pid=11, OS id=2096

MMON started with pid=12, OS id=2864

MMNL started with pid=13, OS id=1044

Wed Feb 29 09:45:55 2012

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

starting up 1 shared server(s) ...

Wed Feb 29 09:45:55 2012

alter database mount exclusive

PSP0 started with pid=3, OS id=3896

Wed Feb 29 09:46:00 2012

Setting recovery target incarnation to 2

Wed Feb 29 09:46:00 2012

Successful mount of redo thread 1, with mount id 1304287827

Wed Feb 29 09:46:00 2012

Database mounted in Exclusive Mode

Completed: alter database mount exclusive

Wed Feb 29 09:46:00 2012

alter database open

Wed Feb 29 09:46:00 2012

Beginning crash recovery of 1 threads

parallel recovery started with 11 processes

Wed Feb 29 09:46:00 2012

Started redo scan

Wed Feb 29 09:46:01 2012

Completed redo scan

45 redo blocks read, 22 data blocks need recovery

Wed Feb 29 09:46:01 2012

Started redo application at

Thread 1: logseq 23266, block 35822

Wed Feb 29 09:46:01 2012