Oracle SCM Repository Installation Guide

Prev Next


This guide is for use when you have installed Oracle9iDS at a client workstation and wish to use Oracle9i Designer or Oracle9i Software Configuration Manager (Oracle SCM, formerly known as Oracle 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:

The Oracle8i Server or Oracle9i Database software must already be installed on the database server.


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 NT).


This guide contains:
Section Description

Server-Side Installation, Migration and Upgrade

Contains detailed information about installing a new repository, or migrating or upgrading an existing one.

Appendix A, "Setting the Configuration Parameters"

Describes how to customize your Oracle configuration by changing the parameter values defined in the Windows Registry. 

Appendix B, "Log Files"

Lists the log files produced by a successful installation, migration or upgrade.

Appendix C, "Error Messages"

Provides information on some common error messages relating to an Oracle SCM repository installation or upgrade.

Related Documentation

For more information about Oracle9i Designer or Oracle9i SCM, see these Oracle resources:

For more information about Oracle9i, see these Oracle resources:

For more information about Oracle8i, see these Oracle resources:

In North America, printed documentation is available for sale in the Oracle Store at

Customers in Europe, the Middle East, and Africa (EMEA) can purchase documentation from

Other customers can contact their Oracle representative to purchase printed documentation.

To download free release notes, installation documentation, white papers, or other collateral, please visit the Oracle Technology Network (OTN). You must register online before using OTN; registration is free and can be done at

If you already have a username and password for OTN, then you can go directly to the documentation section of the OTN Web site at


The following conventions are used in this guide:

Convention Meaning

fixed-width font

Text in a fixed-width font indicates commands that you must enter exactly as shown. Such text is not case-sensitive unless noted otherwise. 


Characters in italics in a command statement represent a variable. Substitute an appropriate value. Also used for book titles.


Uppercase characters within the text represent command names, file and directory names, SQL reserved words, and keywords.


In commands, punctuation other than brackets and vertical bars must be entered exactly as shown.


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 Oracle9iDS client software.

database administrator 

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 SCM 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

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 For the location of these scripts within OTN, see the Oracle9iDS Release Notes.





Oracle logo 
Copyright © 2002, 2004 Oracle Corporation. 
All Rights Reserved.