Configure Oracle Forms & Reports 12c on WebLogic Server

How to Configure Oracle Forms and Reports 12c on WebLogic Server 12.2.1.4.0

After installing Oracle Database 12c, Java JDK 8, WebLogic Server Infrastructure, and Oracle Forms & Reports 12c, the next step is configuring the complete Oracle Forms and Reports environment.

In this practical tutorial, we'll configure Oracle Forms and Reports 12.2.1.4.0 on Windows using Oracle WebLogic Server.

We'll create the required database repository schemas using Repository Creation Utility (RCU), create a new WebLogic domain, configure Forms and Reports templates, add a managed server, configure Oracle HTTP Server (OHS), and set the required Windows environment variables.

By the end of this tutorial, you'll have a configured WebLogic domain ready for the next stage of starting and testing Oracle Forms and Reports services.

What You'll Learn in This Tutorial

We'll cover the following configuration steps:

• Install Notepad++ for editing configuration files.
• Configure the ORACLE_HOME system environment variable.
• Run Repository Creation Utility (RCU).
• Create the required Oracle middleware repository schemas.
• Create a new WebLogic domain.
• Configure Oracle Forms and Reports templates.
• Configure the WebLogic administrator account.
• Configure database connectivity.
• Add and configure a managed server.
• Configure Node Manager credentials.
• Add Oracle HTTP Server (OHS).
• Assign servers and system components to machines.
• Configure the DOMAIN_HOME environment variable.

Prerequisites

Before starting this configuration, make sure you have completed the previous installation tutorial.

Required software:

Software	Version
Oracle Database	12c
Java JDK	JDK 8
WebLogic Server Infrastructure	12.2.1.4.0
Oracle Forms & Reports	12.2.1.4.0
Microsoft Visual C++	2012 Redistributable (x64)
Notepad++	Latest compatible version

You should also have a working Oracle Database instance with the required listener and service configured.

Step 1: Install Notepad++

First, download and install Notepad++.

Notepad++ is a lightweight text editor that will be useful when editing Oracle configuration files, environment settings, and other configuration scripts.

Official Website:

https://notepad-plus-plus.org/

Complete the installation using the default settings.

Step 2: Configure ORACLE_HOME Environment Variable

Before running RCU, configure the ORACLE_HOME system environment variable.

Open Windows Environment Variables:

1. Search for Environment Variables in Windows.
2. Select Edit the system environment variables.
3. Click Environment Variables.
4. Under System Variables, click New.
5. Enter the following details.

Variable Name:

ORACLE_HOME

Variable Value:

C:\Oracle\Middleware\Oracle_Home

Click OK to save the changes.

You can verify the variable using Command Prompt:

echo %ORACLE_HOME%

It should display your Oracle Home directory.

For the remaining steps, we'll use %ORACLE_HOME% instead of repeatedly typing the full installation path.

Step 3: Run Repository Creation Utility (RCU)

Repository Creation Utility (RCU) is used to create the database schemas required by Oracle Fusion Middleware components.

These schemas store the configuration and metadata required by WebLogic, Oracle Forms, and related middleware services.

Navigate to the following directory:

%ORACLE_HOME%\oracle_common\bin

Locate:

rcu.bat

Right-click the file and select Run as administrator.

The Repository Creation Utility wizard will open.

3.1 Create Repository

On the Welcome screen, click Next.

On the Create Repository screen:

• Select Create Repository.
• Keep the default System Load and Product Load options.

Proceed to the next screen.

3.2 Configure Database Connection Details

Enter your Oracle Database connection information.

Use the following example configuration:

Field	Value
Host Name	localhost
Port	1521
Service Name	orcl
Username	SYS
Password	Your SYS password (I used "abc123")
Role	SYSDBA

Click Next.

RCU will check the database connection and required prerequisites.

Wait for the prerequisite checks to complete successfully.

Note: The service name orcl must match your actual Oracle Database service. If your database uses another service name, enter that instead.

3.3 Select Repository Components

On the Select Components screen:

1. Select Create a new prefix if required.
2. Keep the default prefix name:

DEV

1. Select the required components for your Forms and Reports environment.

In this practical demonstration, we'll select all available components and keep the default DEV prefix.

RCU will automatically select dependent components where necessary.

Important: Selecting every available component is not necessary for every Oracle installation. For a production environment, select only the components required by your intended products and configuration.

Click Next and allow RCU to perform its prerequisite checks.

3.4 Configure Schema Passwords

On the Schema Passwords screen, configure the passwords for the repository schemas.

For this demonstration, we'll use the same password for all schemas:

abcd1234

Select the option to use the same password for all schemas, enter the password, and confirm it.

Click Next and continue through the remaining screens.

Review the configuration summary and click Create to start creating the repository.

Wait until RCU completes the schema creation process successfully.

Security note: The passwords shown in this tutorial are demonstration values only. Use strong, unique passwords in real environments.

Step 4: Open WebLogic Configuration Wizard

After successfully creating the repository schemas, it's time to configure WebLogic Server.

Navigate to:

%ORACLE_HOME%\oracle_common\common\bin

Locate:

config.cmd

Right-click and select Run as administrator.

The Oracle Fusion Middleware Configuration Wizard will open.

Select:

Create a new domain

For the domain location, keep the default domain name:

base_domain

The default domain location will be similar to:

%ORACLE_HOME%\user_projects\domains\base_domain

Click Next.

Step 5: Select Oracle Forms and Reports Templates

On the Templates screen, select:

Include all selected templates

Now configure the following templates.

No.	Template	Selection
1	Oracle Forms Application Deployment Service (FADS) [forms]	Select
2	Oracle Forms [forms]	Automatically selected
3	Oracle Enterprise Manager [em]	Automatically selected
4	Oracle WSM Policy Manager [oracle_common]	Automatically selected
5	Oracle JRF [oracle_common]	Automatically selected
6	Oracle Coherence Cluster Extension [wlserver]	Automatically selected
7	Oracle Reports Application [reports]	Select
8	Oracle Reports Tools [ReportsToolsComponent]	Automatically selected
9	Oracle HTTP Server (Collocated) [ohs]	Select
10	Oracle Reports Server [ReportsServerComponent]	Select
11	Oracle Reports Bridge [ReportsBridgeComponent]	Select

Some templates are automatically selected when their parent templates are selected.

For example:

• Selecting FADS automatically selects its required Forms dependencies.
• Selecting Oracle Reports Application automatically selects Oracle Reports Tools.

For this practical configuration, we'll also select Oracle HTTP Server, Oracle Reports Server, and Oracle Reports Bridge.

Click Next to continue.

Step 6: Configure Administrator Account

On the Administrator Account screen, configure your WebLogic administrator credentials.

For this demonstration:

Field	Value
Name	weblogic
Password	Your chosen password
Confirm Password	Same password

The example password used in the video is:

weblogic1

Click Next.

This account will be used to access the WebLogic Administration Console and manage your domain.

Step 7: Configure Domain Mode and JDK

On the Domain Mode and JDK screen, select the following options:

Setting	Value
Domain Mode	Production
JDK	Previously installed JDK 8

Make sure the selected JDK is the compatible JDK installation used for your Oracle environment.

Click Next.

Step 8: Configure Database Connection

On the Database Configuration Type screen, enter the database information used when creating the RCU repository.

Use the following example settings:

Field	Value
Hostname	localhost
DBMS/Service	orcl
Port	1521
Schema Owner	DEV_STB
Schema Password	Same password configured in RCU (I used ("abcd1234")

Example schema password:

abcd1234

The DEV_STB schema belongs to the DEV repository prefix created earlier.

Click Next.

The Configuration Wizard will test the database connections and repository schemas.

Wait for all tests to complete successfully.

If the tests pass, click Next.

Step 9: Select Advanced Configuration

On the Advanced Configuration screen, select the following options:

1. Topology
2. System Components

These options allow us to configure additional servers, machines, and system components.

Click Next.

Step 10: Configure Managed Servers

On the Managed Servers screen, click the + Add button to create a new managed server.

Rename the newly created server:

server1

Under Server Groups, select the appropriate server group for your Forms deployment.

For the Forms managed server, verify that the FORMS-MAN-SVR server group is selected. Select additional groups only if they are required by your chosen deployment templates.

Click Next.

Step 11: Configure Node Manager Credentials

On the Node Manager screen, configure the Node Manager credentials.

For this practical example:

Field	Value
Username	weblogic
Password	Your chosen password
Confirm Password	Same password

Example:

Username: weblogic
Password: weblogic1

Click Next to continue.

Step 12: Assign Servers to Machines

Continue through the configuration wizard until you reach the Assign Servers to Machines screen.

On this screen:

1. Select AdminServer from the Server column on the left.
2. Select AdminServerMachine.
3. Click the right-arrow button to assign the server to the machine.

Verify that AdminServer is assigned correctly.

Click Next.

Step 13: Configure System Components

Continue until you reach the System Components screen.

You should see the existing Forms system component:

forms1

Now click the + Add button to create another system component.

Rename the newly created component:

ohs1

Next, select its Component Type:

OHS

This adds an Oracle HTTP Server system component to your domain.

Click Next.

Step 14: Configure Oracle HTTP Server

On the OHS Server screen, configure the Listen Address.

For this demonstration, enter:

localhost

You can also leave the Listen Address at its default setting if appropriate for your environment.

Click Next.

Step 15: Assign System Components to Machines

On the Assign System Components to Machines screen:

1. Select ohs1 from the System Components column on the left.
2. Select AdminServerMachine.
3. Click the right-arrow button to assign ohs1 to the machine.

Verify that the OHS component is assigned to the correct machine.

Click Next.

Step 16: Create the WebLogic Domain

Continue through the remaining wizard screens until you reach the Configuration Summary.

Review all your selected settings, including:

• Domain configuration
• Administrator credentials
• Database repository connection
• Managed server configuration
• Node Manager settings
• Forms system component
• Oracle HTTP Server component

Once everything looks correct, click Create.

The Configuration Wizard will begin creating your WebLogic domain.

Wait for the configuration process to finish successfully.

When complete, you should see the configuration success screen.

Your Oracle Forms and Reports WebLogic domain has now been created.

Step 17: Configure DOMAIN_HOME Environment Variable

After successfully creating the domain, configure another Windows system environment variable.

Open Windows Environment Variables.

Under System Variables, click New.

Enter:

Variable Name:

DOMAIN_HOME

Variable Value:

C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain

Click OK to save the changes.

You can verify the variable using Command Prompt:

echo %DOMAIN_HOME%

It should display the complete path of your newly created WebLogic domain.

Final Configuration Checklist

After completing all the steps, your Oracle Forms and Reports environment should have the following configuration:

Component	Configuration
Oracle Database	Oracle 12c
Java	JDK 8
Oracle Home	C:\Oracle\Middleware\Oracle_Home
Repository Prefix	DEV
Repository Schema	DEV_STB
WebLogic Domain	base_domain
Domain Mode	Production
Administrator	weblogic
Managed Server	server1
Forms Component	forms1
OHS Component	ohs1
OHS Component Type	OHS
Domain Home	...\domains\base_domain

Congratulations! You have completed the Oracle Forms and Reports 12c configuration process.

Important Notes Before Starting the Servers

Creating the WebLogic domain does not automatically mean that all services are running and ready for use.

The next stage is to start and verify the required services, including Node Manager, WebLogic Administration Server, Forms Managed Server, Reports Server, and Oracle HTTP Server.

We'll cover these steps in the next practical tutorial.

Watch the Complete Video Tutorial

Follow the complete Urdu video tutorial to see the configuration process practically, from creating the RCU repository to successfully creating the WebLogic domain.

Follow each step carefully and use the same Oracle Home and database settings throughout the configuration.

Frequently Asked Questions

1. What is RCU in Oracle WebLogic?

RCU stands for Repository Creation Utility. It creates the database schemas required by Oracle Fusion Middleware products, including Oracle Forms and Reports.

2. What is the DEV_STB schema?

DEV_STB is the Service Table schema associated with the repository prefix DEV. The WebLogic Configuration Wizard uses it to retrieve repository configuration information.

3. What is base_domain?

base_domain is the default WebLogic domain name in this tutorial. A WebLogic domain provides a logical environment for managing servers, applications, and system components.

4. What is a Managed Server?

A Managed Server is a WebLogic server instance that runs applications and services independently of the Administration Server. In our example, we create a managed server named server1.

5. What is Oracle HTTP Server (OHS)?

Oracle HTTP Server is a web server component that can work with Oracle Forms and Reports to handle HTTP requests and route traffic to the appropriate application services.

6. What is DOMAIN_HOME?

DOMAIN_HOME is the directory where the WebLogic domain configuration and related files are stored. In our tutorial, it points to the base_domain directory.

Conclusion

Configuring Oracle Forms and Reports 12c involves several important steps, but following them in the correct order makes the process easier.

In this tutorial, we created the required database repository using RCU, configured the WebLogic domain, selected Oracle Forms and Reports templates, added a managed server, configured Node Manager, added Oracle HTTP Server, and assigned the required system components to the machine.

Your WebLogic domain is now created, and the environment is ready for the next stage: starting and testing Oracle Forms and Reports services.

If you found this tutorial helpful, don't forget to like, share, and subscribe to Complex To Easy for more practical Oracle, database, and software development tutorials.

Complex To Easy – Everything Will Be Just Easy!

---

Helpful Resources

• Complex To Easy: https://complextoeasy.com
• YouTube Channel: https://youtube.com/@ComplexToEasy
• Oracle Software Delivery Cloud: https://edelivery.oracle.com/
• Oracle Forms & Reports 12.2.1.4 Documentation: https://docs.oracle.com/en/middleware/developer-tools/forms/12.2.1.4/install-fnr/
• Oracle Database Documentation: https://docs.oracle.com/en/database/

Blog Tags

Oracle Forms and Reports Configuration, Oracle WebLogic Configuration, Oracle Forms 12c, Oracle Reports 12c, WebLogic Server 12.2.1.4.0, Oracle Fusion Middleware, Oracle RCU, Repository Creation Utility, Oracle Database 12c, WebLogic Domain Creation, Oracle Forms Installation, Oracle Reports Installation, Forms and Reports Deployment, DEV_STB Schema, Oracle HTTP Server, OHS Configuration, WebLogic Managed Server, Node Manager Configuration, DOMAIN_HOME, ORACLE_HOME, Oracle DBA Tutorial, Oracle Middleware Tutorial, Oracle Forms Urdu Tutorial, Complex To Easy