[PL/SQL] Install Oracle Forms 12.2.1.4

  • Oracle Forms and Reports 12c (12.2.1.4.0)
  • Fusion Middleware Infrastructure Installer (included Oracle WebLogic Server 12c 12.2.1.4)
  • Java SE Development Kit 8u221,…
  • Visual C++ Redistributable for Visual Studio 2012 Update 4
https://en.wikipedia.org/wiki/Oracle_WebLogic_Server

1. Download stuffs

  • Download “Java SE Development Kit 8u221”
https://www.oracle.com/java/technologies/javase/javase8u211-later-archive-downloads.html
  • Download “Fusion Middleware Infrastructure Installer”
https://www.oracle.com/middleware/technologies/weblogic-server-downloads.html
  • Download “Oracle Forms and Reports 12c” (12.2.1.4.0)
https://www.oracle.com/middleware/technologies/forms/downloads.html#
  • Extract 2 zip files, then we’ll get 2 files in blue square

2. Installation

Right click and run “jdk-8u221-windows-x64” with administrators. Then set up with default settings.

  • Start “cmd” with administrators
C:\WINDOWS\system32>d:
D:\>cd app\oracle_form_downloads
D:\app\oracle_form_downloads> "C:\Program Files\Java\jdk1.8.0_221\bin\java" -jar fmw_12.2.1.4.0_infrastructure.jar
  • Download “Visual C++ Redistributable for Visual Studio 2012 Update 4”
https://docs.microsoft.com/en-us/cpp/windows/latest-supported-vc-redist?view=msvc-160
  • Install Oracle Forms
setup_fmw_12.2.1.4.0_fr_win64.exe
  • Repository Creation Utility
C:\WINDOWS\system32>d:
D:\>cd app\oracle\Middleware\Oracle_Home\oracle_common\bin
D:\app\oracle\Middleware\Oracle_Home\oracle_common\bin>rcu.bat
  • Create the domain
  • Configure the servers
  • Start the Node Manager
  • Check Form Builder is functional by double click “frmbld”
  • Deal with MSVCR100.DLL (If necessary)
  • Download and install
  • Launch Fusion Middleware control
http://localhost:7001/em
  • Configure FORMS
<Location /forms>
SetHandler weblogic-handler
WebLogicHost localhost
WeblogicPort 9001
</Location>
D:\app\oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\components\OHS\instances\ohs1\moduleconf
  • Check that the FORMS server is working
http://localhost:9001/forms/frmservlet?config=webstart

3.Configuring Forms & Launching The Servers

Install “git for windows” if you didn’t

git clone https://github.com/finos/exodus
Copy D:\git\exodus\extras\background.png D:\app\oracle\Middleware\Oracle_Home\forms\java
  • Setup tnsnames.ora
  • Edit “formsweb.cfg”
[binh]
# Note: baseSAAfile must end with .txt
baseSAAfile=basesaa.txt
lookAndFeel=oracle
form=PRE_ETL_MAPPING.fmx
quiet=YES
separateFrame=True
background=/forms/java/background.png
colorScheme=Olive
width=1256
height=975
allowAlertClipboard=false
Logo=NO
fsalcheck=true
isResizable=false
D:\app\oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config
  • Edit “default.env”
D:\git\exodus\forms;
  • Create the Batch file
java -jar D:\app\oracle\Middleware\Oracle_Home\forms\java\frmsal.jar -url "http://127.0.0.1:9001/forms/frmservlet?config=binh&userid=pre_etl_owner/pre_etl_owner@binh"
1) 1-StartNodeMGR.bat
D:\app\oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\bin\startNodeManager.cmd
2) 2-StartWLAdm.bat
D:\app\oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\bin\startWeblogic.cmd
3) 3-StartWLS_FORMS.bat
D:\app\oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\bin\startManagedWebLogic.cmd WLS_FORMS
4) stopAll.txt
cd D:\app\oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\bin
stopManagedWebLogic.cmd WLS_FORMS
stopWeblogic.cmd
stopNodeManager.cmd
  • Stop Form server

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
binh12A3

binh12A3

“Developer never die” 😎🇻🇳