How to Install and Upgrade Oracle 11g Forms and Reports 11.1.1.2.0 on Microsoft Window 7 Professional

In this article I will describe "How to Install Oracle 11g  Forms and Reports 11.1.1.2.0 on Microsoft Window 7 Professional 32-bit" and then "How to Upgrade it to Oracle 11g  Forms and Reports 11.1.1.3.0".

Download Forms and Reports 11.1.1.2.0, its patch 11.1.1.3.0 and Oracle WebLogic Server 10.3.5 for Microsoft Windows 32-bit from oracle website .

First of all you need to install Oracle WebLogic Server. You can find its installation on Red Hat Linux here. You can easily install it on Windows.

Extract the installation files and run the setup from Disk1.

Figure - 1

Click Next button.

Figure - 2

Select "Install Software - Do Not Configure" option and click Next. Don't Configure at this stage because 11.1.1.2.0 has compatibility issues with WebLogic Server 10.3.5.

Figure - 3

Click Next button.

Figure - 4

Specify the Middleware home which is created during WebLogic Server Installation and click Next button.

Figure - 5

Uncheck the support checkbox and click Next button.

Figure - 6

Click Yes button.

Figure - 7

Click Install button.

Figure - 8

View progress.

Figure - 9

Click Next button.

Figure - 10

View summary and click Finish to finish installation of Oracle Forms and Reports 11.1.1.2.0. Extract the patch set 11.1.1.3.0 and run the setup.

Figure - 11

Click Next button.

Figure - 12

Specify the Middleware home which is created during WebLogic Server Installation and click Next button.

Figure - 13

Uncheck the support checkbox and click Next button.

Figure - 14

Click Yes button.

Figure - 15

Review the summary and click Install button.

Figure - 16

View progress.

Figure - 17

Click Next button.

Figure - 18

Review the summary and click Finish button to finish the installation of patch set 11.1.1.3.0. Select the "Configure Classic Instance" from "Start -> All Programs - > Oracle Classic 11g - Home1" Menu.

Figure - 19

Click Next button.

Figure - 20

Click Next button.

Figure - 21

Provide User Name and Password for new domain and click Next button.

Figure - 22

Uncheck the support checkbox and click Next button.

Figure - 23

Click Next button.

Figure - 24

Click Next button.

Figure - 25

Click Next button.

Figure - 26

Click Next button.

Figure - 27

Provide proxy information or you can disable it as well and click Next button.

Figure - 28

Click Next button.

Figure - 29

Review the summary information and click Configure button.

Figure - 30

View progress.

Figure - 31

View progress.

Figure - 32

Oracle Forms and Reports 11g 11.1.1.3.0 is configured successfully.

Insha-Allah this will help and serve the purpose. For any corrections and improvements please suggest.

How to install Oracle Database 10gR2 10.2.0.1.0 64-bit On Oracle Solaris 10 64-bit

In this article I will describe the installation of Oracle Database 10g R2 64-bit on Oracle Solaris 10 64-bit.

Login with root user, open a terminal and check the physical memory by issuing following command.

/usr/sbin/prtconf | grep "Mem"

Memory should be approximately 1 GB otherwise it will fail the memory check (ignorable) during the installation as in my case.

Check the swap space available by issuing following command.

/usr/sbin/swap -l

Available swap should be approximately 1.5GB. if you have swap space less then 1.5GB you can add swap file by issuing following command.

mkfile 1024m /export/home/swapfile

swap -a /export/home/swapfile

Add the following entry in /etc/vfstab

/export/home/swapfile    -    -    swap    -    no    -

You can also check the space available under /tmp by issuing following command.

df -h /tmp

Check the hardware information by issuing following command.

/bin/isainfo -kv

Following should appear as the result of command above otherwise Oracle Database 10gR2 64-bit will not be installed.

64-bit amd64 kernel modules

Check the OS version installed by issuing following command.

uname -r

5.10 should appear as the result of command above.

Add following commands in /etc/system

    set noexec_user_stack=1
    set semsys:seminfo_semmni=100
    set semsys:seminfo_semmns=1024
    set semsys:seminfo_semmsl=256
    set shmsys:shminfo_semvmx=32767
    set shmsys:shminfo_shmmax=4294967295
    set shmsys:shminfo_shmmni=100
    set shmsys:shminfo_shmseg=10

Check the value of max-shm-memory and max-sem-ids for the root user

prctl -n project.max-shm-memory -i project user.root
prctl -n project.max-sem-ids -i project user.root

Modify these parameters as follows

prctl -n project.max-shm-memory -v 6gb -r -i project user.root
prctl -n project.max-sem-ids -v 256 -r -i project user.root

Create "oracle" user for installation by issuing following commands.

groupadd oinstall
groupadd dba
groupadd oper
useradd -g oinstall -G dba,oper -m -d /export/home/orale -s /bin/sh oracle
passwd -r files oracle

Add oracle project by issuing following command

projadd oracle

And append the following line to the "/etc/user_attr" file.

    oracle::::project=oracle

Open a new terminal and login with oracle the issue following commands from root's terminal

prctl -n project.max-shm-memory -v 4gb -r -i project oracle
projmod -s -K "project.max-shm-memory=(priv,4gb,deny)" oracle

From root user install SUNWi1cs and SUNWi15cs packages by issuing following commands. these packages are available in Solaris 10 DVD.

pkgadd -d /cdrom/sol_10_811_x86/Solaris_10/Product SUNWi1cs SUNWi15cs

Create database installation directories by issuing following commands

mkdir -p /u01/app/oracle
mkdir -p /u02/oradata
chown -R oracle:oinstall /u01/app/oracle
chown -R oracle:oinstall /u02/oradata
chmod -R 775 /u01/app/oracle/
chmod -R 775 /u02/oradata/

Login with oracle user and add following line into .profile

umask 022

export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=umsapp

Now execute the .profile by issuing following commands

. ./.profile

Download Oracle Database 10gR2 10.2.0.1.0 64-bit from oracle website and extract it to some where lets say /export/home/oracle/

cd /export/home/oracle/database

./runInstaller

Figure - 1

Select "Advanced Installation" and click Next Button.

Figure - 2

Click Next Button.

Figure - 3

Click Next Button.

Figure - 4

Click Next Button.

Figure - 5

As my physical memory is less then 922 MB so warning appears but it is recommended to have minimum 1GB physical memory. click Next Button.

Figure - 6

Click Next Button.

Figure - 7

Click Next Button.

Figure - 8

Select Unicode standard UTF-8 AL32UTF8 or character set of your choice and click Next Button.

Figure - 9

Click Next Button.

Figure - 10

Click Next button.

Figure - 11

Click Next Button.

Figure - 12

Specify password and click Next Button.

Figure - 13

Review the summary and click Install button.

Figure - 14

View progress.

Figure - 15

View progress.

Figure - 16

View progress.

Figure - 17

Note the Database Control URL and click Ok button.

Figure - 18

 Click Next button.

Figure - 19

Open a terminal, login with root and run the scripts above.

Figure - 20

Click Ok on Figure - 19

Figure - 21

Run the Enterprise Manager 10g Database Control URL in browser.

Figure - 22

Click Login button and it will login to Enterprise Manager.

Figure - 23

You can also launch the iSQL plus by issuing the iSQL Plus URL: from Figure - 21

Figure - 24

By clicking Login button following screen appears.

Figure - 25

You can stop isqlplus, database control, database and listener by issuing following commands.

$ORACLE_HOME/bin/isqlplusctl stop;

$ORACLE_HOME/bin/emctl stop dbconsole;

$ORACLE_HOME/bin/sqlplus / as sysdba

shutdown immediate;

exit;

$ORACLE_HOME/bin/lsnrctl stop;

You can start isqlplus, database control, database and listener by issuing following commands.

$ORACLE_HOME/bin/lsnrctl start;

$ORACLE_HOME/bin/sqlplus / as sysdba

startup;

exit;

$ORACLE_HOME/bin/emctl start dbconsole;

$ORACLE_HOME/bin/isqlplusctl start; 

Insha-Allah this will help and serve the purpose. For any corrections and improvements please suggest.