Contents

Title and Copyright Information

Send Us Your Comments

Preface

Purpose of This Guide

Intended Audience

Documentation Accessibility

Structure

How to Use this Guide

Oracle Enterprise Manager Pack Information

Oracle Enterprise Manager Documentation

Oracle Support

1 Overview of the Oracle Change Management Pack

New Features for This Release of Oracle Change Management Pack

Database Objects Supported by Oracle Change Management Pack Applications

Understanding Oracle Change Management Pack Objects

Tracking Applications and Change Applications

Tracking Applications

Change Applications

Overview of Change Manager

Overview of Create Baseline

Capturing a Baseline from the Oracle Enterprise Manager Console

Overview of Compare Database Objects

Performing a Comparison from the Oracle Enterprise Manager Console

Overview of Synchronization Wizard

Overview of DB Quick Change

Overview of DB Alter

Overview of DB Propagate

Starting DB Propagate in the Console

Copying Definitions Using Drag and Drop in the Console

Overview of Plan Editor

Comparison of Other Change Applications and Plan Editor

Starting the Oracle Change Management Pack Quick Tour

Sample Uses for the Oracle Change Management Pack

Using Change Plans to Make Changes

Planning and Defining Changes

Evaluating the Impact of Changes

Implementing the Changes

Learning More About Making Changes Using Change Plans

Using Help

Displaying the Contents Page for Help

Displaying a Help Topic for Your Current Context in an Application

Finding a Particular Type of Help Topic

2 Using Change Manager

Running Change Manager Connected to an Oracle Management Server or Standalone

Creating a Standalone Repository for Change Management Pack Applications

Changing Your Standalone Change Management Pack Repository

Starting Change Manager

Using the Change Manager Main Window

Starting Change Management Pack Applications from Change Manager

Working with Baselines

Working with Comparisons

Working with Change Plans

Viewing History Entries for Tasks

Viewing and Completing Pending Tasks

Viewing Completed Tasks

Working With a Particular Version of a Change Plan, Baseline, or Comparison

Exporting and Importing Change Plans, Baselines, and Comparisons

Required Privileges and Roles for Change Management Operations

Defining and Granting the CM_SELECT_ROLE Role in Oracle 8.x Databases

Receiving Error Messages About Objects That Do Not Exist

Receiving a Privilege Warning When You Generate and Run Change Plan Scripts

3 Using Plan Editor

Modifying and Creating Object Definitions with Plan Editor

Creating a Plan with Plan Editor

Understanding Change Requests

Understanding Directives

Understanding Scoped Directives

Understanding Exemplars

Understanding Modified Exemplars

Defining Change Requests with Plan Editor

Defining a Directive with Plan Editor

Defining a Scoped Directive with Plan Editor

Defining an Exemplar with Plan Editor

Creating a Modified Exemplar with Plan Editor

Selecting a Destination Database with Plan Editor

Understanding Script Generation

Generating a Script with Plan Editor

Viewing the Impact Report and Script Summary with Plan Editor

Understanding Script Execution

Executing the Script with Plan Editor

Dealing with Script Execution Errors

A Command Line Interface Appendix

Possible Uses for the Command Line Interface

Understanding the Notation Used for the Command Syntax

Requirements for Using the Command Line Interface

Understanding Case-Sensitivity Requirements for the Command Line Interface

Using the Command Line Interface with the Oracle Management Server

Scheduling the Execution of Command Line Interface Scripts

Using the Command Line Interface Commands

login command

logout command

capture command

compare command

generate command

execute command

Specifying the Direction in Which to Execute the Script

Specifying Completion Actions for a Script Execution

Examples of Using the Execute Command

Status Codes Returned by the Command Line Interface

B Troubleshooting Appendix

Using Environment Variables When Running Change Manager from the Command
Line

Enabling Tracing and Debugging for Oracle Change Management Pack

Index