Install, configure Forms & launch the servers,…😎😎
In general, we’ll need to download/install below stuffs :
- 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
1. Download stuffs
- Download “Java SE Development Kit 8u221”
- Download “Fusion Middleware Infrastructure Installer”
- Download “Oracle Forms and Reports 12c” (12.2.1.4.0)
- 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”
- 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
Then minimize the command window
Then run “startWebLogic” and wait a while until you see the line in square block as below then minimize the command window
Run “startManagedWebLogic.cmd”, wait a while then minimize the command window
- Check Form Builder is functional by double click “frmbld”
If you see an error with MSVCR100.DLL then follow below steps
- Deal with MSVCR100.DLL (If necessary)
- Download and install
- Launch Fusion Middleware control
http://localhost:7001/em
Start the server
- Configure FORMS
<Location /forms>
SetHandler weblogic-handler
WebLogicHost localhost
WeblogicPort 9001
</Location>
Then copy “forms.conf” to the “moduleconf” folder as below
Then restart the server
- Check that the FORMS server is working
Enter new tab
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”
Add below block
[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
- Edit “default.env”
D:\git\exodus\forms;
- Create the Batch file
On desktop, create a new txt file named “StartExodus.bat”
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"Creates 3batches files + 1 txt file
1) 1-StartNodeMGR.bat
D:\app\oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\bin\startNodeManager.cmd2) 2-StartWLAdm.bat
D:\app\oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\bin\startWeblogic.cmd3) 3-StartWLS_FORMS.bat
D:\app\oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\bin\startManagedWebLogic.cmd WLS_FORMS4) stopAll.txt
cd D:\app\oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\bin
stopManagedWebLogic.cmd WLS_FORMS
stopWeblogic.cmd
stopNodeManager.cmd
Double click “StartExodus.bat”
- Stop Form server
Reference
