Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Catpatch.sql Problem

Re: Catpatch.sql Problem

From: Pete's <empete2000_at_yahoo.com>
Date: 17 Mar 2003 07:34:40 -0800
Message-ID: <6724a51f.0303170734.784cd8e7@posting.google.com>


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
Received on Mon Mar 17 2003 - 09:34:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US