Is Oracle metalink database corrupted?

Hi list,

When I tried to search something in the metalink a while ago, it throws me
following ORA error:

ORA-00372: file 102 cannot be modified at this time ORA-01110: data file
102: '/u01/app/oracle/admin/mlrepap/db/metalink_08.dbf'

*Debug:*

   1: begin
   2: DECLARE
   3:   lv_sortBy NUMBER;
   4:   lv_saveButton BOOLEAN;
   5:   lv_srcVal NUMBER;
   6:   lv_text  varchar2(400);
   7:   vSql     VARCHAR2(4000);
   8: BEGIN
   9:
  10:   lv_text  := replace(:P_SRCHTXT, '##', ':');
  11:   lv_text  := utl_url.unescape(lv_text);
  12:   lv_srcVal := :P_SOURCE;
  13:   :P_SRCHTXT := lv_text;
  14: htp.p('<script>
  15: document.getElementById("F130_P0_SRCH_SOURCE").value='''||lv_srcVal||''';
  16: document.getElementById("F130_P0_SRCH_TEXT").value='''||replace(lv_text,
'''', '\''')||''';
  17: </script>');
  18:
  19: if (lv_srcVal >4) then
  20:    lv_text   := '';
  21: end if;
  22: lv_text  := ml2_util.urlencode(lv_text);
  23:
  24: begin
  25: lv_sortBy := to_number(:sortBy);
  26: exception
  27:   when others then
  28:           lv_sortBy :=sure_api.c_orderByQueryScore;
  29: end;
  30: BEGIN
  31: IF to_number(:saveButton) = 0 THEN
  32:   lv_saveButton := TRUE;
  33: ELSE
  34:   lv_saveButton := FALSE;
  35: END IF;
  36: exception
  37:   when others then
  38:           lv_saveButton := FALSE;
  39: end;
  40:
  41: IF UPPER(:ST) = 'SC' THEN
  42: :ST := 'R';
  43: :P_SRCHTXT := null;
  44: :F130_P0_SRCH_TEXT := null;
  45: htp.p('<script>
  46: document.getElementById("F130_P0_SRCH_TEXT").value='''';
  47: </script>');
  48: END IF;
  49:
  50: IF ( (upper(:forums) = 'TRUE') and
(ml2_priv.hasAccess(ml2_priv.grantCodeForumAccess) = FALSE) ) then
  51: :forums := 'FALSE';
  52: END IF;
  53:
  54: kno_main.newPreDoAdvancedQuery(
  55:      p_name             =>:name
  56:      ,p_alltext          => REPLACE(:alltext, '$colan',':')
  57:      ,p_anytext          => REPLACE(:anytext, '$colan',':')
  58:      ,p_exctext          => REPLACE(:exctext, '$colan',':')
  59:      ,p_nontext          => REPLACE(:nontext, '$colan',':')
  60:      ,p_docId            => :docid
  61:      ,p_knowledge        => :knowledge
  62:      ,p_bug              => :bug
  63:      ,p_forums           => :forums
  64:      ,p_archive          => :archive
  65:      ,p_product_id       => :product_id
  66:      ,p_platform_id      => :platform_id
  67:      ,p_update           => :update
  68:      ,p_numHits          => NVL(:numHits, 100)
  69:      ,p_sortBy           => NVL(lv_sortBy,sure_api.c_orderByQueryScore)
  70:      ,p_ss               => :ss
  71:      ,p_st               => NVL(:st,'R')
  72:      ,p_saveButton       => lv_saveButton
  73:      ,p_sss              => :sss
  74:      ,p_type             => :type
  75:      ,p_callFrom         => 'ML'
  76:      ,p_filterCrit       => :filtcrit
  77:      ,p_filterVal        => :filtcritval
  78: );
  79:
  80: :name := NULL;
  81: :alltext := NULL;
  82: :anytext:= NULL;
  83: :exctext:= NULL;
  84: :nontext:= NULL;
  85: :docid:= NULL;
  86: :knowledge:= NULL;
  87: :bug:= NULL;
  88: :forums:= NULL;
  89: :archive:= NULL;
  90: :product_id:= NULL;
  91: :platform_id:= NULL;
  92: :update:= NULL;
  93: :numHits:= NULL;
  94: :sortBy := NULL;
  95: :ss:= NULL;
  96: :st:= NULL;
  97: :saveButton := NULL;
  98: :sss:= NULL;
  99: :type:= NULL;
 100: :filtcrit:= NULL;
 101: :filtcritval:= NULL;
 102: END;


 103: end;


Is anyone else got the same issue?

-- 
Best Regards,

Syed Jaffar Hussain
Oracle Certified Master (10g)
http://www.oracle.com/technology/ocm/shussain.html
Oracle ACE
http://apex.oracle.com/pls/otn/f?p=19297:4:4640302666204919::NO:4:P4_ID:186
OCP 8i,9i & 10g DBA
RAC Certified Expert
Official Oracle RAC SIG Representative for Saudi Arabian region  (
http://www.oracleracsig.org/)
I blog at
http://jaffardba.blogspot.com/
LinkedIn : http://www.linkedin.com/pub/syed-jaffar-hussain/2/a71/918
--------------------
"Winners don't do different things. They do things differently."

Other related posts: