A. Introduction
        Reports Demos Requirements
        Reports Demos overview

B. System Configuration
         Directory Structure
               On Windows NT
               On UNIX
         Environment Variables
         Listener Configuration
         Demo Database Objects
         Key Mapping File (cgicmd.dat)
         Deinstallation of 6i Demos

C. Known Issues
         SQL*Net
         Netscape
         Acrobat 4.0
         External PDF Viewer
         Reports fonts on UNIX

 A. Introduction
This document describes the Oracle Reports demo configuration. We are confident that it is accurate as we go to press; however, should changes occur, you'll find information about them through normal support channels.

1. Requirements

The Reports demos require the following components to run correctly in a Web environment:

• HTML browser:  Netscape 4.0 or later
                             Microsoft Internet Explorer 4.0 or later
• NT or UNIX operating system
• A CGI-aware Web listener. We have supplied the lightweight Oracle WebDB Listener on the installation CD. Use it to execute the Oracle Reports Release 6i demos. If you prefer, you can use any other CGI-aware Web listener. If you install the WebDB Listener when you install the Oracle Reports Server, the necessary virtual mappings will be automatically created for you during installation.
• Oracle Database version 7.3 or later

Note:

• On Windows 95/98, only the client/server demos will be installed. These require that Forms and Reports Runtimes are also installed.
• The file report_index.htm provides a high-level definition of each report and its functionality. You'll find it at %ORACLE_HOME%\tools\devdem60\demo\reports\

2. Overview

When you install Reports Developer, the installation creates the %ORACLE_HOME%\TOOLS\DEVDEM60 directory structure. This is where all of the Oracle Reports demo files reside.

The installation also automatically creates any other appropriate directory structures, listener mappings (if using the WebDB Listener), Program groups, and the like. Any additional configuration steps you must take are described for you in an installer-generated file: dev6iconfig.txt. You'll find the dev6iconfig.txt file in %ORACLE_HOME%\orainst or $ORACLE_HOME/orainst. Once you finish installing Oracle Reports Server, read this file and perform the requested actions.

Depending on your operating system, after you install the demos, you should be able to run the Reports demos successfully from a browser. (On Windows 95/98, only client/server demos are supported.)

On Windows NT, demos are accessible from the start bar shortcut:
Start-->Programs-->Reports 6i Demos-->Reports Benefits and Features on the Web

We've created an HTML file to provide a quick and easy way to access and run Reports from your browser. The appropriate hyperlinks for running Reports have been included. All you do is click the hyperlink, and the report will display within your browser. Go to: http://<host_name_including_domain>:<listener_port>/rep60demo/html/rwdemo6i.html

Navigate to this location and create a bookmark for future quick access.

If you install the WebDB Listener when you install the Reports Server, the necessary virtual mappings will be created for you automatically during installation. If you are using any other Web listener, you will need to create the necessary virtual mappings and MIME types. This is explained below in the Listener Configuration section.

B. System Configuration

After installing the Oracle Reports 6i Demos you may notice the following additions to your system configuration.

1. Directory Structure

1.1 This section describes the directory structure on Windows NT.
 

%ORACLE_HOME%\TOOLS\DEVDEM60\DEMO\REPORTS	Demo RDF's  & template files
%ORACLE_HOME%\TOOLS\DEVDEM60\DEMO\REPORTS\AVI	WebDB, Express and Discoverer AVI files
%ORACLE_HOME%\TOOLS\DEVDEM60\DEMO\REPORTS\HTML	Walk-through scripts for the AVI files and other necessary HTML files
%ORACLE_HOME%\TOOLS\DEVDEM60\DEMO\REPORTS\IMG	Necessary image files for running the demos
%ORACLE_HOME%\TOOLS\DEVDEM60\DEMO\REPORTS\OUTPUT	Path used for dumping report output

1.2 This section describes the directory structure on UNIX platforms.

$ORACLE_HOME/TOOLS/DEVDEM60/DEMO/REPORTS	Demo RDF's  & template files
$ORACLE_HOME/TOOLS/DEVDEM60/DEMO/REPORTS/AVI	WebDB, Express and Discoverer AVI files
$ORACLE_HOME/TOOLS/DEVDEM60/DEMO/REPORTS/HTML	Walk-through scripts for the AVI files and other necessary HTML files
$ORACLE_HOME/TOOLS/DEVDEM60/DEMO/REPORTS/IMG	Necessary image files for running the demos
$ORACLE_HOME/TOOLS/DEVDEM60/DEMO/REPORTS/OUTPUT	Path used for dumping output from reports

2. Environment Variables

The following environment variables will be added to your registry on Windows NT 4.0:
 

R60_DEMOS	"Oracle Reports 6i Demos"
DEMO60	%ORACLE_HOME%\TOOLS\DEVDEM60
GRAPHICS60_PATH	%ORACLE_HOME%\TOOLS\DEVDEM60\DEMO\GRAPHICS
REPORTS60_PATH	%ORACLE_HOME%\REPORT60\ADMIN\TEMPLATE\US
	%ORACLE_HOME%\TOOLS\DEVDEM60\DEMO\REPORTS
	%ORACLE_HOME%\DEMO\REPORTS
	%ORACLE_HOME%\TOOLS\DEVDEM60\DEMO\GRAPHICS
UI_ICON	%ORACLE_HOME%\TOOLS\DEVDEM60\BIN\ICON

On UNIX:

The install process creates two files: reports60.csh and reports60.sh . These files are stored in the $ORACLE_HOME directory. Please reference these files if you would like to include these settings in a specific user's profile.

3. Listener Configuration

If a WebDB Listener is already installed on your system, the following listener mappings will be created by the demo installer:

Virtual Mappings:
 

Virtual Mappings	Physical Mappings
/rep60demo/	%ORACLE_HOME%\TOOLS\DEVDEM60\DEMO\REPORTS
/forms60demos/	%ORACLE_HOME%\TOOLS\DEVDEM60\WEB
/Web_qt/	%ORACLE_HOME%\TOOLS\DEC60\US
/dev60cgi/	%ORACLE_HOME%\BIN

Listener Mime Types:
 

Mime type/Extension 

video/avi	avi
video/x-msvideo	avi

Note:

If you are not running with the WebDB Listener, you may need to add the above mappings and MIME types to your Web listener configuration.

You can install the WebDB Listener from the Oracle Reports Server 6i CD.

If you wish to run AVI files and you are using the Netscape browser, it may be necessary to do a right-mouse click and choose the "Play" option.

4. Demo database objects

The installer runs the following scripts to create the demo database objects:

rdemo60.sql
video.sql

Note:

If necessary, you can run these scripts manually in any order. They are located in %ORACLE_HOME%\TOOLS\DEVDEM60\ADMIN.  The orcl_video_demo.log and orcl_demos.log log files are created to log errors while running the scripts. Please make sure to check your log file for any errors that may have occurred.

If you are running these scripts manually, remember to import the data into the schema you identified as your DEMO user. This user MUST have CONNECT and RESOURCE privileges in the database.

5. Key mapping file (CGICMD.dat)

Once you have installed the Reports Server and demo database objects, the installer creates a cgicmd.dat file that contains the required mappings to run the Reports demos. The installer takes care of replacing your Reports Server (server=%reports_server%) and username/password@connectstring (userid=%demo_connectstring%) in the key mapping file.

If you did not use the installer to create the Reports Server and demo database objects, you will need to make the appropriate changes to your key mapping file.

6. Deinstallation of 6i Demos

Use the Oracle installer to deinstall the demos. The Oracle installer will remove the entire directory structure and program group, as well as the R60_DEMOS AND DEMO60 registry variables (NT only).
 

C. Known Issues

• A SQL*Net connection is required to run the demos, even if you are using a local database. You may use "tcp-loopback" as the connect string. If SQL*Net is not configured, graphics will not display correctly.
  
  
• If you are using a Netscape browser, HTMLCSS output becomes distorted if the browser window is re-sized. This problem does not occur with MS IE.
  
  
• When you use Acrobat 4.0 with Netscape, bookmarks do not display when the report first displays in your browser. If you press "Back" within the the browser and then "Forward," the bookmarks will appear. This problem does not occur with MS IE.
  
  
• If Adobe PDF is registered with your browser as a helper application (set up as a MIME type) and not as a plug-in, PDF documents (such as Reports) are launched in the external Adobe Viewer and not within the browser. This means the predefined links in a report will not function. See the Adobe documentation for installing the PDF plug-in to properly display PDF documents within your browser.
  
  
• The Reports 6i demos are designed to run under 75 dpi fonts on UNIX. If you do not have a default printer installed, Oracle Reports will get it's font information from the device that is pointed to by the DISPLAY environment variable (which must be running motif). If the X font path for that particular device does not have 75dpi fonts listed first, then the demo output may be corrupted (most notably, the newsletter and runtime customizations demos).
  
  You can see the font path value by typing the following at the UNIX command prompt (on the machine pointed to by the DISPLAY environment variable):
  
  xset q
  
  To put the 75 dpi fonts first in the font path, type the following at the UNIX command prompt:
  
  xset +fp /usr/openwin/lib/X11/fonts/75dpi
  
  where '/usr/openwin/lib/X11/fonts' is the directory containing the font files (on a Solaris machine).
  
  Note: This directory will vary depending on the machine. Please consult the machine's system administrator for information on the location of the font files.