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's manually using the below method,

 

$ORACLE_HOME/bin/frmcmp.sh module=<Name_of_pll_file> userid=APPS_/<apps_pw> output_file=<Name_of_plx_file> module_type=library batch=yes compile_all=special
OR

$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.

 

Comments:

nice one thanks

Posted by guest on February 19, 2013 at 12:39 PM GMT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

I am Jagatheesh Ramakrishnan - Apps DBA currently part of Advanced Customer Services for Oracle Corp.Am based out in London and working for a major bank customer.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today