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
- Install JRockit
- Install Weblogic server 10.3.4
- Install the latest Weblogic CPU/PSU
- Install Forms/Reports version 11.1.1.2.0
- Patch Forms/Reports to version 11.1.1.4.0
- Install the latest version of opatch
- Install the latest Forms/Reports CPU
- Configure Forms/Reports
- Homes overview
- Verifying the Installation
- Configure automatic start of the servers/processes
- Configure OCM
- Create soft link as JRockit “alias”
- JRockit
- Weblogic 10.3.4
- Weblogic 10.3.4 July 2011 CPU/PSU (Patch 12357891)
- Forms/Reports 11.1.1.2.0 Disk1
- Forms/Reports 11.1.1.2.0 Disk2
- Forms/Reports 11.1.1.2.0 Disk3
- Forms/Reports 11.1.1.2.0 Disk4
- Forms/Reports version 11.1.1.4.0 (Patch 11060983)
- Latest version of the opatch from MOS (6880880)
- Forms/Reports 11.1.1.4 July 2011 CPU (12434184)
- Latest version of the OCM from MOS
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.
./jrockit-jdk1.6.0_26-R28.1.4-4.0.1-linux-x64.bin
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.
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.
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
The above screen will be repeated for all the disks (several times).
cd /data01/app/oracle/product/fmw/pfrd_binaries
./oracleRoot.sh
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.
cd /data01/app/oracle/product/fmw/pfrd_binaries
./oracleRoot.sh
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
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.
When you press configure it might take a long time before it proceeds so be patient π
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.
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 }
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
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
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?
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
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
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?
You can get that error for several reasons. Check “Master Note for Known Causes of FRM-91500 [ID 756384.1]” on MOS.
Regards Peter
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
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
Thanks alot dear friend.
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
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
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
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
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
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
Dear Peter,
hi,
please help me on installation oracle developer suite10g on red hat 5 ’32’bits.
i am unable to install this.pleaseeeeee……
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
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.
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
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
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.
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.
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
I don’t check this. I stopped where i have this error.
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 (
+ EM agent not wort too (