Tuesday, December 7, 2010

Strange Misleading Error[XML -2018/ AC-10006] while R12 Clone

During the recent Multi Node to Single Node R12 Clone, Encountered an strange error. When doing the database portion of the clone. Below command 'adclonectx.pl' creates the Context file


$ perl adclonectx.pl contextfile=$ORACLE_HOME/appsutil/SOURCE_CONTEXT_FILE.xml template=$ORACLE_HOME/appsutil/template/adxdbctx.tmp pairsfile=$ORACLE_HOME/appsutil/clone/pairsfile.txt initialnode


When running the same command, It dumped the below error,


file:/tmp/tmpCtxClone.xml: XML-20108: (Fatal Error) Start of root element expected.

AC-10006: Exception - org.xml.sax.SAXParseException: file:/tmp/tmpCtxClone.xml: XML-20108: (Fatal Error) Start of root element expected. thrown while creating OAVars object for file: /tmp/tmpCtxClone.xml

The new database context file has been created :
/opt/oracle/product/11.1.0_
SID/appsutil/SID_HostName.xml


At first site, I suspected that the issue is with format of the source xml file. Hence compared with the working XML file. Result is clean. Below portion of the error struck me


Thrown while creating OAVars object for file: /tmp//dummy.xml


Cause :

The /tmp is 100% full.


Fix:

Either remove the old files in /tmp directory OR export TEMP=/new/location where there is plenty of free space.

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.