ORACLE FORMS AND REPORTS SETUP


PREPARE THE OS
Special Startup Requirements for Linux x86 or Linux x86-64 Operating Systems
If you are running Oracle Universal Installer on Linux x86 or Linux x86-64 operating systems, you must modify the value of the SHMMAX kernel parameter to avoid seeing errors generated by the Oracle Universal Installer. To do so:
[root@VTSTFORMS ~]# vi /etc/sysctl.conf
Change kernel.shmmax = 4294967295
[root@VTSTFORMS ~]# /sbin/sysctl –p   ( reload the sysctl parameters )
[root@VTSTFORMS ~]# /sbin/sysctl -a | grep shmmax    ( check the value )
kernel.shmmax = 4294967295

Following packages should be installed.

yum install binutils.x86_64 -y -q
yum install compat-libcap1.x86_64 -y -q
yum install compat-libstdc++-33.x86_64 -y -q
yum install compat-libstdc++-33.i686 -y -q
yum install gcc.x86_64 -y -q
yum install gcc-c++.x86_64 -y -q
yum install glibc.x86_64 -y -q
yum install glibc.i686 -y -q
yum install glibc-devel.i686 -y -q
yum install libaio.x86_64 -y -q
yum install libaio-devel.x86_64 -y -q
yum install libgcc.x86_64 -y -q
yum install libstdc++.x86_64 -y -q
yum install libstdc++.i686 -y -q
yum install libstdc++-devel.x86_64 -y -q
yum install libXext.i686 -y -q
yum install libXtst.i686 -y -q
yum install openmotif.x86_64 -y -q
yum install openmotif22.x86_64 -y -q
yum install redhat-lsb.x86_64 -y -q
yum install sysstat.x86_64 -y -q
yum install xorg-x11-utils.x86_64 -y –q
yum install oracle-rdbms-server-11gR2-preinstall –y -q

Firewall
To turn off the firewall do the following as the "root" user.
# service iptables stop
# chkconfig iptables off

SELinux
Set SELinux to "permissive" by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.
SELINUX=permissive
Once the change is complete, either restart the server or run the following command as "root".
# setenforce Permissive

Change the open file limits in /etc/security/limits.conf to whatever is appropriate for you environment
sed -i '/.*End of file/d' /etc/security/limits.conf
echo "* soft nofile 65536" >> /etc/security/limits.conf
echo "* hard nofile 65536" >> /etc/security/limits.conf
echo "# End of file"  >> /etc/security/limits.conf
cat /etc/security/limits.conf

Create user, group and directories:
groupadd oinstall
useradd -g oinstall -G oinstall oracle
passwd oracle

mkdir -p /u01/app/oracle/product
mkdir -p /home/oracle/tmp
chown -R oracle:oinstall /u01/app/
chmod -R 775 /u01/app/
chown -R oracle:oinstall /home/oracle/tmp/
chmod -R 775 /home/oracle/tmp/

Install Java or Jrockit

JRockit Installation on Linux

$ chmod u+x jrockit-jdk1.6.0_45-R28.2.7-4.1.0-linux-x64.bin
$ ./jrockit-jdk1.6.0_45-R28.2.7-4.1.0-linux-x64.bin
Click the "Next" button on the welcome screen.
Welcome

Enter the relevant installation directory and click the "Next" button.

Choose Product Installation Directories
Pick any required optional components and click the "Next" button.
Optional Components

Wait for the installation to complete, then click the "Done" button.

Installation Complete

You may want to set the JAVA_HOME environment variable in your .bash_profile file to point at the new installation.

export JAVA_HOME=/u01/app/oracle/jrockit-jdk1.6.0_45-R28.2.7-4.1.0

[oracle@VDEVFORMS ~]$ java -version
java version "1.6.0_45"
Java(TM) SE Runtime Environment (build 1.6.0_45-b06)
Oracle JRockit(R) (build R28.2.7-7-155314-1.6.0_45-20130329-0641-linux-x86_64, compiled mode)




Setup Oracle WebLogic Server

The following actions should be performed by the "root" user.
Make sure the "/etc/hosts" file contains correct entries for both the "localhost" and real host names. ***Exactly like this***
127.0.0.1       localhost.localdomain localhost localhost4.localdomain4
192.168.1.54    VDEVFORMS.fcicanada.com         VDEVFORMS
Create the directories in which the Oracle software will be installed.
mkdir -p /u01/app/oracle/product/fmw11g
mkdir -p /u01/app/oracle/config/domains
mkdir -p /u01/app/oracle/config/applications
chown -R oracle:oinstall /u01
chmod -R 775 /u01/
Append the following entries into the "/home/oracle/.bash_profile" file.
export MW_HOME=/u01/app/oracle/product/fmw11g
export WLS_HOME=$MW_HOME/wlserver_10.3
export WL_HOME=$WLS_HOME
export JAVA_HOME=/u01/app/oracle/jrockit-jdk1.6.0_45-R28.2.7-4.1.0
export PATH=$JAVA_HOME/bin:$PATH
As specified in MOS Note [ID 1487773.1], amend the "/etc/security/limits.d/90-nproc.conf" file, making the following change.
# From
*          soft    nproc     1024

#To
* - nproc 16384

Installation

Run the installer as the "oracle" user.
$ $JAVA_HOME/bin/java -Xmx1024m -jar wls1035_generic.jar
$ $JAVA_HOME/bin/java -Xmx1024m -jar wls1036_generic.jar
Click the "Next" button on the welcome screen.
Welcome
Enter the middleware home ("/u01/app/oracle/product/fmw11g") and click the "Next" button.
Choose Middleware Home Directory
Either enter your support details, or attempt to uncheck the security updates checkbox. The box doesn't actually uncheck, but presents you with a warning dialog. If you click the "Yes" button, indicating you don't want updates, you are returned to the same screen with the box still checked. Click the "Next" button anyway.
Register For Security Updates
Assuming you don't want security updates, click "Yes" and "Yes" on the subsequent warning dialogs and you are presented with the "Connection Failed" screen. Check the "I wish to remain uninformed..." checkbox and click the "Continue" button. This whole process is very confusing at first. Obviously the developers responsible didn't really expect people to say no to security updates!
Connection Failed
Accept the typical setup by clicking the "Next" button.
Choose Install Type
Accept the default JDK selection by clicking the "Next" button.
JDK Selection
Accept the default product installation directories by clicking the "Next" button.
Choose Product Installation Directories
If you are happy with the summary information, click the "Next" button and wait while the installation completes.
Installation Summary
On the installation complete screen, uncheck the "Quickstart" checkbox and click the "Done" button.
Installation Complete

Install Forms/Reports version 11.1.1.2.0

Unzip the install kits.
1
2
unzip ofm_frmrpts_linux_11.1.2.2.0_64_disk1_1of2.zip
unzip ofm_frmrpts_linux_11.1.2.2.0_64_disk1_2of2.zip
Start the installer.
1
2
cd Disk1
./runInstaller
Below I have ignored the screens where you can sign up for security updates etc.
http://theheat.dk/images/install_forms11.1.2.2.0/forms_install1.png
http://theheat.dk/images/install_forms11.1.2.2.0/forms_install2.png

1
2
3
su -
cd /u01/app/oracle/oraInventory
./createCentralInventory.sh
Output.
1
2
3
4
5
6
Setting the inventory to /u01/app/oracle/oraInventory
Setting the group name to oinstall
Creating the Oracle inventory pointer file (/etc/oraInst.loc)
Changing permissions of /u01/app/oracle/oraInventory to 770.
Changing groupname of /u01/app/oracle/oraInventory to oinstall.
The execution of the script is complete
http://theheat.dk/images/install_forms11.1.2.2.0/forms_install3.png
http://theheat.dk/images/install_forms11.1.2.2.0/forms_install4.png
http://theheat.dk/images/install_forms11.1.2.2.0/forms_install5.png
http://theheat.dk/images/install_forms11.1.2.2.0/forms_install6.png
http://theheat.dk/images/install_forms11.1.2.2.0/forms_install7.png

http://theheat.dk/images/install_forms11.1.2.2.0/forms_install8.png
If you press Save you will be prompted for a place to save a response file you can use for silent installation.
http://theheat.dk/images/install_forms11.1.2.2.0/forms_install9.png
http://theheat.dk/images/install_forms11.1.2.2.0/forms_install10.png


1
2
3
su -
cd /u01/app/oracle/product/forms112/ fr_binaries
./oracleRoot.sh
There is no output from the script.
http://theheat.dk/images/install_forms11.1.2.2.0/forms_install11.png

Configure Forms/Reports

The CONFIG_JVM_ARGS is set to speed things up if the system is low on entropy.

1
2
3
export CONFIG_JVM_ARGS="-Djava.security.egd=file:/dev/./urandom"
cd /u01/app/oracle/product/fmw11g/fr_binaries/bin
./config.sh

http://theheat.dk/images/install_forms11.1.2.2.0/create_domain1.png
http://theheat.dk/images/install_forms11.1.2.2.0/create_domain2.png

Here we select “Configure for Deployment”. Among other things this also mean the domain is configured to run in Production Mode. This is a WebLogic server thing. Make sure you understand the difference between Production Mode and Development Mode.
http://theheat.dk/images/install_forms11.1.2.2.0/create_domain3.png
http://theheat.dk/images/install_forms11.1.2.2.0/create_domain4.png

In Forms 11g R1 you domain had to be placed in MIDDLEWARE_HOME/user_projects/domains. This has been fixed in R2 so now we can place it away form the software installation, as is best practice.
http://theheat.dk/images/install_forms11.1.2.2.0/create_domain5.png
Check if the ports are being used by any other process
sudo netstat -pnlt | grep 9003
sudo netstat -pnlt | grep 9004
sudo netstat -pnlt | grep 9005
sudo netstat -pnlt | grep 6704
sudo netstat -pnlt | grep 6705
sudo netstat -pnlt | grep 6706
sudo netstat -pnlt | grep 5156
sudo netstat -pnlt | grep 8091
sudo netstat -pnlt | grep 8092
sudo netstat -pnlt | grep 8093
sudo netstat -pnlt | grep 8094
sudo netstat -pnlt | grep 8090
sudo netstat -pnlt | grep 8890
sudo netstat -pnlt | grep 8889
sudo netstat -pnlt | grep 8888
sudo netstat -pnlt | grep 7010

http://theheat.dk/images/install_forms11.1.2.2.0/create_domain6.png


A Forms/Reports installation uses more that 10 different ports. If you want to decide which ports are used you can copy the Disk1/stage/Response/staticports.ini somewhere an edit it. You just need to “add” the ports you want to change to the file.http://theheat.dk/images/install_forms11.1.2.2.0/create_domain7.png
http://theheat.dk/images/install_forms11.1.2.2.0/create_domain8.png
http://theheat.dk/images/install_forms11.1.2.2.0/create_domain9.png

If you press Save you will be prompted for a place to save a response file you can use for silent installation.
http://theheat.dk/images/install_forms11.1.2.2.0/create_domain10.png
http://theheat.dk/images/install_forms11.1.2.2.0/create_domain11.png

If you press Save Installation Configuration you can save a file that contains this:
Configuring the boot.properties File
To configure the boot.properties file, perform the following steps:
1.
Browse to
/u01/app/oracle/domains/DEV_FORMS/servers/AdminServer/security/
and edit the boot.properties file.

$ vi boot.properties
Note: You need to create the security folder and the boot.properties file incase the parent folder is empty.
2.
Modify the file with the following values and save it.

username=weblogic
password=weblogic1


[oracle@xxxxxxx ~]$ cp /u01/app/oracle/domains/DEV_FORMS/servers/AdminServer/security/boot.properties /u01/app/oracle/domains/DEV_FORMS/servers/WLS_FORMS/security/
[oracle@xxxxxxx ~]$ cp  /u01/app/oracle/domains/DEV_FORMS/servers/AdminServer/security/boot.properties /u01/app/oracle/domains/DEV_FORMS/servers/WLS_REPORTS/security/


Starting process

nohup $WLS_HOME/server/bin/startNodeManager.sh
/u01/app/oracle/product/fmw11g/wlserver_10.3/common/nodemanager/nodemanager.log

nohup /u01/app/oracle/domains/DEV_FORMS/bin/startWebLogic.sh
/u01/app/oracle/domains/DEV_FORMS/servers/AdminServer/logs/AdminServer.log

nohup /u01/app/oracle/domains/DEV_FORMS/bin/startManagedWebLogic.sh WLS_FORMS
/u01/app/oracle/domains/DEV_FORMS/servers/AdminServer/logs/DEV_FORMS.log

nohup /u01/app/oracle/domains/DEV_FORMS/bin/startManagedWebLogic.sh WLS_REPORTS

[oracle@VDEVFORMS ~]$ /u01/app/oracle/product/fmw11g/FRinst/bin/opmnctl startall
opmnctl startall: starting opmn and all managed processes...




Stopping process

nohup /u01/app/oracle/domains/DEV_FORMS/bin/stopManagedWebLogic.sh WLS_FORMS

nohup /u01/app/oracle/domains/DEV_FORMS/bin/stopManagedWebLogic.sh WLS_REPORTS

nohup /u01/app/oracle/domains/DEV_FORMS/bin/startWebLogic.sh

nohup $FR_INST/bin/opmnctl stopall

Bash_profile

# Middleware
export MW_HOME=/u01/app/oracle/product/fmw11g
export WLS_HOME=$MW_HOME/wlserver_10.3
export WL_HOME=$WLS_HOME
export ORACLE_HOME=$MW_HOME/fr_binaries
export ORACLE_INSTANCE=$MW_HOME/FRinst
export FR_HOME=$ORACLE_HOME
export FR_INST=$ORACLE_INSTANCE
export DOMAIN_HOME=$/u01/app/oracle/domains/DEV_FORMS
export JAVA_HOME=/u01/app/oracle/jrockit-jdk1.6.0_45-R28.2.7-4.1.0
export PATH=$JAVA_HOME/bin:$PATH
# Forms compilation
export PATH=.:$FR_HOME/bin:$FR_HOME/forms/mesg:$PATH
export LD_LIBRARY_PATH=$FR_HOME/jdk/jre/lib/amd64/native_threads:$FR_HOME/jdk/jre/lib/amd64:$FR_HOME/lib:$FR_HOME/jdk/jre/lib/amd64/server
export FORMS_BUILDER_CLASSPATH=$FR_HOME/jlib/
export FORMS_PATH=/u01/app/oracle/product/fmw11g/fr_binaries/forms
export REPORTS_PATH=/u01/app/oracle/product/fmw11g/fr_binaries/reports
export TNS_ADMIN=/u01/app/oracle/product/fmw11g/fr_binaries/network/admin/
export TERM=vt220
export ORACLE_TERM=$TERM