A
Discoverer configuration files

applypreferences.sh 

This file is a script file that updates the Discoverer preferences in the cache (UNIX specific).

On UNIX: <ORACLE_HOME>/discoverer902/util

On Windows: n/a 

blaf.css 

This cascading style sheet file stores browser look-and-feel settings for Discoverer. To see Viewer's current look-and-feel settings, refer to blaf.htm (see blaf.htm entry below).

On UNIX: <ORACLE_HOME>/j2ee/OC4J_BI_Forms/applications/discoverer/web/common/xsl

On Windows: <ORACLE_HOME>/j2ee/OC4J_BI_Forms/applications/discoverer/web/common/xsl 

blaf.htm 

This file contains example Viewer look-and-feel settings and enables you to see what customization tags are currently set to. This file displays settings stored in blaf.css (see blaf.css entry above).

On UNIX: <ORACLE_HOME>/j2ee/OC4J_BI_Forms/applications/discoverer/web/common/xsl

On Windows: <ORACLE_HOME>/j2ee/OC4J_BI_Forms/applications/discoverer/web/common/xsl 

configuration.xml 

This file stores configuration settings for Discoverer. You can also use the Discoverer Services Configuration page in Oracle Enterprise Manager to configure some of the settings in this file.

On UNIX: <ORACLE_HOME>/j2ee/OC4J_BI_Forms/applications/discoverer/web/plus_files/xsl

On Windows: <ORACLE_HOME>/j2ee/OC4J_BI_Forms/applications/discoverer/web/plus_files/xsl 

defaults.txt 

This file stores factory-supplied default preferences.

On UNIX: <ORACLE_HOME>/discoverer902/util

On Windows: <ORACLE_HOME>/discoverer902/util 

dis51pr 

This file runs the command line utility used to manage preferences stored in the .reg_key.dc file.

On UNIX: <ORACLE_HOME>/discoverer902/bin

On Windows: <ORACLE_HOME>/discoverer902/bin 

discwb.sh 

This script file sets the PATH and other environment variables needed to run Discoverer utility scripts located in /discoverer902/util/. Because this script is included in most other script files, the commands in this file run automatically. Therefore, you do NOT need to run this script unless you are working independently of the Oracle Discoverer supplied scripts.

Type the following at the command prompt:

> . ./discwb.sh

Note: You must separate the periods with a space. 

plus_config.xml 

On UNIX: <ORACLE_HOME>/j2ee/OC4J_BI_Forms/applications/discoverer/web/WEB-INF/

On Windows: <ORACLE_HOME>/j2ee/OC4J_BI_Forms/applications/discoverer/web/WEB-INF/

pref.txt 

This file stores the Discoverer middle tier preferences, and is used to generate the .reg_key.dc file. On install, this file is populated using settings in the default.txt file.

On UNIX: <ORACLE_HOME>/discoverer902/util

On Windows: <ORACLE_HOME>/discoverer902/util 

registerSession.bat 

This file is a script file that registers the Discoverer session component (Windows specific).

On UNIX: n/a

On Windows: <ORACLE_HOME>\discoverer902\util 

registerSession.sh 

This file is a script file that registers the Discoverer session component (UNIX specific).

On UNIX: <ORACLE_HOME>/discoverer902/util

On Windows: n/a 

startoad.sh 

This file is a script file that starts the Object Activation Daemon.

On UNIX: <ORACLE_HOME>/discoverer902/util

On Windows: n/a 

startall.bat 

Start Discoverer, OAD, OSAGENT, and the Discoverer Preference component (Windows specific).

On UNIX: n/a

On Windows: <ORACLE_HOME>\discoverer902\util 

startall.sh 

Start Discoverer, OAD, OSAGENT, and the Discoverer Preference component (UNIX specific).

On UNIX: <ORACLE_HOME>/discoverer902/util

On Windows: n/a 

startpreference.sh 

This file is a script file that starts (and registers) the Discoverer preferences component (UNIX specific).

On UNIX: <ORACLE_HOME>/discoverer902/util

On Windows: n/a 

stopall.bat 

Stops Discoverer, OAD, OSAGENT, and the Discoverer Preference component (Windows specific).

On UNIX: n/a

On Windows: <ORACLE_HOME>\discoverer902\util 

stopall.sh 

Stops Discoverer, OAD, OSAGENT, and the Discoverer Preference component (UNIX specific).

On UNIX: <ORACLE_HOME>/discoverer902/util

On Windows: n/a 

stoppreference.sh 

This file is a script file that stops (and unregisters) the Discoverer preferences component (UNIX specific).

On UNIX: <ORACLE_HOME>/discoverer902/util

On Windows: n/a 

tnsnames.ora 

This file contains the names and aliases of all the databases that users can access using Oracle9iAS Discoverer.

On UNIX: <ORACLE_HOME>/network/admin

On Windows: <ORACLE_HOME>/network/admin 

ui_config.xml 

This file stores user interface configuration settings for Discoverer.

On UNIX: <ORACLE_HOME>/j2ee/OC4J_BI_Forms/applications/discoverer/web/common/xsl

On Windows: <ORACLE_HOME>/j2ee/OC4J_BI_Forms/applications/discoverer/web/common/xsl 

unRegisterSession.bat 

This file is a script file that unregisters the Discoverer session component (Windows specific).

On UNIX: n/a

On Windows: <ORACLE_HOME>\discoverer902\util 

unregistersession.sh 

This file is a script file that registers the Discoverer session component (UNIX specific).

On UNIX: <ORACLE_HOME>/discoverer902/util

On Windows: n/a 

Configuration 

base_dir="." 

Specifies the location of directories for images and help if different from the default. 

Appearance 

option id="display_login_method_control" state="false" 

Specifies whether to display the "Applications User" check box. 

option id="display_show_xml_link" state="true" 

Specifies whether to display the "Show XML" link at the bottom of every page. 

option id="display_language_control" state="true" 

Specifies whether to display the Language drop down list on the Connect dialog. 

option id="display_rerun_query_link" state="true"/ 

Specifies whether to display the Rerun query link on the Worksheet page.

Note: If you are using Oracle9iAS Web Cache, set this value to false.  

option id="display_preferences_link" state="true"/ 

Specifies whether to display the Preferences global icon.

Note: If you are using Oracle9iAS Web Cache, set this value to false.  

option id="display_presentation_options_link" state="true"/ 

Specifies whether to display the Presentation Option link on the Worksheet page.

Note: If you are using Oracle9iAS Web Cache, set this value to false.  

option id="use_javascript_enhanced_ui" state="true" 

Specifies whether to use the JavaScript enhanced user interface. 

Behavior 

option id="sticky_worksheets" state="true" 

Specifies whether worksheet drills and pivot operations are remembered between visits to the same worksheet in a single session. 

option id="debug_mode" state="false"/ 

When set to true, every HTML page generated by Viewer includes a text box containing XML describing the internal state of the Viewer Servlet. This information is useful when developing custom XSL or debugging. 

Presentation_
templates 

look name="Corporate Look" 

Specifies the name of the presentation template. 

component name="xxx" state="true|false" 

Specifies whether a particular UI component is displayed or hidden for the current presentation template (refer to the comments in ui_config.xml for more details about component names). 

NLS 

resource id="xxx" href="yyy" help="zzz" 

Specifies the message file yyy and help file zzz to use for a particular language xxx. 

resource id="es" href="resources/es.xml" help="es" images="en" 

The images attribute enables you to specify the sub-directory within the images directory to find images specific to this locale. 

Help 

<page name="add_connection" file="add_conn.htm"/> 

Specifies the name of the help page for the Add Connection online page.  

<page name="add_eul" file="sel_eul.htm"/> 

Specifies the name of the help page for the Add Connection: EUL page.  

<page name="add_responsibility" file="sel_resp.htm"/> 

Specifies the name of the help page for the Add Connection: Responsibility page.  

<page name="connection_list" file="connections.htm"/> 

Specifies the name of the help page for the Connections List page.  

<page name="home" file="index.htm"/> 

Specifies the name of the help page for the top level help page.  

<page name="launch_plus" file="app_launch.htm"/> 

Specifies the name of the help page for the Launch Discoverer Plus page (not used in this release.)  

<page name="sort_crosstab" file="sort_crosstab.htm"/> 

Specifies the name of the help page for the Crosstab Sorting page (not used in this release).  

<page name="sort_table" file="sort_table.htm"/> 

Specifies the name of the help page for the Table Sorting page.  

<page name="update_eul" file="edit_eul.htm"/> 

Specifies the name of the help page for the Update Connection: EUL page.  

<page name="update_main" file="update_conn.htm"/> 

Specifies the name of the help page for the Update Connection page. 

<page name="update_responsibility" file="edit_resp.htm"/> 

Specifies the name of the help page for the Update Connection: Responsibility page.  

page name="data" file="worksheet_display.htm" 

Specifies the name of the help page for the data page. 

page name="edit_layout" file="edit_layout.htm" 

Specifies the name of the help page for the Edit layout page. 

page name="export" file="export.htm" 

Specifies the name of the help page for the export page. 

page name="parameters" file="edit_parameters.htm" 

Specifies the name of the help page for the parameters page. 

page name="preferences" file="preferences.htm" 

Specifies the name of the help page for the preferences page. 

page name="presentation" file="presentation_options.htm" 

Specifies the name of the help page for the presentation options page. 

page name="reconnect" file="connect.htm" 

Specifies the name of the help page for the reconnect page. 

page name="run_query" file="run_query.htm" 

Specifies the name of the help page for the start query page. 

page name="running_query" file="query_progress.htm" 

Specifies the name of the help page for the running query page. 

page name="workbooks" file="list_of_workbooks.htm" 

Specifies the name of the help page for the workbooks page. 

page name="worksheets" file="list_of_worksheets.htm" 

Specifies the name of the help page for the worksheets page. 

/disco:configuration/@locale 

Specifies the default locale. The locale that Discoverer Viewer uses to display its UI is determined by the language setting in the end user's browser. If this setting has not been defined, Viewer will default to the system locale set on the middle tier. If Viewer is unable to determine the system locale, it will default on the locale set here.  

/disco:configuration/@rmi 

Specifies whether the servlet should listen for RMI requests from the Plus applet. Setting this to false prevents Discoverer Plus from working but frees up a small amount of resources on the middle tier.  

/disco:configuration/@webcache 

Specifies whether Oracle9iAS Web Cache is being used to cache the pages generated by the Discoverer servlet.  

/disco:configuration/portlet/@maximumSessions 

/disco:configuration/portlet/xsl_translator/* 

Same as above but for the Discoverer Portlet Provider rather than the Discoverer Servlet. 

/disco:configuration/server/@session 

Specifies the name of the instance of the Discoverer Server for both Discoverer Plus and Discoverer Viewer. 

/disco:configuration/servlet/@charting 

Specifies whether to display charts that have been saved with workbooks:

• set to true to display charts (default)

• set to false to prevent the display of charts (improves performance where charts are not required)

/disco:configuration/servlet/@exportRefreshPeriod 

Specifies the delay in seconds before a browser is redirected to the original URL. Use this argument to prevent the browser timing out during export operations. Note: This setting only applies when a valid value has also been specified for the fm argument.  

/disco:configuration/servlet/@queryRefreshPeriod 

Specifies the delay in seconds before a query progress page is displayed (or re-displayed). You might use this argument to avoid writing code to handle query progress pages when using the Discoverer servlet to return data to an application you have written. 

/disco:configuration/servlet/@userDefinedConnections 

Specifies whether users are allowed to create private Connections. If set to false, users are still able to use public connections (and if they know how to create their own URLs, they will be able to create temporary connections).  

/disco:configuration/servlet/xsl_translator/@cache 

Specifies whether the servlet caches the xsl or not. 

/disco:configuration/servlet/xsl_translator/@path 

Specifies the path to the discoverer.xsl file. 

/disco:configuration/servlet/xsl_translator/@processor 

Enables you to choose a different XSL Processor.  

/disco:configuration/servlet/xsl_translator/stylesheet_pool 

Enables you to configure how stylesheets are pooled for maximum performance (for more information, see Section 12.5.4, "How to enhance Discoverer Viewer scalability using XSL stylesheet pooling"). 

maximumSessions 

This setting specifies the maximum number of sessions the Portlet Provider can spawn at any given time.

The Discoverer Portlet Provider runs Discoverer Sessions in order to refresh the portlet content in the background. It also uses Discoverer Sessions when a user is publishing or customizing a portlet.

If the maximum number of sessions is reached, the Portlet Provider defers the background refresh until the number of sessions is below the maximum. If a user tries to customize or publish a portlet when the maximum number of sessions is reached, they are asked to retry later.

The default value for this setting is 20.  

query_progress_delay 

Specifies the delay in seconds before a query progress page is displayed (or re-displayed). You can use this parameter to improve accessibility if you use a JAWS screen reader (for more information, see "Documentation Accessibility").

Note: You can also set this parameter on a per-user basis using the URL parameter qpd (for more information, see Section 8.7, "Discoverer Viewer URL arguments"). 

transport 

Specifies the protocols the Discoverer Plus applet and the Discoverer servlet use to communicate.

Hint: You can use Oracle Enterprise Manager to change this setting. 

jvm 

Specifies the version of the JVM (e.g. JInitiator) to use. You can change the JVM for particular platforms, browsers, and browser versions.