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