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 }

Fereshteh September 28, 2011 at 07:20

Dear Mr. Lorenzen
Thanks a lot for your helpful document.
I have RHEL5 on a 64 bit box and installing weblogic 10.3.2 and form/report 11.1.1.2.during form/report configuration I get this error message:

“/u01/Oracle/Middleware/as_1/bin/rwserver: error while loading shared libraries: libXm.so.3: cannot open shared object file: No such file or directory”

These are some related info:
$echo $LD_LIBRARY_PATH
/u01/app/oracle/product/10.2.0/db_1/lib:/lib:/usr/lib:/usr/lib64
ls -l `find / -name libXm.so.* -print`
-rw-r—– 1 oracle oinstall 466376 Sep 12 2005 /u01/app/oracle/product/10.2.0/db_1/lib/stubs/libXm.so.3
lrwxrwxrwx 1 oracle oinstall 25 Sep 27 15:45 /u01/Oracle/Middleware/as_1/lib32/stubs/libXm.so.3 -> /usr/lib64/libXm.so.4.0.1
-rw-r—– 1 oracle oinstall 361729 Sep 27 15:43 /u01/Oracle/Middleware/as_1/lib32/stubs/libXm.so.3.ORG
lrwxrwxrwx 1 oracle oinstall 25 Sep 27 15:45 /u01/Oracle/Middleware/as_1/lib/stubs/libXm.so.3 -> /usr/lib64/libXm.so.4.0.1
-rw-r—– 1 oracle oinstall 415469 Sep 27 15:43 /u01/Oracle/Middleware/as_1/lib/stubs/libXm.so.3.ORG
lrwxrwxrwx 1 root root 14 Sep 21 14:20 /usr/lib64/libXm.so.4 -> libXm.so.4.0.1
-rwxr-xr-x 1 root root 2836528 Mar 2 2010 /usr/lib64/libXm.so.4.0.1
lrwxrwxrwx 1 root root 25 Sep 27 15:13 /usr/lib/libXm.so.3 -> /usr/lib64/libXm.so.4.0.1
-rwxr-xr-x 1 root root 2542860 Nov 14 2006 /usr/lib/libXm.so.3.0.2

# ldconfig -p |grep libXm.so
libXm.so.4 (libc6,x86-64) => /usr/lib64/libXm.so.4
libXm.so.3 (libc6) => /usr/lib/libXm.so.3

what should I do?

Thanks in advanced
Fereshteh

LD_LIBRARY_PATH is /u01/app/oracle/product/10.2.0/db_1/lib:/lib:/usr/lib:/usr/lib64

Peter Lorenzen September 28, 2011 at 13:46

Hi Fereshteh,
Looks like you are missing some packages like openmotif22. Did you go through the requirements for Red Hat 5.x before trying to install? Check this: http://download.oracle.com/docs/html/E18558_01/fusion_requirements.htm#BABGBCIG
Regards Peter

fereshteh October 2, 2011 at 12:15

Dear Mr. Lorenzen
Thanks a lot for your help.
another problem : I copied a form (xxx.fmb , xxx.fmx) from Windows to Linux server in $FMW_HOME/as_1/forms (where the test.fmb exists) but when I run it in browser, I get this error:

FRM-40010: Cannot read from xxx.fmx
while test.fmb successfuly could be run.
what should i do?

Peter Lorenzen October 2, 2011 at 15:35

You cannot move a .fmx from Windows to Linux or from 32-bit server to 64-bit server. You should delete the .fmx file and then recompile the .fmb file on the Linux server.
Regards Peter

Fereshteh October 3, 2011 at 09:10

Thanks a lot for your help.

As you know Form/Report builder is not supported in RHEL5 (64 bit). Then I should compile forms with what tool?

Regards

Fereshteh October 3, 2011 at 12:42

I use frmcmp.sh in this way :
$ORACLE_INSTANCE/bin/frmcmp.sh module=test2.fmx userid=user/pass@mydb

( env variablesORACLE_INSTANCE, ORACLE_HOME, are set properly)
the error is FRM-91500: Unable to start/complete the build.

what should i do?

Peter Lorenzen October 3, 2011 at 20:08

You can get that error for several reasons. Check “Master Note for Known Causes of FRM-91500 [ID 756384.1]” on MOS.
Regards Peter

Fereshte October 6, 2011 at 12:53

Thanks.
sorry to bother you.I’m newbi in Oracle, Idon’t know how i can find β€œMaster Note for Known Causes of FRM-91500 [ID 756384.1]” on MOS.(What is the meaning of MOS ?)
I searched the Oracle forum but couldn’t be successful.

Regards,
Fereshte

Peter Lorenzen October 7, 2011 at 01:45

That is OK. MOS stands for My Oracle Support and can be accessed here: https://support.oracle.com
It is the most important knowledge repository for Oracle information. Don’t just rely on Google but use MOS as the first place to look.
You need a support license to access MOS but if you are working processional with Oracle you should have access.
Regards Peter

fereshte October 8, 2011 at 06:33

Thanks alot dear friend.

Fereshte October 25, 2011 at 14:16

Dear Mr. Lorenzen
When I transfer a form from windows to my RHEL5 64-bit ,which has an Oracle Form, fonts of the form
are not readable, what should I do?

Thanks
Fereshte

Peter Lorenzen October 25, 2011 at 15:54

I have not encountered that problem. I would assume that you use a Windows font that is not available on Linux. Maybe have a look at this MOS note: Configuration Script to add Common Windows Fonts to Unix 9i, 10g R1 and 10g R2 Reports Server [ID 261879.1]
Regards Peter

Abdul Hameed October 31, 2011 at 12:44

Dear Peter,

I have installed this same in windows environment its running fine.(for Developer Machine)
I wanted to install this in server side, How can i do that,, is there any concept like that to install in server side where forms and report developers can deploy the .fmb files.!???

I really doubt on this concept,, if the same installation from where the clients access this forms and report.Will you please explain me this concept clearly,,

If there is a concept for server side installation kindly let me know the configurations and its software requirements.

Regards
Hamid0

Peter Lorenzen October 31, 2011 at 20:28

Hi Hamid,
I am not sure I understand πŸ™‚ What I describe in this blog post is the server side installation. You can do the same on Windows.
Regards Peter

Fereshte November 19, 2011 at 09:07

Hi dear Peter

you mean that you don’t have font problem with PDF reports which are located on Linux server and run from a Windows client?

(I did all steps in FRM-91500 [ID 756384.1 and relevance documents, but the font problem exists still.
NOTE: I have installed and configured Oracle Forms/Reports 11.1.1.2 on Red Hat 5.5(64-bit)).
Can you shed some light on the way I miss.

Regards,
Fereshteh

fereshte November 19, 2011 at 13:13

Dear friend

The problem is solved now.its a miracle.
Please dont spend time to answer may latest question.

Thanks God and Thank you dear friend
RegarDS,
Fereshte

shahnawaj February 7, 2012 at 16:51

Dear Peter,
hi,
please help me on installation oracle developer suite10g on red hat 5 ’32’bits.
i am unable to install this.pleaseeeeee……

Peter Lorenzen February 7, 2012 at 22:01

Hi,
Have you checked Oracle Forms/Reports Certification Reference [ID 1050790.1] on Metalink and http://docs.oracle.com/cd/B25016_08/doc/dl/core/B16012_04/toc.htm.
As far as I can see Red hat 5 is not supported. You need Red hat 4.
Regards Peter

flosch February 21, 2012 at 17:32

Hi Peter,
I think Forms / Reports 11g R1 and R2 is NOT supported with JRockit!?
In certmatrix only Oracle JDK 1.6.0_18+ is mentioned.

Regards, Florian.

Kerstin March 21, 2012 at 19:02

Thank you for a great post. Saved me some headache, especially the firewall issue.
I also had a problem with webcache not starting:
Found this on oracle support:
Webcache Fails to Start with “Failed to assign port xxxx: Address family not supported by protocol” After FMW 11g Installation. [ID 1113163.1] and it helped to disable ipv6 in webcache.xml.
// Kerstin

Peter Lorenzen June 4, 2012 at 15:55

Hi Florian,
Yes. You are absolutely right. This is a bit surprising.
If you go to Forms 11.1.1.6 you can use JDK 7 by the way.
Regards Peter

Ram December 17, 2013 at 22:41

Excellent article !!! Easy to follow and very descriptive. I was hoping such an article be available in MOS or at least the installation documentation.

Thanks,
Ram.

Yuri SIlko February 21, 2014 at 14:05

Hello.
I install Reports by this article.
All of them installed is ok.
When i configure Reports, i have a error with “Applying Oracle JRF Template” state is error.
Can i fix this issue ?
thanks.

Peter Lorenzen February 21, 2014 at 17:42

Hi Yuri,
Do all your deployments have status Active in the Admin Console? I would assume that one of more of them is not target to a WebLogic server.
Regards Peter

Yuri SIlko February 24, 2014 at 11:04

I don’t check this. I stopped where i have this error.

Yuri SIlko February 25, 2014 at 13:29

i try install step-by-step with same path, but i have the same error with JRF templates. Besause it not applied, NodeManager not working. It says that JRF not apply – apply now. And nothing to do (

Yuri SIlko February 25, 2014 at 13:43

+ EM agent not wort too (

Leave a Comment

Previous post:

Next post: