Kamran Agayev's Oracle Blog

Oracle Certified Master

Fixing "Archive not applied " error during patch apply

Posted by Kamran Agayev A. on July 22nd, 2011

I was requested to apply a patch on one of the production databases. During patch apply, I got the following error and rolled the patch back:

[code]

The following actions have failed:
Archive not applied /oracle/orasoft/8528171/files/lib/libserver10.a/kqlm.o to /oracle/product/10.2.0/lib/libserver10.a... ''
Archive not applied /oracle/orasoft/8528171/files/lib/libserver10.a/kkpod.o to /oracle/product/10.2.0/lib/libserver10.a... ''
Archive not applied /oracle/orasoft/8528171/files/lib/libserver10.a/kkpox.o to /oracle/product/10.2.0/lib/libserver10.a... ''
Archive not applied /oracle/orasoft/8528171/files/lib/libgeneric10.a/kgl.o to /oracle/product/10.2.0/lib/libgeneric10.a... ''
Archive not applied /oracle/orasoft/8528171/files/lib/libgeneric10.a/kgl2.o to /oracle/product/10.2.0/lib/libgeneric10.a... ''
Archive not applied /oracle/orasoft/8528171/files/lib/libgeneric10.a/kgh.o to /oracle/product/10.2.0/lib/libgeneric10.a... ''
Archive not applied /oracle/orasoft/8528171/files/lib32/libgeneric10.a/kgl.o to /oracle/product/10.2.0/lib32/libgeneric10.a... ''
Archive not applied /oracle/orasoft/8528171/files/lib32/libgeneric10.a/kgl2.o to /oracle/product/10.2.0/lib32/libgeneric10.a... ''
Archive not applied /oracle/orasoft/8528171/files/lib32/libgeneric10.a/kgh.o to /oracle/product/10.2.0/lib32/libgeneric10.a... ''
Do you want to proceed?
[y|n]
[/code]

 

After contacting Oracle Support we decided that there may be a corruption on the mentioned library files.

As a solution, I installed Oracle Software to the different directory, applied necessary patchset, created new database and tested the patch, it succeeded. So I rolled back the latest patch, copied three library files to the previous Oracle home (to the lib and lib32 folders) and applied the patch, and of course, it succeeded.

 

So if you get the above message “Archive not applied” when applying patch, don’t worry, this means that the mentioned library files might be corrupted. Just perform above steps and don’t forget to backup your old library files :)

5 Responses to “Fixing "Archive not applied " error during patch apply”

  1. Ali Says:

    Hi Mr.Kamran,
    How did you which library files are corrupted ????

  2. fabio Says:

    Nice topic! Good job!

  3. ram Says:

    good topic

  4. Ajay Says:

    Hi
    Kamran this is Ajay recentely i got this error when using datapump

    Export: Release 10.2.0.4.0 – 64bit Production on Thursday, 29 December, 2011 please advice why it’s comming and how to fix this

    ORA-39127: unexpected error from call to export_string := SYS.DBMS_RULE_EXP_RULES.create_exp(620688,’10.02.00.04.00′,newblock)
    ORA-01403: no data found
    ORA-01403: no data found
    ORA-06512: at “SYS.DBMS_RULE_EXP_UTL”, line 42
    ORA-06512: at “SYS.DBMS_RULE_EXP_RULES”, line 26
    ORA-06512: at line 1
    ORA-06512: at “SYS.DBMS_METADATA”, line 5038
    ORA-39127: unexpected error from call to export_string := SYS.DBMS_RULE_EXP_RULE_SETS.create_exp(620687,’10.02.00.04.00′,newblock)
    ORA-01403: no data found
    ORA-01403: no data found
    ORA-06512: at “SYS.DBMS_RULE_EXP_UTL”, line 42
    ORA-06512: at “SYS.DBMS_RULE_EXP_RULE_SETS”, line 26
    ORA-06512: at line 1
    ORA-06512: at “SYS.DBMS_METADATA”, line 5038
    ORA-39127: unexpected error from call to export_string := SYS.DBMS_RULE_EXP_RULE_SETS.create_exp(620683,’10.02.00.04.00′,newblock)
    ORA-01403: no data found
    ORA-01403: no data found
    ORA-06512: at “SYS.DBMS_RULE_EXP_UTL”, line 42
    ORA-06512: at “SYS.DBMS_RULE_EXP_RULE_SETS”, line 26
    ORA-06512: at line 1
    ORA-06512: at “SYS.DBMS_METADATA”, line 5038
    ORA-39127: unexpected error from call to export_string := SYS.DBMS_RULE_EXP_RULE_SETS.create_exp(620684,’10.02.00.04.00′,newblock)
    ORA-01403: no data found
    ORA-01403: no data found
    ORA-06512: at “SYS.DBMS_RULE_EXP_UTL”, line 42
    ORA-06512: at “SYS.DBMS_RULE_EXP_RULE_SETS”, line 26
    ORA-06512: at line 1
    ORA-06512: at “SYS.DBMS_METADATA”, line 5038

  5. Kamran Agayev A. Says:

    Hi Ajay. Check the following link:
    MOS DOC 852794.1

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>