Installing Oracle Forms/Reports 11.1.1.4 on Red Hat 5 (64-bit)

Peter Lorenzen
30/08-2011

I have a new and improved post about installing Forms/Reports 11.1.2.2.0
I have a new and improved post about installing Forms/Reports 11.1.1.6

My first installation of Forms/Reports services on a Weblogic server was not as easy as I would have expected so I thought I would share the steps.

First have a look at the Installation Guide for Oracle Portal, Forms, Reports and Discoverer

Overview

Download the software

Prepare the OS
I am using Red Hat 5.x 64-bit. Check the System Requirements for UNIX Operating Systems.

Create user, group and directories:

groupadd oinstall
useradd -g oinstall -G oinstall oracle
passwd oracle

mkdir -p /data01/app/
mkdir -p /data01/app/oracle
mkdir -p /data01/app/oracle/product
mkdir /data01/tmp

chown -R oracle:oinstall /data01/app/
chmod -R 775 /data01/app/

/etc/hosts:
The Reports service is named like this: “RptSvr_[myHostName]“. The name cannot be longer than 30 characters.
I got an error because it used the server name including the domain (wintermute.dk.logica.com):

oracle.as.config.impl.SimpleProvisionException: Invalid component name:
RptSvr_wintermute.dk.logica.co  (Component name must begin with an alphabetic
character; may only contain alphanumeric characters, or the underscore (_) or
hyphen (-) characters; and must be 4 to 30 characters long.)

I solved this by inserting this in the hosts file:

172.31.8.238  wintermute.dk.logica.com wintermute

Then the service name will be RptSvr_wintermute.

Firewall:
I got the below error because the Report service could not be started:

Process (index=1,uid=1000236589,pid=26680)
failed to start a managed process after the maximum retry limit
Log:
/data01/app/oracle/product/fmw/instances/diagnostics/logs/
ReportsServerComponent/RptSvr_wintermute_FRinst/console~
RptSvr_wintermute_FRinst~1.log

This was because the local firewall on the server was running. Reports is broadcasting something on port 14021. As soon as I allowed 14021:udp in the firewall it worked fine.

Install JRockit

./jrockit-jdk1.6.0_26-R28.1.4-4.0.1-linux-x64.bin

JRockit1
JRockit2
JRockit3
JRockit4

Install Weblogic server 10.3.4
Forms/Reports 11.1.1.4 is not certified with Weblogic 10.3.5 so use 10.3.4. For more information checke MOS article 1316076.1.
Take care when downloading the wls1034_generic.jar file since some browsers will rename it to wls1034_generic.zip.

/data01/app/oracle/product/jrockit-jdk1.6.0_26-R28.1.4-4.0.1/bin/java -jar
 -Djava.io.tmpdir=/data01/tmp wls1034_generic.jar -log=wls_install.log

-Djava.io.tmpdir is only needed if there is not enough tmp space.
Below I have ignored the screens where you can sign up for security updates etc.

wls1
wls2
wls3
wls4
wls5
wls6
wls7
wls8

Install the latest Weblogic CPU/PSU

Weblogic 10.3.4 July 2011 CPU/PSU (Patch 12357891)

unzip p12357891_1034_Generic.zip
mkdir /data01/app/oracle/product/fmw/utils/bsu/cache_dir/
cp H94Y.jar /data01/app/oracle/product/fmw/utils/bsu/cache_dir/.
cp patch-catalog_15776.xml /data01/app/oracle/product/fmw/utils/bsu/
cache_dir/patch-catalog.xml

Make sure that the patch-catalog_15776.xml is renamed to patch-catalog.xml!

cd /data01/app/oracle/product/fmw/utils/bsu/
./bsu.sh -prod_dir=/data01/app/oracle/product/fmw/wlserver_10.3
 -patchlist=H94Y -verbose -install

Verify that the patch is installed.

./bsu.sh -prod_dir=/data01/app/oracle/product/fmw/wlserver_10.3
 -status=applied -verbose -view

Install Forms/Reports version 11.1.1.2.0

cd ofm_pfrd_linux_11.1.1.2.0_64_disk1_1of1/Disk1
./runInstaller

Below I have ignored the screens where you can sign up for security updates etc.

forms1
forms2

cd /home/oracle/oraInventory
./createCentralInventory.sh
Setting the inventory to /home/oracle/oraInventory
Setting the group name to oinstall
Creating the Oracle inventory pointer file (/etc/oraInst.loc)
Changing permissions of /home/oracle/oraInventory to 770.
Changing groupname of /home/oracle/oraInventory to oinstall.
The execution of the script is complete

forms3
forms4
forms5
forms6
forms7
forms8

The above screen will be repeated for all the disks (several times).

forms9
forms10

cd /data01/app/oracle/product/fmw/pfrd_binaries
./oracleRoot.sh

forms11

Patch Forms/Reports to version 11.1.1.4.0

Patch 11060983.

cd p11060983_111140_Linux-x86-64/Disk1
./runInstaller

Below I have ignored the screens where you can sign up for security updates etc.

forms_patch1
forms_patch2
forms_patch3
forms_patch4
forms_patch5

cd /data01/app/oracle/product/fmw/pfrd_binaries
./oracleRoot.sh

forms_patch6

Install the latest version of opatch

unzip p6880880_111000_Linux-x86-64.zip -d /data01/app/oracle/product/fmw
/pfrd_binaries

Install the latest Forms/Reports CPU

Forms/Reports 11.1.1.4 July 2011 CPU (12434184)

cd p12434184_111140_Linux-x86-64/12434184
/data01/app/oracle/product/fmw/pfrd_binaries/OPatch/opatch apply

Configure Forms/Reports

cd /data01/app/oracle/product/fmw/pfrd_binaries/bin
./config.sh

Below I have ignored the screens where you can sign up for security updates etc.

create_domain1
create_domain2
create_domain3
create_domain4
create_domain5
create_domain6
create_domain7
create_domain8
When you press configure it might take a long time before it proceeds so be patient :-)
create_domain9
create_domain10
create_domain11

Homes overview
There is a wealth of homes in this installation:

  • Domain Home – /data01/app/oracle/product/fmw/user_projects/domains/FormsReports
  • Instance Home – /data01/app/oracle/product/fmw/instances/FRinst
  • Middleware Home – /data01/app/oracle/product/fmw
  • Oracle Commone Home – /data01/app/oracle/product/fmw/oracle_common
  • Oracle Home – /data01/app/oracle/product/fmw/pfrd_binaries
  • Weblogic Server Home – /data01/app/oracle/product/fmw/wlserver_10.3

For more information check the Oracle Fusion Middleware Installation Planning Guide.

Verifying the Installation

OPMN status:

cd /data01/app/oracle/product/fmw/instances/FRinst/bin
 ./opmnctl status -l
Processes in Instance: FRinst
---------------------------------+--------------------+---------+----------+------------+----------+-----------+------
ias-component                    | process-type       |     pid | status   |        uid |  memused |    uptime | ports
---------------------------------+--------------------+---------+----------+------------+----------+-----------+------
emagent_FRinst                   | EMAGENT            |    6332 | Alive    | 1120212237 |    63828 |   2:45:41 | N/A
RptSvr_wintermute_FRinst         | ReportsServerComp~ |    7644 | Alive    | 1120212239 |    63828 |   2:34:25 | N/A
ohs1                             | OHS                |    5467 | Alive    | 1120212232 |   144976 |   3:07:36 | https:8889,https:8890,http:8888

Checking Browser URLs:
If you are not sure which ports are used check this file: /data01/app/oracle/product/fmw/pfrd_binaries/install/portlist.ini

#Sun Aug 28 01:32:58 CEST 2011
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

Screenshots:
Administration Server Console – http://wintermute:7001/console
Enterprise Manager Console – http://wintermute:7001/em
Enterprise Manager Agent – http://wintermute:5155/emd/main
Oracle Forms – http://wintermute:8888/forms/frmservlet
Oracle Reports – http://wintermute:8888/reports/rwservlet

Configure automatic start of the servers/processes
I always use the Node Manager to restart the Weblogic servers after a server boot. If you don’t want to use the Node Manager have a look at this MOS note:
“Sample Script (Unix): Start / Stop Oracle Fusion Middleware 11g OPMN and WebLogic Components [ID 1060855.1]”

Besides Weblogic we also need to start the opmn processes.

I did the following:
1. Set CrashRecoveryEnabled=true in Weblogic_Server_Home/common/nodemanager/nodemanager.properties
2. Set the NodeManager Username and Password in the Admin server console. Domain => Security => Advanced
3. Created two (+init script) boot scripts:
/etc/init.d/fmwNodeManager
/etc/init.d/initFmwNodeManager
/etc/init.d/opmn
4. Added them

cd /etc/init.d
chkconfig --add fmwNodeManager
chkconfig --level 3 fmwNodeManager on
chkconfig --level 5 fmwNodeManager on
chkconfig --list fmwNodeManager

chkconfig --add opmn
chkconfig --level 3 opmn on
chkconfig --level 5 opmn on
chkconfig --list opmn

5. Stop/start everything manually
Stop all Weblogic servers via the Admin server console and killing the Node Manager process.
Start the Node Manager via:

/etc/init.d/fmwNodeManager start

Start the Admin server via:

. /data01/app/oracle/product/fmw/user_projects/domains/FormsReports/bin/
setDomainEnv.sh
java weblogic.WLST 
nmConnect(username='nodemgr',password='passwd',domainName='FormsReports',
port='5556',nmType='ssl')
nmStart('AdminServer')

Start the two Managed servers via the Admin Server console.
6. Boot the server and check if everything starts up.

Configure OCM
As far as I know OCM will default upgrade it self if it has a direct connection to Oracle via the Internet.
But I normally do this manually :-)

Download the latest OCM from MOS.

This installation contains two OCM installations:
/data01/app/oracle/product/fmw/utils/ccr
/data01/app/oracle/product/fmw/oracle_common/ccr

I assume that it does not make a difference which one you use.

rm -rf /data01/app/oracle/product/fmw/utils/ccr
unzip p5567658_1035_Linux-x86-64.zip -d /data01/app/oracle/product/fmw/utils
. /data01/app/oracle/product/fmw/user_projects/domains/FormsReports/
bin/setDomainEnv.sh
export ORACLE_HOME=/data01/app/oracle/product/fmw/utils
export JAVA_HOME=/data01/app/oracle/product/jrockit-jdk
1.6.0_26-R28.1.4-4.0.1
cd $ORACLE_HOME/ccr/bin
./setupCCR -s 12345678 nobody@logica.com DK

Verify that it is working:

cd $ORACLE_HOME/ccr/bin
./emCCR start
./emCCR status
./emCCR -register test
./emCCR -verbose test
./emCCR register
./emCCR collect
./emCCR upload
./emCCR disable_target

You need to restart the Weblogic Admin server before OCM will pickup all the targets.

Create soft link as JRockit “alias”
I always create a softlink for the JDK and reference it everywhere so it is easier to upgrade it.

ln -s /data01/app/oracle/product/jrockit-jdk1.6.0_26-R28.1.4-4.0.1
 /data01/app/oracle/product/java_current

Stop the Weblogic servers/processes (Admin, Managed, Node Manager).
Replace the paths to the JDK:

cd /data01/app/oracle/product/fmw
find . -type f -exec sed -i "s/\/data01\/app\/oracle\/product\/jrockit-jdk
1.6.0_26-R28.1.4-4.0.1/\/data01\/app\/oracle\/product\/java_current/g" {} \;

{ 27 comments… read them below or add one }

Leave a Comment

Previous post:

Next post: