This repository was archived by the owner on Oct 9, 2023. It is now read-only.
Repository navigation
Configuring Forms & Launching The Servers
Christian Leigh edited this page Apr 5, 2020
·
2 revisions
Setting up Forms Executables & Starting Your Webservers
=======================================================
You must first follow the instruction for installing the database components for Exodus see installation videos and instructions in) : https://github.com/finos/exodus
You will need to install git for windows:
Starting at C:\ (root)
Make a directory called git on your disk: mkdir git
Change directory: cd git
Get the code from github: git clone https://github.com/finos/exodus
Copy background.png image from extras: Copy C:\git\exodus\extras\background.png C:\Oracle\Middleware\Oracle_Home\forms\java
All source is available on : https://github.com/finos/exodus
===========================================================================================================
Set up your tnsnames.ora
FYI - For Exodus PEM (is an acronym for Pre ETL Mapping) - obviously your forms installation will be different
IN : C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig
(obviously your host will be diff
PEM = (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=PEM))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.38)(PORT=1521)))
===========================================================================================================
Edit the file: formsweb.cfg
IN : C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config
Add this section....
[pem]
# 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 the file : default.env
(same directory location as the formsweb.cfg file above)
IN : C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config
Add this section....
FORMS_PATH=C:\git\exodus\forms;.....<---- put this first in your FORMS_PATH
===========================================================================================================
Create this Batch File
======================
(NOTE: Obviously your pre_etl_owner password would not normally be the same as your username - Mine is like this for demonstration only)
StartExodus.bat
java -jar C:\Oracle\Middleware\Oracle_Home\forms\java\frmsal.jar -url "http://127.0.0.1:9001/forms/frmservlet?config=pem&userid=pre_etl_owner/pre_etl_owner@pem"
Make these batch (.bat) command files and keep them on your desktop
===================================================================
1) 1-StartNodeMGR.bat
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\bin\startNodeManager.cmd
2) 2-StartWLAdm.bat
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\bin\startWeblogic.cmd
3) 3-StartWLS_FORMS.bat
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\bin\startManagedWebLogic.cmd WLS_FORMS
4) stopAll.bat
cd C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\bin
stopManagedWebLogic.cmd WLS_FORMS
stopWeblogic.cmd
stopNodeManager.cmd
Exodus is a mapping, documenting, and migration tool that has been especially designed with Oracle PL/SQL developers in mind.
Exodus is FREE! And Can Help You Move To A JSON Datastore
