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