Re: Is Oracle metalink database corrupted?

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

Oh ya, you are true. I have over looked their maintenance note.

On Sat, Nov 7, 2009 at 3:18 PM, Howard Latham <howard.latham_at_gmail.com>wrote:

> They are doing an upgrade it is read only!
>
> On 07/11/2009, Syed Jaffar Hussain <sjaffarhussain_at_gmail.com> 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."
> >
>
>
> --
> Howard A. Latham
>

-- 
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:21:01 CST