Configure Oracle Forms and Reports 12c on CentOS 7

Share on Social Media

In this tutorial, you will learn, how to configure Oracle Forms and Reports 12c on CentOS 7. #centlinux #linux #oracle

What is Oracle Forms and Reports 12c? :

Oracle Forms and Reports 12c is a component of the Oracle Fusion Middleware, a comprehensive suite of tools and technologies for building, deploying, and managing enterprise applications. Oracle Forms and Reports provides a development and deployment framework for creating database-driven applications with a focus on building user interfaces and generating reports.

Oracle Forms is a graphical user interface (GUI) development tool that enables developers to design and create forms-based applications. These applications typically interact with Oracle databases, allowing users to input, modify, and retrieve data in a structured manner. Oracle Forms simplifies the process of creating data entry forms with features like drag-and-drop functionality and a declarative programming model.

Oracle Reports, on the other hand, is a tool for designing and generating reports from various data sources, with a particular emphasis on Oracle databases. It allows developers to create sophisticated, formatted reports that can be output in various formats, such as PDF or HTML.

The “12c” in Oracle Forms and Reports 12c refers to the version number, and it indicates that it is part of the Oracle Cloud architecture. The “c” stands for “cloud,” highlighting Oracle’s focus on cloud-based solutions and services.

Overall, Oracle Forms and Reports 12c is used by organizations to develop and deploy database-centric applications and reports, providing a robust and scalable solution for managing enterprise data.

In this article, we will create a Repository for Oracle Forms and Reports 12c in a Remote Oracle Database. Then, we will use Configuration Wizard to perform necessary configurations.

System Specification:

We are using the same Linux server that we have used in Install Oracle Forms and Reports 12c on CentOS 7.

  • CPU – 2.4 Ghz (4 cores)
  • Memory – 4 GB
  • Storage – 60 GB
  • Operating System – CentOS 7.6
  • Java Development Kit (JDK) – 8u192
  • Oracle Weblogic Infrastructure – 12.2.1.3
  • Oracle Forms and Reports – 12.2.1.3

Create Database Schemas with RCU:

Connect with appserver-04.example.com using ssh as oracle user.

Run Repository Configuration Utility (RCU) as follows:

$ $MW_HOME/oracle_common/bin/rcu

        RCU Logfile: /tmp/RCU2018-12-31_14-23_1336016982/logs/rcu.log
welcome

Click on Next.

rcu-configure-oracle-forms-reports-12c-02

Select Create Repository option. Since, we have DBA privileges on our Repository database, therefore, we selected System Load and Product Load option.

Click on Next.

rcu-configure-oracle-forms-reports-12c-03

Provide database connection details here and click on Next.

rcu-configure-oracle-forms-reports-12c-04

RCU performs prerequisite checks. Click on OK when done.

rcu-configure-oracle-forms-reports-12c-05

Select required components to create their respective schemas and click on Next.

rcu-configure-oracle-forms-reports-12c-06

RCU perform prerequisite checks for the required components. Click on OK.

rcu-configure-oracle-forms-reports-12c-07

Define password for the Repository schemas here and click on Next.

rcu-configure-oracle-forms-reports-12c-08

Define Tablespace mappings and click on Next.

rcu-configure-oracle-forms-reports-12c-09

Click on OK.

repository creation utility

RCU is creating tablespaces. Click on OK when done.

rcu-configure-oracle-forms-reports-12c-11

Review the summary of the configurations and click on Create.

rcu-configure-oracle-forms-reports-12c-11a

Repository creation is in progress.

rcu-configure-oracle-forms-reports-12c-12

Check the completion summary and installation log.

Click on Close.

RCU has successfully created the Repository.

Configure Oracle Forms and Reports 12c:

Connect with appserver-04.example.com using ssh as oracle user.

Run Configuration Wizard as follows:

$ $MW_HOME/oracle_common/common/bin/config.sh
configure-oracle-forms-and-reports-12c-01
create a new domain

Select Create a new domain and provide Domain location.

Click on Next.

configure-oracle-forms-and-reports-12c-03

Select the required product templates and click on Next.

configure-oracle-forms-and-reports-12c-04

Provide application location and click on Next.

configure-oracle-forms-and-reports-12c-05

Define an Administrator user here. Click on Next.

configure-oracle-forms-and-reports-12c-06

Select Production domain mode and a certified JDK. Click on Next.

configure-oracle-forms-and-reports-12c-07

Provide database connection details here and click on Next.

components data source

Edit database connection details for individual components. Click on Next.

configure-oracle-forms-and-reports-12c-09

Check JDBC connectivity and Click on Next.

advanced configuration

Select a component to performed Advance Configuration relevant to that component. Click on Next.

configuration summary

Review configuration summary and click on Create.

configure-oracle-forms-and-reports-12c-12
configure-oracle-forms-and-reports-12c-13

Configuration is in progress.

end of configuration

Oracle Forms and Reports 12c has been configured. Note down the URL to access the Admin console from browser.

Click on Finish to exit Configuration Manager.

Configure Linux Firewall:

Connect as root user and allow Weblogic Server and Node Manager ports 7001/tcp and 5556/tcp respectively in Linux firewall.

# firewall-cmd --permanent --add-port=7001/tcp
success
# firewall-cmd --permanent --add-port=5556/tcp
success
# firewall-cmd --reload
success

Configure Oracle Fusion Startup:

Create boot.properties credential file for easier startup of weblogic server.

$ mkdir -p $DOMAIN_HOME/servers/AdminServer/security/
$ echo "username=weblogic" > $DOMAIN_HOME/servers/AdminServer/security/boot.properties
$ echo "password=weblogic123" >> $DOMAIN_HOME/servers/AdminServer/security/boot.properties

Start Node Manager.

$ $DOMAIN_HOME/bin/startNodeManager.sh &

Start Weblogic Server.

$ $DOMAIN_HOME/bin/startWebLogic.sh &

Open URL http://appserver-04.example.com:7001/em in a browser.

oracle-weblogic-12c-admin-console-login

We have successfully created a Repository using RCU and configure Oracle Forms and Reports 12c using Configuration Wizard.

Conclusion:

In this tutorial, you have learned, how to configure Oracle Forms and Reports 12c on CentOS 7.

Scroll to Top