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 
August 1st, 2011 at 10:15 pm
Hi Mr.Kamran,
How did you which library files are corrupted ????
August 19th, 2011 at 12:50 pm
Nice topic! Good job!
December 8th, 2011 at 7:17 pm
good topic
January 2nd, 2012 at 10:52 am
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
January 13th, 2012 at 8:35 am
Hi Ajay. Check the following link:
MOS DOC 852794.1