一个朋友的数据库意外掉电,重新启动报错ora-600[kccsbck_first][1]......,环境是oracle816ops
查看了下metalink.http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=157536.1&p_database_id=NOT
两个机器都重新启动后就解决问题了。
转贴原文:
<script language=JavaScript> var savetarg = ""; var saveactn = ""; var srcform = null; var winid = null; function Launch( url,nam,w,h,mbar,tbar ) { if (!w) { w=600; } if (!h) { h=600; } if (!mbar) { mbar="yes"; } if (!tbar) { tbar="no"; } plist='scrollbars=yes,resizable=yes,width='+w+',height='+h+',menubar='+mbar+',toolbar='+tbar; //open(url,nam,'menubar=no,scrollbars=yes,resizable=yes,width='+w+',height='+h); //open(url,nam,'menubar=no,scrollbars=yes,resizable=yes,width='+w+',height='+h+',toolbar='+tbar); winid=open(url,nam,plist); return true; } function TargetPost(srcf, targ, actn, submitval, newwin, mbar, tbar) { srcform = srcf; if (newwin){ Launch('/webiv/pages/blank.html',targ, 600, 600, mbar, tbar); savetarg=document.forms[srcform].target; document.forms[srcform].target=targ; } else {document.forms[srcform].target = "" } saveactn = document.forms[srcform].action; document.forms[srcform].action=actn; // special cases ... if (targ == "EditPrivs"){ document.forms[srcform].elements["IGNORE_LOCKS"].value="FALSE"; } if (submitval != null){ document.forms[srcform].WwwAction.value = submitval; } document.forms[srcform].submit(); return(true); } function SaveTarget() { if (document.forms[0] != null) { savetarg=document.forms[0].target; saveactn=document.forms[0].action; } } function ResetTarget() { if (srcform != null && document.forms[srcform] != null) { // document.forms[srcform].target=""; document.forms[srcform].target=savetarg; document.forms[srcform].action=saveactn; } } function GetRandom() { return Math.round(100 * Math.random()); } </script>
查看了下metalink.http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=157536.1&p_database_id=NOT
两个机器都重新启动后就解决问题了。
转贴原文:
<script language=JavaScript> var savetarg = ""; var saveactn = ""; var srcform = null; var winid = null; function Launch( url,nam,w,h,mbar,tbar ) { if (!w) { w=600; } if (!h) { h=600; } if (!mbar) { mbar="yes"; } if (!tbar) { tbar="no"; } plist='scrollbars=yes,resizable=yes,width='+w+',height='+h+',menubar='+mbar+',toolbar='+tbar; //open(url,nam,'menubar=no,scrollbars=yes,resizable=yes,width='+w+',height='+h); //open(url,nam,'menubar=no,scrollbars=yes,resizable=yes,width='+w+',height='+h+',toolbar='+tbar); winid=open(url,nam,plist); return true; } function TargetPost(srcf, targ, actn, submitval, newwin, mbar, tbar) { srcform = srcf; if (newwin){ Launch('/webiv/pages/blank.html',targ, 600, 600, mbar, tbar); savetarg=document.forms[srcform].target; document.forms[srcform].target=targ; } else {document.forms[srcform].target = "" } saveactn = document.forms[srcform].action; document.forms[srcform].action=actn; // special cases ... if (targ == "EditPrivs"){ document.forms[srcform].elements["IGNORE_LOCKS"].value="FALSE"; } if (submitval != null){ document.forms[srcform].WwwAction.value = submitval; } document.forms[srcform].submit(); return(true); } function SaveTarget() { if (document.forms[0] != null) { savetarg=document.forms[0].target; saveactn=document.forms[0].action; } } function ResetTarget() { if (srcform != null && document.forms[srcform] != null) { // document.forms[srcform].target=""; document.forms[srcform].target=savetarg; document.forms[srcform].action=saveactn; } } function GetRandom() { return Math.round(100 * Math.random()); } </script>
Problem Description ------------------- This article helps to resolve problems with the error ora-600[kccsbck_first]. The ORA-600[kccsbck_first] error occurs when Oracle detects that another instance has this database already mounted. For some reason, Oracle already sees a thread with a heartbeat. This could be the expected behaviour if running OPS. In such a case the parallel_server parameter needs to be set. In cases where Parallel Server is not linked in, this is not the expected