Author Photo

Being a Linux Enthusiast and a Fan of Open Source Software, I created Ahmer’s SysAdmin Recipes blog to share my experiences with other System Administrators. The curiosity doesn’t let me stop; therefore, I am constantly trying to learn new software tools and techniques. Whereas I also have the passion and the patience to teach the others.

I am always ready to accept new challenges and wish to explore the areas, that I haven’t worked on. Please give me your feedback and help me improve this blog.

Tuesday, 1 January 2019

Configure Oracle Forms and Reports 12c on CentOS 7

configure-Oracle-Forms-and-Reports-12c-on-CentOSThis post is the sequel of our previous post Install Oracle Forms and Reports 12c on CentOS 7. We have successfully installed Oracle Forms and Reports 12c on CentOS 7 server. Now it’s time post installation configurations of Oracle Forms and Reports 12c.

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

 

System Specification:

We are using the same CentOS 7 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 using Repository Creation Utility (RCU):

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

Run Repository Configuration Utility (RCU) as follows:

[oracle@appserver-04 ~]$ $MW_HOME/oracle_common/bin/rcu RCU Logfile: /tmp/RCU2018-12-31_14-23_1336016982/logs/rcu.log

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

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.

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

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:

[oracle@appserver-04 ~]$ $MW_HOME/oracle_common/common/bin/config.sh

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

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

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.

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

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

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

Check JDBC connectivity and Click on Next.

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

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

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

Review configuration summary and click on Create.

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

Configuration is in progress.

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

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.

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

[root@appserver-04 ~]# firewall-cmd --permanent --add-port=7001/tcp success [root@appserver-04 ~]# firewall-cmd --permanent --add-port=5556/tcp success [root@appserver-04 ~]# firewall-cmd --reload success

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

[oracle@appserver-04 ~]$ mkdir -p $DOMAIN_HOME/servers/AdminServer/security/ [oracle@appserver-04 ~]$ echo "username=weblogic" > $DOMAIN_HOME/servers/AdminServer/security/boot.properties [oracle@appserver-04 ~]$ echo "password=weblogic123" >> $DOMAIN_HOME/servers/AdminServer/security/boot.properties

Start Node Manager.

[oracle@appserver-04 ~]$ $DOMAIN_HOME/bin/startNodeManager.sh &

Start Weblogic Server.

[oracle@appserver-04 ~]$ $DOMAIN_HOME/bin/startWebLogic.sh &

Open URL http://192.168.116.130: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.

Configure Oracle Forms and Reports 12c on CentOS 7


YOU MIGHT ALSO LIKE:

No comments:

Post a Comment