这篇文章主要介绍“怎么修复Oracle 11.2.0.1 dblink访问ORA-600”，在日常操作中，相信很多人在怎么修复Oracle 11.2.0.1 dblink访问ORA-600问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”怎么修复Oracle 11.2.0.1 dblink访问ORA-600”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！

db alert log

2019-08-1215:46:15.334000+08:00Errorsinfile/oracle/app/oracle/diag/rdbms/anbob/anbob/trace/anbob_ora_14800.trc(incident=320040):ORA-00600:internalerrorcode,arguments:[2252],[5579],[3110485746],[],[],[],[],[],[],[],[],[]Incidentdetailsin:/oracle/app/oracle/diag/rdbms/anbob/anbob/incident/incdir_320040/anbob_ora_14800_i320040.trc2019-08-1215:46:17.000000+08:00Tracedumpingisperformingid=[cdmp_20190812154617]Sweep[inc][320040]:completedSweep[inc2][320040]:completed

trace file

adrci>showincident-allADRHome=/oracle/app/oracle/diag/rdbms/anbob/anbob:*************************************************************************INCIDENT_IDPROBLEM_KEYCREATE_TIME-----------------------------------------------------------------------------------------------------------------------...320037ORA600[2252]2019-08-0809:35:59.628000+08:00304310ORA600[2252]2019-08-0809:39:21.668000+08:00304295ORA600[2252]2019-08-0809:59:10.141000+08:00304302ORA600[2252]2019-08-0814:38:15.196000+08:00304253ORA600[2252]2019-08-0911:04:34.003000+08:00320038ORA600[2252]2019-08-0911:40:43.692000+08:00304289ORA600[2252]2019-08-0915:02:21.345000+08:00320039ORA600[2252]2019-08-1210:05:07.925000+08:00304303ORA600[2252]2019-08-1211:21:54.489000+08:00320040ORA600[2252]2019-08-1215:46:15.334000+08:0050rowsfetchedadrci>showtracefile/oracle/app/oracle/diag/rdbms/anbob/anbob/trace/anbob_ora_14800.trcDumpcontinuedfromfile:/oracle/app/oracle/diag/rdbms/anbob/anbob/trace/anbob_ora_14800.trc1>*****ErrorStack*****ORA-00600:internalerrorcode,arguments:[2252],[5579],[3110485746],[],[],[],[],[],[],[],[],[]1<*****ErrorStack*****1>*****Dumpforincident320040(ORA600[2252])********2019-08-1215:46:15.336dbkedDefDump():Startingincidentdefaultdumps(flags=0x2,level=3,mask=0x0)2>*****SQLStatement(None)*****CurrentSQLinformationunavailable-nocursor.*****CallStackTrace*****callingcallentrylocationtypepoint------------------------------------------------skdstdst()+36callkgdsdst()ksedst1()+98callskdstdst()ksedst()+34callksedst1()dbkedDefDump()+2736callksedst()ksedmp()+36calldbkedDefDump()ksfdmp()+64callksedmp()dbgexPhaseII()+1764callksfdmp()dbgexProcessError()calldbgexPhaseII()+2279dbgeExecuteForErrorcalldbgexProcessError()()+83dbgePostErrorKGE()+calldbgeExecuteForError1615()dbkePostKGE_kgsf()+calldbgePostErrorKGE()63kgeade()+350calldbkePostKGE_kgsf()kgeriv_int()+98callkgeade()kgeriv()+12callkgeriv_int()kgesiv()+110callkgeriv()ksesic2()+194callkgesiv()kcmchk()+113callksesic2()kcsadjn()+315callkcmchk()k2serv()+390callkcsadjn()opiodr()+1149callk2serv()ttcpip()+1251callopiodr()opitsk()+1628callttcpip()

临时断开dblink 后

SQL>selectversion,to_char(SYSDATE,'YYYY/MM/DDHH24:MI:SS')DATE_TIME,((((((to_number(to_char(sysdate,'YYYY'))-1988)*12*31*24*60*60)+((to_number(to_char(sysdate,'MM'))-1)*31*24*60*60)+(((to_number(to_char(sysdate,'DD'))-1))*24*60*60)+(to_number(to_char(sysdate,'HH24'))*60*60)+(to_number(to_char(sysdate,'MI'))*60)+(to_number(to_char(sysdate,'SS'))))*(16*1024))-dbms_flashback.get_system_change_number)/(16*1024*60*60*24))indicatorfromv$instance;VERSIONDATE_TIMEINDICATOR----------------------------------------------11.2.0.1.02019/08/1217:31:2013.1391809

下载补丁
[oracle@localhost ~]$ ls
p12419378_112010_Linux-x86-64.zip
p6880880_112000_Linux-x86-64.zip
p14121009_112016_Linux-x86-64.zip

安装11.2.0.1 PSU

$exportPATH=$PATH:$ORACLE_HOME/OPatch$opatchprereqCheckConflictAgainstOHWithDetail-phBaseDir./12419378$opatchapplySQL>@?/rdbms/admin/catbundlepsuapply

note:
Opatch warning: overriding ….This is a warning only which opatch is reporting. The Patch has applied successfully and the warning output can be safely ignored.

安装one-off patch

[oracle@localhost14121009]$opatchprereqCheckConflictAgainstOHWithDetail-ph./[oracle@localhost14121009]$opatchapplySQL>@?/sqlpatch/14121009/postinstall.sql

检查

SQL>select*fromregistry$history;SQL>@scn_compat_check.sqlCurrentdatatime:2019081410:38:33OracleVersion:OracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProductionDatabaserole:PRIMARYInstancestarttime:2019081410:34:43RSL=35937836695552headroom_in_scn=19308210069494headroom_in_sec=196413269CUR_SCN_COMPAT=3MAX_SCN_COMPAT=3auto_rollover_ts=2019-06-23target_compat=3Auto_rolloverisenabled!SCNcompathadAutorollover!PL/SQLproceduresuccessfullycompleted.

到此，关于“怎么修复Oracle 11.2.0.1 dblink访问ORA-600”的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注亿速云网站，小编会继续努力为大家带来更多实用的文章！