How to install Oracle Forms and Reports 11g on windows 7 64bit

Mar 13, 2012 | java, Oracle, oracle forms, oracle reports

specs: Pentium Dual 2.2 64bit, 5 GB mem, Windows 7 64bit
reqs: Win7 x64, 1GB Memory, Administrator
time: Oracle Weblogic: 5 min, Fusion Middleware: 23 min setup, 16 min config

  1. Download Java JDK 6u25 x64 (jdk-6u25-windows-x64.exe)
  2. Download Weblogic Server 10.1.3.2 (11g) from here
    Tip: look for “Oracle WebLogic Server 11gR1 (10.3.2) – Package Installer” and select
    the x64 JVM installer package (about 1 GB)
  3. Download Fusion Middleware – Portal, Forms, Reports and Discoverer (11.1.1.2.0) from here
    Tip: look for “Portal, Forms, Reports and Discoverer (11.1.1.2.0)” download link and select
    the x64 zip files (about 2.5 GB in chunks of ~500MB).
  4. Make sure you have at least
    • a 64bit CPU and Windows system
    • 1 GB of memory
    • 5 GB of free disk space for a typical install

Install Java JDK and test in console:
[bash]java -version[/bash]
[text]java version “1.6.0_25”
Java(TM) SE Runtime Environment (build 1.6.0_25-b06)
Java HotSpot(TM) 64-Bit Server VM (build 20.0-b11, mixed mode)[/text]
Make sure your System Environment Variables are set as follows:
Note: Use Admin and stick to the same cmd window for both installs
[bash]set PATH=%WINDIR%;%WINDIR%\system32 #system paths to minimal
set TEMP=c:\temp
set TMP=c:\temp[/bash]

Note for PATH: might only need to change the entries in Environment Variables that have spaces, i.e.
[text]Program Files = progra~1 for 64bit OS
Program Files (x86) = progra~2 for 32bit OS[/text]

Install Weblogic Server from console:
[bash]”c:\Program Files\Java\jdk1.6.0_25\bin\java.exe” -jar wls1032_generic.jar[/bash]
Choose Middleware Home: leave default
Install type: Typical Install
JDK Selection: Should automatically find the 64bit JDK dir otherwise point to above JDK path
Choose product install dirs: leave default
Leave all other default selections and proceed.
No System Variables or Registry are entered.
Install Folders:
[text]c:\Oracle\Middleware\logs\
c:\Oracle\Middleware\modules\
c:\Oracle\Middleware\utils\
c:\Oracle\Middleware\wlserver_10.3\
c:\Oracle\Middleware\.home
c:\Oracle\Middleware\ocm.rsp
c:\Oracle\Middleware\registry.dat
c:\Oracle\Middleware\registry.xml

c:\bea\beahomelist

c:\ProgramData\Microsoft\Windows\Start Menu\Programs\Oracle WebLogic (BEAHOME 1)\WebLogic Server 11gR1\
c:\ProgramData\Microsoft\Windows\Start Menu\Programs\Oracle WebLogic (BEAHOME 1)\Online Documentation.lnk
c:\ProgramData\Microsoft\Windows\Start Menu\Programs\Oracle WebLogic (BEAHOME 1)\QuickStart.lnk
c:\ProgramData\Microsoft\Windows\Start Menu\Programs\Oracle WebLogic (BEAHOME 1)\Smart Update.lnk
c:\ProgramData\Microsoft\Windows\Start Menu\Programs\Oracle WebLogic (BEAHOME 1)\Uninstall Oracle WebLogic.lnk[/text]

Install Fusion Middleware:
Extract the 4 downloaded files ofm_pfrd_win_11.1.1.2.0_64_disk1/2/3 & 4 and run
[text]Disk1\setup.exe[/text]
Continue with setup as follows:
Select Install Type: Select Install and Configure
Create Domain: enter a password and give a domain name
Installation Location: leave default
Configure Components: deselect
[text]Portal, Discoverer, Web Cache and Clustered options[/text]
Select from Development Tools
[text]Forms and Reports[/text]
Application Level OID: deselect the “Use application Level Identity Store”
Proceed to complete install.

At this point you are offered to save a “Response File” so you can automate this installation on the same system
[bash]setup.exe -silent -response c:\forms_reports.rsp[/bash]

 

To test the forms (from Start Menu):

1. Oracle WebLogic > WebLogic 11gR1 > Tools > Node Manager

Note: If in some cases you can’t get your Node Manager running and get a error:
[text]<Fatal error in node manager server> java.lang.IllegalArgumentException: Invalid pid format[/text] then try removing any *.lck (“lock files”) within you Oracle Middleware dir.
some credits: forums.oracle.com

2. Oracle Classic Instance – [inst_name] > Forms Services > Start WebLogic Server – WLS_FORMS
3. Oracle Classic Instance – [inst_name] > Developer Tools > Forms Builder
4. Open any .frm type file to test
Note: * If you get an error ORA-12154 TNS:could not resolve the connect identifier… then your Forms Builder cannot find the path to tnsnames.ora or the file doesn’t have a proper DB connection string. Edit the default.env file
[text]\Oracle\Middleware\user_projects\domains\<mydomain>\config\fmwconfig\
servers\WLS_FORMS\applications\formsapp_11.1.1\config\default.env[/text]
and set TNS_ADMIN attibute to the path of your active tnsnames.ora file, i.e.
[text]TNS_ADMIN=c:\Users\<username>\oracle\instantclient\network\admin

* If you run a form and the url-address in the browser is other than something like:
[text]http://<pc-name>:9001/forms/frmservlet (port can be other/similar)[/text]
then check that you are running Forms Builder with Administrator rights

 

To Uninstall:

Stop the processes/services
[text]opmn.exe, odl_rotate_logs.exe, rwserver.exe, perl.exe, Apache.exe,
webcachea.exe, webcached.exe
OracleProsessManager_asinst_1[/text]

Warning: Use the following process at your own risk! If you have other Oracle applications
installed, you may cripple such installations. You better know what you’re doing in such case!

Delete all Oracle folders from C:\ and C:\Program Files.
Remove any ORACLE entries in System Variables (ORACLE_*,LD_LIBRARY_PATH).
Remove any ORACLE entries found in Registry
– HKCU: Software\Oracle
– HKLM: Software\Oracle
– HKLM: System\CurrentControlSet###\Services\OracleXXX  (OracleProcessManagerxxx)