ORACLE FORMS AND REPORTS 12C INSTALLATION DOCUMENT LINUX

SOFTWARE REQUIREMENT:

1.Java(jdk-8u65-windows-x64.exe)

2.Oracle Weblogic Server 12C(fmw_12.2.1.0.0_infrastructure_Disk1_1of1.zip)

3.Oracle Forms and Reports 12c (12.2.1.0)(fmw_12.2.1.0.0_fr_linux64_Disk1_1of1.zip).

Setup

The following actions should be performed by the "root" user.

Make sure the "/etc/hosts" file contains correct entries for both the "localhost" and real host names.

127.0.0.1      localhostlocalhost.localdomain localhost4 localhost4.localdomain4

Create a new group and user.

groupadd -g 54321 oinstall

useradd -u 54321 -g oinstall oracle

passwd oracle

Create the directories in which the Oracle software will be installed.

mkdir -p /u02/app/oracle/product/12.2.1

mkdir -p /u02/app/oracle/config/domains

mkdir -p /u02/app/oracle/config/applications

chown -R applfrw:oinstall /u02

chmod -R 775 /u02/

Append the following entries into the "/home/applfrw/.bash_profile" file.

# Adjust paths as required.

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.2.1

export MW_HOME=$ORACLE_HOME

export WLS_HOME=$MW_HOME/wlserver

export WL_HOME=$WLS_HOME

export DOMAIN_BASE=$ORACLE_BASE/config/domains

export DOMAIN_HOME=$DOMAIN_BASE/mydomain

export JAVA_HOME=/u01/app/oracle/jdk1.8.0_65

export PATH=$JAVA_HOME/bin:$PATH

Install the JDK.

# su - applfrw

$ cp/home/applfrw/jdk-8u91-linux-x64.tar.gz $ORACLE_BASE

$ cd $ORACLE_BASE

$ tar -zxvf jdk-8u91-linux-x64.tar.gz

Oracle Weblogic Server 12c Installation:

Unzip the software fmw_12.2.1.0.0_infrastructure_Disk1_1of1.zip.We will get the following executable file fmw_12.2.1.0.0_infrastructure.jar.

Below I have attached the Screenshots of Weblogic installation.

$ unzip fmw_12.2.1.0.0_infrastructure_Disk1_1of1.zip

$ $JAVA_HOME/bin/java -jar fmw_12.2.1.0.0_infrastructure.jar

The Auto Updates page appears. This page enables you to choose to automatically receive software updates for your components from Oracle Corporation. make your choices, then click Next.

The Installation Location page appears. Specify the Oracle home location into which you want to install the product(s). Click Next.

Accept the "Fusion Middleware Infrastructure" option by clicking the "Next" button.

Wait for the prerequisite checks to complete. If there are failures, correct them and rerun the checks. If there are no failures, click the "Next" button.

Either enter your support details, or uncheck the security updates checkbox. Click the "Next" button. If you chose not to receive security updates, click the "Yes" button on the warning dialog.

click the "Install" button.

Wait for the installation to complete, then click the "Next" button.

On the installation complete screen, click the "Finish" button to launch the Configuration Wizard.

After the Weblogic Installation we have to install Forms and Reports 12C

FORMS and REPORTS INSTALLATION

Unzip the forms and reports software

unzipfmw_12.2.1.0.0_fr_linux64_Disk1_1of1.zip

./ fmw_12.2.1.0.0_fr_linux64.bin

Welcome screen will appears

Skip Auto Update and click Next.

Enter weblogic server (Middleware) home path where you have installed it. Click Next button.

Select Forms and Reports Deployment and click Next button.

Click Next button on prerequisite check.

Click Install on Installation summary page.

Installation progress is completed press Next.

Installation completed press Finish button.

Your Installation process is completed. But there are few more steps are required. It is not like 11g forms installation where domain are automatically created during installation.

In 12c it is different. You have to create Repository and domain manually. Now let us see how to create this Repository and domain.

Repository & Domain Creation

Let us start Repository Creation Utility (RCU). Your rcu.sh file is located at below location (Check location where you installed the forms and reports).

My location is

cd /u02/app/oracle/product/12.2.1/oracle_common/bin/

./rcu

Or If want to drop old repository, run the below command

rcu [-silent | -interactive] -dropRepository

Click Next on RCU Welcome page.

On create repository page option for [Create Repository and System Load and Product Load] should be selected. Click Next.

Enter database details and click next.

Prerequisite check should be ok.

In Select Components window enter prefix and click on option Oracle Platform Security Services all other components are automatically selected for Audit Services, Autid Services Append and Audit Services viewer Click Next.

All Components prerequisites should be ok then press ok button

Select Use same passwords for all schemas and provide the password and click Next button.

If you need to change the tablespace detail then click Manage Tablespaces and provide the details else Click Next.

Click OK to continue.

Tablespaces Created Click OK to continue.

Start creating RCU by clicking Create button.

RCU creation completed click Close.

Create Domain

After completing RCU you will need to create the domain by executing the config.cmd from below location.

My location

cd /u02/app/oracle/product/12.2.1/oracle_common/common/bin/

sh config.sh

 Right click and Run as administrator.

Accept default and click Next.

Select the required products and click the "Next" button.

1)          Oracle Reports Server - 12.2.1 [ReportsServerComponent]

2)          Oracle Reports Bridge - 12.2.1 [ReportsBridgeComponent]

3)          Oracle Reports Application - 12.2.1 [reports]

4)          Oracle Reports Tools - 12.2.1 [ReportsToolsComponent]

5)          Oracle HTTP Server (Collocated) - 12.2.1 [ohs]

6)          Oracle Forms - 12.2.1 [forms]

7)          Oracle Forms – 12.2.1 [forms]

Click the "Next" button for Application location.

Enter Admin user and password and click the "Next" button.

Select Production and leave JDK as it it unless you are using other JDK and click the "Next" button.

Enter details of Database configuration type which we have given during RCU Configuration.

Enter details of DBMS/Service as :orcl.testsri.com
Host Name : 192.168.1.69
Port : 1521
Schema Owner : As It is
Schema Password : Provide we have given during RCU Configuration.

Click Get RCU Configuration button. If connection is successful then press Next button

Click Next. It is assumed that all component have same schema passwords.

Click Next. When all JDBC Test is successful.

Select Managed Servers, Clusters and Coherence and click Next.

Check that the Server Groups is set to FORMS-MAN-SVR (for Forms). And  REPORTS-SVR (for Reports). Click Next.

Accept the Cluster details and Click Next.

Accept the details and Click Next.

Accept the details for Coherence Cluster and Click Next.

Accept the details for Machines Click Next.

Move AdminServer to Machines by clicking > Arrow.

Click Add Button and add ohs1 system component and component type as OHS and click Next.

Enter Listen Address and click Next.

Select ohs1 and click > Button to move ohs1 to Machines.

Click Create on configuration summary.

Configuration progress starts.

Configuration Completes press Next button.

Click Finish button.

Oracle Forms 12c, Reports 12c are installed. Now we need to configure Reports and Forms in following steps.

Post-Installation

If you chose the "Production Mode" options for the domain, you will need to create a "boot.properties" file for the scripts referred to later to work without credentials. Adjust the DOMAIN_HOME and credentials appropriately.

$ export DOMAIN_HOME/u02/app/oracle/config/domains/sridomain

$ mkdir -p $DOMAIN_HOME/servers/AdminServer/security

$ mkdir -p $DOMAIN_HOME/servers/WLS_FORMS/security

$ mkdir -p $DOMAIN_HOME/servers/WLS_REPORTS/security

$ echo "username=weblogic">/u02/app/oracle/config/domains/sridomain/servers/AdminServer/security/boot.properties

$ echo "password=weblogic123">>/u02/app/oracle/config/domains/sridomain/servers/AdminServer/security/boot.properties

$ echo "username=weblogic">/u02/app/oracle/config/domains/sridomain/servers/WLS_FORMS/security/boot.properties

$ echo "password=weblogic123">>/u02/app/oracle/config/domains/sridomain/servers/WLS_FORMS/security/boot.properties

$ echo "username=weblogic">/u02/app/oracle/config/domains/sridomain/servers/WLS_REPORTS/security/boot.properties

$ echo "password=weblogic123">>/u02/app/oracle/config/domains/sridomain/servers/WLS_REPORTS/security/boot.properties

Step 1.Start Node Node Manager by providing following command located in
sh/u02/app/oracle/config/domains/sridomain/bin/startNodeManager.sh

Step 2.Now we will start Weblogic Admin Server by providing following command located in

sh/u02/app/oracle/config/domains/sridomain/bin/startWebLogic.sh

Now Weblogic server is started and in Running mode.

Step 3.Open the Command window andwe will start WLS_FORMS by giving following command.

sh/u02/app/oracle/config/domains/sridomain/bin/startManagedWebLogic.sh WLS_FORMS

Now we can start the forms builder from below location.

sh/u02/app/oracle/config/domains/sridomain/config/fmwconfig/components/FORMS/instances/forms1/bin/frmbld.sh

Step 4.Now we will start the HTTP Server. Open the browser I used Internet explorer and give URL as http://localhost. It will open the console. Provide the Domain Admin User name and password.

Step 5.Now Click Target Navigation Icon on left top most Icon

Step 6.Expand HTTP Server and click ohs1 and click Start Up at the top. Ohs1 completed successfully now Press Close button.

Step 7.  Edit the

vi /u02/app/oracle/product/12.2.1/forms/templates/config/forms.conf

file to contain the following.

SetHandlerweblogic-handler
WebLogicHostlocalhost or
WeblogicPort 9001

Now Edit the

vi /u02/app/oracle/product/12.2.1/reports/conf/reports_ohs.conf file to contain the following.

SetHandlerweblogic-handler
WebLogicHostlocalhost or
WebLogicPort 9002

Now copy both [forms.conf and reports_ohs.conf ] to following location.

cd/u02/app/oracle/config/domains/sridomain/config/fmwconfig/components/OHS/instances/ohs1/moduleconf/

Now Restart the HTTP Server to take effect.

Step 8.Now Start the forms server by providing following command in Command window

sh/u02/app/oracle/config/domains/sridomain/bin/startManagedWebLogic.sh WLS_FORMS

Now Restart the HTTP Server to take effect. You can see that forms server is started and running and its health is ok.

At this point we have not created the Report server and Report server is not started this we will start afterwards.

Now we will check that our forms is installed successfully of not. We need Java JRE to be installed which we have already installed before installing Weblogic Server.

Now Open Internet Explorer and check that our forms is successfully installed and running provide the following URL.

http://hostname:9001/forms/frmservlet?config=webstart

(in hostname provide your hostname where you have installed for ex. Localhost or Ipaddress).

See our forms is installed and running successfully.

Step 9.Now we will use WLST (Weblogic Scripting Tool) to create Report Components.

 We will create a Reports tool for Machine ‘AdminServerMachine’ – [reportsToolsName].

We will Create a Reports server  for machine 'AdminServerMachine' -

Execute WLST.cmd from following location.

sh/u02/app/oracle/product/12.2.1/oracle_common/common/bin/wlst.sh

Type the following commands in WLST Window.

connect("weblogic",<"weblogic123">,"172.16.1.108:7001")

Now Type the following command to create report tools

createReportsToolsInstance(instanceName=’RepTools1’,machine=’AdminServerMachine’)
createReportsServerInstance(instanceName=’MyServer1’,machine=’AdminServerMachine’)
exit()

 Now your Reports Tool and Server is created.

Step 10.Now let us start WLS_REPORTS. Open command prompt and give following command.
sh /u01/app/oracle/product/12.2.1/config/domains/frsdomain /bin/startManagedWebLogic.sh WLS_REPORTS

Now start the Report Builder from the below path.

sh /u01/app/oracle/product/12.2.1/config/domains/frsdomain /reports/bin/rwbuilder.sh

I have created simple report

ERRORS WHICH I FACED DURING INSTALLATION

ERROR 1 : Reports Installation Error :

REP-58100: An error occurred starting the internal Web server at port $$Self.OHSPort$$.
Error: java.lang.NumberFormatException:For input string: "$$Self.OHSPort

We faced this error when we run the report in weblayout.

Cause:

This is a plugin parameter whic should be added in rwbuilder.conf file after report builder is installed.

Solution :

1) Go the the below location

cd /u01/app/oracle/config/domain/frsdomain/config/fmwconfig/components/ReportsToolsComponent/report_server1

2) vi rwbuilder.conf

3) Add the below parameter :

ERROR 2:REP-51019 system user authentication is missing

1)  In  rwservlet.properties confirm SSO is already disabled:

no

2) Disable JAZN security.  In rwserver.conf that belongs to the reports server you will use (in-process, standalone or both) change the following entry:

...

...

...

Add "!--" at the beginning and "--" at the end, in order oracle.reports.server.RWJAZNSecurity is commented:

and delete securityId="rwJaznSec" in jobType="report":

Old Value:

New Value:

3) Restart the reports server to apply the changes.

 If it was the in-process reports server, or you applied changes in rwservlet.properties, you need to restart WLS_REPORTS.

Important URLs

The basic URLs of importance are shown below. Ports may vary between installations.

· http://localhost:7001/console (Console)

· http://localhost:7001/em (Enterprise Manager)

· http://localhost:9001/forms/frmservlet (Forms Base URL)

· http://localhost:9002/reports/rwservlet (Reports Base URL)

· http://localhost:7777/forms/frmservlet (Base HTTP URL you would normally use to initiate Forms)

· http://localhost:7777/reports (Base HTTP URL you would normally use to initiate Reports)

· https://localhost:4443/forms/frmservlet (Base HTTPS URL you would normally use to initiate Forms)

· https://localhost:4443/reports (Base HTTPS URL you would normally use to initiate Reports)