Re: Is Oracle metalink database corrupted?
Date: Sat, 7 Nov 2009 04:53:16 -0800 (PST)
Message-ID: <910724.56034.qm_at_web45011.mail.sp1.yahoo.com>
�
Well they can't see it is "read only" when you can't read anything :-) because a datafile is offline
Fairlie Rego
Senior Oracle Consultant
http://el-caro.blogspot.com/
M: +61 402 792 405
�
- On Sat, 7/11/09, Syed Jaffar Hussain <sjaffarhussain_at_gmail.com> wrote:
From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com> Subject: Re: Is Oracle metalink database corrupted? To: "Howard Latham" <howard.latham_at_gmail.com> Cc: "Oracle-L Freelists" <oracle-l_at_freelists.org> Received: Saturday, 7 November, 2009, 11:21 PM
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." __________________________________________________________________________________ Win 1 of 4 Sony home entertainment packs thanks to Yahoo!7. Enter now: http://au.docs.yahoo.com/homepageset/ -- http://www.freelists.org/webpage/oracle-lReceived on Sat Nov 07 2009 - 06:53:16 CST