机器配置
HP RP4440 2*cpu 2G RAM
软件
HP-UX 11.11 oracle 8.17
问题:
数据库建立都没有问题,前端是websphere3.5,现在问题是数据库性能测试时发现oracle seesion
大概只能达到60个左右,设置的processes是300,看log数据startup sessions是335,可是测试时
发现大概达到60个session时oracle就挂了settingsprocesses = 300
sessions = 335
shared_pool_size = 419430400
large_pool_size = 78643200
java_pool_size = 20971520
control_files = /oracle/app/oracle/oradata/sinodb/control01.ctl, /oracle/app/oracle/oradata/sinodb/control02.ctl, /oracle/app/oracle/oradata/sinodb/control03.ctl
db_block_buffers = 51200
db_block_size = 8192
compatible = 8.1.0
log_buffer = 163840
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
distributed_transactions = 10
instance_name = sinodb
service_names = sinodb
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = sinodb
open_cursors = 300
os_authent_prefix =
job_queue_processes = 1
job_queue_interval = 1
background_dump_dest = /oracle/app/oracle/admin/sinodb/bdump
user_dump_dest = /oracle/app/oracle/admin/sinodb/udump
core_dump_dest = /oracle/app/oracle/admin/sinodb/cdump
error
Errors in file /oracle/app/oracle/admin/sinodb/bdump/ckpt_8871_sinodb.trc:
ORA-01110: data file 5: '/oracle/app/oracle/oradata/sinodb/users01.dbf'
ORA-01115: IO error reading block from file 5 (block # 1)
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/oracle/app/oracle/oradata/sinodb/users01.dbf'
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
Wed Mar 2 13:27:33 2005
Errors in file /oracle/app/oracle/admin/sinodb/bdump/ckpt_8871_sinodb.trc:
ORA-01110: data file 6: '/oracle/app/oracle/oradata/sinodb/indx01.dbf'
ORA-01115: IO error reading block from file 6 (block # 1)
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/oracle/app/oracle/oradata/sinodb/users01.dbf'
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
Wed Mar 2 13:27:33 2005
Errors in file /oracle/app/oracle/admin/sinodb/bdump/ckpt_8871_sinodb.trc:
ORA-01110: data file 7: '/oracle/app/oracle/oradata/sinodb/drsys01.dbf'
ORA-01115: IO error reading block from file 7 (block # 1)
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/oracle/app/oracle/oradata/sinodb/users01.dbf'
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
Wed Mar 2 13:27:33 2005
Errors in file /oracle/app/oracle/admin/sinodb/bdump/ckpt_8871_sinodb.trc:
ORA-01110: data file 8: '/oracle/oradata/sinodb/DATA.dbf'
ORA-01115: IO error reading block from file 8 (block # 1)
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/oracle/app/oracle/oradata/sinodb/users01.dbf'
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
Wed Mar 2 13:27:33 2005
Errors in file /oracle/app/oracle/admin/sinodb/bdump/ckpt_8871_sinodb.trc:
ORA-01110: data file 9: '/oracle/oradata/sinodb/HIS_DATA.dbf'
ORA-01115: IO error reading block from file 9 (block # 1)
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/oracle/app/oracle/oradata/sinodb/users01.dbf'
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
Wed Mar 2 13:27:33 2005
CKPT: terminating instance due to error 1242
Instance terminated by CKPT, pid = 8871
Wed Mar 2 13:42:59 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
HP RP4440 2*cpu 2G RAM
软件
HP-UX 11.11 oracle 8.17
问题:
数据库建立都没有问题,前端是websphere3.5,现在问题是数据库性能测试时发现oracle seesion
大概只能达到60个左右,设置的processes是300,看log数据startup sessions是335,可是测试时
发现大概达到60个session时oracle就挂了settingsprocesses = 300
sessions = 335
shared_pool_size = 419430400
large_pool_size = 78643200
java_pool_size = 20971520
control_files = /oracle/app/oracle/oradata/sinodb/control01.ctl, /oracle/app/oracle/oradata/sinodb/control02.ctl, /oracle/app/oracle/oradata/sinodb/control03.ctl
db_block_buffers = 51200
db_block_size = 8192
compatible = 8.1.0
log_buffer = 163840
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
distributed_transactions = 10
instance_name = sinodb
service_names = sinodb
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = sinodb
open_cursors = 300
os_authent_prefix =
job_queue_processes = 1
job_queue_interval = 1
background_dump_dest = /oracle/app/oracle/admin/sinodb/bdump
user_dump_dest = /oracle/app/oracle/admin/sinodb/udump
core_dump_dest = /oracle/app/oracle/admin/sinodb/cdump
error
Errors in file /oracle/app/oracle/admin/sinodb/bdump/ckpt_8871_sinodb.trc:
ORA-01110: data file 5: '/oracle/app/oracle/oradata/sinodb/users01.dbf'
ORA-01115: IO error reading block from file 5 (block # 1)
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/oracle/app/oracle/oradata/sinodb/users01.dbf'
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
Wed Mar 2 13:27:33 2005
Errors in file /oracle/app/oracle/admin/sinodb/bdump/ckpt_8871_sinodb.trc:
ORA-01110: data file 6: '/oracle/app/oracle/oradata/sinodb/indx01.dbf'
ORA-01115: IO error reading block from file 6 (block # 1)
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/oracle/app/oracle/oradata/sinodb/users01.dbf'
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
Wed Mar 2 13:27:33 2005
Errors in file /oracle/app/oracle/admin/sinodb/bdump/ckpt_8871_sinodb.trc:
ORA-01110: data file 7: '/oracle/app/oracle/oradata/sinodb/drsys01.dbf'
ORA-01115: IO error reading block from file 7 (block # 1)
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/oracle/app/oracle/oradata/sinodb/users01.dbf'
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
Wed Mar 2 13:27:33 2005
Errors in file /oracle/app/oracle/admin/sinodb/bdump/ckpt_8871_sinodb.trc:
ORA-01110: data file 8: '/oracle/oradata/sinodb/DATA.dbf'
ORA-01115: IO error reading block from file 8 (block # 1)
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/oracle/app/oracle/oradata/sinodb/users01.dbf'
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
Wed Mar 2 13:27:33 2005
Errors in file /oracle/app/oracle/admin/sinodb/bdump/ckpt_8871_sinodb.trc:
ORA-01110: data file 9: '/oracle/oradata/sinodb/HIS_DATA.dbf'
ORA-01115: IO error reading block from file 9 (block # 1)
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/oracle/app/oracle/oradata/sinodb/users01.dbf'
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3
Wed Mar 2 13:27:33 2005
CKPT: terminating instance due to error 1242
Instance terminated by CKPT, pid = 8871
Wed Mar 2 13:42:59 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/oracle/app/oracle/oradata/sinodb/users01.dbf'
ORA-27041: unable to open file
数据文件出现坏块了吧?如果是session上不去了..查看系统的进程数设置和信号量设置
shared_pool_size = 419430400
large_pool_size = 78643200
你看下'/oracle/app/oracle/oradata/sinodb/users01.dbf这个文件所在的表空间有没有人使用如果没有人使用可以删除这个文件
$svrmgrl
svrmgrl>connect internal
svrmgrl>alter database datafile 下'/oracle/app/oracle/oradata/sinodb/users01.dbf' offline drop;
因为这个文件有坏块,只要访问到这个块的时候都会有错误。
data file 5: '/oracle/app/oracle/oradata/sinodb/users01.dbf'
data file 6: '/oracle/app/oracle/oradata/sinodb/indx01.dbf'
data file 7: '/oracle/app/oracle/oradata/sinodb/drsys01.dbf'
data file 8: '/oracle/oradata/sinodb/DATA.dbf'
data file 9: '/oracle/oradata/sinodb/HIS_DATA.dbf'
database in NOARCHIVELOG mode
session上不去,应该是pga/uga中sort_area_size等参数设置问题吧~
(一家之言)