Re: Un-able to upload xml file - Error:ORA-14400: inserted partition key does not map to any partition

From: Robert Hanuschke <robert.hanuschke_at_gmail.com>
Date: Wed, 8 Aug 2012 08:01:11 +0200
Message-ID: <CAL6WDh1yBB=wZaBQjHhaVO0uPmbztcfGgVr-zks9qjJsGKFGZg_at_mail.gmail.com>

Hi,
lots of oracle documents mention to set job_queue_processes to 0 for maintenance tasks, upgrades, etc.
Possibly the setting was forgotten when a task of that kind was finished. I don't see a possibility that it changed to 0 by itself.

Have you checked the alert log of the repository database for corresponding "alter system" commands?

Best regards,
Robert
http://robertvsoracle.blogspot.com

On Wed, Aug 8, 2012 at 7:42 AM, <m.mudhalvan_at_aozorabank.co.jp> wrote:

> Dear Team,
> Just an update Today I have checked my Grid and found more error
> messages Management Services and Repository with "Thread: XMLLoader0
> xxxxxxx.xml Failed to load xxxxxxxxxxx.xml even after 2 attempts; moving
> to errors directory. Error:ORA-14400: inserted partition key does not map
> to any partition , File name:/xxx/xxx/xxxxxx.xml"
>
> When we checked in the metalink found a note 303359.1 and checked
> the job_queue_process is set to 0 and we have changed to 10 and it is
> working fine.
>
> Now I am trying to find out the root cause of Job_queue_process
> changed to zero.
>
> Did any one faced the problem of restarting the repository DB
> caused or some other reason job_queue_process changed to zero?
>
> Thanks & Regards
> Mudhalvan M.M
>
> Infrastructure Management Division
> Tel. 042(319)4516 Ext. 34516
> Mobile 81-80-4890-1973
> Email m.mudhalvan_at_aozorabank.co.jp
>
> ----------------------------------------------------------------------------------------------------
> $B!V(B $B$=$N_at_h$O!"$"$*$>$i!#(B $B!W(B
> $BCm!'$3$N(BE-mail$B$O!"5!L)>pJs$r4^$s$G$*$j!"H/?.<T$,0U?^$7$?(B $B<u?.<T$N$_$,MxMQ(B
> $B$9$k$3$H$r0U?^$7$?$b$N$G$9!#K|$,0l!"5.EB(B $B$,$3$N(BE-mail$B$NH/?.<T$,0U?^$7$?<u(B
> $B?.<T$G$J$$>l9g$K$O!"$3(B $B$N(BE-mail$B$N0u:~!"%3%T!<!"E>Aw$=$NB>0l_at_Z$N;HMQ$O6X;_(B
> $B$5$l(B $B$^$9!#EvJ}$N8m$j$K$h$j$3$N(BE-mail$B$r$*<u$1<h$j$K$J$C$?>l9g(B $B$O!"$*<j?t$r(B
> $B$*$+$1$7$^$9$,!"$3$N(BE-mail$B$rGK4~$7!"D>$A$K$4O"(B $BMm$rD:BW$G$-$^$9$H9,$$$G$9(B
> $B!#(B
>
> ----------------------------------------------------------------------------------------------------
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 08 2012 - 01:01:11 CDT