2
Using Discoverer with Oracle Enterprise Manager

2.1 Using Discoverer with Oracle Enterprise Manager

This chapter describes how to deploy Oracle9iAS Discoverer with Oracle Enterprise Manager, and contains the following topics:

• Section 2.2, "About Oracle Enterprise Manager"

• Section 2.3, "Why use Oracle Enterprise Manager?"

• Section 2.4, "How to start Oracle Enterprise Manager"

• Section 2.5, "How to create a public connection"

2.2 About Oracle Enterprise Manager

Oracle Enterprise Manager (OEM) provides a single point of entry for configuring the middle tier for Oracle9iAS Discoverer. This enables an Oracle9iAS Discoverer manager to administer the Discoverer server without having to access and perform tasks through the server Operating System.

For more information about using Oracle9iAS Discoverer with Oracle Enterprise Manager, see Oracle Enterprise Manager Help and Oracle Enterprise Manager Configuration Guide.

Note: For more information about how to start OEM, see Section 13.5.2.3, "How to display the Oracle9iAS Discoverer Plus Configuration page in OEM".

2.3 Why use Oracle Enterprise Manager?

You use Oracle Enterprise Manager to do the following configuration tasks:

• Select the locale for public connections - for more information, see Oracle Enterprise Manager Help

• Enable or disable graphs in Discoverer Viewer and Discoverer Portlet Provider - for more information, see Oracle Enterprise Manager Help

• Manage public connections for Discoverer Plus and Discoverer Viewer - for more information, see Section 2.5, "How to create a public connection"

• Change database passwords - for more information, see Oracle Enterprise Manager Help

• Specify the maximum number of stylesheets to pool (in the cache) for Discoverer Viewer and Discoverer Portlet Provider, for more information, see Section 12.5.4, "How to enhance Discoverer Viewer scalability using XSL stylesheet pooling"

• Specify a delay value for the Query Progress page in Discoverer Viewer, see Oracle Enterprise Manager Help

• Specify communication protocols for the Discoverer Plus middle tier - for more information, see Section 13.5.2.3, "How to display the Oracle9iAS Discoverer Plus Configuration page in OEM".

• Specify the maximum number of Discoverer Portlet Provider sessions to pool, see Oracle Enterprise Manager Help

Notes:

• If you configure Discoverer using Oracle Enterprise Manager, you must restart Discoverer for the changes to take effect, as follows:
  • on a Unix platform, use the Oracle Enterprise Manager to restart Discoverer (for more information, see Section 4.4, "How to stop standalone Oracle9iAS Discoverer components in Unix"

  • on a Windows platform, use the startall.bat command (for more information about the location of configuration files, see Section A.2, "List of Discoverer file locations")

2.4 How to start Oracle Enterprise Manager

You use the Oracle Enterprise Manager to configure Oracle9iAS Discoverer. For example, if you want to encrypt Discoverer Plus data, you might want to configure Discoverer Plus to use the HTTPS communication protocol.

How to display the Oracle9iAS Discoverer Plus Configuration page in OEM:

1. Start a Web browser and display the Oracle9iAS Application Server main page.

   If you are connected to the Oracle HTTP Server locally, the URL will be in the form:

   http://hostname:7777

   
   
   Text description of the illustration ias_main.gif

2. Select the Log on to Oracle Enterprise Manager link.

   Tip: You can also go directly to the Oracle Enterprise Manager page using the 1810 port, i.e the URL will be in the form:

   http://hostname:1810

   Note: For more information about starting OEM, see Oracle Enterprise Manager Configuration Guide.

3. When prompted, enter a user name and password.

   Note: If you need an OEM user name and password, contact the Oracle9iAS system manager.

4. Click OK to display the Oracle Enterprise Manager main page.

   
   
   Text description of the illustration oem1a.gif

You can now monitor Oracle9iAS and manage the machines on your network such as Oracle9iAS Discoverer and Oracle9iAS Web Cache.

Notes:

• For more information about using Oracle Enterprise Manager, see the Oracle Enterprise Manager Help system, and Oracle Enterprise Manager Administrator's Guide

2.5 How to create a public connection

You create a public connection when you want to provide a pre-defined login to Discoverer Plus and Discoverer Viewer users. For example, you might create a public connection called 'Start tutorial', which connects to the tutorial database as a tutorial user. Or you might create a public connection that connects to the Oracle9iAS demo database.

You use Oracle Enterprise Manager to create public connections. For more information about Oracle Enterprise Manager, see the Oracle9i Application Server Administrator's Guide.

To create a public connection:

1. Start Oracle Enterprise Manager.

   For more information about starting Oracle Enterprise Manager, see Section 2.4, "How to start Oracle Enterprise Manager"

2. In the Name column, select the instance that you want to update to display a list of components on that machine (e.g. iasdb.host1.uk.companyname.com).

   A list of Oracle9iAS components on that machine is displayed (e.g. HTTP Server, OC4J_BI_Forms, Web Cache, OC4J_Portal).

3. In the Name column, select the OC4J_BI_Forms link to display the Oracle9iAS Discoverer Services Configuration page.

   The Oracle9iAS Discoverer Services Configuration table contains a row for each part of Discoverer that you can configure.

4. Click the Update icon in the General Discoverer row to display the General Discoverer Configuration page.

5. Click Create Connection to display the Create Discoverer Public Connection page.

6. Enter the connection details, then click Apply to save the details.

   The new connection that you created is displayed in the Discoverer Public Connections list on the General Discoverer Configuration page.

   When Discoverer end users connect to Discoverer Plus or Discoverer Viewer, they will be able to select the connection that you have just created.

Notes:

• For more information about managing public connections, see Oracle9i Discoverer Administrator Administration Guide.