Oracle(R) Enterprise Manager Getting Started with Oracle(R) Change Management Pack
Release 2.1
A76919-01
Library
Product
Contents
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
A
attribute changes not undone by a recovery script, 3-17
attributes
for an exemplar
viewing, 3-10
B
baseline
capturing definitions using DB Capture, 1-9
capturing definitions using the command line interface, A-4
creating, 2-4
creating a new version, 2-5
creating using the command line interface, A-4
definition of, 1-6
deleting, 2-4
deleting a previous version of, 2-5
exporting, 2-4,
2-11
importing, 2-5,
2-11
viewing, 1-10,
2-4
viewing a previous version of, 2-5
viewing history entries for, 2-5
working with a particular version of, 2-10
Baseline Viewer application
function of, 1-8
overview of, 1-10
C
change applications, 1-8
change management applications
starting from Change Manager, 2-3
change management objects, 1-6
copying from one repository to another, 2-11
change management task
history entry for, 1-2
Change Manager application
function of, 1-9
overview of, 1-17
right mouse button support for, 2-3
running from the command line, B-2
starting, 2-1
starting DBA Studio from, 2-4
starting other applications from, 2-3
change plan
creating, 2-7,
3-2
creating a new version, 2-7
defining change requests for, 3-3
definition of, 1-6
deleting, 2-7
deleting a previous version, 2-7
editing and modifying, 2-7
excluding grants from, 3-10
exporting, 2-7,
2-11
generating a script from, 3-12
generating a script using the command line interface, A-5
importing, 2-7,
2-11
including grants in, 3-10
naming, 3-2
renaming, 2-7
selecting a destination database for, 3-11
selecting the source database for, 3-2
viewing a previous version, 2-7
viewing history entries for, 2-7
working with a particular version of, 2-10
changes
for which undo operations are not present in the recovery script, 3-17
making, 1-7
tracking, 1-7
command line
running Change Manager from, B-2
command line interface
capture command, A-4
compare command, A-4
creating a baseline using, A-4
creating a comparison using, A-4
de-establishing administrator credentials for, A-4
entering commands in a .BAT file, A-2
establishing administrator credentials for, A-3
execute command, A-5
examples of, A-7
executing a script using, A-5
exit status codes returned by, A-8
generate command, A-5
generating a script using, A-5
login command, A-3
logout command, A-4
overview of commands, A-3
requirements for using, A-2
specifying completion actions for a script execution, A-6
specifying the direction in which to execute a script, A-6
understanding the notation for command syntax, A-2
using, 1-3,
A-1
comparison
creating, 2-5
creating a new version of, 2-6
creating using the command line interface, A-4
creating, naming, saving, and viewing, 1-11
definition of, 1-7
deleting, 2-6
deleting a previous version of, 2-6
exporting, 2-6,
2-11
importing, 2-6,
2-11
viewing, 2-5
viewing a previous version of, 2-6
viewing history entries for, 2-6
working with a particular version of, 2-10
completed task
refreshing the display, 2-10
viewing, 2-10
completing
pending task, 2-9
conceptual help topics
accessing, 1-24
explained, 1-23
Contents page for help
accessing, 1-23
context-sensitive help
accessing, 1-23
copying
change management objects to a different repository, 2-11
object definitions to a destination database, 1-12,
1-14
table definitions and data to a destination database, 1-15,
3-11
creating
a new version of a baseline, 2-5
a new version of a change plan, 2-7
a new version of a comparison, 2-6
baseline, 2-4
change plan, 2-7
comparison, 2-5
D
DB Alter application
function of, 1-9
overview of, 1-14
DB Capture application
capturing definitions in a baseline, 1-9
capturing definitions in SQL DDL format, 1-10
function of, 1-8
overview of, 1-9
DB Diff application
function of, 1-8
overview of, 1-11
DB Propagate application
function of, 1-9
overview of, 1-14
DB Quick Change application
function of, 1-9
overview of, 1-13
DB Search application
function of, 1-8
overview of, 1-16
DBA Studio
starting from Change Manager, 2-4
deleting
a previous version of a baseline, 2-5
a previous version of a change plan, 2-7
a previous version of a comparison, 2-6
a task from the History page, 2-10
baseline, 2-4
change plan, 2-7
comparison, 2-6
dependency object definition
adding to a plan, 3-11
definition of, 3-10
viewing for an exemplar, 3-10
dependent object definition
adding to a plan, 3-10
definition of, 3-11
viewing for an exemplar, 3-10
destination database
generating a script for, 3-12
selecting, 3-11
directive
applications used to create, 3-4
defining, 3-5
definition of, 3-3
extending the scope of, 3-4
viewing the changes specified by, 3-6
drag and drop copying of object definitions, 1-15
E
executing
a script, 1-21,
3-16
a script using the command line interface, A-5
exemplar
actions performed at a destination database, 3-8
applications used to create, 3-4
defining, 3-9
definition of, 3-4
viewing attributes for, 3-10
viewing dependency object definitions for, 3-10
viewing dependent object definitions for, 3-10
viewing grants for, 3-10
exit status codes
returned by command line interface, A-8
exporting
baseline, 2-4,
2-11
change plan, 2-7,
2-11
comparison, 2-6,
2-11
F
failure prediction during script generation, 3-18
finding object definitions that meet a set of criteria, 1-16
G
generating
a script, 1-21,
3-12
a script using the command line interface, A-5
glossary
accessing, 1-24
grants
for an exemplar
excluding from a change plan, 3-10
including in a change plan, 3-10
viewing, 3-10
H
help
accessing the glossary, 1-24
displaying the Contents page, 1-23
finding a particular type of topic, 1-23
finding a specific topic, 1-23
locating a conceptual or task topic, 1-23
obtaining for a particular context, 1-23
using, 1-22
history entries
for change management tasks, 1-2
saving to a file, 2-9,
2-10
sorting on the History page, 2-10
sorting on the Pending page, 2-9
viewing for a change plan, 2-7
viewing for a comparison, 2-6
viewing for a task, 2-8
History page
manually moving a pending task to, 2-9
removing a task, 2-10
viewing new history entries for, 2-10
I
impact
for a script
determining prior to execution, 3-15
importing
baseline, 2-5,
2-11
change plan, 2-7,
2-11
comparison, 2-6,
2-11
J
job system
using to execute a script, 3-17
L
log (trace) files
location of, B-4
M
mapping schemas, 3-13
modifying
change plan, 2-7
object definitions using Plan Editor, 3-1
O
object definitions
basic steps for changing, 1-19
capturing using DB Capture, 1-9
capturing using the command line interface, A-4
changes that cannot be undone using the recovery script, 3-17
comparing using DB Diff, 1-11
comparing using the command line interface, A-4
copying table definitions and data, 3-11
copying using drag and drop, 1-15
keeping changes made to, 3-16
making changes to definitions in one or more databases, 1-14
making one or more changes to one definition, 1-13
modifying using Plan Editor, 3-1
reproducing, 3-8
reproducing one or more object definitions in one or more databases, 1-14
searching for, 1-16
specifying changes for, 3-5
supported by change management applications, 1-4
synchronizing one set with another, 1-12
undoing changes made to, 3-16
viewing differences between, 1-11
viewing the changes specified for, 3-6
objects
created by change management applications, 1-6
obsolete script, 3-12
OCM_FAILURE_PREDICTION property
enabling to predict script execution failures, 3-18
ocm.properties file
description of properties, B-3
location of, B-2
using to enable tracing and debugging for applications, B-2
Oracle Enterprise Manager repository
copying change management objects, 2-11
P
pending task
completing, 2-9
manually moving to the History page, 2-9
refreshing the display, 2-9
saving history entries to a file, 2-9
viewing, 2-9
plan
viewing and modifying the propagate options for, 3-11
Plan Editor application
modifying and creating object definitions using, 3-1
overview of, 1-16
right mouse button support for, 3-2
predicting script execution failures, 3-18
propagate options
viewing and modifying, 3-11
Q
Quick Tour
starting, 1-18
R
recovery script
attribute changes not undone by, 3-17
refreshing
list of completed tasks, 2-10
list of pending tasks, 2-9
removing
a task from the History page, 2-10
renaming
change plan, 2-7
reproducing
object definitions at a destination database, 1-12,
1-14
table definitions and data at a destination database, 1-15,
3-11
right mouse button support
for Change Manager, 2-3
for Plan Editor, 3-2
rolling back script changes, 3-16
S
schema mapping, 3-13
scoped directive
creating, 3-7
definition of, 3-4,
3-6
scratch tablespace
specifying for script operations that require temporary data storage, 3-13
script
dealing with problems in, 3-15
determing impact of prior to execution, 3-15
editing, 3-15
enabling failure prediction during generation, 3-18
executing, 3-16
executing using the command line interface, A-5
executing using the job system, 3-17
executing using the Oracle Enterprise Manager job system, 3-17
generating for a destination database, 3-12
generating for a destination database using the command line interface, A-5
keeping changes made by, 3-16
obsolete, 3-12
stale, 3-18
undoing changes made by, 3-16
viewing a summary of, 3-15
viewing the results after executing a, 3-16
searching for object definitions that match a set of criteria, 1-16
sorting
history entries for completed tasks or manually moved pending tasks, 2-10
history entries for pending tasks, 2-9
SQL statements
capturing definitions using DB Capture, 1-10
stale script, 3-18
starting
change management applications from Change Manager, 2-3
Change Manager, 2-1
Synchronization wizard, 1-12
the Quick Tour, 1-18
supported database objects, 1-4
Synchronization wizard application
function of, 1-9
starting, 1-12
synchronizing
one set of object definitions with another, 1-12
T
task
completing pending, 2-9
history entry for, 1-2
manually moving a pending task to the History page, 2-9
removing from the History page, 2-10
viewing completed, 2-10
viewing history entries for, 2-8
viewing new completed tasks, 2-10
viewing pending, 2-9
task help topics
accessing, 1-24
explained, 1-24
trace files
location of, B-4
tracking applications, 1-8
tracking changes, 1-7
troubleshooting
script execution errors, 3-18
script execution failures, 3-18
using the ocm.properties file, B-2
U
undoing script changes, 3-16
updating
list of completed tasks, 2-10
list of pending tasks, 2-9
usage scenarios
for change management applications, 1-18
V
version
baseline, 2-10
change plan, 2-10
comparison, 2-10
viewing
a previous version of a baseline, 2-5
a previous version of a change plan, 2-7
a previous version of a comparison, 2-6
baseline, 2-4
change plan, 2-7
comparison, 2-5
completed task, 2-10
history entries for a baseline, 2-5
history entries for a change plan, 2-7
history entries for a comparison, 2-6
pending task, 2-9
Prev
Copyright © 2000 Oracle Corporation.
All Rights Reserved.
Library
Product
Contents