Writen by
Devil
6:48 PM
-
1
Comments
Some of the very common Errors post 11g up-gradation are as below
1) After successfully migrating the 10g repository and catalog to 11g most of the reports are working fine, except for some reports which are shooting the following error:
Error Codes: OAMP2OPY:ACIOA5LN
Assertion failure: isXsiTypeSqlExpression(rExpr) at line 67 of C:\ADE\aime_bi\bifndn\analytics_web\main/project/webreport/exprformulautils.cpp
Resolution :
Apply Patch 12561330, Follow below steps for applying the patch
Download opatch setup from here,
"https://support.oracle.com/CSP/ui/flash.html#tab=PatchHomePage(page=PatchHomePage&id=gj46o799()),(page=PatchSearchResultsHome&id=gj46pr1y(search=%3CSearch%3E%0A%20%20%3CFilter%20name=%22patch_number%22%20op=%22IS%22%20value=%226880880%22%20type=%22patch_number%22/%3E%0A%20%20%3CFilter%20name=%22platform%22%20op=%22IS%22%20value=%22%22%20type=%22platform%22/%3E%0A%3C/Search%3E&incFamilyProds=false&flag=search))"
*Make sure you only use 11.1.0.8.3, do not use 11.2.x version
"https://support.oracle.com/CSP/ui/flash.html#tab=PatchHomePage(page=PatchHomePage&id=gj46o799()),(page=PatchSearchResultsHome&id=gj46pr1y(search=%3CSearch%3E%0A%20%20%3CFilter%20name=%22patch_number%22%20op=%22IS%22%20value=%226880880%22%20type=%22patch_number%22/%3E%0A%20%20%3CFilter%20name=%22platform%22%20op=%22IS%22%20value=%22%22%20type=%22platform%22/%3E%0A%3C/Search%3E&incFamilyProds=false&flag=search))"
*Make sure you only use 11.1.0.8.3, do not use 11.2.x version
1. Unzip the patch zip file into the PATCH_TOP.
unzip -d PATCH_TOP p12561330_111150_WINNT.zip
2. Set your current directory to the directory where the patch is located.
cd PATCH_TOP/12561330
3. Run OPatch to apply the patch.
Run following command:
- opatch apply -jre $ORACLE_HOME/jdk/jre
unzip -d PATCH_TOP p12561330_111150_WINNT.zip
2. Set your current directory to the directory where the patch is located.
cd PATCH_TOP/12561330
3. Run OPatch to apply the patch.
Run following command:
- opatch apply -jre $ORACLE_HOME/jdk/jre
On step 3 i got the following error: 'opatch' is not recognized as internal or external command, operable program or batch file.
ReplyDeletePlease advise