ORA-00600: [kck_rls_check must use (11,0, 0) or lower] troubleshooting

Source: Internet
Author: User

 

 

A friend asked me on QQ that the pfile and spfile of his database were gone. I asked him whether the database was 10 Gb or 11 GB. He said 11 GB, so I asked him to use this syntax to create spfile:

 

SQL> Create spfile from memory;

 

This is a new feature of Oracle 11g. In my new features of Oracle 11g, we will introduce the following:

New Features of Oracle 11g-instructions for managing spfile

Http://blog.csdn.net/tianlesoftware/article/details/8225247

 

 

After a friend uses this method, the following error occurs when the database is started:

ORA-00600: Internal errorcode, arguments: [kck_rls_check must use (11,0, 0) or lower], [kdt. c], [9419], [11.2.0.1.0], [], [], [], [], [], [], [], []

 

Create a pfile and create a ORA-600, which is a little tricky. However, we have not studied this function of creating pfile from memory.

I tested it on my own virtual machine:

 

SQL> Create pfile = '/u01/Dave. ora' frommemory;

File Created.

 

SQL> startuppfile = '/u01/Dave. ora ';

ORA-32006: background_dump_destinitialization parameter has been deprecated

ORA-32006: user_dump_dest initializationparameter has been deprecated

Oracle instance started.

 

Total system global area 718188544 bytes

Fixed size 2231832 bytes

Variable Size 440402408 bytes

Database buffers 272629760 bytes

Redo buffers 2924544 bytes

Database mounted.

Database opened.

SQL>

 

I use pfile to start it. No error is reported. But my friend Missed the ORA-600 error.

 

 

 

The generated pfile is as follows:

[Oracle @ Dave ~] $ CAT/u01/Dave. ora

# Oracle init. ora parameterfile generated by instance Dave on 07/04/2013 09:43:36

_ Db_cache_size = 264 m

_ Java_pool_size = 4 m

_ Large_pool_size = 4 m

_ Oracle_base = '/u01/APP/Oracle' # oracle_base set from Environment

_ Pga_aggregate_target = 280 m

_ Sga_target = 408 m

_ Shared_io_pool_size = 0

_ Shared_pool_size = 128 m

_ Streams_pool_size = 0

_ 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_selecti.pdf = 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 = '000000'

_ Ksb_restart_policy_times = '000000' # Internal update to set default

_ Left_nested_loops_random = true

_ Local_communication_costing_enabled = true

_ Minimal_stats_aggregation = true

_ Mmv_query_rewrite_enabled = true

_ 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_selecti.pdf = 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_selecti.pdf = 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_enable_table_lookup_by_nl = 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 = 192

_ Optimizer_false_filter_pred_pullup = true

_ Optimizer_fast_access_pred_analysis = true

_ Optimizer_fast_pred_transiti.pdf = true

_ Optimizer_filter_pred_pullup = true

_ Optimizer_fkr_index_cost_bias = 10

_ Optimizer_full_outer_join_to_outer = true

_ Optimizer_group_by_placement = true

_ Optimizer_improve_selecti.pdf = true

_ Optimizer_interleave_jppd = 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 = 'dest'

_ Optimizer_order_by_elimination_enabled = true

_ Optimizer_outer_join_to_inner = 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.3'

_ Optimizer_unnest_assist_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

_ Effect_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_partition_scan_enabled = 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

_ 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 = '/u01/APP/Oracle/admin/Dave/adump'

Audit_trail = 'db'

Background_dump_dest = '/u01/APP/Oracle/diag/rdbms/dave_st/Dave/track' # deprecate Parameter

Compatible = '11. 2.0.0.0'

Control_files = '/u01/APP/Oracle/oradata/Dave/control01.ctl'

Control_files = '/u01/APP/Oracle/fast_recovery_area/Dave/control02.ctl' # restore controlfile

Core_dump_dest = '/u01/APP/Oracle/diag/rdbms/dave_st/Dave/cdump'

DB _ block_size = 8192

Db_create_file_dest = '/u01/APP/Oracle/oradata/Dave'

Db_domain =''

Db_file_multiblock_read_count = 16

Db_file_name_convert = '+ Data/Dave/datafile'

Db_file_name_convert = '/u01/APP/Oracle/oradata/Dave'

Db_file_name_convert = '+ Data/Dave/tempfile'

Db_file_name_convert = '/u01/APP/Oracle/oradata/Dave'

Db_name = 'Dave'

Db_recovery_file_dest = '/u01/APP/Oracle/fast_recovery_area'

Db_recovery_file_dest_size = 1018937856

Db_unique_name = 'Dave _ st'

Fal_client = 'Dave _ st'

Fal_server = 'Dave _ pd1'

Fal_server = 'Dave _ pd2'

Log_archive_config = 'dg _ Config = (Dave, dave_st )'

Log_archive_dest_1 = 'location =/u01/archvalid_for = (all_logfiles, all_roles) db_unique_name = dave_st'

Log_archive_dest_2 = 'service = davevalid_for = (online_logfiles, primary_role) db_unique_name = Dave'

Log_archive_dest_state_1 = 'enable'

Log_archive_dest_state_2 = 'enable'

Log_buffer = 2736128 # logbuffer update

Log_file_name_convert = '+ fra/Dave/onlinelog'

Log_file_name_convert = '/u01/APP/Oracle/oradata/Dave'

Memory_target = 688 M

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 = 'clusive'

Resource_manager_plan = 'scheduler [0x318f]: default_maintenance_plan'

Result_cache_max_size = 1792 K

Skip_unusable_indexes = true

Standby_file_management = 'auto'

Undo_tablespace = 'undotbs1'

User_dump_dest = '/u01/APP/Oracle/diag/rdbms/dave_st/Dave/track' # deprecate Parameter

 

 

 

From the above results, I also know why. To create a pfile from the memory, some implicit parameters will also be written in.

 

The default value here is:

_ Compression_compatibility = '11. 2.0.0.0'

 

The default value here is:

_ Compression_compatibility = '11. 2.0.1.0'

 

This parameter is a friend database boot Report: ORA-00600: Internal errorcode, arguments: [kck_rls_check must use (11,0, 0) or lower] Error cause.

 

Change this parameter to _ compression_compatibility = "11.2.0". The database can be started normally.

 

 

In fact, this problem is a small problem left over from Oracle 11g. This problem occurs in 11.2.0.1 and 11.0.2.0.2.

 

In Oracle 11.2.0.3, the default value of this _ compression_compatibility parameter is 11.2.0.0.0, so when you create a pfile from memory, there will be no ORA-600 error reported.

 

This is also the reason why I did not report an error when creating and starting a database. My database version is 11.2.0.3.

 

Another point is that when we use the memory to create database parameters, we can delete all the preceding implicit parameters. Which parameters are too cumbersome and the default values are good.

 

 

 

 

 

Bytes --------------------------------------------------------------------------------------------

All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!

QQ: 251097186

Skype: tianlesoftware

Email: tianlesoftware@gmail.com

Blog: http://blog.csdn.net/tianlesoftware

WEAVER: http://weibo.com/tianlesoftware

Twitter: http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

LinkedIn: http://cn.linkedin.com/in/tianlesoftware

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.