tag:blogger.com,1999:blog-6369673212267799064.post1224508522737443193..comments2024-03-27T10:34:25.100+05:30Comments on FOA(Fun Oracle Apps) -Learn Oracle Apps/Linux Admin/Bash Scripting/Core/RAC/Datagaurd DBA/Cloud: Oracle EBS Release Update Steps from 12.2.0 to R12.2.10Himanshuhttp://www.blogger.com/profile/16681678232243263545noreply@blogger.comBlogger17125tag:blogger.com,1999:blog-6369673212267799064.post-62442734793301526512023-10-27T16:11:39.166+05:302023-10-27T16:11:39.166+05:30Getting below error after apply etcc application p...Getting below error after apply etcc application patches while starting application. URL not accessible-<br />[applmgr@testerp scripts]$ ./adapcctl.sh startall<br /><br />You are running adapcctl.sh version 120.0.12020000.2<br /><br />opmnctl startall: starting opmn and all managed processes...<br />================================================================================<br />opmn id=testerp.txis.com:6207<br />Response: 0 of 1 processes started.<br /><br />ias-instance id=EBS_web_TEST_OHS1<br />++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++<br />--------------------------------------------------------------------------------<br />ias-component/process-type/process-set:<br /> EBS_web_TEST/OHS/OHS/<br /><br />Error<br />--> Process (index=1,uid=1919571417,pid=29429)<br /> failed to start a managed process after the maximum retry limit<br /> Log:<br /> /data/TEST/apps/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1/diagnostics/logs/OHS/EBS_web_TEST/console~OHS~1.log<br /><br /><br />adapcctl.sh: exiting with status 0<br /><br />adapcctl.sh: check the logfile /data/TEST/apps/fs1/inst/apps/TEST_testerp/logs/appl/admin/log/adapcctl.txt for more information ...<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6369673212267799064.post-31211468007731903812022-05-11T13:49:59.752+05:302022-05-11T13:49:59.752+05:30You are referring to online patching or hotpatch m...You are referring to online patching or hotpatch mode?Himanshuhttps://www.blogger.com/profile/16681678232243263545noreply@blogger.comtag:blogger.com,1999:blog-6369673212267799064.post-61398899681330624682022-05-09T10:53:43.675+05:302022-05-09T10:53:43.675+05:30from 12.2.0 onwards no need to stop the applicatio...from 12.2.0 onwards no need to stop the application tier for ETCC and TXK patches during the patching activity. i tried and it workedAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6369673212267799064.post-4082496836604608312022-02-06T16:48:01.577+05:302022-02-06T16:48:01.577+05:30Thanks Himanshu . A good reference.Thanks Himanshu . A good reference.pradeephttps://www.blogger.com/profile/02128105329410013200noreply@blogger.comtag:blogger.com,1999:blog-6369673212267799064.post-22867431630793159252021-11-09T18:03:10.023+05:302021-11-09T18:03:10.023+05:30Yes ,AppsLocalLogin.jsp is in folder $OA_HTML
html...Yes ,AppsLocalLogin.jsp is in folder $OA_HTML<br />html]$ ls -ltr AppsLocalLogin.jsp<br />-rw-r--r--. 1 oracle oinstall 4358 Nov 9 12:34 AppsLocalLogin.jsp<br />And related runtime classes are available in $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/_pages folder<br />_pages]$ ls -ltr *appslocallo*<br />-rw-r--r--. 1 oracle oinstall 9112 Nov 9 14:45 __appslocallogout.class<br />-rw-r--r--. 1 oracle oinstall 10151 Nov 9 14:58 __appslocallogin.class<br /><br />Recompiled all jsp , but no luck. Only this /OA_HTML/AppsLocalLogin.jsp is not working. Otherwise application is working without any issue.<br />Is there any special setup in $FND_TOP/secure?<br /><br />Regards<br />Satheesh<br />SATHEESH KUMARhttps://www.blogger.com/profile/10804277613487164342noreply@blogger.comtag:blogger.com,1999:blog-6369673212267799064.post-37865824475831507342021-11-09T15:41:38.027+05:302021-11-09T15:41:38.027+05:30AppsLocalLogin.jsp file is present on server, if y...AppsLocalLogin.jsp file is present on server, if yes please try to recompile the jsp.Himanshuhttps://www.blogger.com/profile/16681678232243263545noreply@blogger.comtag:blogger.com,1999:blog-6369673212267799064.post-20168162324327794202021-11-09T09:32:52.322+05:302021-11-09T09:32:52.322+05:30Yes, I able to access the application using the be...Yes, I able to access the application using the below URL<br />https://XXXXX.com/OA_HTML/RF.jsp?function_id=31645&resp_id=-1&resp_appl_id=-1&security_group_id=0&lang_code=US&oas=6OXZu5iX1LEIuCj8xJLQlA..&params=KQ0ueFd3h5ncJDQ0.532EQ.<br />Using the above URL login page is appearing , after login application working normally.<br /><br />But OA_HTML/AppsLocalLogin.jsp is not accessibleSATHEESH KUMARhttps://www.blogger.com/profile/10804277613487164342noreply@blogger.comtag:blogger.com,1999:blog-6369673212267799064.post-13590625517313357892021-11-08T22:19:54.348+05:302021-11-08T22:19:54.348+05:30s_url_protocol
s_local_url_protocol
s_webentryu...s_url_protocol <br />s_local_url_protocol <br />s_webentryurlprotocol<br />s_active_webport <br />s_webssl_port <br />s_https_listen_parameter <br />s_login_page <br />s_external_urlHimanshuhttps://www.blogger.com/profile/16681678232243263545noreply@blogger.comtag:blogger.com,1999:blog-6369673212267799064.post-71925272281383986892021-11-08T22:17:57.141+05:302021-11-08T22:17:57.141+05:30what is working before upgrade. Have you checked t...what is working before upgrade. Have you checked the patches required for R12.2.10Himanshuhttps://www.blogger.com/profile/16681678232243263545noreply@blogger.comtag:blogger.com,1999:blog-6369673212267799064.post-48703719052924438692021-11-08T20:58:37.604+05:302021-11-08T20:58:37.604+05:30Thank you for detailed explanation.
I am also upg...Thank you for detailed explanation.<br /><br />I am also upgrading 12.1.3 to 12.2.10, upgrade went well and able to access the application through application server url.<br />But failed to access through load balancer, error message "Invalid redirect has been blocked".<br />Updated following context parameters<br />"s_external_url"<br /><br />"s_webentryhost"<br /><br />"s_webentrydomain"<br /><br />"s_login_page"<br /><br />“s_webentryurlprotocol”<br /><br />“s_active_webport”<br /><br />"s_enable_sslterminator"<br /><br />Any idea , what is the issue<br />SATHEESH KUMARhttps://www.blogger.com/profile/10804277613487164342noreply@blogger.comtag:blogger.com,1999:blog-6369673212267799064.post-9180851255013803072021-10-03T09:40:05.042+05:302021-10-03T09:40:05.042+05:30Thanks for your beautifull presentation.Thanks for your beautifull presentation.Robert Mugerwahttps://www.blogger.com/profile/01225623049508355574noreply@blogger.comtag:blogger.com,1999:blog-6369673212267799064.post-61694490580321141452021-08-04T23:00:18.515+05:302021-08-04T23:00:18.515+05:30u dont need to press Y twice for each patch with b...u dont need to press Y twice for each patch with below method . copy paste all once or 1 by1 u can as well but keep an eye for error .<br /><br />. /u01/app/oracle/db/tech_st/12.1.0/PROD_prod.env<br /><br />export PATH=$PATH:$ORACLE_HOME/OPatch<br /><br />cd /u01/app/oracle/db/tech_st/12.1.0/Opatch<br /><br />opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/8975044<br />opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/27264965 <br />opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/29748518 <br />opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/18607546 <br />opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/31692949 <br />opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/22098146 <br />opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/18793246 <br />opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/25599890 <br />opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/28653113 <br />opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/19068380 <br />opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/19291380 <br />opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/19472320 <br />Rehanhttps://www.blogger.com/profile/04544784837751812268noreply@blogger.comtag:blogger.com,1999:blog-6369673212267799064.post-39095689443895354862021-08-04T22:58:05.220+05:302021-08-04T22:58:05.220+05:30adop phase=apply patches=30735865 hotpatch=yes wor...<br />adop phase=apply patches=30735865 hotpatch=yes workers=10<br /><br /><br /><br /><br />error for patch <br /><br /><br />Validating system setup.<br /> Node registry is valid.<br /> [WARNING] SYS.DUAL table has incorrect privileges<br /> Shut down the application tier services and then run the following commands in the order shown<br /> sqlplus apps/ @ $AD_TOP/patch/115/sql/ADFIXUSER.sql<br /> sqlplus apps/ @ $AD_TOP/sql/adutlrcmp.sql<br /> [ERROR] ETCC not run in the database node prod<br /> The EBS Technology Codelevel Checker needs to be run on the database node.<br /> It is available as Patch 17537119.<br /> [WARNING] MTCC has not been run. Apply Patch 17537119 and run checkMTpatch.sh.<br /> <br /> Encountered the above errors when performing database validations.<br /> Resolve the above errors and restart adop.<br /><br /><br /><br />[STATEMENT] Please run adopscanlog utility, using the command<br /><br />"adopscanlog -latest=yes"<br /><br />to get the list of the log files along with snippet of the error message corresponding to each log file.<br /><br /><br />adop exiting with status = 1 (Fail)<br /><br /><br />--------<br /><br />solution :<br /><br />bounce apps and db services <br /><br />sqlplus apps/ @ $AD_TOP/patch/115/sql/ADFIXUSER.sql<br />sqlplus apps/ @ $AD_TOP/sql/adutlrcmp.sql<br /><br /><br />SQL> select NODE_NAME from applsys.txk_tcc_results;<br /><br />NODE_NAME<br />--------------------------------------------------------------------------------<br />prod<br />prod<br />prod<br />prod<br />prod<br />prod<br />prod.oracledba.org<br /><br />7 rows selected.<br /><br /><br /> UPDATE applsys.txk_tcc_results SET node_name ='prod' where NODE_NAME='prod.oracledba.org';<br /><br />1 row updated.<br /><br />SQL> commit;<br /><br /><br />rerun above patch :<br />adop phase=apply patches=30735865 hotpatch=yes workers=10<br />Rehanhttps://www.blogger.com/profile/04544784837751812268noreply@blogger.comtag:blogger.com,1999:blog-6369673212267799064.post-55206210486645929642021-06-19T06:36:24.834+05:302021-06-19T06:36:24.834+05:30apply patch 17537119
###########
error :
-----
...apply patch 17537119<br /><br />###########<br /><br />error :<br />-----<br /><br />opatch lsinventory<br />Oracle Interim Patch Installer version 12.1.0.1.3<br />Copyright (c) 2017, Oracle Corporation. All rights reserved.<br /><br /><br />Oracle Home : /u01/oracle/product/12102<br />Central Inventory : /home/oracle/oraInventory<br /> from : /u01/oracle/product/12102/oraInst.loc<br />OPatch version : 12.1.0.1.3<br />OUI version : 12.1.0.2.0<br />Log file location : /u01/oracle/product/12102/cfgtoollogs/opatch/opatch2017-09-12_15-30-47PM_1.log<br /><br />List of Homes on this system:<br /><br /> Home name= agent13c2, Location= "/u01/oracle/product/agent13c/agent_13.2.0.0.0"<br /> Home name= 11204, Location= "/u01/oracle/product/11204"<br /> Home name= OraHome3, Location= "/u01/oracle/product/gg121"<br />Inventory load failed... OPatch cannot load inventory for the given Oracle Home.<br />Possible causes are:<br /> Oracle Home dir. path does not exist in Central Inventory<br /> Oracle Home is a symbolic link<br /> Oracle Home inventory is corrupted<br />LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo<br /><br />OPatch failed with error code 73<br /><br /><br />solution :<br />---------<br /><br />took backup of oraInventory contents<br /><br />becuase two oraInventory directories were created so rm -rf oraInventory*<br /><br />mkdir -p /u01/app/oracle/oraInventory<br /><br />copied oraInventory contents from backup to this newly created directory <br /><br /><br />$ORACLE_HOME/oui/bin/runInstaller -silent -ignoreSysPrereqs -invPtrLoc "/u01/app/oracle/db/tech_st/12.1.0/oraInst.loc" -attachHome ORACLE_HOME="/u01/app/oracle/db/tech_st/12.1.0" ORACLE_HOME_NAME="Ora12cHome"<br />Rehanhttps://www.blogger.com/profile/04544784837751812268noreply@blogger.comtag:blogger.com,1999:blog-6369673212267799064.post-20943835809531240782021-04-15T22:59:58.825+05:302021-04-15T22:59:58.825+05:30Nice document broNice document broRanesh https://www.blogger.com/profile/05452717284573915284noreply@blogger.comtag:blogger.com,1999:blog-6369673212267799064.post-89660047954101847562021-02-15T16:29:03.823+05:302021-02-15T16:29:03.823+05:30Hi,
Yes I understood, I just applied them separate...Hi,<br />Yes I understood, I just applied them separately. As I do all these steps on my test server so I try to check various combinations and how they impact the steps.<br /><br />Regards,Himanshuhttps://www.blogger.com/profile/16681678232243263545noreply@blogger.comtag:blogger.com,1999:blog-6369673212267799064.post-68103133175983999412021-02-13T20:18:40.972+05:302021-02-13T20:18:40.972+05:30Thanks for sharing your experience.
I have some co...Thanks for sharing your experience.<br />I have some concerns about what you've suggested below:<br /><br />adop phase=apply patches=31904550 merge=yes hotpatch=yes<br /><br />In “Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)” it's adviced to apply Patch 31904550:R12.TXK.C (Section 4.2, Critical TXK Patches) as follows:<br /><br />adop phase=apply patches=30735865,31904550 hotpatch=yes merge=yes<br />Anonymousnoreply@blogger.com