Sunday, November 7, 2021

Weblogic patching in EBS R12.2.9


Hi, In this topic we will apply weblogic patch using bsu utility
the issue reported is after upgrading workflow mailer account with office365 it was not starting, and even after starting had a unexpected behavior. 
================================================================================================================
Oracle E-Business Suite Release 12.2: Consolidated List of Oracle Fusion Middleware Patches and Bug Fixes (Doc ID 2877607.1)
How to Apply WebLogic Server (WLS) Patches Using Smart Update (Doc ID 876004.1)
Enhancement for WLS BSU (Smart Update): Resolves Very Long Time to Apply Patches - Especially When Checking for Patch Conflicts (Doc ID 2271366.1)

Workflow Mailer Down and Gives Error of "Unable to connect to the mail account. Check the host, user name, password and connection security" due to Office365 Started Desupporting TLS1.0,TLS1.1 Connection to there Cloud Email Servers (Doc ID 2816784.1)

[applmgr@ebsapp1 ~]$ 
[applmgr@ebsapp1 ~]$ adstpall.sh apps/devpdb1
[applmgr@ebsapp1 ~]$ ps -ef | grep -i applmgr
[applmgr@ebsapp1 ~]$ pkill -u applmgr
[applmgr@ebsapp1 ~]$ 

To check current applied Weblogic patches:
Method-2 go to bsu folder and run below and check/identify with patch ID for the mentioned patch in Readme or from patch description
Method-1
[oraerp@rac1 scripts]$
. $FMW_HOME/wlserver_10.3/server/bin/setWLSEnv.sh
java weblogic.version
WebLogic Server 10.3.6.0.220118 PSU Patch for BUG33494814 Mon Dec 13 10:08:03 UTC 2021

Method-2 go to bsu folder and run below and check/identify with patch ID for the mentioned patch in Readme or from patch description
cd $FMW_HOME/utils/bsu
bsu.sh -prod_dir=$FMW_HOME/wlserver_10.3 -status=applied -verbose -view
[oraerp@rac1 bsu]$ bsu.sh -version

Method-3 only for check applied PSU on Weblogic from checkMTpatch.sh results:
[applmgr@rac1 ~]$ grep 10.3.6 /home/applmgr/log/checkMTpatch_7428.log
Product Version = 10.3.6.0.201020
Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.201020.
[applmgr@rac1 ~]$ grep Checking /home/applmgr/log/checkMTpatch_7428.log
Checking for prerequisite bugfixes in File Edition: run
Checking for ETCC results table.
Checking required bugfixes for Oracle Forms and Reports 10.1.2.3.0.
Checking required bugfixes for RSF within Forms 10.1.0.5.0.
Checking required bugfixes for FMW - Web Tier 11.1.1.9.0.
Checking required bugfixes for RSF within FMW Web tier 11.1.0.7.0.
Checking required bugfixes for FMW - oracle common 11.1.1.9.0.
Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.201020.
[applmgr@rac1 ~]$
[applmgr@ebsapp1 ~]$ 
cd $FMW_HOME/utils/bsu
bsu.sh -version

Unzip patch to cache_dir directory: 
[applmgr@ebsapp1 ~]$ unzip /u02/ftp/wl_patch/p22323006_1036_Generic.zip -d $FMW_HOME/utils/bsu/cache_dir
[applmgr@ebsapp1 ~]$ ls -ltr $FMW_HOME/utils/bsu/cache_dir
[applmgr@ebsapp1 ~]$ rm -rf $FMW_HOME/utils/bsu/cache_dir/README.txt
[applmgr@ebsapp1 ~]$ cd $FMW_HOME/utils/bsu
[applmgr@ebsapp1 bsu]$

Modify bus.sh parameters:
[applmgr@ebsapp1 bsu]$ bsu.sh -version
Oracle Smart Update. Version: 3.3.0.0
[applmgr@ebsapp1 bsu]$ cat $FMW_HOME/utils/bsu/bsu.sh
#!/bin/sh

JAVA_HOME="/u01/dev/fs1/EBSapps/comn/util/jdk64"

MEM_ARGS="-Xms2048m -Xmx3072m -XX:+UseParallelGC"

"$JAVA_HOME/bin/java" ${MEM_ARGS} -jar patch-client.jar $*
[applmgr@ebsapp1 bsu]$

Source Env and apply weblogic patch:
[applmgr@ebsapp1 bsu]$ . $FMW_HOME/wlserver_10.3/server/bin/setWLSEnv.sh

CLASSPATH=/u01/dev/fs2/FMW_Home/patch_wls1036/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/u01/dev/fs2/EBSapps/comn/util/jdk64/lib/tools.jar:/u01/dev/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic_sp.jar:/u01/dev/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/dev/fs2/FMW_Home/modules/features/weblogic.server.modules_10.3.6.0.jar:/u01/dev/fs2/FMW_Home/wlserver_10.3/server/lib/webservices.jar:/u01/dev/fs2/FMW_Home/modules/org.apache.ant_1.7.1/lib/ant-all.jar:/u01/dev/fs2/FMW_Home/modules/net.sf.antcontrib_1.1.0.0_1-0b2/lib/ant-contrib.jar:/u01/dev/fs2/EBSapps/comn/util/jdk32/lib/dt.jar:/u01/dev/fs2/EBSapps/comn/util/jdk32/lib/tools.jar:/u01/dev/fs2/EBSapps/comn/util/jdk32/jre/lib/rt.jar:/u01/dev/fs2/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/u01/dev/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/ebsFMWManifest.jar:/u01/dev/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/dev/fs2/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/u01/dev/fs2/EBSapps/comn/java/classes:/u01/dev/fs2/EBSapps/10.1.2/forms/java:/u01/dev/fs2/EBSapps/10.1.2/forms/java/frmall.jar:/u01/dev/fs2/EBSapps/10.1.2/jlib/ewt3.jar:/u01/dev/fs2/EBSapps/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar

PATH=/u01/dev/fs2/FMW_Home/wlserver_10.3/server/bin:/u01/dev/fs2/FMW_Home/modules/org.apache.ant_1.7.1/bin:/u01/dev/fs2/EBSapps/comn/util/jdk64/jre/bin:/u01/dev/fs2/EBSapps/comn/util/jdk64/bin:/u01/dev/fs_ne/EBSapps/appl/ad/bin:/u01/dev/fs2/FMW_Home/modules/org.apache.ant_1.7.1/bin:/u01/dev/fs2/inst/apps/DEVPDB_ebsapp1/admin/scripts:/u01/dev/fs2/FMW_Home/webtier/perl/bin:/u01/dev/fs2/EBSapps/10.1.2/bin:/u01/dev/fs2/EBSapps/appl/fnd/12.0.0/bin:/u01/dev/fs2/EBSapps/appl/ad/12.0.0/bin:/u01/dev/fs2/EBSapps/comn/util/jdk32/jre/bin:/u01/dev/fs2/EBSapps/comn/util/jdk32/bin::/u01/dev/fs2/EBSapps/10.1.2/OPatch:/u01/dev/fs2/EBSapps/10.1.2/bin:/usr/bin:/usr/sbin:/u01/dev/fs2/EBSapps/comn/util/jdk32/jre/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/applmgr/.local/bin:/home/applmgr/bin

Your environment has been set.
[applmgr@ebsapp1 bsu]$



Workflow Mailer Down and Gives Error "Unable to connect to the mail account. Check the host, user name, password and connection security" due to Office365 Started DeSupporting TLS1.0,TLS1.1 Connection to their Cloud Email Servers(Only TLS1.2 allowed) (Doc ID 2816784.1)
[applmgr@ebsapp1 bsu]$
[applmgr@ebsapp1 bsu]$
[applmgr@ebsapp1 bsu]$ ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=DI8E -prod_dir=$FMW_HOME/wlserver_10.3 -log=patch_DI8E_apply.log  (approx 6 mins)
Checking for conflicts....
No conflict(s) detected

Installing Patch ID: DI8E.
Result: Success

[applmgr@ebsapp1 bsu]$
[applmgr@ebsapp1 bsu]$ tailf $FMW_HOME/utils/bsu/patch_DI8E_apply.log

Verify patch is applied or not:
[applmgr@ebsapp1 bsu]$ bsu.sh -prod_dir=$FMW_HOME/wlserver_10.3 -status=applied -verbose -view

Finally run autoconfig to take effect:
[applmgr@ebsapp1 bsu]$ adautocfg.sh

Start Application and test email(Doc ID 2493004.1)
Profile option: WF: Workflow Mailer Framework Web Agent

To remove any conflict patches:
[applmgr@ebsapp1 bsu]$ ./bsu.sh -remove -patchlist=<patch_name without jar extension> -prod_dir=$FMW_HOME/wlserver_10.3 -log=remove_conflicts.log
[applmgr@ebsapp1 bsu]$

When tried to remove all listed 8 conflicts, it was mandatory to remove prior 5 advised and then rest 3 (5+3=8):
[applmgr@ebsapp1 bsu]$ ./bsu.sh -remove -patchlist=YHJK,1LRI,VKXF,CW9T,Y5AP,2GYW,BLTG,FCX7 -prod_dir=$FMW_HOME/wlserver_10.3 -log=remove_conflicts.log
The selected patch cannot be removed until the following patch(es) are removed first: 1LRI,2GYW,CW9T,VKXF,BLTG

[applmgr@ebsapp1 bsu]$ ./bsu.sh -remove -patchlist=1LRI,2GYW,CW9T,VKXF,BLTG -prod_dir=$FMW_HOME/wlserver_10.3 -log=remove_conflicts.log
[applmgr@ebsapp1 bsu]$ ./bsu.sh -remove -patchlist=YHJK,Y5AP,FCX7 -prod_dir=$FMW_HOME/wlserver_10.3 -log=remove_conflicts.log


Oracle WebLogic Server (WLS) BSU Update (as per checkMTpatch.sh result)
Please download from My Oracle Support and apply Patch 32898996 to update to the latest WLS 10.3.6 Patching tool codeline.

[applmgr@ebsapp1 ~]$
[applmgr@ebsapp1 ~]$ unzip p32898996_R12_GENERIC.zip -d $FMW_HOME/utils/bsu
[applmgr@ebsapp1 ~]$ unzip $FMW_HOME/utils/bsu/p31136426_1036_Generic.zip -d $FMW_HOME/utils/bsu
[applmgr@ebsapp1 bsu]$ cd $FMW_HOME/utils/bsu
[applmgr@ebsapp1 bsu]$ ls -ltrh
[applmgr@ebsapp1 bsu]$ vi $FMW_HOME/utils/bsu/bsu_update.sh
[applmgr@ebsapp1 bsu]$ . ./bsu_update.sh install
Installing Smart Update V4...
Updating bsu modules
Update was successful.
[applmgr@ebsapp1 bsu]$ 


Thanks for Reading


Regards,
Mohammed Areefuddin.

No comments:

Post a Comment