R12 Patch Failed as PLL regeneration didnt succeed.
By JAGORACLE on Dec 03, 2010
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 APPAYSHD.pll
au resource APPREPAY.pll
au resource APXINLIN.pll
I tried to regenerate the PLL's manually using the below method,
output_file=<Name_of_plx_file> module_type=library batch=yes
$ORACLE_HOME/bin/frmcmp_batch.sh userid=apps/apps module=<Name_of_pll_file> output_file=<Name_of_plx_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 executable's. This is has fixed the issue. The issue could have been due to the fact that 'adcfgclone.pl' would have run using wrong path set.