Configure Forms/Reports
The CONFIG_JVM_ARGS is set to speed things up if the system is low on entropy.
export CONFIG_JVM_ARGS="-Djava.security.egd=file:/dev/./urandom"
cd /u01/app/oracle/product/forms112/fr_binaries/bin
./config.sh
Below I have ignored the screens where you can sign up for security updates etc.
If you press Save Installation Configuration you can save a file that contains this:
Type: Oracle Forms and Reports Installation
Configuration Options
Middleware Home Location: /u01/app/oracle/product/forms112
Oracle Home Location: /u01/app/oracle/product/forms112/fr_binaries
Oracle Instance Location: /u01/app/oracle/product/forms112/instances/FRinst
Oracle Instance: FRinst
Domain Option: Create Domain
Domain Name: FormsReports
Domain Home: /u01/app/oracle/domains/FormsReports
Domain Host Name: oraerptest.com
Domain Port No: 7001
User Name: weblogic
Automatic Port Detection: false
Administrator Console: http://oraerptest.com:7001/console
EM Console: http://oraerptest.com:7001/em
EMAgent URL: http://oraerptest.com:5155/emd/main
Forms URL: http://oraerptest.com:8888/forms/frmservlet
Reports URL: http://oraerptest.com:8888/reports/rwservlet
Normally when you are finished with configuring a FMW domain, no processes are running. Forms/Reports works a bit different, so here everything should be up and running.
Have a look.
ps -ef | grep oracle
While it is nice and helpful that the domain configuration wizard has configured the Node Manager and started everything up, it is not without problems. In the following sections we will verify the installation and fix a couple of problems.
Homes overview
There is a wealth of homes in this installation:
Application Home /u01/app/oracle/applications/FormsReports
Domain Home /u01/app/oracle/domains/FormsReports
Instance Home /u01/app/oracle/product/forms112/instances/FRinst
Middleware Home /u01/app/oracle/product/forms112
Oracle Common Home /u01/app/oracle/product/forms112/oracle_common
Oracle Home /u01/app/oracle/product/forms112/fr_binaries
Weblogic Server Home /u01/app/oracle/product/forms112/wlserver_10.3
Verifying the Installation
You should have 4 WebLogic processes, an Admin Server, two Managed Servers and a Node Manager.
Here is the output from a bash script that lists running WebLogic Servers and Node Managers.
################################################################################
# WebLogic Servers
# <owner> <domain> <server> <pid> <ports>
################################################################################
oracle FormsReports AdminServer 26915 7001
oracle FormsReports WLS_FORMS 3277 9001
oracle FormsReports WLS_REPORTS 27859 9002
################################################################################
# Node Managers
# <owner> <mw_home> <pid> <port>
################################################################################
oracle /u01/app/oracle/product/forms112 23674 5556
You should also have some system component processes.
cd /u01/app/oracle/product/forms112/instances/FRinst/bin
./opmnctl status -l
For example.
Processes in Instance: FRinst
------------------------+-------------------+-----+------+----------+-------+----------+-----
ias-component | process-type | pid|status| uid |memused| uptime |ports
------------------------+-------------------+-----+------+----------+-------+----------+-----
emagent_FRinst | EMAGENT |18737|Alive |957811805 | 63884|215:32:43 |N/A
RptSvr_wintermute_FRinst| ReportsServerComp~|18736|Alive |957811804 | 63884|215:32:43 |N/A
ohs1 | OHS |18735|Alive |957811803 | 384152|215:32:43 |https:8889,https:8890,http:8888
Verify that you can use the different URLs (Screenshots):
Administration Server Console – http://oraerptest.com:7001/console
Enterprise Manager Console – http://oraerptest.com:7001/em
Enterprise Manager Agent – http://oraerptest.com:5155/emd/main
Oracle Forms – http://oraerptest.com:8888/forms/frmservlet
Oracle Reports – http://oraerptest.com:8888/reports/rwservlet
If you are not sure which ports are used check this file: /u01/app/oracle/product/forms112/fr_binaries/install/portlist.in
#Sun Feb 09 18:30:56 CET 2014
OPMN_LOCAL_PORT=6700
OHS_LISTEN_PORT=8888
WLS_FORMS_PORT=9001
OHS_SSL_PORT=8890
OHS_PROXY_PORT=8889
WLS_REPORTS_PORT=9002
OPMN_REQUEST_PORT=6702
OPMN_REMOTE_PORT=6701
DOMAIN_PORT=7001
NODE_MANAGER_PORT=-1
EMAGENT_PORT=5155
Summary
==========
Database Restored done
Web logic Installation done.
Forms/Report Installation done.
Form/Report Configuration done.
NOTE: Very Important Steps
Now it's time to Copy FORMS & Report from production and move to clone server..
Default.env define all paths...forms,report,java follow the below file.
Last steps Application side tnsnames.ora change according to enviroment.
[root@oraerptest config]# pwd
/u01/app/oracle/product/forms112/user_projects/domains/FormsReports/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.2/config
[root@oraerptest config]# cat default.env
# default.env - default Forms environment file, Linux version
#
# This file is used to set the Forms runtime environment parameters.
# If a parameter is not defined here, the value used will be that defined
# in the environment in which the WLS Managed Server was started.
#
# NOTES
# Configuration assitant will replace all the macro's with
# the actual values.
#
#
#
#
ORACLE_HOME=/u01/app/oracle/product/forms112/fr_binaries
ORACLE_INSTANCE=/u01/app/oracle/product/forms112/instances/FRinst
#
#
# TNS Entry to locate the database
#
TNS_ADMIN=/u01/app/oracle/product/forms112/instances/FRinst/config
#
#
# Search path for Forms applications (.fmx files, PL/SQL libraries)
#
FORMS_PATH=/u01/app/oracle/product/forms112/fr_binaries/forms:/u01/app/oracle/product/forms112/instances/FRinst/FormsComponent/forms:/u01/app/oracle/product/forms112/fr_binaries/forms/rrl
#
#
# WebUtil config file path. WebUtil is available for download from OTN.
#
WEBUTIL_CONFIG=/u01/app/oracle/product/forms112/instances/FRinst/config/FormsComponent/forms/server/webutil.cfg
#
# Disable/remove this variable if end-users need access to the query-where
# functionality which potentially allows them to enter arbitrary SQL
# statements when in enter-query mode.
FORMS_RESTRICT_ENTER_QUERY=TRUE
#
# Java class path
# This is required for the Forms debugger
# You can append your own Java code here)
# frmsrv.jar and ldapjclnt11.jar are required for
# the password expiry feature to work(2213140).
#
CLASSPATH=/u01/app/oracle/product/forms112/fr_binaries/forms/j2ee/frmsrv.jar:/u01/app/oracle/product/forms112/fr_binaries/jlib/ldapjclnt11.jar:/u01/app/oracle/product/forms112/fr_binaries/jlib/debugger.jar:/u01/app/oracle/product/forms112/fr_binaries/jlib/ewt3.jar:/u01/app/oracle/product/forms112/fr_binaries/jlib/share.jar:/u01/app/oracle/product/forms112/fr_binaries/jlib/utj.jar:/u01/app/oracle/product/forms112/fr_binaries/jlib/zrclient.jar:/u01/app/oracle/product/forms112/fr_binaries/reports/jlib/rwrun.jar:/u01/app/oracle/product/forms112/fr_binaries/forms/java/frmwebutil.jar:/u01/app/oracle/product/forms112/fr_binaries/jlib/start_dejvm.jar:/u01/app/oracle/product/forms112/fr_binaries/opmn/lib/optic.jar:/u01/app/oracle/product/forms112/fr_binaries/forms/rrl:/u01/app/oracle/product/forms112/fr_binaries/reports/rrl
#
#
# The PATH setting is not required for Forms if the Forms executables are
# in <ORACLE_HOME>/bin.JDK/bin is also required for dejvm to be
# auto-started by frmweb
#
PATH=/u01/app/oracle/product/forms112/fr_binaries/bin:/u01/app/oracle/product/forms112/fr_binaries/jdk/bin:/u01/app/oracle/product/forms112/fr_binaries/forms/rrl:/u01/app/oracle/product/forms112/fr_binaries/reports/rrl
#
# Settings for Reports
# -------------------------------
# NOTE: This setting is only needed if Reports applications
# are called from Forms applications
# However, because of bug 2336698 where a report is started from
# a forms debugger session with an already running JVM, then
# the report's class path should also be included in the forms
# class path.
# We no longer need to set REPORTS_CLASSPATH as forms will
# always start the JVM before calling reports.
#
#
#
#
#
# Settings for Forms tracing and logging
# -----------------------------------------------
# Note: By default tracing and logging directory is
# $ORACLE_INSTANCE/FormsComponent/forms/trace
# To change the trace directory this entry has to be uncommented and set to
# desired directory for tracing and logging
#
#FORMS_TRACE_DIR=%ORACLE_INSTANCE%/FormsComponent/forms/trace
#
#
# Settings for Javascript events
# -----------------------------------------------
# Note: If this variable is set to false then the triggers and
# built-ins associated with javascript events are disabled
#
#FORMS_ALLOW_JAVASCRIPT_EVENTS=TRUE
#
#
#
# System settings
# ---------------
# You should not normally need to modify these settings
#
#
# Path for shared library objects
# This is highly platform (if not machine) specific ! At install time
# <percent>LD_LIBRARY_PATH<percent> should be replaced with the
# actual value of the LD_LIBRARY_PATH environment variable (at install
# time). That should ensure we have the paths for such necessities as
# the motif and X11 libraries.
# Explanations:
# - Reports needs the path for libjava.so
# (.../jre/lib/sparc)
# - Forms needs two paths to the jre, for libjvm.so and libhpi.so
# - In JDK 1.4.1 the location of libjvm.so is lib/sparc (there is no
# classic directory) so we do not include the .../classic directory
# below. There are other versions of libjvm.so (in directories server,
# client and hotspot) but we will use the version in lib/sparc for now.
#
LD_LIBRARY_PATH=/u01/app/oracle/product/forms112/fr_binaries/lib:/u01/app/oracle/product/forms112/fr_binaries/jdk/jre/lib/amd64:/u01/app/oracle/product/forms112/fr_binaries/jdk/jre/lib/amd64/server:/u01/app/oracle/product/forms112/fr_binaries/jdk/jre/lib/amd64/native_threads
#
#
# Setting to take care of signal-chaining facility offered by JVM 1.5
# Without this Forms/Reports integration could have issues on Unix/Linux
#
LD_PRELOAD=/u01/app/oracle/product/forms112/fr_binaries/jdk/jre/lib/amd64/libjsig.so
[root@oraerptest config]#
=======================================================================
Application Side
======================================================================
[root@oraerptest /]# cd /u01/app/oracle/product/forms112/instances/FRinst/config/
[root@oraerptest config]# ls
EMAGENT FRComponent OHS reports ReportsToolsComponent
FormsComponent JPS OPMN ReportsServerComponent tnsnames.ora
[root@oraerptest config]# cat tnsnames.ora
#
# sample tnsnames.ora file added by the Formsconfiguration assistant.
#
#sample entry
#<ALIAS> = (DESCRIPTION =(ADDRESS_LIST =
# (ADDRESS = (PROTOCOL = TCP)
# (HOST = <HOST>)(PORT = <PORT)))
# (CONNECT_DATA = (SID = <SID)))
#
#
PRODTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraerptest.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PRODTEST)
)
)
=======================================================================
Database Side
=======================================================================
[oracle@oraerptest admin]$ cat listener.ora
# listener.ora Network Configuration File: /u02/oradb/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraerptest.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = /u02/oradb
[oracle@oraerptest admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u02/oradb/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
PRODTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraerptest.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PRODTEST)
)
)
[oracle@oraerptest admin]$
Now access the forms using below link
Oracle Forms – http://oraerptest.com:8888/forms/frmservlet
Refer:
https://theheat.dk/blog/?p=1983
