Oracle E-Business Suite 12.2.15 Installation on Windows

PART 3 ‐ APPLY LATEST AD & TXK PATCH

• Unzip patch 37197085 to $PATCH_TOP. Copy the adgrants.sql from this patch to database side.

  xxxxxxxxxx
  copy C:\oracle\TST\fs_ne\EBSapps\patch\37197085\admin\adgrants.sql C:\oracle\TST\12.1.0\appsutil\admin
  cd C:\oracle\TST\12.1.0\appsutil\admin
  sqlplus / as sysdba @adgrants.sql apps
  

• Run SQL to reset the account EBS_SYSTEM:

  xxxxxxxxxx
  sqlplus / as sysdba
  ALTER USER EBS_SYSTEM ACCOUNT UNLOCK;
  ALTER USER EBS_SYSTEM IDENTIFIED BY MANAGER;
  

• Copy adlibout.sh from this patch to AD_TOP

  • copy C:\oracle\TST\fs_ne\EBSapps\patch\37197085\ad\bin\adlibout.sh %AD_TOP%\bin

• Unzip patch 37606136, and run copyOraLIB.cmd:

  xxxxxxxxxx
  D:\patch\37606136>copyOraLIB.cmd
  Enter database SID: TST
  Enter RUN APPL_TOP: C:\oracle\TST\fs1\EBSapps\appl
  ECHO is off.
  ECHO is off.
  Sat 10/24/2015 08:51 PM
  ECHO is off.
  ECHO is off.
  Setting environment for using Microsoft Visual Studio 2008 x86 tools.
  APPSORA.cmd exiting with status 0
  Copying to RUN FS....
  command : xcopy /c /d /i /q /y D:\patch\37606136\orancrypt10.lib C:\oracle\TST\fs1\EBSapps\10.1.2\lib
  1 File(s) copied
  END
  

• unzip MTCC patch 17537119 to anywhere and run the checkMTPatch.cmd and checkDBPatch.cmd

• Now you can apply the AD patch R12.AD.C.DELTA.17 (37197085)

  xxxxxxxxxx
  %ADMIN_SCRIPTS_HOME%\adadminsrvctl.cmd start
  adop phase=apply patches=37197085 hotpatch=yes
  

• If you see the error message at the end:

  xxxxxxxxxx
  Running cutover actions for the patches being applied.
      Creating workers to process cutover DDL in parallel
      Log:<Log_Location>/cutover.log
      [UNEXPECTED]Error occurred in CUTOVER.
      [UNEXPECTED]Apply phase has failed.
  

  • Open a new profile (it has updated by the patch already), then re-apply the patch by running:

    adop phase=apply patches=37197085 hotpatch=yes options=forceapply,nocopyportion.

  • This time, the password is masked when you type it, rather than plain text before.

  • Ignore the error about adworker error with MSVCR90.dll

• Shutdown Weblogic server and Node Manager

  %ADMIN_SCRIPTS_HOME%\adadminsrvctl.cmd stop.

• Unzip patch 37204510 to %PATCH_TOP%, then apply this TXK Patch:

  adop phase=apply patches=37204510 hotpatch=yes

• Sync the appsutil files from APPS tier to DB Tier

  xxxxxxxxxx
  perl %AD_TOP%\bin\admkappsutil.pl`
  unzip -o C:\oracle\TST\fs1\inst\apps\TST_demo\admin\out\appsutil.zip -d C:\oracle\TST\12.1.0
  

• Edit template

  xxxxxxxxxx
  mkdir %ORACLE_HOME%\appsutil\template\custom
  
  copy %ORACLE_HOME%\appsutil\template\afinit_db121.ora ^
  %ORACLE_HOME%\appsutil\template\custom\afinit_db121.ora
  
  copy %ORACLE_HOME%\appsutil\template\afinit_db121RAC.ora ^
  %ORACLE_HOME%\appsutil\template\custom\afinit_db121RAC.ora
  

• Edit %ORACLE_HOME%\appsutil\template\custom\afinit_db121.ora and afinit_db121RAC.ora

  • replace optimizer_adaptive_features=false to optimizer_adaptive_plans=false

• Run adconfig in DB Tier

  xxxxxxxxxx
  cd C:\oracle\TST\12.1.0\appsutil\bin
  adconfig.cmd contextfile=C:\oracle\TST\12.1.0\appsutil\TST_demo.xml
  

• Shutdown database and restart Windows. Start up the EBS again and check.

• Now you have a working EBS 12.2.0 system and latest AD and TXK patch. However at this moment you can only use Internet Explorer in Windows 2008 server to open any Form. We'll continue the upgrade in the next part.

| Table of Content | Next |

| Home | Repositories | Blog |

© 2026 by Christopher Ho. All Rights Reserved