Install Oracle Forms Reports 12214 With Weblogic 12c 122
Installing Oracle Forms and Reports 12.2.1.4.0 with WebLogic 12c (12.2.1.4) is a critical task for maintaining enterprise legacy applications on modern infrastructure. This version represents the terminal release for the 12c line, offering the most stable environment for Java 8-based middleware.
This guide provides a comprehensive walkthrough for a standard single-node installation on Windows or Linux. Prerequisites and System Requirements
Before running any installers, ensure your environment meets the minimum specifications:
Operating System: Windows Server 2016/2019 or Oracle Linux 7/8.
Memory: Minimum 16GB RAM (8GB for WebLogic/Forms, 4GB for the Database, 4GB for OS). Processor: 2.0 GHz+ multi-core CPU.
Database: A certified Oracle Database (12c, 18c, or 19c) to host the Repository Creation Utility (RCU) schemas. JDK: Oracle Java Development Kit 1.8.0_211 or higher. Step 1: Install Java Development Kit (JDK) WebLogic 12.2.1.4 requires a 64-bit JDK 8.
Download the latest JDK 8 (e.g., jdk-8u301-windows-x64.exe).
Install it to a path without spaces (e.g., C:\Java\jdk1.8.0).
Set the JAVA_HOME environment variable and add the bin directory to your PATH. Step 2: Install Oracle WebLogic Infrastructure 12.2.1.4
Note that the standard WebLogic Server installer is not sufficient; you must use the Fusion Middleware Infrastructure installer.
Launch the installer via command line:java -jar fmw_12.2.1.4.0_infrastructure.jar
Inventory Directory: Define your central inventory location.
Installation Type: Select "Fusion Middleware Infrastructure".
Installation Location: Define your ORACLE_HOME (e.g., C:\Oracle\Middleware\Oracle_Home). Follow the prompts to complete the installation. Step 3: Install Oracle Forms and Reports 12.2.1.4
Download the two-disk zip files for Forms and Reports 12.2.1.4.
Extract them and run the setup.exe (Windows) or ./runInstaller (Linux). install oracle forms reports 12214 with weblogic 12c 122
Installation Location: Use the same ORACLE_HOME created in the WebLogic step. Installation Type: Choose "Forms and Reports Installation".
The installer will perform a prerequisite check; ensure all items pass before clicking "Install". Step 4: Repository Creation Utility (RCU)
Oracle Forms and Reports requires several database schemas to manage metadata and security.
Navigate to ORACLE_HOME\oracle_common\bin and run rcu.bat (or ./rcu).
Create Repository: Select "System Load and Product Creation".
Database Connection: Provide your DBA credentials (Host, Port, Service Name, and SYS password). Select Components: AS Common Schemas (Metadata Services, Audit Services, etc.) Oracle Forms Oracle Reports (If required)
Set a password for all schemas (using the same password for all simplifies development). Complete the wizard to create the tablespaces and users. Step 5: Configuring the Domain
Now, you must link the installed software with the RCU schemas via a WebLogic Domain.
Run ORACLE_HOME\oracle_common\common\bin\config.cmd (or .sh).
Create Domain: Choose a new domain path (e.g., C:\Oracle\Middleware\Domains\fr_domain). Templates: Select: Oracle Forms [forms] Oracle Reports [reports] Oracle Enterprise Manager [em] Application Location: Keep default. Administrator Account: Define your weblogic user password. Domain Mode: Select "Production" for better security.
Database Configuration: Input the RCU schema credentials created in Step 4.
Advanced Configuration: Select "Topology" and "System Components".
Server Assignments: Ensure WLS_FORMS and WLS_REPORTS are assigned to the machine. Click Create. Step 6: Post-Installation Tasks Start the Servers Start the components in this specific order: Node Manager: startNodeManager.cmd Admin Server: startWebLogic.cmd
Managed Servers: Via the WebLogic Console (localhost:7001/console) or script. Create Reports Tools (Specific to 12.2.1.4)
Reports 12c requires an extra manual step to create the system component:ORACLE_HOME/oracle_common/common/bin/wlst.cmdConnect to the AdminServer and run:createReportsToolsInstance(instanceName='reprots_tools_1',machine='AdminServerMachine') Verification To verify the installation, access the following URLs: WebLogic Console: http://hostname:7001/console Fusion Middleware Control (EM): http://hostname:7001/em Forms Servlet: http://hostname:9001/forms/frmservlet Reports Server: http://hostname:9002/reports/rwservlet/help Installing Oracle Forms and Reports 12
💡 Pro Tip: Always disable the browser’s popup blocker when testing Forms, as the Java Web Start or FSAL (Form Standalone Launcher) may be triggered via a new window.
To help you get the environment up and running, do you need: The specific download links for these versions?
A guide on configuring FSAL (Forms Standalone Launcher) to avoid browser plugin issues? Linux-specific shell commands for the installation?
Step-by-Step Guide: Installing Oracle Forms and Reports 12.2.1.4 with WebLogic 12c
Installing Oracle Forms and Reports 12.2.1.4 is a complex process that requires specific software versions to work together correctly. This guide provides a high-level roadmap for a successful installation on a production-ready environment. 1. Pre-Installation Prerequisites
Before starting, ensure your environment meets the following minimum requirements: Operating System : Windows (64-bit), Linux, or UNIX.
: Minimum 4 GB physical RAM; 8 GB available memory is recommended. Java JDK 8 Update 211 or higher (64-bit).
: A certified Oracle Database (Standard or Enterprise Edition) version 12.2.0.4 or newer is required to host the repository schemas. 2. Download Required Software Obtain the following distributions from the Oracle Software Delivery Cloud Oracle WebLogic Server Installers Oracle Fusion Middleware Infrastructure 12.2.1.4.0 : This is critical. Do use the standalone WebLogic Server installer. Oracle Forms and Reports 12.2.1.4.0 : The specific version for your platform. 3. Installation Sequence
Follow these steps in exact order to avoid compatibility issues: Installing and Configuring Oracle Forms
Installing Oracle Forms and Reports 12.2.1.4 on a WebLogic 12c (12.2.1.4) Infrastructure is a multi-stage process involving precise version matching and sequential configuration Prerequisites and Downloads
Before beginning, ensure your system meets the basic hardware and operating system requirements. Oracle Help Center 64-bit Java 8 (JDK) 8u151 or newer (8u321 is recommended). WebLogic Infrastructure : Download the Oracle Fusion Middleware Infrastructure 12.2.1.4.0
(standard WebLogic Server is not sufficient; the Infrastructure distribution includes JRF components). Forms and Reports : Download the Oracle Forms and Reports 12.2.1.4.0 installer packages for your platform. Oracle Forums Installation Steps Follow this specific order to ensure a stable environment: Installing and Configuring Oracle Forms
Installing Oracle Forms and Reports 12.2.1.4 with WebLogic Server 12.2.1.4 involves a specific sequence of software installations and domain configuration steps. This process requires a certified 64-bit JDK and an Oracle Database to host the necessary metadata repository. 1. Prerequisites and Downloads
Before starting, ensure your system meets the minimum memory (at least 4GB RAM, 8GB recommended) and disk space (approx. 6.5GB for full deployment).
JDK: Install a certified 64-bit Java Development Kit, such as JDK 8u211 or higher. Step 5
WebLogic Infrastructure: Download the Fusion Middleware Infrastructure 12.2.1.4 installer, which includes WebLogic Server and JRF components.
Forms and Reports: Download the Oracle Forms and Reports 12.2.1.4 distribution.
Database: Ensure an Oracle Database (12.2.0.4 or newer) is accessible to host the repository. 2. Software Installation Sequence
Install the software into the same Oracle Home directory in the following order:
Install FMW Infrastructure: Launch the infrastructure installer using your JDK:java -jar fmw_12.2.1.4.0_infrastructure.jar.
Install Forms and Reports: Run the setup_fmw_12.2.1.4.0_fr_win64.exe (Windows) or .bin (Linux) installer.
Select Forms and Reports Deployment as the installation type.
Point to the same Oracle Home used for the Infrastructure installation. 3. Repository and Domain Configuration
Once the software is installed, you must configure the environment: System Requirements and Specifications - Oracle Help Center
8.2 Reports Configuration (rwserver.conf)
Location: /u01/oracle/middleware/oracle_fr_home/reports/conf/
rwserver.rwbuilder.server=localhost:9002
rwserver.rwserver.server=localhost:9002
Step 5.1 – Domain Creation Mode
Select "Create a new domain"
Step 5.7 – JDBC Component Schema Details
- mds-owsm (Metadata Services): Schema
DEV_STB - opss-audit (Audit): Schema
DEV_IAU - Test connections – all should succeed.
Test 2: Reports Servlet
http://your-server:9002/reports/rwservlet
You should see: "Oracle Reports Servlet — version 12.2.1.4"
Step 8: Uninstall / Reinstall
To uninstall cleanly:
cd $ORACLE_HOME/oui/bin
./deinstall.sh -silent -removeAllFiles
rm -rf $DOMAIN_HOME
rm -rf /u01/app/oracle/fmw12214
rm -rf /u01/app/oracle/inventory
Then reinstall from Step 2.
7. Start WebLogic Servers
1. Pre-install checklist (practical planning)
- Verify software versions and certification matrix: Forms & Reports 12.2.1.4 requires WebLogic 12.2.1.x family and JDK 8; confirm exact patch set for OS.
- Hardware sizing: allocate CPU, memory, disk. Minimum for dev/test: 4 vCPU, 8–16 GB RAM; production typically 8+ vCPU, 16–64 GB RAM depending on user load and report complexity.
- Disk layout: separate partitions for Oracle Middleware Home, domain home, ORACLE_BASE (apps), and logs. Ensure adequate disk space for reports temp files and FRCache.
- OS user: create dedicated oracle (or fmw) user with proper ulimits (open files, processes) — e.g., nofile 65536, nproc 16384.
- Networking: stable hostname (FQDN), proper /etc/hosts entry, DNS resolution. Avoid changing hostnames later.
- Ports: plan ports for AdminServer (default 7001), Managed Servers (e.g., 9001, 9002), Forms port (default 9001), Reports port (also via managed server or standalone?), Node Manager, and web server (80/443) if fronting. Avoid conflicts.
- DB connectivity: if Forms use an Oracle Database (for custom apps), ensure JDBC connections and drivers (JDBC thin with correct ojdbc jar); keep credentials and connect strings ready.
- Backups: snapshot or backup plan before patching. Keep installation media stored securely.
- Download required installers:
- WebLogic Server 12.2.1.x Generic Installer (or install via Fusion Middleware Infrastructure).
- Oracle Forms and Reports 12.2.1.4 installer (FMw Infrastructure + Forms & Reports).
- JDK 8 (update matching certification).
- Environment variables: ORACLE_BASE, ORACLE_HOME for database if needed, FMW_HOME, JAVA_HOME.
8. Configure HTTP front-end and SSL
- Web listener options:
- Use Oracle HTTP Server (OHS) with mod_wl_ohs to proxy requests to WebLogic, or use a reverse proxy such as Apache httpd or Nginx.
- Configure mod_wl_ohs or mod_proxy_balancer for load balancing managed servers.
- SSL:
- Generate certificates and configure keystore and identity keystore for AdminServer/Managed Servers.
- Enable HTTPS in WebLogic Console (set Listen Port Enabled in SSL and configure private key).
- Bind webserver (OHS/Apache/Nginx) to SSL and forward to WebLogic via secure channels or set-up SSL passthrough.
- URL rewriting:
- Map friendly URLs (e.g., /forms, /reports) and configure rewrite rules to pass correct context and query strings.
Practical tip: terminate SSL at the webserver or load balancer to reduce WebLogic overhead; ensure traffic to WebLogic is secured if network is untrusted.