Oracle Designer Tutorial

Contents

Appendix A
Tutorial installation notes

This appendix is intended for repository managers who are responsible for enabling users to follow the Oracle Designer tutorial.

The sections in this appendix are:

• importing the TUTORIAL application system
• setting up for Web PL/SQL Generator users
• what the Oracle Installer installs on the client
• how tutorial users are instructed to start the tutorial

Importing the TUTORIAL application system

The tutorial in this document requires that users have access to an application system containing predefined entity and function definitions. This application system is shipped with Oracle Designer as a dump file. The dump file is named tutapsys.dmp and by default is located in the \ctutxNN directory, below the ORACLE_HOME directory. The tutorial application was originally named TUTORIAL and was created within a workarea named TUTORIAL.

To import the application system (within its workarea), you use the Repository Object Navigator. You must have sufficient privileges. See the online help for the Repository Object Navigator for full instructions about importing repository objects.

If you import the TUTORIAL application system as a user other than the tutorial user, you will have to grant the tutorial user access to the TUTORIAL application system. The online help explains how to do this.

The instructions given to users elsewhere in this document assume the application system is called TUTORIAL. When you import the TUTORIAL application system, you have the option to give the imported application system a different name. If you do give the application system a name other than TUTORIAL, make sure you tell users the name.

Setting up for Web PL/SQL Generator users

Tutorial users will not be able to follow lesson 10 unless Web PL/SQL Generator has been installed and set up.

Set up Web PL/SQL Generator as described in the Installation Guide and on-line help.

Be prepared to make the following information available to the tutorial user:

• the username, password and connect string for the web server
• connection information for the web agent URL

The connection information is needed for the Web PL/SQL Generator Options dialog box. You can see this dialog box by opening the Design Editor and selecting OptionsGenerator OptionsWeb PL/SQL. Use the Help button on the dialog box to obtain a detailed description of what is required. You may wish to enter this information before the tutorial user starts the lessons.

The tutorial user will also need to know the location of a web browser executable, which may be local.

What the Oracle Installer installs on the client

This section describes the operation of the Oracle Installer during installation of the Oracle Designer tutorial, and is for information purposes only.

During installation, the Oracle Installer:

• Copies into the <ORACLE_HOME>\ctutxNN directory the following files:
  
  

  tutapsys.dmp	destut.drp	destut.sql
  destut.dat	yesno.sql	destut.txt

• Creates a directory in <ORACLE_HOME>\ctutxNN\ called tutorial.
  
  
• Copies into the <ORACLE_HOME>\ctutxNN\tutorial directory the following files:
  
  

  tutorial.fmb

  tutorial.olb

• Creates a folder called Oracle Designer Tutorial.
  
  
• Populates the Oracle Designer Tutorial folder with the following programs:
  • About the Oracle Designer Tutorial (displays the text file destut.txt)
  • Drop Tutorial Tables (runs the SQL script destut.drp)
  • Oracle Designer for Tutorial User (starts Oracle Designer with the working directory set to <ORACLE_HOME>\ctutxNN\tutorial)
  • Populate Tutorial Tables (runs the SQL script destut.sql).

Note: The working directory specified for the Oracle Designer for Tutorial User program must be writeable.

How tutorial users are instructed to start the tutorial

When following the tutorial, users are instructed to start Oracle Designer by selecting the Oracle Designer for Tutorial User program in the Oracle Designer Tutorial folder.

The working directory of this program item is set to <ORACLE_HOME>\ctutxNN\tutorial.