Visit Counter

Tuesday, January 5, 2021

Restore Oracle DB & FMW Cloning (Part 4)

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







No comments:

Post a Comment