Is Oracle metalink database corrupted?

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Sat, 7 Nov 2009 15:13:02 +0300
Message-ID: <97b7fd2f0911070413p347fa8aat8043ccbe81a272d0_at_mail.gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Nov 07 2009 - 06:13:02 CST

Original text of this message