Forms, Reports, Discoverer, Portal 11g installation with OID 10g (10.1.4.3) and SSO (10.1.4.3)

I want to share my experience of installing Oracle Forms, Reports, Discoverer, Portal 11g with Oracle internet Directory 10g (10.1.4.3) and Oracle Single Sign-On 10g (10.1.4.3). I did it on windows server 2003 sp2. Under each step I have provided the names of installer packages which can be downloaded from oracle website.

1- Install Oracle Database 10.2.0.3. Do not install starter database, only install Database Software.

a. 10203_vista_w2k8_x86_production_db.zip

2- Install Oracle database companion CD Release R2

a. 10201_companion_win32

3- Apply patch no 6810189 to upgrade Database to 10.2.0.4.

a. p6810189_10204_Win32

4- Copy msvcr71.dll to %windir%\system32 and %windir%\system

5- Create a Listener

6- Create Database using DBCA, Database Character set must be AL32UTF8

7- Modify Database to install oracle Ultra Search Schema using DBCA

8- Register Database with Listener

9- Modify database initialization parameter as under

db_cache_size=144M

shared_pool_size=175M

java_pool_size=120m

aq_tm_processes=1

processes=500

open_cursors=500

10- Install MRCA to create repository for Oracle Identity Management( 10.1.4.0.1).First run installer and then run Repository Creation Assistant from start menu.

a. as_windows_x86_mrca_101401_disk1.zip

b. as_windows_x86_mrca_101401_disk2.zip

11- Install Schemas for PORTAL and DISCOVERER 11g by running RCU.BAT from bin directory

a. ofm_rcu_win32_11.1.1.2.1_disk1_1of1.zip

12- Install Oracle Identity Management 10g (10.1.4.0.1), here I installed oracle internet Directory, Oracle Single Sign-on, Oracle application server Delegated Administration services and Oracle Directory Integration Platform. I choose “Oracle Application server Infrastructure 10g” on first page of installer and “Identity Management 10g (1.10GB) on second page.

a. as_windows_x86_oim_oif_101401_disk1.zip

b. as_windows_x86_oim_oif_101401_disk2.zip

13- Upgrade Oracle identity Management from 10.1.4.0.1 to 10.1.4.3.0 by applying patch no. 7215628.This patch can be downloaded from support.oracle.com

a. p7215628_101430_WINNT.zip

14- Install Weblogic server 10.3.1

a. oepe11_wls1031.exe

15- Install Forms, Reports, Portal, Discoverer 11g (11.1.1.1.0)

a. ofm_pfrd_win_11.1.1.1.0_32_disk1_1of1.zip

b. ofm_pfrd_win_11.1.1.1.0_32_disk2_1of1.zip

c. ofm_pfrd_win_11.1.1.1.0_32_disk3_1of1.zip

d. ofm_pfrd_win_11.1.1.1.0_32_disk4_1of1.zip

16- Now test your installation using following URL

http://Hostname:8090/portal/pls/portal

If you get following error

Failure of server APACHE bridge

It means Oracle HTTP server (OHS) is not working, to resolve this

a- copy mod_wl_22.so from %MiddleWareHome%\wlserver_10.3\server\plugin \win\32

b- Paste this file in %OracleHome%\ohs\modules\ directory, Locate file named mod_wl_ohs.so in this directory, backup mod_wl_ohs.so file and delete it , Now rename mod_wl_22.so to mod_wl_ohs.so

c- Restart Your OHS using following command at command Line

opmnctl startproc ias-component=ohs1

5 thoughts on “Forms, Reports, Discoverer, Portal 11g installation with OID 10g (10.1.4.3) and SSO (10.1.4.3)”

  1. re step 2 – Install Oracle database companion CD Release R2 10201_companion_win32 –

    what option did you select for the companion cd installation?

  2. After weeks of struggling through the truly awful Oracle documents I came across this page which helped me immensely to tackle the installation. Many thanks for this. I also found the PFRD viewlets on Metalink useful.

    In case anyone from Oracle is reading this – please give teh chap who wrote this page a job to compile similar notes on how to install your bloatware. I give Oracle 0 out of 10 for documentation.

    One minor criticism is that some more details on teh options selcted/values entered in each bit of the process, but the viewlets help with that.

    By the way, I managed to do all this but I installed 11.1.1.2 PFRD and then patched to 11.1.1.3. I also used WLS 10.3.3 and it worked. My target environment was Win2003 SP2 running as a VMWare Workjstation assigned 4 GB RAM (host has 8Gb) and 28Gb hard disk. The Oracle homes and database (all installed under C:\Oracle) consumed 17Gb GB disk space.

    Given the complete mess you are likely to makes thank to the myriad of Oracle products and patches you need to install and the dodgy abstruse and sketchy documentation I strongly recommend the first few times using VM based machines first and snapshot them to enable easy rollback to set pointsso you can repeat steps when you mess up.

Leave a Reply

Your email address will not be published. Required fields are marked *