Patch Location:
/interface/patches/CPU_2018
######################################################################################################
1) Apply AD Pacthes (US) in below order
====>Enable Maintaince Mode
sqlplus apps/apps4ebsdb @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE
cd /interface/patches/CPU_2018/ADPATCH_US
23231676
24840574
25110821
22284589
23200210
————————————————————>
28018146–> PRE-Steps : adgrants.sql from DB Node
o Compare the version of adgrants.sql(UNIX) in $APPL_TOP/admin to that in patch directory(PATCH/admin/adgrants.sql)
o Copy the higher version of adgrants.sql (UNIX) to RDBMS “$ORACLE_HOME/appsutil/admin”
Login to DB tier & use SQL*Plus to run the script as sys user.
sqlplus “/as sysdba”
@$ORACLE_HOME/appsutil/admin/adgrants.sql APPS
Apply Patch –28018146
——————————————————————>
====>Disable Maintaince Mode
sqlplus apps/apps4ebsdb @$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE
######################################################################################################
2) Apply NLS Pacthes in Hotpacth ( Screen Mode)
screen -S CPU_18JUL
cd /interface/patches/CPU_2018/ADPATCH_NLS/ADPATCH_NLS_D
adpatch options=hotpatch driver=u_merged.drv logfile=CPU_JUL2018_12_17SEP.log
######################################################################################################
Take backup of 10.1.3 and 10.1.2 Homes
cp -pr 10.1.3 10.1.3_bkp_CPU_19SEP
cp -pr 10.1.2 10.1.2_bkp_CPU_19SEP
10.1.3 Patch :
######################################################################################################
1) Apply 21845960———————–>
export OPATCH_PLATFORM_ID=46
echo $OPATCH_PLATFORM_ID
cd /interface/patches/CPU_2018/1013_PATCH/21845960
. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;
$ORACLE_HOME/OPatch/opatch napply
$ORACLE_HOME/OPatch/opatch lsinventory|egrep 21845960
unset OPATCH_PLATFORM_ID
OUI Patch
applmgr@of201:/interface/patches $ unzip p6640838_10106_Linux-x86-64.zip
2) Apply 22123753———————–>
cd /interface/patches/CPU_2018/1013_PATCH/22123753
. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;
$ORACLE_HOME/OPatch/opatch apply
$ORACLE_HOME/OPatch/opatch lsinventory|egrep 22123753
10.1.2 Patch
######################################################################################################
1) Apply 26825525
cd /interface/patches/CPU_2018/1012_PATCH/26825525
. $INST_TOP/ora/10.1.2/*.env;echo $ORACLE_HOME;
$ORACLE_HOME/OPatch/opatch apply
$ORACLE_HOME/OPatch/opatch lsinventory|egrep 26825525
###################
“Forms having some issues while opening
to fix the issue,Re-deploy forms.ear file
(Given in Readme,but steps are not correct,refer comments)”
“Deploying a New EAR File in Oracle Applications Release 12 (Doc ID 397174.1) –Change Password for oc4jadmin
TXKRUN.PL Deploying a New Forms .EAR File Error with OPMNCTL Start (Doc ID 1295791.1) — EBSPRD patch opmnctl”
###################
JRE Patch
Using JDK 7.0 Latest Update with Oracle E-Business Suite Release 12.0 and 12.1 (Doc ID 1467892.1)
Upgrading JRE Plugin with Oracle Applications R12 (MetaLink Note 393931.1)
R12 E-Business Suite Java / JRE Upgrade Does Not Correctly Update The 3 Digit Version Of Java Installed In The Context File,
Forms Applications, Or Java Console (Doc ID 2227147.1)
http://erpondb.blogspot.com/2015/11/ebs-r121-patching-for-jre-18.html
######################################################################################################
cd /interface/patches/CPU_2018/JRE
——–Backup of Webapps———————————
cd $COMMON_TOP
cp -rp webapps webapps_bkp_CPU_19SEP
——–Backup of Webapps———————————
==> Apply interoperability Patch 21624242:R12.TXK.B. (ALready Applied ) ******************>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
1)Download 32 Bit Microsoft Version
unzip p27890728_180181_WINNT.zip
cp -p jre-8u181-windows-i586.exe $COMMON_TOP/webapps/oacore/util/jinitiator/j2se18181.exe
$FND_TOP/bin/txkSetPlugin.sh 18181
$FND_TOP/bin/txkSetPlugin.sh 18073 –Revert to old if any issues
Issues :
#########################################################################################################################
diff -y /ebsdb/apps/apps_st/appl/fnd/12.0.0/admin/template/orion_web_xml_1013.tmp /ebsdb/apps/apps_st/appl/fnd/12.0.0/admin/template/custom/orion_web_xml_1013.tmp_bkp_18SEP |grep ‘|’
add diff lines
[ VERSION CONFLICTS INFORMATION ]
Template shipped by oracle is having a version different than the template lying in custom directory.
Template shipped by Oracle : /ebsdb/apps/apps_st/appl/fnd/12.0.0/admin/template/orion_web_xml_1013.tmp(version: 120.69.12010000.17)
Custom template : /ebsdb/apps/apps_st/appl/fnd/12.0.0/admin/template/custom/orion_web_xml_1013.tmp(version: 120.69.12010000.10)
Please resolve the differences between the two templates or refer to Metalink Note 387859.1 for further details.
Issues :
===============
lsinventory is failing with below error
##############################
LsInventory: OPatch Exception while accessing O2O
OPATCH_JAVA_ERROR : An exception of type “OPatchException” has occurred:
OPatch Exception: OUI found no such ORACLE_HOME set in the environment
Can not get details for given Oracle Home
An exception occurs
null
##############################
. $INST_TOP/ora/10.1.2/*.env;echo $ORACLE_HOME;
cd $ORACLE_HOME/oui/bin
./runInstaller -silent -attachHome ORACLE_HOME=/EBSDEV/tech_st/10.1.2 ORACLE_HOME_NAME=EBSDEV_1012_home
. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;
cd $ORACLE_HOME/oui/bin
./runInstaller -silent -attachHome ORACLE_HOME=/EBSDEV/tech_st/10.1.3 ORACLE_HOME_NAME=EBSDEV_1013_home
##############################
10.1.2 runInstaller attachHome failing with below error
.The Java RunTime Environment was not found at /tmp/OraInstall2018-09-16_12-18-52PM/jre/bin/java. Hence, the Oracle Universal Installer cannot be run.
##############################
Reason for the error
On investigation,I found the following solution to the problem
The oraparam.ini file is incorrect in $ORACLE_HOME/oui directory.
The line in the oraparm.ini file that was incorrect was:
appltst@of552:/ebsdb/apps/tech_st/10.1.2/oui $ cat oraparam.ini|grep -i JRE|grep -v ^#
JRE_LOCATION=/apps/prd/apps/tech_st/10.1.2/jdk/jre ****************************************************pointing to prod Path
JRE_MEMORY_OPTIONS=”-mx256m”
1. Back up the oraparm.ini file in $ORACLE_HOME/oui
2. Modify the oraparam.ini file:
vi oraparam.ini
JRE_LOCATION=../../jdk/jre
3. Run the universal installer from $ORACLE_HOME/oui/bin/runInstaller
TXKRUN.PL Deploying a New Forms
applmgr@of201:~ $ $FND_TOP/bin/txkrun.pl -script=CfgOC4JApp
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** Log File = /EBSDEV/inst/apps/EBSDEV_of201/logs/appl/rgf/TXK/txkCfgOC4JApp_Wed_Sep_19_05_57_14_2018.log
Program : /EBSDEV/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl started @ Wed Sep 19 05:57:14 2018
*** Log File = /EBSDEV/inst/apps/EBSDEV_of201/logs/appl/rgf/TXK/txkCfgOC4JApp_Wed_Sep_19_05_57_14_2018.log
Enter Application name for re-deployment ? forms
Enter Oc4j Instance password for re-deployment ?
Run Autoconfig ? No
*****************************************************
Required values for starting OC4J instance “forms”:
====================================================
s_formsstatus = enabled
s_forms_nprocs = 1 (value should be greater than 0)
Existing values from the context file:
======================================
s_formsstatus = enabled
s_forms_nprocs = 1
———————————————-
*** Values for context variables are VALID ***
———————————————-
*****************************************************
Stopping all OPMN processes.
OPMN stopped.
OPMN started.
Deplolying Application : “forms” onto OC4J instance: “forms”
Application deployed successfully.
Stopping and starting OC4J instances.
Started OC4J instances.
Binding webApp : “forms” with webmodule : “formsweb” for OC4J instance: “forms”
Web application bound successfully.
Stopping OPMN.
OPMN stopped.
Program : /EBSDEV/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl completed @ Wed Sep 19 05:57:54 2018
End of /EBSDEV/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl : No Errors encountered
applmgr@of201:~ $
AD Pacthes Patch – Desciption Pre requisities
Post requisities
Applied Patch – Desciption Pre-Requisities Not Appiled
Post requisities
Not Appiled
28018146 12.1:CPU PATCH FOR JULY 2018
Yes NoRun ADGRANTS Yes 9239089 R12.AD.B.delta.3
NA NA Yes 19559960 R12.FRM.B.delta.4
NA NA No 23231676 R12.JTT.B.delta.4
NA 24840574 JSP COMPILATION FAILS AFTER APPLYING R12.JTT.B.DELTA.4
25110821 ERROR ON FLEXFIELDS AFTER APPLYING R12.JTT.B.DELTA.4
Yes 8919491 R12.ATG_PF.B.delta.3
NA NA Yes 19273341 R12.BNE.B.delta.4
NA NA No 22284589 R12.FWK.B.delta.5
NA 23200210 PERFORMANCE ISSUE WHILE SEARCHACCOUNT FLEXFIELD( SELECT FROM FND_FLEX_VALUES_VL)
12572001:
AFTER FRAMEWORK PATCH 11894708 JAVA ERROR ON CREATE CLAIM, CLAIM LINE, SYS PARAM (Not Required as we don’t have OZF)
Required Actions
If Not On
Apr 2018 CPU
14108961 Only if Landed Cost Management is used
Check Below Applications are used or not with Funactional Teamand see if this are applied INL Inactive select abbreviation
,codelevel
from
ad_trackable_entities
where
abbreviation in( ‘hr_pf’,’ibe’,’prc_pf’,’inl’,’ozf’ )
order by
abbreviation;
22465286 IF have applied Patch 21198991:R12.PRC_PF.B then apply Patch 22465286:R12.PON.B after applying this CPU patch.
PON Inactive select decode(nvl(a.APPLICATION_short_name,’Not Found’), ‘SQLAP’,’AP’,’SQLGL’,’GL’,’OFA’,’FA’,
‘Not Found’,’id ‘||to_char(fpi.application_id),
a.APPLICATION_short_name) apps,
decode(fpi.status,’I’,’Installed’,’S’,’Shared’,
‘N’,’Inactive’,fpi.status) status,
fpi.product_version,
nvl(fpi.patch_level,’– Not Available –‘) Patchset,
to_char(fpi.last_update_date,’dd-Mon-RRRR’) “Update Date”
from fnd_oracle_userid o, fnd_application a, fnd_product_installations fpi
where fpi.application_id = a.application_id(+)
and fpi.oracle_id = o.oracle_id(+)
and APPLICATION_short_name in( ‘HR’,’IBE’,’PRC’,’INL’,’OZF’ )
order by 1,2
25510561 If have applied R12.HR_PF.B.delta.9, Release 12.1 HRMS RUP9, apply Patch 25510561:R12.PAY.B after applying this CPU patch.
Current Version is HR PF DELTA 3 PAY Shared
26267391 If have applied R12.IBE.B.Delta.4, apply Patch 26267391:R12.IBE.B after applying this CPU patch.
IBE Inactive DB Patches: 28317232 COMBO OF OJVM COMPONENT 12.1.0.2.180717 DB PSU + DBPSU 12.1.0.2.180717
12.1.0.2 NA REVIEW With CORE DBA TEAM Java JRE 27890728 Oracle JRE 8 Update 181
Apply only 32 bit patch No -Pre Req
10.1.3.5 Patches 21845960CPUOCT2015 TRACKING BUG FOR APPLICATION SERVER 10.1.3.5 UNIX 10.1.3.5.0 NA If you encounter conflicts with Patch 19943587 and Patch 18025250, allow OPatch to roll it back. The fix for 19943587 and 18025250 is already included in the Oct 2015 CPU Patch 21845960.mv: cannot stat `.backup/.10011970/cabo’: No such file or directory mv: cannot stat `cabo’: No such file or directory
This message can safely be ignored.
We can apply 32 bit
version in Linux X86-64
run the below command before applying patch
$ export OPATCH_PLATFORM_ID=46
19943587/18025250 Not appliedApply 21845960. directly
. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;$ORACLE_HOME/OPatch/opatch lsinventory|egrep ‘22123753|20683632|20426272|19943587|18025250|21845960’ 22123753CPUOCT2015: MLR ON TOP OF 10.1.3.5.0 FOR BUGS 20034700 8939568 20492610 10.1.3.5.0 NA If you have previously installed Patch 20683632 or Patch 20426272, use OPatch to explicitly roll it back. Then, apply Patch 22123753.why this patch ? Slow performance of HTML-based (self-service) applications on Oracle E-Business Suite Release 12.1.
20683632/20426272 Not appliedApply 22123753 directly
Only if TLS 1.2 Configured 27078378|27208670
10.1.3.5.0 NA to enable TLS 1.2 you should update the OpenSSL libraries by applying two patches – Patch 27078378 and Patch 27208670 27078378|27208670 Not appplied
. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;$ORACLE_HOME/OPatch/opatch lsinventory|egrep ‘27078378|27208670’ 10.1.2 Patches 26825525MERGE REQUEST ON TOP OF 10.1.2.3.2PSU FOR BUGS 25768948 1770039 25990479 10.1.2.3 NA Only Available for Linux X86, not with 64 bit we have to check with Oracle for applying
Pre-Reqs are applied. 14825718 /8551790OUI 10.1 8551790
. $INST_TOP/ora/10.1.2/*.env;echo $ORACLE_HOME;$ORACLE_HOME/OPatch/opatch lsinventory|egrep ‘14825718|8551790|26825525’. $INST_TOP/ora/10.1.2/*.env;echo $ORACLE_HOME;grep -i version= $ORACLE_HOME/oui/oraparam.ini Known Issue Categories, Details and Resolutions UI issues (such as poorly rendered fonts, missing links, or buttons and fields out of place) in Oracle E-Business Suite Release 12.1.3. Refer to Solution A in Document 1348791.1, R12: Font and Links Have Changed After Patching.
Patch Type Pacth# Comments References 10.1.3 21845960 10.1.3 22123753 10.1.2 26825525 Forms having some issues while opening to fix the issue,Re-deploy forms.ear file
(Given in Readme,but steps are not correct,refer comments)
Deploying a New EAR File in Oracle Applications Release 12 (Doc ID 397174.1) –Change Password for oc4jadmin TXKRUN.PL Deploying a New Forms .EAR File Error with OPMNCTL Start (Doc ID 1295791.1) — Prod patch opmn ctl
JRE Plugin 27890728 After applying JRE Plugin,Forms are not opening ,no errors. Reverted the changes,after that forms are opening
Upgrading JRE Plugin with Oracle Applications R12 (MetaLink Note 393931.1)
#notes
My NoteBook 
Leave a Reply