(Part F) Multinode/Multiuser Installation of Oracle EBS(12.2.0) & Fresh DB(12.1.0.2) using StartCD 51 And Upgrade to 12.2.10 and 19C [Linux x86_64]

JWS (Java Web Start) Ref Note 2188898.1??(Bonus!)

=======================================

Before we begin with JWS?

Please NOTE: JWS patches will be applied thru Online Patching Cycle (First cycle in our case) because our environment is newly installed EBS Environment, hence we need to ENABLE AUTOCONFIG ON DATABASE TIER as first step.?

1. Backup existing appsutil.zip file and appsutil directory from DB Node?

[oracle@dbdemo01 12.1.0]$ pwd

/u01/oracle/CWI/12.1.0

ls -d appsutil*

appsutil

appsutil_beforefirstAutoconfig?

appsutil.zip_beforefirstAutoconfig

2. Execute admkappsutil.pl on the apps node.

perl $AD_TOP/bin/admkappsutil.pl

Output located at /u01/apps/CWI/fs1/inst/apps/CWI_ebsdemo01/admin/out/appsutil.zip

3. Copy the generated appsutil.zip to db node.?

scp /u01/apps/CWI/fs1/inst/apps/CWI_ebsdemo01/admin/out/appsutil.zip [email protected]:/u01/oracle/CWI/12.1.0/

[email protected]'s password:

appsutil.zip??????????????????????????????????????100% 3949KB 116.3MB/s??00:00????????????

4. Unzip appsutil.zip on DB node ( using -o overwrite option to existing appsutil directory, that will ensure to retain JRE/JAVA)

-rw-r--r--.?1 oracle oinstall 4043270 Oct 18 15:09 appsutil.zip

-rwxr-xr-x.?1 oracle oinstall 3632269 Oct 18 15:04 appsutil.zip_beforefirstAutoconfig

unzip -o appsutil.zip

ls appsutil*

appsutil.zip?appsutil.zip_beforefirstAutoconfig

appsutil:

admin?bin?clone?conf_CWI.txt?CWI_dbdemo01.xml?etcc?html?install?java?jre?log?media?out?outbound?perl?scripts?sql?temp?template?txkSetCfgCDB.cmd?txkSetCfgCDB.env

appsutil_beforefirstAutoconfig:

admin?bin?clone?conf_CWI.txt?CWI_dbdemo01.xml?etcc?html?install?java?jre?log?media?out?outbound?perl?scripts?sql?temp?template

5. Generate/ENABLE The Database Context File

perl $ORACLE_HOME/appsutil/bin/adbldxml.pl

Starting context file generation for db tier..

Using JVM from /u01/oracle/CWI/12.1.0/appsutil/jre/bin/java to execute java programs..

APPS Password:

The log file for this adbldxml session is located at:

/u01/oracle/CWI/12.1.0/appsutil/log/adbldxml_10181516.log

Enter Database Service Name: CWI

Context File?/u01/oracle/CWI/12.1.0/appsutil/CWI_dbdemo01.xml

?already exists.

Overwriting Context File may cause loss of existing settings, hence

?backing it up as: /u01/oracle/CWI/12.1.0/appsutil/CWI_dbdemo01.xml.bak

The context file has been created at:

/u01/oracle/CWI/12.1.0/appsutil/CWI_dbdemo01.xml

5. Execute autoconfig on the database tier.

$ORACLE_HOME/appsutil/bin/adconfig.sh contextfile=/u01/oracle/CWI/12.1.0/appsutil/CWI_dbdemo01.xml

AutoConfig completed successfully.

6. Ensure s_patch_service_name entry exists in the db context file.?( REQUIRED to begin with Online Patching cycle)?

[oracle@dbdemo01 12.1.0]$ grep patch_service $CONTEXT_FILE

???<patch_service_name oa_var="s_patch_service_name">CWI_ebs_patch</patch_service_name>

JWS Steps:?

==========

1. List Of JWS Patches :??(Total 12 Patches)?

A. Oracle Forms 10g Technology Patch for Oracle E-Business Suite Release 12.2??( 1 Patch)?

• Patch 25441839 - Merge Request On Top Of 10.1.2.3.2PSU For Bugs 24946444, 24620875, 25355211 is the minimum required Oracle Forms 10g overlay patch that adds support for Java Web Start to Oracle Forms as part of the Oracle E-Business Suite technology stack.

B. Application Technology Patches for Oracle E-Business Suite Release 12.2??( 3 Patches)

Application Technology Patch Description Patch Number

• AD: Add Java Web Start support to Oracle E-Business Suite Patch 24498616:R12.AD.C
• TXK: Add Java Web Start support to Oracle E-Business Suite Patch 25449925:R12.TXK.C
• Oracle E-Business Suite Java Applets launching with Java Web Start Patch 25380324:R12.FND.C

C. Product-Specific Patches for Oracle E-Business Suite Release 12.2??( 8 Patches)?

Product Feature Patch Number

• Oracle Workflow Status Diagram; Notification signing with Digital Signature Patch 28713780:R12.OWF.C?
• Oracle Scripting Script Author Patch 23475123:R12.IES.C
• Oracle Customers Online Party Relationships Patch 23280764:R12.IMC.C
• Oracle General Ledger Account Hierarchy Manager Patch 23645622:R12.GL.C
• Oracle Sourcing Auction Monitor Patch 23575933:R12.PON.D
• Oracle Installed Base Visualizer Applet Patch 22221603:R12.CSI.C
• Oracle Advanced Supply Chain Planning Plan Editor (PS/SNO) Patch 23586286:R12.MSC.C
• Oracle Process Manufacturing Recipe Designer Patch 24833534:R12.GMD.C

2. Applying Patches to Oracle E-Business Suite Release 12.2

2.1 Pre-requisite for Patch 25441839 (as per Read Me)?

NOTE:

?----

a. Please ensure the patch for bug 14825718 is already applied before you proceed.?- MET

b. Upgrade to the latest OUI 10.1 by downloading and installing the same from bug 6640838.??- MET

c. Please Apply Mandatory Patch 8551790.???- MET

d. Please make sure you have the latest OPATCH 10.1 that's available from metalink via bug number 6880880.??- MET

• $ORACLE_HOME/OPatch/opatch version

OPatch Version: 1.0.0.0.64

• opatch lsinventory | grep 14825718

Patch?14825718 applied on Wed Oct 13 14:08:49 EDT 2021

• opatch lsinventory | grep 8551790

?[ Bug fixes: 8551790 16234436?]

2.2 Downloaded all above patches (A,B,C) in /software?

2.3 Unzip all above patches (A,B,C) in Patch Top?

?unzip -q p25441839_101232_LINUX.zip -d /u01/apps/CWI/fs_ne/EBSapps/patch/

?unzip -q p24498616_R12.AD.C_R12_GENERIC.zip -d /u01/apps/CWI/fs_ne/EBSapps/patch/

?unzip -q p25449925_R12.TXK.C_R12_GENERIC.zip -d /u01/apps/CWI/fs_ne/EBSapps/patch/

?unzip -q p25380324_R12.FND.C_R12_GENERIC.zip -d /u01/apps/CWI/fs_ne/EBSapps/patch/

?unzip -q p28713780_R12.OWF.C_R12_GENERIC.zip -d /u01/apps/CWI/fs_ne/EBSapps/patch/

?unzip -q p23475123_R12.IES.C_R12_GENERIC.zip -d /u01/apps/CWI/fs_ne/EBSapps/patch/

?unzip -q p23280764_R12.IMC.C_R12_GENERIC.zip -d /u01/apps/CWI/fs_ne/EBSapps/patch/

?unzip -q p23645622_R12.GL.C_R12_GENERIC.zip -d /u01/apps/CWI/fs_ne/EBSapps/patch/

?unzip -q p23575933_R12.PON.D_R12_GENERIC.zip -d /u01/apps/CWI/fs_ne/EBSapps/patch/

?unzip -q p22221603_R12.CSI.C_R12_GENERIC.zip -d /u01/apps/CWI/fs_ne/EBSapps/patch/

?unzip -q p23586286_R12.MSC.C_R12_GENERIC.zip -d /u01/apps/CWI/fs_ne/EBSapps/patch/

?unzip -q p24833534_R12.GMD.C_R12_GENERIC.zip -d /u01/apps/CWI/fs_ne/EBSapps/patch/

2.4?Source Run FS

. EBSapps.env run

2.5 Start a new online patch cycle

adop phase=prepare

2.6 Source Patch FS

. EBSapps.env patch

2.7 Apply the Oracle Forms 10g technology patch

cd 25441839; $ORACLE_HOME/OPatch/opatch apply?

2.8 opatch lsinventory | grep 25441839

?1) Patch?25441839 applied on Mon Oct 18 15:37:47 EDT 2021

2.9 Apply the required Oracle E-Business Suite application technology patches (AD/TXK/FND)

adop phase=apply patches=24498616,25449925,25380324 merge=yes

2.10 Apply product-specific patches

adop phase=apply patches=28713780

adop phase=apply patches=23475123

adop phase=apply patches=23280764

adop phase=apply patches=23645622

adop phase=apply patches=23575933

adop phase=apply patches=22221603

adop phase=apply patches=23586286

adop phase=apply patches=24833534

2.11 Use the AD Administration tool (adadmin) to regenerate JAR files with force option in PATCH File System.

adadmin

Navigation: Generate Applications Files -> Generate product JAR files

Regenerate JAR files with FORCE option set to Yes

Do you wish to force regeneration of all jar files? [No] ? Yes

2.12 Complete the online patch cycle

adop phase=finalize,cutover

2.13 Perform a cleanup of the online patch cycle

. EBSapps.env run

adop phase=cleanup

==============================================================

ADOP (C.Delta.12)

Session Id: 4

Command: status

Output: /u01/apps/CWI/fs_ne/EBSapps/log/adop/4/20211018_163142/adzdshowstatus.out

===============================================================

Node Name????Node Type?Phase??????Status?????Started???????Finished???????Elapsed

--------------- ---------- --------------- --------------- -------------------- -------------------- ------------

ebsdemo01????master???PREPARE?????COMPLETED????2021/10/18 15:21:15?2021/10/18 15:34:07?0:12:52

??????????????APPLY??????COMPLETED????2021/10/18 15:38:59?2021/10/18 16:06:52?0:27:53

??????????????FINALIZE????COMPLETED????2021/10/18 16:20:43?2021/10/18 16:21:01?0:00:18

??????????????CUTOVER?????COMPLETED????2021/10/18 16:21:13?2021/10/18 16:29:30?0:08:17

??????????????CLEANUP?????COMPLETED????2021/10/18 16:31:11?2021/10/18 16:31:30?0:00:19

2.14 Synchronize the patch file system with the new run file system.

adop phase=fs_clone

===============================================================

Node Name????Node Type?Phase??????Status?????Started???????Finished???????Elapsed

--------------- ---------- --------------- --------------- -------------------- -------------------- ------------

ebsdemo01????master???FS_CLONE????COMPLETED????2021/10/18 16:32:58?2021/10/18 16:54:00?0:21:02

3. Configuring and Enabling Java Web Start (Set Java Web Start as the default for all application users)

[The installation of the patches does not enable Java Web Start. The Java Plug-in remains the default launch method for all application users.]

3.1 Update the context file using Oracle Application Manager.

a.?Using the System Administration responsibility, run AutoConfig through the Oracle Applications Manager interface.

b.?Click the Edit Parameters icon for the application tier context file.

c.?Click the System tab.

d.?Expand the oa_system_config node.

e.?Change the value of OA_VAR for s_forms_launch_method from browser to jws.

f.?Click Save at the bottom of the page.

3.2?Stop all application tier services.

$ sh <ADMIN_SCRIPTS_HOME>/adstpall.sh

3.3?Run AutoConfig on the application tier.

$ sh <ADMIN_SCRIPTS_HOME>/adautocfg.sh

3.4 Start all application tier services.

$ sh <ADMIN_SCRIPTS_HOME>/adstrtal.sh

Completing these steps sets Java Web Start as the default launch method for the environment.?

NOTE: In step 3.3, AutoConfig updates the two profile options at the site level accordingly:

Profile Option / Internal Code ???Value at the Site Level

• Enable Java Web Start / FND_ENABLE_JAVA_WEB_START??Yes
• ICX: Forms Launcher / ICX_FORMS_LAUNCHER <s_webentryurlprotocol>://<s_webentryhost>.<s_webentrydomain>:<s_active_webport>/forms/frmservlet

3.5 Usage ?

- Open Chrome/Edge in Host Machine ( Windows)

- Login to EBS URL?

- Select any Form (ex. System -> Profile)- It will ask to save 'frmservlet.jnlp'.?

- Save and then Run the 'jnlp' file.?

- Form will launch successfully.?

This completes JWS setup.?

Next Parts will be about 19C Upgrade!?