Results 1 to 12 of 12
  1. #1
    Join Date
    Jan 2006
    Posts
    19

    Unanswered: Drive (recv\errors) filling up - ORA-14400

    Hello,

    I have a oracle environment with several servers and I am managing them with the Enterprise Manager. This all worked fine until somewhere 2 weeks ago.

    The recv/errors started filling up fast and I am running out of disk space. So now daily I have to empty this folder. What I see in the files is the following:
    recv/errors/*.* (it all seems to be xml files):

    Code:
    <!-- 
    
    	 Time: <datetime>
    	 From: https://<servername>:3872/emd/main/
    
    -->
    
    <UPLOAD OMS_PROTOCOL_VERSION="10.2.0.2.0"  UPLOAD_TYPE="data"  EMD_URL="https://<servername>:3872/emd/main/" MERGE_TIMESTAMP="<datetime>">
    <ROWSET OMS_PROTOCOL_VERSION="10.2.0.2.0" TABLE="MGMT_METRICS_RAW">
    <ROW>
    	<TARGET_GUID><GUIDHERE></TARGET_GUID>
    	<METRIC_GUID><METRIC VALUE></METRIC_GUID>
    	<KEY_VALUE/>
    	<COLLECTION_TIMESTAMP><DATETIME></COLLECTION_TIMESTAMP>
    	<STRING_VALUE>ARCHIVELOG</STRING_VALUE>
    </ROW>
    So I look in the emoms and see this:
    Code:
    <datetime> [XMLLoader0 <filename>] ERROR eml.XMLLoader markFileAsError.824 - Failed to load <filename> even after 2 attempts; moving to errors directory. Error:
    java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition
    Does anyone have an idea where this could all of a sudden come from? The only thing I can find in the database is a warning: "Metrics "Current Open Cursors Count" is at 1208". So I will try to fix that. But does anyone have another thing that I could try/debug?

    /update: removed some additional information
    Last edited by jacsoft; 09-18-11 at 16:31.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    14400, 00000, "inserted partition key does not map to any partition"
    // *Cause:  An attempt was made to insert a record into, a Range or Composite
    //          Range object, with a concatenated partition key that is beyond 
    //          the concatenated partition bound list of the last partition -OR-
    //          An attempt was made to insert a record into a List object with
    //          a partition key that did not match the literal values specified
    //          for any of the partitions. 
    // *Action: Do not insert the key. Or, add a partition capable of accepting
    //          the key, Or add values matching the key to a partition specification
    Is this APEX/XE version of Oracle?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2006
    Posts
    19
    Thanks for your reply. I also found something like that, but the strange thing is that is worked for like 5 months and now all of the sudden these errors start without anything that has changed.

    No it is not the APEX/XE version, it are all Enterprise editions.

    /update: Removed extensive version types.
    Last edited by jacsoft; 09-18-11 at 16:30.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >TABLE="MGMT_METRICS_RAW"
    above is owned by SYSMAN schema, but see below
    1* select table_name, partition_name from dba_tab_partitions where table_owner = 'SYSMAN'
    SQL> /

    no rows selected
    SYSMAN does not own any partitioned tables, so I am unsure exactly what the problem is.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jan 2006
    Posts
    19
    Thanks for your input again. Glad to see I am not the only one who is unsure about what the problem is. Especially since it 'all of a sudden' happened.

    Do you think dropping and rebuilding the table could be an option?

    btw: I am trying this thread to see if it works. https://forums.oracle.com/forums/thr...hreadID=574873

    update: unfortunately the link above did not solve the problem.
    Last edited by jacsoft; 09-18-11 at 17:21.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Do any additional clues exist within alert_SID.log file?
    I would NOT drop the table (yet).
    Do the timestamps on the files provide any clue; like scheduled batch job?
    Consider enable AUDIT SESSION to try to monitor new sessions at same time as the files.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Jan 2006
    Posts
    19
    Thank you for your reply again.
    I cannot find any alert_sid.log file nor can I find any alert_<sid>.log file.
    I can also not find any other message or something in all the log files that I have opened. Do you have a clue where I should find that alert_sid.log file?

    No it is not a scheduled batch job. The errors seem to be created throughout the complete day. I only have backup jobs scheduled and the default maintenance plans. SO nothing out of the ordinary.

    I'll have a look at the audit session option.

    update: It seems that it has dramatically reduced after the link I posted above. After that I got some other problems about columns being too small. I resized them and the errors directory seems to be clean(er). I have an eye on it, but it looks like it is might be resolved.

    Thank you very much anacedent for your replies and taking the time to assist me (y).
    Last edited by jacsoft; 09-18-11 at 19:41.

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I cannot find any alert_sid.log file nor can I find any alert_<sid>.log file.
    The file resides under $ORACLE_HOME; where you replace "sid" with actual value of ORACLE_SID
    I still have no clue OS name & version of DB Sever system
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Jan 2006
    Posts
    19
    Sorry I waited so long for my reply, but I had other things to do.

    I have less errors, but the only error I have now (emoms.log) is:
    [XMLLoader0 <file>.xml] ERROR eml.XMLLoader markFileAsError.824 - Failed to load <file>.xml;

    Without any additional information.

    I have Windows Server 2003 with Oracle Enterprise 10g (and Enterprise Manager 10g) and Oracle Enterprise 11g running.

  10. #10
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    It may be that you have a corrupted file, in which case clearing the agent will help.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  11. #11
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    jacsoft,

    up to (including) Oracle 10g you'll find alert log under $ORACLE_BASE/admin/<SID>/bdump/alert<SID>.ora

    I.e., if your $ORACLE_BASE directory is "/oracle" and your $ORACLE_SID is "ORCL" the file would be /oracle/admin/ORCL/bdump/alertORCL.ora

    In 11g it's under $ORACLE_BASE/diag/rdbms/<instance>/$ORACLE_SID/trace/alert<SID>.ora

    (i.e. /oracle/diag/rdbms/orcl/ORCL/trace/alertORCL.log)
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

  12. #12
    Join Date
    Jan 2006
    Posts
    19
    Thanks for your replies. The problem hasn't been resolved, I only made it much worse. I tried to secure my Agents and the OMS with a valid third party certificate. Created a wallet and tried to secure everything. But now the oms seems to be twice secured (I get two errors that the certificate is not correct) and the Agents ran into problems (they were not uploading the files and were not reporting rman output to the management server. I am now unsecuring the agents so the things work again.

    But I keep on playing with this and hoping to be able to install a correct valid certificate (not self signed)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •