ORA-00600: [kck_rls_check must use (11,0,0,0,0) or lower]故障解决(一)

ORA-00600: [kck_rls_check must use (11,0,0,0,0) or lower]故障解决

一朋友在QQ上问我，说他数据库的pfile 和spfile 都不见了。我问他数据库是10g还是11g的，他说11g，所以我就让他用这个语法来创建spfile了：

SQL> create spfile from memory;

朋友用这种方法操作以后，启动数据库报错：

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

创建一个pfile，还搞出一个ORA-600，有点邪门。 不过之前也没有好好研究这个从内存里创建PFILE的功能。

在自己的 虚拟机上测试了一下：

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>

我这里用pfile 来启动，是没有报错的。 但是朋友那缺报了ORA-600的错误。

生成的PFILE如下：

[oracle@dave~]$ cat /u01





/dave.ora
# Oracle init.ora parameterfile generated by instance dave on 07/04/2013 09:43:36
__db_cache_size=264M
__java_pool_size=4M
__large_pool_size=4M
__oracle_base='/u01/app/oracle'# ORACLE_BASE set from environment
__pga_aggregate_target=280M
__sga_target=408M
__shared_io_pool_size=0
__shared_pool_size=128M
__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_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
_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_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_co