请教ORACLE的RAC的04031错误解决办法

咯咯 发布于 2012/06/18 18:14
阅读 333
收藏 0

@宏哥 你好,想跟你请教个问题:

对于ORACLE的RAC,总是报ORA04031,不知有什么好的办法解决,希望得到你的帮助!

ORACLE版本是:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi

操作系统是:Red Hat Enterprise Linux Server release 5.4 (Tikanga),内存4G。

oracle配置参数:

audit_file_dest='/opt/ora10g/admin/RACDB/adump'
background_dump_dest='/opt/ora10g/admin/RACDB/bdump'
cluster_database_instances=2
cluster_database=true
compatible='10.2.0.1.0'
control_files='+RAC_DISK/racdb/controlfile/current.256.783708123'
core_dump_dest='/opt/ora10g/admin/RACDB/cdump'
db_block_size=8192
db_create_file_dest='+RAC_DISK'
db_domain=''
db_file_multiblock_read_count=16
db_name='RACDB'
dispatchers='(protocol=TCP)(serv=RACDB)(list=RACDB)(poo=on)(disp=5)(conn=33)(sess=224)'
RACDB2.instance_number=2
RACDB1.instance_number=1
*.db_cache_size=256m
*.java_pool_size=10m
*.large_pool_size=320m
job_queue_processes=10
license_max_sessions=400
license_max_users=14
license_sessions_warning=260
RACDB1.local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.230) (PORT = 1521))'
RACDB2.local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.231) (PORT = 1521))'
max_dispatchers=20
max_shared_servers=36
open_cursors=45
pga_aggregate_target=754974720
processes=380
remote_listener='LISTENERS_RACDB'
RACDB1.remote_listener=''
RACDB2.remote_listener=''
remote_login_passwordfile='exclusive'
sessions=355
sga_target=1624m
*.sga_max_size=1600m
*.shared_pool_size=600m
*.shared_pool_reserved_size=60m
shared_servers=3
sort_area_size=537534208
RACDB2.thread=2
RACDB1.thread=1
transactions=918
undo_management='AUTO'
RACDB1.undo_tablespace='UNDOTBS1'
RACDB2.undo_tablespace='UNDOTBS2'
user_dump_dest='/opt/ora10g/admin/RACDB/udump'

返回顶部
顶部