Re: Is Oracle metalink database corrupted?
- From: LS Cheng <exriscer@xxxxxxxxx>
- To: sjaffarhussain@xxxxxxxxx
- Date: Sun, 8 Nov 2009 13:22:44 +0100
even it's in maintenance mode or read only it's not very professional show
those ORA- errors to the public
I have seen ORA- error in lastminute.com, transhotel.com, oracle.com, I
thought that would never happens with the support site! :-D
--
LSC
On Sat, Nov 7, 2009 at 1:13 PM, Syed Jaffar Hussain <
sjaffarhussain@xxxxxxxxx> wrote:
> 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:
