Contents

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in This Guide

• New and Changed Features for 12c (12.1.3)
• Other Significant Changes in this Document for 12c (12.1.3)

1 Understanding Repository Creation Utility

• 1.1 Verifying RCU System and Database Requirements
  • 1.1.1 Verifying Supported Platforms
  • 1.1.2 Finding a Certified Database
  • 1.1.3 Verifying Your Database Configuration
  • 1.1.4 Verifying Additional Requirements for IBM DB2 Databases
• 1.2 Preparing for Schema Creation
  • 1.2.1 Understanding System Load and Product Load
  • 1.2.2 Granting Permissions to Users for Querying System Load Objects
  • 1.2.3 Understanding Custom Prefixes
  • 1.2.4 Understanding the Service Table Schema
  • 1.2.5 Planning Your Schema Creation
  • 1.2.6 Integrating Components Using Declarative XML
• 1.3 Using RCU with Java Access Bridge (Windows Only)
  • 1.3.1 Install Java Access Bridge
  • 1.3.2 Configure RCU to Use Java Access Bridge

2 Obtaining and Running Repository Creation Utility

• 2.1 Obtaining RCU
• 2.2 Starting RCU
• 2.3 Creating Schemas
  • 2.3.1 Creating Schemas as a User with Full SYS or SYSDBA Privileges
  • 2.3.2 Creating Schemas as a User With Limited Database Privileges
  • 2.3.3 Verifying Schema Version Numbers
• 2.4 Dropping Schemas
  • 2.4.1 Dropping Shared Tablespaces
  • 2.4.2 Dropping Schemas and Deleting Datafiles (Windows Only)

3 Running Repository Creation Utility from the Command Line

• 3.1 Command Line Syntax and Parameters
• 3.2 Using the -silent Command
• 3.3 Using the -interactive Command
• 3.4 Creating a Repository from the Command Line
• 3.5 Generating a System Load Script From the Command Line
• 3.6 Loading Data Into the Repository From the Command Line
• 3.7 Dropping a Repository from the Command Line
• 3.8 RCU Environment Variables

A Understanding Repository Creation Utility Screens

• A.1 Welcome
• A.2 Create Repository
  • A.2.1 Create Repository
  • A.2.2 Drop Repository
• A.3 Database Connection Details
  • A.3.1 Specifying Connection Credentials for Oracle Databases and Oracle Databases with Edition-Based Redefinition
  • A.3.2 Specifying Connection Credentials for MySQL Databases
  • A.3.3 Specifying Connection Credentials for Microsoft SQL Server Databases
  • A.3.4 Specifying Connection Credentials for IBM DB2 Databases
• A.4 Select Components (for Create Operation)
• A.5 Select Components (for Drop Operation)
• A.6 Schema Passwords
• A.7 Custom Variables
  • A.7.1 Custom Variables for Oracle Data Integrator
  • A.7.2 Custom Variables for Oracle SOA Suite
• A.8 Map Tablespaces
  • A.8.1 Default Tablespace Mappings
  • A.8.2 Changing Default and Temporary Tablespaces
  • A.8.3 Viewing and Changing Additional Tablespaces
  • A.8.4 Managing Tablespaces and Datafiles
    • A.8.4.1 Adding, Modifying, and Removing Tablespaces
    • A.8.4.2 Adding, Modifying, and Removing Datafiles
• A.9 Summary (for Create Operation)
• A.10 Summary (for Drop Operation)
• A.11 Completion Summary (for Create Operation)
• A.12 Completion Summary (for Drop Operation)

B Understanding Repository Creation Utility Schemas, IDs, and Tablespaces

C Extending Repository Creation Utility to Configure Custom Application Repositories

• C.1 RCU Integration Options
  • C.1.1 RCU JDBC Engine Compliant SQL*Plus Scripts
  • C.1.2 Pure JDBC Scripts
  • C.1.3 SQL*Plus Scripts
  • C.1.4 External Processes
  • C.1.5 Java Code Using JavaAction
• C.2 RCU Configuration Files
  • C.2.1 XML DTDs Defined by RCU
    • C.2.1.1 Component Descriptor Configuration File
    • C.2.1.2 Repository Configuration File
    • C.2.1.3 Master List of Supported Components
    • C.2.1.4 Storage Attributes Configuration File
  • C.2.2 Component Repository Configuration File
  • C.2.3 Component List Configuration File
  • C.2.4 Soft-Prerequisite Support
  • C.2.5 Default Tablespaces Configuration File
• C.3 RCU Script Writing Guidelines
  • C.3.1 Guidelines for RCU JDBC Engine Compliant SQL*Plus Scripts
  • C.3.2 Guidelines for Pure JDBC Scripts
  • C.3.3 Guidelines for SQL*Plus Scripts
  • C.3.4 Guidelines for SQL Server-Based Scripts

D Troubleshooting Repository Creation Utility

• D.1 General Troubleshooting Tips
• D.2 RCU Log Files
• D.3 Need More Help?