Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Catpatch.sql Problem
Dan:
I had no problems except for a couple extents that hit their max in the system table space. Below are my init.ora parameters, they're from a TEST Oracle Apps instance.
HTH,
Pete's
##################################################################
############## START OF INIT.ORA PARAMETERS ##################
##################################################################
control_files = (/oracle/xAPPS/d01/control01.ctl)
audit_trail = os # none, db, or os audit_file_dest = /oracle/apps11/xAPPSdb/9.2.0/admin/audit
background_dump_dest = /oracle/apps11/xAPPSdb/9.2.0/admin/bdump
core_dump_dest = /oracle/apps11/xAPPSdb/9.2.0/admin/cdump user_dump_dest = /oracle/apps11/xAPPSdb/9.2.0/admin/udump utl_file_dir =
# _trace_files_public = true # allow public to see trace files
db_block_size = 8192
db_name = xAPPS db_domain = .world db_files = 1022 global_names = true
# gc_db_locks = 1
rollback_segments = (rbs1, rbs2, rbs3, rbs4)
# rollback_segments = (rbs1, rbs2, rbs3, rbs4, rbs5)
# open_cursors = 1000
open_cursors = 4000 # changed for 8.1.7 10.7 db_file_multiblock_read_count = 30 # LARGE
#db_block_buffers = 9600 # LARGE
#db_block_buffers = 10200
#db_block_buffers = 14400
db_block_buffers = 10000
#db_block_buffers = 20000
#db_block_buffers = 24000
#shared_pool_size = 98304000
#hared_pool_size = 121440000
#shared_pool_size = 30000000
shared_pool_size = 300000000
shared_pool_reserved_size = 3000000
# shared_pool_reserved_min_alloc = 10000 obsolete 817
# checkpoint_process = true obsolete 817
log_archive_start = true # if you want automatic archiving
log_archive_dest = /oracle/xAPPS/a01 log_archive_format = "xAPPS%S.arc"
# log_buffer = 655360
log_buffer = 1048576 # add more for 8.1.7 10.7 log_checkpoint_interval = 10000
processes = 200 # LARGE dml_locks = 1000 # LARGEMeg each
# sequence_cache_entries = 10 obsolete 817 # SMALL
# sequence_cache_hash_buckets = 10 obsolete 817 # SMALL
# async_write = true obsolete 817
# timed_statistics = true # if you want timed statistics
max_dump_file_size = 10240 # limit trace file size to 5
# sql_trace = true
enqueue_resources = 15000
#sort_area_size = 256000 # N/A for 9.2
row_locking = always
# event requested by blind
# event="10076 trace name context forever, level 1"
# added for 817 10.7 apps
# event="10929 trace name context forever" # No longer for 9.2.0.2 &
11.5.7
# event="10932 trace name context level 2" # N/A for 9.2.0.2 & 11.5.7
# AD requires this date format
nls_date_format = DD-MON-RR nls_language = AMERICAN nls_numeric_characters = ".," nls_sort = binary nls_territory = AMERICA compatible = 8.1.7.1.0#
#compatible = 9.2.0.0.0
parallel_max_servers = 24 java_pool_size = 25000000
# end changes for 11i
# _optimizer_undo_changes = true was used before 8.1.7, see below
#mts_dispatchers = "ipc,4"
#mts_dispatchers = "tcp,2"
#mts_max_dispatchers = 6
#mts_servers = 8
#mts_max_servers = 20
#mts_service = xAPPS
#mts_listener_address = "(ADDRESS=(PROTOCOL=ipc)(KEY=xAPPS))"
#mts_listener_address =
"(ADDRESS=(PROTOCOL=tcp)(host=dba1)(port=1531))"
sessions = 400 # 9.2 license_sessions_warning = 1500 license_max_sessions = 9999
# license_max_users = 999
# use_ism = false obsolete 817
audit_trail = os # none, db, or os audit_file_dest = /oracle/apps11/xAPPSdb/9.2.0/admin/audit
background_dump_dest = /oracle/apps11/xAPPSdb/9.2.0/admin/bdump
core_dump_dest = /oracle/apps11/xAPPSdb/9.2.0/admin/cdump user_dump_dest = /oracle/apps11/xAPPSdb/9.2.0/admin/udump utl_file_dir =
# _trace_files_public = true # allow public to see trace files
db_block_size = 8192
db_name = xAPPS db_domain = .world db_files = 1022 global_names = true
# gc_db_locks = 1
rollback_segments = (rbs1, rbs2, rbs3, rbs4)
# rollback_segments = (rbs1, rbs2, rbs3, rbs4, rbs5)
# open_cursors = 1000
open_cursors = 4000 # changed for 8.1.7 10.7 db_file_multiblock_read_count = 30 # LARGE
#db_block_buffers = 9600 # LARGE
#db_block_buffers = 10200
#db_block_buffers = 14400
db_block_buffers = 10000
#db_block_buffers = 20000
#db_block_buffers = 24000
#shared_pool_size = 98304000
#hared_pool_size = 121440000
#shared_pool_size = 30000000
shared_pool_size = 300000000
shared_pool_reserved_size = 3000000
# shared_pool_reserved_min_alloc = 10000 obsolete 817
# checkpoint_process = true obsolete 817
log_archive_start = true # if you want automatic archiving
log_archive_dest = /oracle/xAPPS/a01 log_archive_format = "xAPPS%S.arc"
# log_buffer = 655360
log_buffer = 1048576 # add more for 8.1.7 10.7 log_checkpoint_interval = 10000
processes = 200 # LARGE dml_locks = 1000 # LARGEMeg each
# sequence_cache_entries = 10 obsolete 817 # SMALL
# sequence_cache_hash_buckets = 10 obsolete 817 # SMALL
# async_write = true obsolete 817
# timed_statistics = true # if you want timed statistics
max_dump_file_size = 10240 # limit trace file size to 5
# sql_trace = true
enqueue_resources = 15000
#sort_area_size = 256000 # N/A for 9.2
row_locking = always
# event requested by blind
# event="10076 trace name context forever, level 1"
# added for 817 10.7 apps
# event="10929 trace name context forever" # No longer for 9.2.0.2 &
11.5.7
# event="10932 trace name context level 2" # N/A for 9.2.0.2 & 11.5.7
# AD requires this date format
nls_date_format = DD-MON-RR nls_language = AMERICAN nls_numeric_characters = ".," nls_sort = binary nls_territory = AMERICA compatible = 8.1.7.1.0#
#compatible = 9.2.0.0.0
parallel_max_servers = 24 java_pool_size = 25000000
# end changes for 11i
# _optimizer_undo_changes = true was used before 8.1.7, see below
#mts_dispatchers = "ipc,4"
#mts_dispatchers = "tcp,2"
#mts_max_dispatchers = 6
#mts_servers = 8
#mts_max_servers = 20
#mts_service = xAPPS
#mts_listener_address = "(ADDRESS=(PROTOCOL=ipc)(KEY=xAPPS))"
#mts_listener_address =
"(ADDRESS=(PROTOCOL=tcp)(host=dba1)(port=1531))"
sessions = 400 # 9.2 license_sessions_warning = 1500 license_max_sessions = 9999
# license_max_users = 999
# use_ism = false obsolete 817
job_queue_processes = 2 # set to 2 for 11.5.7
# job_queue_interval = 60
timed_statistics = true
# Tuning parameters -- set to true to collect stats:
#db_block_lru_statistics = true
#
# below added per page 1-4 Oracle Applications Upgrading Oracle
# Applications, Rel 11i(11.5.4), A90308-01
#
#_complex_view_merging = true # N/a for 9.2
_fast_full_scan_enabled = false _like_with_bind_as_equality = trueevent="10933 trace name context level 512" # 9.2 & 11.5.7 event="10943 trace name context level 16384" # 9.2 & 11.5.7
#_new_initial_join_orders = true # N/A for 9.2
#_optimizer_mode_force = true # N/A for 9.2
#_optimizer_undo_changes = false # N/A for 9.2
#_or_expand_nvl_predicate = true # N/A for 9.2
#_ordered_nested_loop = true # N/A for 9.2
#_push_join_predicate = true # N/A for 9.2
#_push_join_union_view = true # N/A for 9.2
_sort_elimination_cost_ratio = 5 _table_scan_cost_plus_one = true _trace_files_public = true
#_use_column_stats_for_function = true # N/A for 9.2
_sqlexec_progression_cost = 0 aq_tm_processes = 1
#always_anti_join = NESTED_LOOPS
#always_semi_join = NESTED_LOOPS
max_enabled_roles = 40 optimizer_features_enable = 8.1.7 optimizer_max_permutations = 2000
#optimizer_percent_parallel = 0
parallel_min_servers = 0 query_rewrite_enabled = true nls_length_semantics = BYTE # 9.2.0.2 undo_management = MANUAL # 9.2.0.2 undo_retention = 1800 # 9.2.0.2 undo_suppress_errors = FALSE # 9.2.0.2 undo_tablespace = RBSUNDO pga_aggregate_target = 500M # 9.2.0.2 workarea_size_policy = AUTO # 9.2.0.2 event="10932 trace name context level 32768" # 9.2.0.2 & 11.5.7 only.
optimizer_features_enable = 9.2.0 # 9.2
job_queue_processes = 2 # set to 2 for 11.5.7
# job_queue_interval = 60
timed_statistics = true
# Tuning parameters -- set to true to collect stats:
#db_block_lru_statistics = true
#
# below added per page 1-4 Oracle Applications Upgrading Oracle
# Applications, Rel 11i(11.5.4), A90308-01
#
#_complex_view_merging = true # N/a for 9.2
_fast_full_scan_enabled = false _like_with_bind_as_equality = trueevent="10933 trace name context level 512" # 9.2 & 11.5.7 event="10943 trace name context level 16384" # 9.2 & 11.5.7
#_new_initial_join_orders = true # N/A for 9.2
#_optimizer_mode_force = true # N/A for 9.2
#_optimizer_undo_changes = false # N/A for 9.2
#_or_expand_nvl_predicate = true # N/A for 9.2
#_ordered_nested_loop = true # N/A for 9.2
#_push_join_predicate = true # N/A for 9.2
#_push_join_union_view = true # N/A for 9.2
_sort_elimination_cost_ratio = 5 _table_scan_cost_plus_one = true _trace_files_public = true
#_use_column_stats_for_function = true # N/A for 9.2
_sqlexec_progression_cost = 0 aq_tm_processes = 1
#always_anti_join = NESTED_LOOPS
#always_semi_join = NESTED_LOOPS
max_enabled_roles = 40 optimizer_features_enable = 8.1.7 optimizer_max_permutations = 2000
#optimizer_percent_parallel = 0
parallel_min_servers = 0 query_rewrite_enabled = true nls_length_semantics = BYTE # 9.2.0.2 undo_management = MANUAL # 9.2.0.2 undo_retention = 1800 # 9.2.0.2 undo_suppress_errors = FALSE # 9.2.0.2 undo_tablespace = RBSUNDO pga_aggregate_target = 500M # 9.2.0.2 workarea_size_policy = AUTO # 9.2.0.2 event="10932 trace name context level 32768" # 9.2.0.2 & 11.5.7 only.
optimizer_features_enable = 9.2.0 # 9.2
##################################################################
############## END OF INIT.ORA PARAMETERS ##################
##################################################################
DA Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3E755D98.4D7673A3_at_exxesolutions.com>...
> Finally I've got a problem I can't solve. > > Just patched from 9.2.0.1.0 to 9.2.0.2 and now it is time to run > catpatch.sql on a 500MB PIII running W2K. And here's the error message > > DOC>####################################################################### > > DOC>####################################################################### > > DOC> The following statement may cause an > DOC> ORA-29554: unhandled Java out of memory condition > DOC> error, and thereby terminate the sqlplus connection. > DOC> If so, this is because there is insufficient system tablespace, > DOC> shared or java pool size, or some other resource value is too > small. > DOC> An additional message describing the problem will be output by > DOC> the statement. > DOC>####################################################################### > > DOC>####################################################################### > > DOC*/ > BEGIN initjvmmaux.check_sizes_for_cjs; END; > > * > ERROR at line 1: > ORA-29554: unhandled Java out of memory condition > ORA-06512 at "SYS.INITJVMAUX", line 167 > ORA-06512 at line 1 > > And yes I've checked the google archives and yes I've run all over otn > and tahiti and metalink. And I will tell you for free the information at > metalink is so bad Oracle should hang its head in shame. Lots of > statements about what the problem is ... not a single solution. > > Ive done shutdown followed by startup migrate numerous times and it > seems that no setting for the following: > > java_pool_size=51200000 > java_soft_sessionspace_limit=10240000 > > solves the problem. These are my current values. > > Has anyone done this successfully and could you please post the init > parameters that made it work. If not these ... which ones? > > Thanks, > > Daniel MorganReceived on Mon Mar 17 2003 - 09:34:40 CST