This note describes the process of installing and configuring FMW 11g R2 (11.1.2) Forms and Reports.
Note that we are not configuring Forms and Reports to be protected by Oracle Identity Management in this case – if required, then we need to install and configure Oracle Identity and Access Management first before we start this installation.
Download the required software from the Oracle E-Delivery web site.
These are the part numbers :
Oracle WebLogic Server 11gR1 (10.3.6) Generic and Coherence – Part V29856-01
Oracle Forms and Reports 11g R2 (11.1.2.1.0) for Linux x86-64 – Part V35700-01
Install JDK 1.6 Update 38 and add environment variable JAVA_HOME to point to this location
Install openmotif RPM’s
# rpm -ivh openmotif22-2.2.3-18.x86_64.rpm warning: openmotif22-2.2.3-18.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159 Preparing... ########################################### [100%] 1:openmotif22 ########################################### [100%] # rpm -ivh openmotif-2.3.1-5.el5_5.1.x86_64.rpm warning: openmotif-2.3.1-5.el5_5.1.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159 Preparing... ########################################### [100%] 1:openmotif ###########################################< /pre> Create directory for Middleware home $ cd /u01/app $ mkdir Middleware
Installing Oracle 11g Weblogic Server 10.3.6
Ensure the JAVA_HOME environment variable is now pointing to the JDK 1.6-u38 java (check using java -version command) and launch the installer via the command
java -jar wls1036_generic.jar
Starting the Oracle Forms and Reports Installer
To start the installer, go to the directory where you downloaded the Oracle Forms and Reports installer and unpacked the archive file. Switch to the Disk1 directory.
Start the installer:
./runInstaller
These are some the checks being performed:
Root
Checking operating system certification
Expected result: One of redhat-6,oracle-6,enterprise-5.4,enterprise-4,enterprise-5,redhat-5.4,redhat-4,redhat-5,SuSE-10,SuSE-11
Actual Result: enterprise-5.4
Check complete. The overall result of this check is: Passed
Checking recommended operating system packages
Checking for binutils-2.17.50.0.6; found binutils-2.17.50.0.6-20.el5_8.3-x86_64. Passed
Checking for compat-libstdc++-33-3.2.3-x86_64; found compat-libstdc++-33-3.2.3-61-x86_64. Passed
Checking for compat-libstdc++-33-3.2.3-i386; found compat-libstdc++-33-3.2.3-61-i386. Passed
Checking for elfutils-libelf-0.125; found elfutils-libelf-0.137-3.el5-i386. Passed
Checking for elfutils-libelf-devel-0.125; found elfutils-libelf-devel-0.137-3.el5-x86_64. Passed
Checking for gcc-4.1.1; found gcc-4.1.2-54.el5-x86_64. Passed
Checking for gcc-c++-4.1.1; found gcc-c++-4.1.2-54.el5-x86_64. Passed
Checking for glibc-2.5-12-x86_64; found glibc-2.5-107-x86_64. Passed
Checking for glibc-2.5-12-i686; found glibc-2.5-107-i686. Passed
Checking for glibc-common-2.5; found glibc-common-2.5-107-x86_64. Passed
Checking for glibc-devel-2.5-x86_64; found glibc-devel-2.5-107-x86_64. Passed
Checking for glibc-devel-2.5-12-i386; found glibc-devel-2.5-107-i386. Passed
Checking for libaio-0.3.106-x86_64; found libaio-0.3.106-5-x86_64. Passed
Checking for libaio-0.3.106-i386; found libaio-0.3.106-5-i386. Passed
Checking for libaio-devel-0.3.106; found libaio-devel-0.3.106-5-i386. Passed
Checking for libgcc-4.1.1-x86_64; found libgcc-4.1.2-54.el5-x86_64. Passed
Checking for libgcc-4.1.1-i386; found libgcc-4.1.2-54.el5-i386. Passed
Checking for libstdc++-4.1.1-x86_64; found libstdc++-4.1.2-54.el5-x86_64. Passed
Checking for libstdc++-4.1.1-i386; found libstdc++-4.1.2-54.el5-i386. Passed
Checking for libstdc++-devel-4.1.1; found libstdc++-devel-4.1.2-54.el5-x86_64. Passed
Checking for make-3.81; found make-1:3.81-3.el5-x86_64. Passed
Checking for sysstat-7.0.0; found sysstat-7.0.2-12.0.1.el5-x86_64. Passed
Checking for openmotif-2.2.3-x86_64; found openmotif-2.3.1-5.el5_5.1-x86_64. Passed
Checking for openmotif22-2.2.3-x86_64; found openmotif22-2.2.3-18-x86_64. Passed
Check complete. The overall result of this check is: Passed
Checking kernel parameters
Checking for VERSION=2.6.18; found VERSION=2.6.39-300.26.1.el5uek. Passed
Checking for hardnofiles=4096; found hardnofiles=4096. Passed
Checking for softnofiles=4096; found softnofiles=4096. Passed
Check complete. The overall result of this check is: Passed
Checking Recommended glibc version
Expected result: ATLEAST=2.5-12
Actual Result: 2.5-107
Check complete. The overall result of this check is: Passed
Checking physical memory
Expected result: 922MB
Actual Result: 100648MB
Check complete. The overall result of this check is: Passed
Checking for LD_ASSUME_KERNEL environment variable
Expected result: LD_ASSUME_KERNEL environment variable should not be set in the environment.
Actual Result: Variable Not set.
Check complete. The overall result of this check is: Passed
Setting up a stand alone reports server
We run the opmnctl command from the $INSTANCE_HOME/bin directory.
We need to provide the host name of the web logic server, the admin user name, the port of the admin server, the Oracle Home location for 11g Forms and Reports, the $INSTANCE_HOME location and name and the reports server name which we are configuring which in this case is Repserver.
We also have the provide the weblogic administrator user password as well when prompted.
$ ./opmnctl createcomponent -adminUsername weblogic -adminHost orafin-001-test -adminPort 7001 -oracleHome /u01/app/Middleware/Oracle_FRHome1 -oracleInstance /u01/app/Middleware/asinst_1 -instanceName asinst_1 -componentName Repserver -componentType ReportsServerComponent Command requires login to weblogic admin server (orafin-001-test): Username: weblogic Password: Creating empty component directories...Done Provisioning ReportsServerComponent files for Repserver Registering Repserver component Invoking opmn reload...Done Command succeeded.
Update the cgicmd.dat file with the database connection details
$ vi ./user_projects/domains/ClassicDomain/config/fmwconfig/servers/WLS_REPORTS/applications/reports_11.1.2/configuration/cgicmd.dat webrep:server=Repserver userid=webrep/xxx@CLMTS10G destype=cache %*
Edit the REPORTS_PATH in the reports.sh file to include the location of our reports .rdf files
vi ./asinst_1/config/reports/bin/reports.sh
REPORTS_PATH=/u02/applications_prod/webrep/rpt/:/u01/app/Middleware/Oracle_FRHome1/reports/templates:/u01/app/Middleware/Oracle_FRHome1/reports/samples/demo:/u01/app/Middleware/Oracle_FRHome1/reports/printers:/u01/app/Middleware/asinst_1/reports/fonts:${REPORTS_PATH}; export REPORTS_PATH
Next stop and start WLS_REPORTS managed server
When we tried to start the stand alone reports server Repserver via the opmnctl startproc ias-component=Repserver command we recived an error :
REP-56040 error – already have a reports server Repserver in the same subnet
This is documented in Metalink note 437228.1 and the reason we received this error was because we already had a report server with the same name running in a different environment but on the same network subnet.
Since the default port 14021 was already used by a report server with the same name, we either had to change the reports server name or if we wanted to retain the same reports server name accross all our environments, we had to change the port to 14022 in rwnetwork.conf file in three locations as shown below.
cd /u01/app/Middleware/ cd asinst_1/ cd config/ cd ReportsToolsComponent/ReportsTools/ vi rwnetwork.conf change.. multicast channel="228.5.6.7" port="14021" timeout="1000" to multicast channel="228.5.6.7" port="14022" timeout="1000" Then .. cd .. cd ReportsServerComponent/ cd RptSvr_kens-orafin-001-test_as vi rwnetwork.conf Then .. cd .. cd Repserver vi rwnetwork.conf
Now we are able to start the reports server Repserver using opmnctl
$ ./opmnctl startproc ias-component=Repserver opmnctl startproc: starting opmn managed processes... $ ./opmnctl status Processes in Instance: asinst_1 ---------------------------------+--------------------+---------+------- ---------------------------------+--------------------+---------+-- ias-component | process-type | pid | status ---------------------------------+--------------------+---------+------- ---------------------------------+--------------------+---------+-- Repserver | ReportsServerComp~ | 25612 | Alive emagent_asinst_1 | EMAGENT | 5687 | Alive RptSvr_kens-orafin-001-test_as | ReportsServerComp~ | 5523 | Alive ohs1 | OHS | 8459 | Alive
Using the rwdiag.sh command we can check the Channel port in use now is 14022 and not 14021
[oracle@kens-orafin-001-test bin]$ ./rwdiag.sh -findAll Reading the rwnetwork.conf from :/u01/app/Middleware/asinst_1/config/ReportsToolsComponent/ReportsTools/rwnetwork.conf Broadcast mechanism used to locate servers ------------------------------------------ Channel address = 228.5.6.7 Channel port = 14022 (1) Name = repserver : Type = server : Host = orafin-001-test.corporateict.domain
