TITLE: ORA-27300, ORA-27301 and ORA-27302 on w2003 with /PAE
681805Jan 27 2009 — edited Feb 12 2009Dear all,
I have a win2003R2 cluster with Oracle 10g 10.2.0.3 and the machines have 2 Quadcore with 16GB of RAM.
On high load oracle starts giving error and not accepting new connections. The errors are the following:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: Not enough storage is available to process this command.
ORA-27302: failure occurred at: ssthrddcr
The system is using /PAE extension so it can address more phisical memory for the SGA, but not the /3G due to constant system errors if I enable it.
This is the init.ora file:
*.audit_file_dest='r:\admin/INSTANCE/adump'
*.background_dump_dest='r:\admin/INSTANCE/bdump'
*.compatible='10.2.0.1.0'
*.control_files='R:\ORADATA\INSTANCE\control01.ctl','R:\ORADATA\INSTANCE\control02.ctl','R:\ORADATA\INSTANCE\control03.ctl'
*.core_dump_dest='r:\admin/INSTANCE/cdump'
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='SAVAC'
*.db_recovery_file_dest='S:\flash_recovery_area'
*.db_recovery_file_dest_size=150G
*.log_archive_dest_1='location=r:\archivelog'
*.log_archive_dest_10='location=s:\flash_recovery_area\archivelog\'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=INSTANCEXDB)'
*.job_queue_processes=10
*.open_cursors=6000
*.processes=500
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='r:\admin/INSTANCE/udump'
local_listener="(ADDRESS=(PROTOCOL=TCP)(HOST=***.***.***.***)(PORT=1521))"
*.use_indirect_data_buffers=true
*.db_block_size=8192
*.db_block_buffers=655360
*.java_pool_size=4194304
*.large_pool_size=4194304
*.shared_pool_size=444719513
*.pga_aggregate_target=310M
*.utl_file_dir='S:\utl'
*._kgl_large_heap_warning_threshold=0
*.event='10195 TRACE NAME CONTEXT FOREVER'
*.trace_enabled=FALSE
*.sessions=555
*.undo_retention=900
We recently upgraded from 10.2.0.2, so it seemed to be a reported bug, but the problem persists. Keeping SGA size below 700MB seem to avoid the error but is giving huge performance problems.
Any help/advice would be highly appreciated.
Ton.