This guide is for use when you have installed Oracle Developer Suite at a client
workstation and wish to use Oracle Designer or Oracle Designer Repository.
Because these components require a server-side repository at the database
host, you need to use procedures in this guide to do one of the following:
install a brand-new repository
migrate a repository from an Oracle Repository or Oracle Designer release
prior to 6i
upgrade a repository from Oracle Designer/Repository 6i or higher
The Oracle Database software must already
be installed on the database server.
Audience
This guide is intended for system or database administrators who wish to
install a new repository, migrate an existing pre-6i repository
or upgrade an existing release 6i or 9i repository. You will
need to be familiar with SQL and the principles of Oracle database management.
You will also need to know the appropriate commands for file management
under the server operating system (UNIX or Windows).
Text in a fixed-width
font indicates commands that you must enter exactly as shown. Such text
is not case-sensitive unless noted otherwise.
italics
Characters in italics
in a command statement represent a variable. Substitute an appropriate
value. Also used for book titles.
UPPERCASE
Uppercase characters
within the text represent command names, file and directory names, SQL
reserved words, and keywords.
Punctuation
In commands, punctuation
other than brackets and vertical bars must be entered exactly as shown.
\DIRECTORY
A backslash before
a directory name indicates that this directory is a subdirectory.
[ ]
Brackets enclose
optional clauses from which you can choose one or none.
Terms Used
Throughout this guide the following terms are used:
Term
Meaning
Application Programming Interface
(API)
The set of database views,
libraries, packages, functions, procedures, classes and methods that allow
a program to make use of, or communicate with, data in the repository.
client workstation
A machine connected to a local
or remote database; this is the machine on which you install the Oracle iDS
client software.
database administrator
(DBA)
The person responsible for
performing tasks such as installing the database, enrolling users, and
creating database objects. The DBA and the network administrator might
be the same person.
database server
The computer where the database
resides. A remote database (see below) may be located on a computer such
as a minicomputer or mainframe, or on a dedicated PC, or your database
may reside on a file server if your system supports that configuration.
This is the machine on which you install the repository software.
network administrator
The person responsible for
maintaining the network operating system.
repository instance
All the database objects (e.g.,
tables, views, packages) required by the Oracle Designer Respository software.
repository owner
A repository user who owns
the repository objects and who performs administrative tasks associated
with the repository. Only the repository owner has access to all the functions
of the Repository Administration Utility. The repository owner cannot be
either of the Oracle users SYSTEM or SYS.
repository user
An Oracle database user who
has been granted access to the repository.
subordinate user
Any repository user other than
the repository owner. There can be many subordinate users of the repository,
but only one repository owner. In particular, subordinate users do not
have access to all the functions of the Repository Administration Utility.
Documentation Accessibility
Our goal is to make Oracle products, services, and supporting documentation
accessible, with good usability, to the disabled community. To that end,
our documentation includes features that make information available to
users of assistive technology. This documentation is available in HTML
format, and contains markup to facilitate access by the disabled community.
Standards will continue to evolve over time, and Oracle Corporation is
actively engaged with other market-leading technology vendors to address
technical obstacles so that our documentation can be accessible to all
of our customers. For additional information, visit the Oracle Accessibility
Program web site at http://www.oracle.com/accessibility/.
Accessibility of Code Examples in Documentation
JAWS, a Windows screen reader, may not always correctly read the code examples
in this document. The conventions for writing code require that closing
braces should appear on an otherwise empty line; however, JAWS may not
always read a line of text that consists solely of a bracket or brace.
Accessibility of Command Line Tool Output
In order for JAWS to read output from the Command Line Tool correctly,
users should download a set of scripts from the Oracle Technology Network
(OTN) at http://otn.oracle.com. For
the location of these scripts within OTN, see the OracleiDS Release
Notes.