Oracle® Fusion Middleware Publishing Reports to the Web with Oracle Reports Services 11g Release 1 (11.1.1) Part Number B32121-01 |
|
|
View PDF |
11g Release 1 (11.1.1) provides numerous high availability (HA) enhancements, as listed in Table 2-1 in Section 2.1, "What's New In This Release?".
This section discusses the following topics pertinent to establishing a high availability environment:
Oracle Fusion Middleware consists of many components that can be deployed in distributed topologies. The underlying paradigm used to enable high availability for Oracle Fusion Middleware is clustering, which unites various Oracle Fusion Middleware components in certain permutations to offer scalable and unified functionality, and redundancy should any of the individual components fail.
Note:
Refer to the Oracle Fusion Middleware Enterprise Deployment Guide for Java EE and Oracle Fusion Middleware High Availability Guide for more information on the various solutions and techniques to achieve high availability in Oracle Fusion Middleware.Perform the following steps to configure the rwservlet.properties file:
Make sure that the in-process server has a unique name. You can check the sever sub-element of the rwservlet.properties to verify the unique server name.
Configure cluster in the rwservlet.properties file.
<cluster clustername="ha_cluster" clusternodes="ha_server2"/>
cluster name
should be same in all rwservlet.properties files. Cluster nodes
should include in-process server names which are part of the cluster except the current one. More than one server should be separated by a colon.
Save the servlet configuration file.
Alternatively, you can configure a cluster through Oracle Enterprise Manager:
Navigate to the Reports Application Home Page in Enterprise Manager.
From the Reports menu, select System MBean Browser.
The System MBean Browser page is displayed.
From the left content pane, expand Application Defined MBeans > oracle.reportsApp.config > Server: WLS_REPORTS > Application: reports > ReportsApp.
Select rwservlet from the list.
The Application Defined MBeans: Report sApp:rwservlet page is displayed.
Click the Operations tab.
Select addCluster.
The Operation:addCluster page is displayed.
Enter valid values in the Cluster Name and Node fields.
Click Invoke.
For more information about the rwservlet.properties file, refer to Section 7.3.1.1, "rwservlet"
To configure Reports Server for high availability by using the database as the job repository, perform the following steps for each instance:
Configure the database job repository for in-process Reports Servers in all instances in the rwserver.conf
file of all Reports Servers.
Note that in 11g Release 1 (11.1.1) the server configuration file must correspond to the rwserverconf.xsd
file (refer to Section 7.2.1, "Reports Server Configuration Elements"), which means that the order in which different entries appear inside the server configuration file is no longer random, but fixed by the XSD. As a result, the following element must be added immediately before the <connection>
element in the server configuration file:
<jobRepository> <property name="dbuser" value="dbuser"/> <property name="dbpassword" value="csf:reports:dbpasswdKey"/> <property name="dbconn" value="dbconn"/> </jobRepository>
For information about adding a password key in the credential store, see Section 14.1.4, "Credential Store".
Save the server configuration file.
Alternatively, you can configure the database job repository through Oracle Enterprise Manager:
Navigate to the Reports Application home page in Enterprise Manager.
From the Reports menu, select Administration > Advanced Configuration.
The Reports Application Advanced Configuration page is displayed.
Locate the Job Repository content pane in the Advanced Configuration page.
Select the Enable Job Repository DB checkbox.
Enter valid values in the Username, Password Key and Database fields.
Click Apply.
Configure a folder to which all instances have access (write access is needed, read access is not enough) by adding the CacheDir
or JOCCacheDir
property to the <cache>
element of each of the server configuration files,
For example,
on Windows:
<property name="JOCCacheDir" value="folder_name"/> <property name="CacheDir" value="folder_name"/>
on UNIX:
<property name="JOCCacheDir" value="/net/machine_name/usrs/tmp"/> <property name="CacheDir" value="/net/machine_name/usrs/tmp"/>
where, "/usrs/tmp"
is a shared location when Reports Server is running on different machines and has write privileges.
Note:
In a case where the in-process Reports Servers are running on different machines, the configuration can be done by sharing a folder to the other machine or user. For example, on Windows, configure the shared cache for both in-process Reports Servers by adding the following property to the <cache>
element of each of the server configuration files:
<property name="JOCCacheDir" value="\\host\shared"/>
where host
is the machine where the shared folder is available, and shared
is the folder name
Alternatively, you can specify the value for JOC Cache directory through Oracle Enterprise Manager:
Navigate to the Reports Application Home page in Enterprise Manager.
From the Reports menu, select Administration > Advanced Configuration.
The Reports Application Advanced Configuration page is displayed.
Note:
You can use the System MBean Browser to add JOC Cache directory for the first time.The High Availability parameters section in Enterprise Manager is displayed only when the server is part of the HA cluster and the in-process server is running.
Locate the High Availability Parameters section in the content pane.
Enter a valid folder name in the Cluster Cache Directory field.
Click Apply.
For information about the JOCCacheDir
and CacheDir
properties (new in Oracle Reports 11g Release 1 (11.1.1), refer to Chapter 7, "Configuring Oracle Reports Services".
Load the rw_server.sql
file to a database (this file is included with your Oracle Reports Services installation: ORACLE_HOME\reports\admin\sql)
This creates a schema that owns the report queue information and has execute privileges on the server queue API.
Restart the Reports Server.
Set the Environment variables TNS_ADMIN
and ORACLE_HOME
in the shell and start the node manager ($FMW_HOME/wlserver_10.3/server/bin/startNodeManager.sh
). This is required for the reports in-process server to connect to the database.
For more information, see "TNS_ADMIN".
You can use Oracle WebCache as a load balancer. For more information, see Oracle Fusion Middleware Administrator's Guide for Oracle Web Cache
When High Availability is setup across two different domains in Oracle Enterprise Manager, you need to configure the Enterprise Manager settings. This enables both the domains to access the data from all the servers.
Navigate to your Domain Home Page in Enterprise Manager.
From the WebLogic Domain menu, select Security > Credentials.
Select the Reports map and edit EMServerPasswordKey and enter a password.
Repeat the steps from one to three for the other domain and enter the same password.
Restart the Enterprise Manager Agent in both the domains.
In ORACLE_INSTANCE/bin
of each domain
./opmnctl stopproc ias-component=<emagent_name> ./opmnctl startproc ias-component=<emagent_name> ./opmnctl restartproc ias-component=<emagent_name>
Restart the Reports Server in both the domains.
When you have finished configuring the Enterprise Manager settings for both the domains, the Enterprise Manager console monitors and manages jobs in the job queues of all the HA servers.