Re: Catpatch.sql Problem

Pete's wrote:

> 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
> # if you want auditing
>
> 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 =
> (/oracle/apps11/xAPPSdb/9.2.0/admin/utlfile,/oracle/apps11/xAPPScomn/admin/out,/oracle/apps11/xAPPScomn/admin/log)
>
> # _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
> log_checkpoints_to_alert = no
> log_checkpoint_timeout = 7200
>
> processes = 200 # LARGE
>
> dml_locks = 1000 # LARGE
>
> # 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
> Meg each
>
> # 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
> #
> # changes for 11i
> #
> optimizer_mode = choose
> _sqlexec_progression_cost = 0
> #hash_area_size = 30000000 # N/A for 9.2
> 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
> # if you want auditing
>
> 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 =
> (/oracle/apps11/xAPPSdb/9.2.0/admin/utlfile,/oracle/apps11/xAPPScomn/admin/out,/oracle/apps11/xAPPScomn/admin/log)
>
> # _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
> log_checkpoints_to_alert = no
> log_checkpoint_timeout = 7200
>
> processes = 200 # LARGE
>
> dml_locks = 1000 # LARGE
>
> # 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
> Meg each
>
> # 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
> #
> # changes for 11i
> #
> optimizer_mode = choose
> _sqlexec_progression_cost = 0
> #hash_area_size = 30000000 # N/A for 9.2
> 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 = true
> #_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.
> event="10933 trace name context level 512" # 9.2 & 11.5.7
> event="10943 trace name context level 16384" # 9.2 & 11.5.7
>
> 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 = true
> #_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.
> event="10933 trace name context level 512" # 9.2 & 11.5.7
> event="10943 trace name context level 16384" # 9.2 & 11.5.7
>
> 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 Morgan

Thanks. Received on Mon Mar 17 2003 - 10:32:29 CST