Re: Is Oracle metalink database corrupted?

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@xxxxxxxxx>wrote:

> They are doing an upgrade it is read only!
>
> On 07/11/2009, 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."
> >
>
>
> --
> 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."

Other related posts: