这篇文章主要讲解了“怎么解决Oracle中的ORA-01105、ORA-01606错误”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“怎么解决Oracle中的ORA-01105、ORA-01606错误”吧！

生产环境，Oracle Linux 6.4 RAC 11.2.4.0，今天出现了grid集群因为OCR磁盘组不能访问而不能通过命令来显示集群状态信息，在手动mount OCR磁盘组后，准备重启节点2时出现了ORA-01105,ORA-01606错误，具体信息如下:

SQL>startupORACLEinstancestarted.TotalSystemGlobalArea5.3447E+10bytesFixedSize2265864bytesVariableSize1.3019E+10bytesDatabaseBuffers4.0265E+10bytesRedoBuffers160698368bytesORA-01105:mountisincompatiblewithmountsbyotherinstancesORA-01606:parameternotidenticaltothatofanothermountedinstance

查看错误详细说明，根据错误描述可知是由于2号实例与1号实例由于某些参数设置一样所导致的

[oracle@db2dbs]$oerrora110501105,00000,"mountisincompatiblewithmountsbyotherinstances"//*Cause:Anattempttomountthedatabasediscoveredthatanotherinstance//mountedadatabasebythesamename,butthemountisnot//compatible.Additionalerrorsarereportedexplainingwhy.//*Action:Seeaccompanyingerrors.[oracle@db2dbs]$oerrora160601606,00000,"parameternotidenticaltothatofanothermountedinstance"//*Cause:Aparameterwasdifferentontwoinstances.//*Action:Modifytheinitializationparameterandrestart.

使用spfile文件来创建文本格式的pfile文件

SQL>createpfile='rlcs.ora'fromspfile;Filecreated.[oracle@db2dbs]$catrlcs.ora*._serial_direct_read='AUTO'*._swrf_mmon_flush=TRUE*._use_adaptive_log_file_sync='FALSE'*.audit_file_dest='/u01/app/oracle/admin/RL/adump'*.audit_trail='NONE'*.cluster_database=true*.compatible='11.2.0.4.0'*.control_files='+DATA/rl/controlfile/current.260.926786537','+ARCH/rl/controlfile/current.256.926786537'*.db_block_size=8192*.db_create_file_dest='+DATA'*.db_domain=''*.db_file_name_convert='+data/rl/','+data/rldg/'*.db_name='RL'*.db_recovery_file_dest='+ARCH'*.db_recovery_file_dest_size=10737418240*.diagnostic_dest='/u01/app/oracle'*.dispatchers='(PROTOCOL=TCP)(SERVICE=RLZYXDB)'*.fal_server='yb_st'RL1.instance_number=1RL2.instance_number=2*.listener_networks=''*.log_archive_config='dg_config=(rl,rldg)'*.log_archive_dest_1='location=+ARCHvalid_for=(all_logfiles,all_roles)db_unique_name=rl'*.log_archive_dest_2='service=yb_stvalid_for=(online_logfiles,primary_role)db_unique_name=rldg'*.log_archive_dest_state_1='ENABLE'*.log_archive_dest_state_2='ENABLE'*.log_archive_format='%t_%s_%r.arch'*.log_file_name_convert='+data/rl/','+data/rldg/','+arch/rl/','+arch/rldg/'*.open_cursors=300*.parallel_adaptive_multi_user=TRUE*.parallel_degree_policy='AUTO'*.parallel_force_local=FALSE*.pga_aggregate_target=21474836480*.processes=2000*.remote_listener='scan-ip:1521'*.remote_login_passwordfile='exclusive'*.service_names='rl'*.sessions=2205*.sga_max_size=53687091200*.sga_target=53687091200*.standby_file_management='manual'RLZY2.thread=2RLZY1.thread=1*.undo_retention=7200RLZY2.undo_tablespace='UNDOTBS2'RLZY1.undo_tablespace='UNDOTBS1'*.utl_file_dir='/rmanbak/utl'

从文本参数文件看不出来有什么参数是两个实例不一致的。通过执行下面的语句来查看2号实例与gc相关的参数

SQL>setlinesize333SQL>colnamefora35SQL>coldescriptionfora66SQL>colvaluefora30SQL>SELECTi.ksppinmname,2i.ksppdescdescription,3CV.ksppstvlVALUE4FROMsys.x$ksppii,sys.x$ksppcvCV5WHEREi.inst_id=USERENV('Instance')6ANDCV.inst_id=USERENV('Instance')7ANDi.indx=CV.indx8ANDi.ksppinmLIKE'/_gc%'ESCAPE'/'9ORDERBYREPLACE(i.ksppinm,'_','');NAMEDESCRIPTIONVALUE-----------------------------------------------------------------------------------------------------------------------------------_gc_affinity_lockingifTRUE,enableobjectaffinityTRUE_gc_affinity_locksifTRUE,getaffinitylocksTRUE_gc_affinity_ratiodynamicobjectaffinityratio50_gc_async_memcpyifTRUE,useasyncmemcpyFALSE_gc_bypass_readersifTRUE,modificationsbypassreadersTRUE_gc_check_bscnifTRUE,checkforstaleblocksTRUE_gc_coalesce_recovery_readsifTRUE,coalescerecoveryreadsTRUE_gc_cpu_timeifTRUE,recordthegccputimeFALSE_gc_cr_server_read_waitifTRUE,crserverwaitsforareadtocompleteTRUE_gc_defer_ping_index_onlyifTRUE,restrictdeferredpingtoindexblocksonlyTRUE_gc_defer_timehowlongtodeferpingsforhotbuffersinmilliseconds0NAMEDESCRIPTIONVALUE-----------------------------------------------------------------------------------------------------------------------------------_gc_delta_push_compressionifdelta>=Kbytes,compressbeforepush3072_gc_delta_push_max_levelmaxdeltalevelfordeltapush100_gc_delta_push_objectsobjectswhichusedeltapush0_gc_disable_s_lock_brr_ping_checkifTRUE,disableSlockBRRpingcheckforlostwriteprotectTRUE_gc_down_convert_after_keepifTRUE,down-convertlockafterrecoveryTRUE_gc_element_percentglobalcacheelementpercent110_gc_escalate_bidifTRUE,escalatescreateabidTRUE_gc_fg_mergeifTRUE,mergepibuffersintheforegroundTRUE_gc_flush_during_affinityifTRUE,flushduringaffinityTRUE_gc_fusion_compressioncompressfusionblocksifthereisfreespace1024_gc_global_checkpoint_scnifTRUE,enableglobalcheckpointscnTRUENAMEDESCRIPTIONVALUE-----------------------------------------------------------------------------------------------------------------------------------_gc_global_cpuglobalcpuchecksTRUE_gc_global_lruturngloballruoff,makeitautomatic,orturnitonAUTO_gc_global_lru_touch_countgloballrutouchcount5_gc_global_lru_touch_timegloballrutouchtimeinseconds60_gc_integrity_checkssettheintegritychecklevel1_gc_keep_recovery_buffersifTRUE,makesingleinstancecrashrecoverybufferscurrentTRUE_gc_latchesnumberoflatchesperLMSprocess8_gc_log_flushifTRUE,flushredologbeforeacurrentblocktransferTRUE_gc_long_query_thresholdthresholdforlongrunningquery0_gc_max_downcvtmaximumdownconvertstoprocessatonetime256_gc_maximum_bidsmaximumnumberofbidswhichcanbeprepared0NAMEDESCRIPTIONVALUE-----------------------------------------------------------------------------------------------------------------------------------_gc_no_fairness_for_clonesifTRUE,nofairnessifweserveacloneTRUE_gc_object_queue_max_lengthmaximumlengthforanobjectqueue0_gc_override_force_crifTRUE,trytooverrideforce-crrequestsTRUE_gc_persistent_read_mostlyifTRUE,enablepersistentread-mostlylockingTRUE_gc_policy_minimumdynamicobjectpolicyminimumactivityperminute1500_gc_policy_timehowoftentomakeobjectpolicydecisionsinminutes10_gc_read_mostly_flush_checkifTRUE,optimizeflushesforreadmostlyobjectsFALSE_gc_read_mostly_lockingifTRUE,enableread-mostlylockingFALSE_gcr_enable_high_cpu_killifTRUE,GCRmaykillforegroundsunderhighloadFALSE_gcr_enable_high_cpu_rmifTRUE,GCRmayenableaRMplanunderhighloadFALSE_gcr_enable_high_cpu_rtifTRUE,GCRmayboostbgpriorityunderhighloadFALSENAMEDESCRIPTIONVALUE-----------------------------------------------------------------------------------------------------------------------------------_gcr_high_cpu_thresholdminimumamountofCPUprocessmustconsumetobekilltarget10_gcr_use_cssifFALSE,GCRwontregisterwithCSSnoruseanyCSSfeatureTRUE_gc_sanity_check_cr_buffersifTRUE,sanitycheckCRbuffersFALSE_gcs_disable_remote_handlesdisableremoteclient/shadowhandlesFALSE_gcs_disable_skip_close_remasteringifTRUE,disableskipcloseoptimizationinremasteringFALSE_gc_serve_high_pi_as_currentifTRUE,useahigherclonescnwhenservingapiTRUE_gcs_fast_reconfigifTRUE,enablefastreconfigurationforgcslocksTRUE_gcs_latchesnumberofgcsresourcehashlatchestobeallocatedperLMSproces64s_gcs_pkey_historynumberofpkeyremasteringhistory4000NAMEDESCRIPTIONVALUE-----------------------------------------------------------------------------------------------------------------------------------_gcs_process_in_recoveryifTRUE,processgcsrequestsduringinstancerecoveryTRUE_gcs_resourcesnumberofgcsresourcestobeallocated_gcs_res_per_bucketnumberofgcsresourceperhashbucket4_gcs_shadow_locksnumberofpcmshadowlockstobeallocated_gc_statisticsifTRUE,kclstatisticsaremaintainedTRUE_gcs_testingGCStestingparameter0_gc_transfer_ratiodynamicobjectread-mostlytransferratio2_gc_undo_affinityifTRUE,enabledynamicundoaffinityTRUE_gc_undo_block_disk_readsifTRUE,enableundoblockdiskreadsTRUE_gc_use_crifTRUE,allowCRpinsonPIandWRITINGbuffersTRUE_gc_vector_readifTRUE,vectorreadcurrentbuffersTRUE64rowsselected.

查看1号实例与gc相关的参数

SQL>setlinesize333SQL>colnamefora35SQL>coldescriptionfora66SQL>colvaluefora30SQL>SELECTi.ksppinmname,2i.ksppdescdescription,3CV.ksppstvlVALUE4FROMsys.x$ksppii,sys.x$ksppcvCV5WHEREi.inst_id=USERENV('Instance')6ANDCV.inst_id=USERENV('Instance')7ANDi.indx=CV.indx8ANDi.ksppinmLIKE'/_gc%'ESCAPE'/'9ORDERBYREPLACE(i.ksppinm,'_','');NAMEDESCRIPTIONVALUE-----------------------------------------------------------------------------------------------------------------------------------_gc_affinity_lockingifTRUE,enableobjectaffinityTRUE_gc_affinity_locksifTRUE,getaffinitylocksTRUE_gc_affinity_ratiodynamicobjectaffinityratio50_gc_async_memcpyifTRUE,useasyncmemcpyFALSE_gc_bypass_readersifTRUE,modificationsbypassreadersTRUE_gc_check_bscnifTRUE,checkforstaleblocksTRUE_gc_coalesce_recovery_readsifTRUE,coalescerecoveryreadsTRUE_gc_cpu_timeifTRUE,recordthegccputimeFALSE_gc_cr_server_read_waitifTRUE,crserverwaitsforareadtocompleteTRUE_gc_defer_ping_index_onlyifTRUE,restrictdeferredpingtoindexblocksonlyTRUE_gc_defer_timehowlongtodeferpingsforhotbuffersinmilliseconds0NAMEDESCRIPTIONVALUE-----------------------------------------------------------------------------------------------------------------------------------_gc_delta_push_compressionifdelta>=Kbytes,compressbeforepush3072_gc_delta_push_max_levelmaxdeltalevelfordeltapush100_gc_delta_push_objectsobjectswhichusedeltapush0_gc_disable_s_lock_brr_ping_checkifTRUE,disableSlockBRRpingcheckforlostwriteprotectTRUE_gc_down_convert_after_keepifTRUE,down-convertlockafterrecoveryTRUE_gc_element_percentglobalcacheelementpercent110_gc_escalate_bidifTRUE,escalatescreateabidTRUE_gc_fg_mergeifTRUE,mergepibuffersintheforegroundTRUE_gc_flush_during_affinityifTRUE,flushduringaffinityTRUE_gc_fusion_compressioncompressfusionblocksifthereisfreespace1024_gc_global_checkpoint_scnifTRUE,enableglobalcheckpointscnTRUENAMEDESCRIPTIONVALUE-----------------------------------------------------------------------------------------------------------------------------------_gc_global_cpuglobalcpuchecksTRUE_gc_global_lruturngloballruoff,makeitautomatic,orturnitonAUTO_gc_global_lru_touch_countgloballrutouchcount5_gc_global_lru_touch_timegloballrutouchtimeinseconds60_gc_integrity_checkssettheintegritychecklevel1_gc_keep_recovery_buffersifTRUE,makesingleinstancecrashrecoverybufferscurrentTRUE_gc_latchesnumberoflatchesperLMSprocess8_gc_log_flushifTRUE,flushredologbeforeacurrentblocktransferTRUE_gc_long_query_thresholdthresholdforlongrunningquery0_gc_max_downcvtmaximumdownconvertstoprocessatonetime256_gc_maximum_bidsmaximumnumberofbidswhichcanbeprepared0NAMEDESCRIPTIONVALUE-----------------------------------------------------------------------------------------------------------------------------------_gc_no_fairness_for_clonesifTRUE,nofairnessifweserveacloneTRUE_gc_object_queue_max_lengthmaximumlengthforanobjectqueue0_gc_override_force_crifTRUE,trytooverrideforce-crrequestsTRUE_gc_persistent_read_mostlyifTRUE,enablepersistentread-mostlylockingTRUE_gc_policy_minimumdynamicobjectpolicyminimumactivityperminute1500_gc_policy_timehowoftentomakeobjectpolicydecisionsinminutes10_gc_read_mostly_flush_checkifTRUE,optimizeflushesforreadmostlyobjectsFALSE_gc_read_mostly_lockingifTRUE,enableread-mostlylockingTRUE_gcr_enable_high_cpu_killifTRUE,GCRmaykillforegroundsunderhighloadFALSE_gcr_enable_high_cpu_rmifTRUE,GCRmayenableaRMplanunderhighloadFALSE_gcr_enable_high_cpu_rtifTRUE,GCRmayboostbgpriorityunderhighloadFALSENAMEDESCRIPTIONVALUE-----------------------------------------------------------------------------------------------------------------------------------_gcr_high_cpu_thresholdminimumamountofCPUprocessmustconsumetobekilltarget10_gcr_use_cssifFALSE,GCRwontregisterwithCSSnoruseanyCSSfeatureTRUE_gc_sanity_check_cr_buffersifTRUE,sanitycheckCRbuffersFALSE_gcs_disable_remote_handlesdisableremoteclient/shadowhandlesFALSE_gcs_disable_skip_close_remasteringifTRUE,disableskipcloseoptimizationinremasteringFALSE_gc_serve_high_pi_as_currentifTRUE,useahigherclonescnwhenservingapiTRUE_gcs_fast_reconfigifTRUE,enablefastreconfigurationforgcslocksTRUE_gcs_latchesnumberofgcsresourcehashlatchestobeallocatedperLMSproces64s_gcs_pkey_historynumberofpkeyremasteringhistory4000NAMEDESCRIPTIONVALUE-----------------------------------------------------------------------------------------------------------------------------------_gcs_process_in_recoveryifTRUE,processgcsrequestsduringinstancerecoveryTRUE_gcs_resourcesnumberofgcsresourcestobeallocated_gcs_res_per_bucketnumberofgcsresourceperhashbucket4_gcs_shadow_locksnumberofpcmshadowlockstobeallocated_gc_statisticsifTRUE,kclstatisticsaremaintainedTRUE_gcs_testingGCStestingparameter0_gc_transfer_ratiodynamicobjectread-mostlytransferratio2_gc_undo_affinityifTRUE,enabledynamicundoaffinityTRUE_gc_undo_block_disk_readsifTRUE,enableundoblockdiskreadsTRUE_gc_use_crifTRUE,allowCRpinsonPIandWRITINGbuffersTRUE_gc_vector_readifTRUE,vectorreadcurrentbuffersTRUE64rowsselected.

通过对比发现_gc_read_mostly_locking参数在1号实例中为true，2号实例为false

将所有实例中的_gc_read_mostly_locking参数设置为true

SQL>altersystemset"_gc_read_mostly_locking"=truescope=spfilesid='*';Systemaltered.

重启2号实例成功

SQL>shutdownimmediateORA-01507:databasenotmountedORACLEinstanceshutdown.SQL>startupORACLEinstancestarted.TotalSystemGlobalArea5.3447E+10bytesFixedSize2265864bytesVariableSize1.3019E+10bytesDatabaseBuffers4.0265E+10bytesRedoBuffers160698368bytesDatabasemounted.Databaseopened.

原因是因为之前有人修改过_gc_read_mostly_locking隐藏参数，只是只修改了1号实例。

感谢各位的阅读，以上就是“怎么解决Oracle中的ORA-01105、ORA-01606错误”的内容了，经过本文的学习后，相信大家对怎么解决Oracle中的ORA-01105、ORA-01606错误这一问题有了更深刻的体会，具体使用情况还需要大家实践验证。这里是亿速云，小编将为大家推送更多相关知识点的文章，欢迎关注！