Friday, December 3, 2010

R12 Patch Failed as PLL regeneration didnt succeed.

Recently we applied a patch “897561” on R12 Instance. Patch has failed to complete with failure in regeneration of following PLL's

The following Oracle Forms objects did not generate successfully:

au resource APCACHE.pll
au resource APPAYSHD.pll
au resource APPREPAY.pll
au resource APXINLIN.pll

I tried to regenerate the PLL manually using the below method,

$ORACLE_HOME/bin/frmcmp.sh module= userid=APPS_/ output_file= module_type=library batch=yes compile_all=special
OR

$ORACLE_HOME/bin/frmcmp_batch.sh userid=apps/apps module= output_file= module_type=library compile_all=special

It failed with the following errors.

exec(): 0509-036 Cannot load program /opt/oraapps/SID_NAME/tech_st/10.1.2/bin/frmcmp_batch because of the following errors:
rtld: 0712-001 Symbol deucxealert was referenced
from module /opt/oraapps/I/tech_st/10.1.2/lib32/libig.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol deucxget was referenced
from module /opt/oraapps/SID_NAME/tech_st/10.1.2/lib32/libig.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol depcxset was referenced
from module /opt/oraapps/SID_NAME/tech_st/10.1.2/lib32/libig.so(), but a runtime definition
of the symbol was not found.

These above errors show that the problem is not with the regenerating the PLL files instead the frmcmp.sh/frmcmp_batch.sh itself failing to execute. After failed attempts to get some useful notes from metalink,I tried adrelink.sh.still no change. Also tried to change the PATH location by first putting $ORACLE_HOME/lib instead of $ORACLE_HOME/lib32.This time it threw new error. When comparing with the similar environment everything including seems to be same.

Then finally did a 'relink all' under 10.1.2 $ORACLE_HOME to generate the executables. This is has fixed the issue. The issue could have been due to the fact that 'adcfgclone.pl' was run using wrong path set.

No comments: