Oracle Technology Sharing!!!: Installing 11g Fusion Middleware Forms and Reports 11.1.2

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 Disk1directory.

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