MIME-Version: 1.0
In-Reply-To: <OF1EB16E1E.C0FA28E1-ON49257A54.001EE419-49257A54.001F642F@aozorabank.co.jp>
References: <OF1EB16E1E.C0FA28E1-ON49257A54.001EE419-49257A54.001F642F@aozorabank.co.jp>
Date: Wed, 8 Aug 2012 08:01:11 +0200
Message-ID: <CAL6WDh1yBB=wZaBQjHhaVO0uPmbztcfGgVr-zks9qjJsGKFGZg@mail.gmail.com>
Subject: Re: Un-able to upload xml file - Error:ORA-14400: inserted partition
 key does not map to any partition
From: Robert Hanuschke <robert.hanuschke@gmail.com>
To: m.mudhalvan@aozorabank.co.jp
Cc: oracle-l@freelists.org
Content-type: text/plain
Content-Transfer-Encoding: 8bit
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: robert.hanuschke@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@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@aozorabank.co.jp
>
> ----------------------------------------------------------------------------------------------------
> 「 その先は、あおぞら。 」
> 注：このE-mailは、機密情報を含んでおり、発信者が意図した 受信者のみが利用
> することを意図したものです。万が一、貴殿 がこのE-mailの発信者が意図した受
> 信者でない場合には、こ のE-mailの印刷、コピー、転送その他一切の使用は禁止
> され ます。当方の誤りによりこのE-mailをお受け取りになった場合 は、お手数を
> おかけしますが、このE-mailを破棄し、直ちにご連 絡を頂戴できますと幸いです
> 。
>
> ----------------------------------------------------------------------------------------------------
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


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