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,
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:*
- begin
- DECLARE
- lv_sortBy NUMBER;
- lv_saveButton BOOLEAN;
- lv_srcVal NUMBER;
- lv_text varchar2(400);
- vSql VARCHAR2(4000);
- BEGIN 9:
- lv_text := replace(:P_SRCHTXT, '##', ':');
- lv_text := utl_url.unescape(lv_text);
- lv_srcVal := :P_SOURCE;
- :P_SRCHTXT := lv_text;
- htp.p('<script>
- document.getElementById("F130_P0_SRCH_SOURCE").value='''||lv_srcVal||''';
- document.getElementById("F130_P0_SRCH_TEXT").value='''||replace(lv_text, '''', '\''')||''';
- </script>'); 18:
- if (lv_srcVal >4) then
- lv_text := '';
- end if;
- lv_text := ml2_util.urlencode(lv_text); 23:
- begin
- lv_sortBy := to_number(:sortBy);
- exception
- when others then
- lv_sortBy :=sure_api.c_orderByQueryScore;
- end;
- BEGIN
- IF to_number(:saveButton) = 0 THEN
- lv_saveButton := TRUE;
- ELSE
- lv_saveButton := FALSE;
- END IF;
- exception
- when others then
- lv_saveButton := FALSE;
- end; 40:
- IF UPPER(:ST) = 'SC' THEN
- :ST := 'R';
- :P_SRCHTXT := null;
- :F130_P0_SRCH_TEXT := null;
- htp.p('<script>
- document.getElementById("F130_P0_SRCH_TEXT").value='''';
- </script>');
- END IF; 49:
- IF ( (upper(:forums) = 'TRUE') and (ml2_priv.hasAccess(ml2_priv.grantCodeForumAccess) = FALSE) ) then
- :forums := 'FALSE';
- END IF; 53:
- kno_main.newPreDoAdvancedQuery(
- p_name =>:name
- ,p_alltext => REPLACE(:alltext, '$colan',':')
- ,p_anytext => REPLACE(:anytext, '$colan',':')
- ,p_exctext => REPLACE(:exctext, '$colan',':')
- ,p_nontext => REPLACE(:nontext, '$colan',':')
- ,p_docId => :docid
- ,p_knowledge => :knowledge
- ,p_bug => :bug
- ,p_forums => :forums
- ,p_archive => :archive
- ,p_product_id => :product_id
- ,p_platform_id => :platform_id
- ,p_update => :update
- ,p_numHits => NVL(:numHits, 100)
- ,p_sortBy => NVL(lv_sortBy,sure_api.c_orderByQueryScore)
- ,p_ss => :ss
- ,p_st => NVL(:st,'R')
- ,p_saveButton => lv_saveButton
- ,p_sss => :sss
- ,p_type => :type
- ,p_callFrom => 'ML'
- ,p_filterCrit => :filtcrit
- ,p_filterVal => :filtcritval
- ); 79:
- :name := NULL;
- :alltext := NULL;
- :anytext:= NULL;
- :exctext:= NULL;
- :nontext:= NULL;
- :docid:= NULL;
- :knowledge:= NULL;
- :bug:= NULL;
- :forums:= NULL;
- :archive:= NULL;
- :product_id:= NULL;
- :platform_id:= NULL;
- :update:= NULL;
- :numHits:= NULL;
- :sortBy := NULL;
- :ss:= NULL;
- :st:= NULL;
- :saveButton := NULL;
- :sss:= NULL;
- :type:= NULL;
- :filtcrit:= NULL;
- :filtcritval:= NULL;
- END;
- 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-lReceived on Sat Nov 07 2009 - 06:13:02 CST