OraFAQ Forum: Server Utilities » Error during expdp on Oracle 11gR2 on Solaris

Home » RDBMS Server » Server Utilities » Error during expdp on Oracle 11gR2 on Solaris (Oracle 11gR2, Solaris 10 OS on Sparc)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error during expdp on Oracle 11gR2 on Solaris [message #484633]

Thu, 02 December 2010 03:33

maxranzy
Messages: 5
Registered: December 2010
Location: Milan (Italy)

Junior Member

Hi,

I'm a newbe on this forum end I have a question. From some day I have this error during export data pump:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31687: error creating worker process with worker id 1
ORA-31687: error creating worker process with worker id 1
ORA-31688: Worker process failed during startup.

This error is random, if I retry after few minutes the expdp work correctly.

Any idea?

tks
Max

Report message to a moderator

Re: Error during expdp on Oracle 11gR2 on Solaris [message #484665 is a reply to message #484633]

Thu, 02 December 2010 04:43

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

If your init parameter AQ_TM_PROCESSES parameter has a value of zero, remove it.

Report message to a moderator

Re: Error during expdp on Oracle 11gR2 on Solaris [message #484691 is a reply to message #484665]

Thu, 02 December 2010 05:34

maxranzy
Messages: 5
Registered: December 2010
Location: Milan (Italy)

Junior Member

However in init.ora there isn't that parameter:

# Oracle init.ora parameter file generated by instance hind on 12/02/2010 10:16:54
__db_cache_size=1632M
__java_pool_size=16M
__large_pool_size=16M
__oracle_base='/oracle/app' # ORACLE_BASE set from environment
__pga_aggregate_target=2288M
__sga_target=4272M
__shared_io_pool_size=0
__shared_pool_size=2512M
__streams_pool_size=32M
_aggregation_optimization_settings=0
_always_anti_join='CHOOSE'
_always_semi_join='CHOOSE'
_and_pruning_enabled=TRUE
_b_tree_bitmap_plans=TRUE
_bloom_filter_enabled=TRUE
_bloom_folding_enabled=TRUE
_bloom_pruning_enabled=TRUE
_complex_view_merging=TRUE
_compression_compatibility='11.2.0.0.0'
_connect_by_use_union_all='TRUE'
_convert_set_to_join=FALSE
_cost_equality_semi_join=TRUE
_cpu_to_io=0
_dimension_skip_null=TRUE
_eliminate_common_subexpr=TRUE
_enable_type_dep_selectivity=TRUE
_fast_full_scan_enabled=TRUE
_first_k_rows_dynamic_proration=TRUE
_gby_hash_aggregation_enabled=TRUE
_generalized_pruning_enabled=TRUE
_globalindex_pnum_filter_enabled=TRUE
_gs_anti_semi_join_allowed=TRUE
_improved_outerjoin_card=TRUE
_improved_row_length_enabled=TRUE
_index_join_enabled=TRUE
_ksb_restart_policy_times='0'
_ksb_restart_policy_times='60'
_ksb_restart_policy_times='120'
_ksb_restart_policy_times='240' # internal update to set default
_left_nested_loops_random=TRUE
_local_communication_costing_enabled=TRUE
_log_io_size=125
_minimal_stats_aggregation=TRUE
_mmv_query_rewrite_enabled=TRUE
_mv_refresh_use_stats=FALSE
_new_initial_join_orders=TRUE
_new_sort_cost_estimate=TRUE
_nlj_batching_enabled=1
_optim_adjust_for_part_skews=TRUE
_optim_enhance_nnull_detection=TRUE
_optim_new_default_join_sel=TRUE
_optim_peek_user_binds=TRUE
_optimizer_adaptive_cursor_sharing=TRUE
_optimizer_better_inlist_costing='ALL'
_optimizer_cbqt_no_size_restriction=TRUE
_optimizer_coalesce_subqueries=TRUE
_optimizer_complex_pred_selectivity=TRUE
_optimizer_compute_index_stats=TRUE
_optimizer_connect_by_combine_sw=TRUE
_optimizer_connect_by_cost_based=TRUE
_optimizer_connect_by_elim_dups=TRUE
_optimizer_correct_sq_selectivity=TRUE
_optimizer_cost_based_transformation='LINEAR'
_optimizer_cost_hjsmj_multimatch=TRUE
_optimizer_cost_model='CHOOSE'
_optimizer_dim_subq_join_sel=TRUE
_optimizer_distinct_agg_transform=TRUE
_optimizer_distinct_elimination=TRUE
_optimizer_distinct_placement=TRUE
_optimizer_eliminate_filtering_join=TRUE
_optimizer_enable_density_improvements=TRUE
_optimizer_enable_extended_stats=TRUE
_optimizer_enhanced_filter_push=TRUE
_optimizer_extend_jppd_view_types=TRUE
_optimizer_extended_cursor_sharing='UDO'
_optimizer_extended_cursor_sharing_rel='SIMPLE'
_optimizer_extended_stats_usage_control=224
_optimizer_fast_access_pred_analysis=TRUE
_optimizer_fast_pred_transitivity=TRUE
_optimizer_filter_pred_pullup=TRUE
_optimizer_fkr_index_cost_bias=10
_optimizer_group_by_placement=TRUE
_optimizer_improve_selectivity=TRUE
_optimizer_join_elimination_enabled=TRUE
_optimizer_join_factorization=TRUE
_optimizer_join_order_control=3
_optimizer_join_sel_sanity_check=TRUE
_optimizer_max_permutations=2000
_optimizer_mode_force=TRUE
_optimizer_multi_level_push_pred=TRUE
_optimizer_native_full_outer_join='FORCE'
_optimizer_new_join_card_computation=TRUE
_optimizer_null_aware_antijoin=TRUE
_optimizer_or_expansion='DEPTH'
_optimizer_order_by_elimination_enabled=TRUE
_optimizer_outer_to_anti_enabled=TRUE
_optimizer_push_down_distinct=0
_optimizer_push_pred_cost_based=TRUE
_optimizer_rownum_bind_default=10
_optimizer_rownum_pred_based_fkr=TRUE
_optimizer_skip_scan_enabled=TRUE
_optimizer_sortmerge_join_inequality=TRUE
_optimizer_squ_bottomup=TRUE
_optimizer_star_tran_in_with_clause=TRUE
_optimizer_system_stats_usage=TRUE
_optimizer_table_expansion=TRUE
_optimizer_transitivity_retain=TRUE
_optimizer_try_st_before_jppd=TRUE
_optimizer_undo_cost_change='11.2.0.1'
_optimizer_unnest_corr_set_subq=TRUE
_optimizer_unnest_disjunctive_subq=TRUE
_optimizer_use_cbqt_star_transformation=TRUE
_optimizer_use_feedback=TRUE
_or_expand_nvl_predicate=TRUE
_ordered_nested_loop=TRUE
_parallel_broadcast_enabled=TRUE
_partition_view_enabled=TRUE
_pga_max_size=468580K
_pivot_implementation_method='CHOOSE'
_pre_rewrite_push_pred=TRUE
_pred_move_around=TRUE
_push_join_predicate=TRUE
_push_join_union_view=TRUE
_push_join_union_view2=TRUE
_px_minus_intersect=TRUE
_px_pwg_enabled=TRUE
_px_ual_serial_input=TRUE
_query_rewrite_setopgrw_enable=TRUE
_remove_aggr_subquery=TRUE
_replace_virtual_columns=TRUE
_right_outer_hash_enable=TRUE
_selfjoin_mv_duplicates=TRUE
_smm_max_size=234290
_smm_min_size=1024
_smm_px_max_size=1171456
_sql_model_unfold_forloops='RUN_TIME'
_sqltune_category_parsed='DEFAULT' # parsed sqltune_category
_subquery_pruning_enabled=TRUE
_subquery_pruning_mv_enabled=FALSE
_table_scan_cost_plus_one=TRUE
_union_rewrite_for_gs='YES_GSET_MVS'
_unnest_subquery=TRUE
_use_column_stats_for_function=TRUE
audit_file_dest='/oracle/app/admin/hind/adump'
audit_trail='DB'
compatible='11.2.0.0.0'
control_files='/oracle/oradata/hind/control01.ctl'
control_files='/oracle/oradata/flash_recovery_area/hind/control02.ctl'
core_dump_dest='/oracle/app/diag/rdbms/hind/hind/cdump'
db_block_size=8192
db_domain='revo.it'
db_name='hind'
db_recovery_file_dest='/oracle/oradata/flash_recovery_area'
db_recovery_file_dest_size=4977M
diagnostic_dest='/oracle/app'
dispatchers='(PROTOCOL=TCP) (SERVICE=hindXDB)'
filesystemio_options='SETALL'
log_buffer=18800640 # log buffer update
memory_target=6560M
open_cursors=300
optimizer_dynamic_sampling=2
optimizer_mode='ALL_ROWS'
plsql_warnings='DISABLE:ALL' # PL/SQL warnings at init.ora
processes=150
query_rewrite_enabled='TRUE'
remote_login_passwordfile='EXCLUSIVE'
resource_manager_plan=''
result_cache_max_size=16800K
sec_case_sensitive_logon=FALSE
skip_unusable_indexes=TRUE
statistics_level='ALL'
undo_tablespace='UNDOTBS1'

Report message to a moderator

Re: Error during expdp on Oracle 11gR2 on Solaris [message #484707 is a reply to message #484691]

Thu, 02 December 2010 06:14

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Is there anything useful reported in alert log?

Report message to a moderator

Re: Error during expdp on Oracle 11gR2 on Solaris [message #484715 is a reply to message #484707]

Thu, 02 December 2010 06:39

maxranzy
Messages: 5
Registered: December 2010
Location: Milan (Italy)

Junior Member

This is the part of alert log at the time of the export:

Tue Nov 30 23:00:02 2010
DM00 started with pid=130, OS id=20593, job SYSTEM.SYS_EXPORT_SCHEMA_15
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process DW00 submission failed with error = 20

many thanks
(and sorry for my english)

Report message to a moderator

Re: Error during expdp on Oracle 11gR2 on Solaris [message #484731 is a reply to message #484715]

Thu, 02 December 2010 08:20

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

While this might have nothing to do with the original issue,
try increasing the PROCESSES parameter to a much higher value and bounce the instance.
If nothing helps, I would just talk to Oracle Support. A quick search in metalink did not produce much useful hints.

Report message to a moderator

Re: Error during expdp on Oracle 11gR2 on Solaris [message #484739 is a reply to message #484731]

Thu, 02 December 2010 08:36

maxranzy
Messages: 5
Registered: December 2010
Location: Milan (Italy)

Junior Member

Ok,

I'll try, as soon as possible. However I'm not the only user of that oracle.

many thanks
Max

Report message to a moderator

Re: Error during expdp on Oracle 11gR2 on Solaris [message #540143 is a reply to message #484633]

Fri, 20 January 2012 07:21

fabi88
Messages: 112
Registered: November 2011

Senior Member

I've faced this bunch of errors too:

ORA-31626: job does not exist
ORA-31687: error creating worker process  with worker id 1
ORA-31687: error creating worker process  with worker id 1
ORA-31688: Worker process  failed during startup.

This occured when using expdp directly on my server, without any understandable reason (I've made another export successfully a few minutes before).

Then, when I logged out and logged in (exit, su oracle on a linux RHEL 5 server), the problem did not occur anymore...

[Updated on: Fri, 20 January 2012 07:22]

Report message to a moderator

Re: Error during expdp on Oracle 11gR2 on Solaris [message #540154 is a reply to message #540143]

Fri, 20 January 2012 07:53

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post the complete expdp session including the command itself.

Regards
Michel

Report message to a moderator

Previous Topic:	IMP-00085
Next Topic:	sqlldr issue with many tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 27 18:29:38 CDT 2025