Skip Headers
Oracle® Database Upgrade Guide
11g Release 2 (11.2)

Part Number E17222-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

Index

A  B  C  D  E  F  H  I  L  M  N  O  P  R  S  T  U  W  X 

Numerics

32-bit to 64-bit conversion. See word size

A

access control lists (ACLs)
granting access to network utility packages, 3.3.1.2
access control to network utility packages, A.2.13.2
access-control lists (ACLs)
changed behavior in 11g release 1 (11.1), A.2.15
applications
compatibility, 5.1.1
linking with newer libraries, 5.2.2.2.1
running against older server, 5.2.2.1.2
upgrading, 5
client/server configurations, 5.2.1
compatibility rules, 5.2.2
options, 5.2.3
relinking rules, 5.2.2
apxrelod.sql file
reloading after downgrade, 6.4
ASM
cluster ASM upgrade, 4.5.3
database upgrade after, 4.7.1
disk group compatibility, A.2.7
optional tasks after upgrade, 4.7
ASM_PREFERRED_READ_FAILURE_GROUPS, 4.6.3
automatic maintenance tasks management
AutoTask, A.2.5
Automatic Storage Management (ASM)
disk group compatibility, 4.6.2
file access control, 3.1.3.4
preferred read failure groups, 4.6.3
rolling upgrades
ASM, 1.6
upgrading, 3.1.3, 3.8
automatic undo management
migrating to, 4.2.1.8
UNDO_MANAGEMENT, A.2.20
AutoTask, A.2.5

B

backups
after upgrading, 4.2.1.1
before downgrading, 6.3
preparing a strategy, 2.1.6
binary XML storage, A.2.12

C

capturing and replaying database workload, 2.1.5.6.1
case sensitivity
for passwords, 4.2.1.2
catdwgrd.sql script, 6.4
CATRELOD.SQL script, 6.4, 6.4
CATUPGRD.SQL script, 3.7.3
change passwords
for oracle-supplied accounts, 4.3.1
client software
upgrading, 5.2.2.2
client-server configurations, 1.2.1
cluster ASM, 4.5.3
collecting optimizer statistics, B
command line options
for Database Upgrade Assistant, 3.6.1
commands
crsctl, 4.4.2.1
compatibility
applications, 5.1.1
checking for incompatibilities, 6.2
compatibility level, 1.3.1.1.3
COMPATIBLE initialization parameter, 1.3.1.1
downgrading, 1.3.1.1.1
original Export utility, 7.2.2
COMPATIBLE initialization parameter, 1.3.1.1, 4.6.2
checking, 1.3.1.1.3
database structures, 1.3.1.1.2
setting, 4.3.6.1
when to set, 1.3.1.1.4

D

data copying
using Export/Import, 7
data mining models, A.2.9
Data Pump
advantages of using, 2.1.3.3
Data Pump Export/Import
recommendations, 2.1.3.3, 7.1
versus Original Export/Import, 7.1
when to use, 7.1
Database Replay
database workloads before upgrading, 2.1.5.6.1
database upgrade
termination due to ORA_00904, 3.7.3
termination due to ORA_00942, 3.7.3
termination due to ORA_01722, 3.7.3
Database Upgrade Assistant (DBUA)
advantages, 2.1.3.1
command line options, 3.6.1
registering the database in the listener.ora file, 3.4
running, 3.5
silent mode, 3.6.1
starting, 3.5.1
database upgrade process
overview, 1.1
databases
downgrading, 6.4
upgrading, 1.1
upgrading the client software, 5.2.2.2
DB_BLOCK_SIZE
new default value, A.4.23
DB_BLOCK_SIZE initialization parameter
compatibility, A.4.23
DBMS_DST PL/SQL package
ORA-01822 error, 3.7.4.3
DBMS_STATS package
upgrading statistics tables, 4.1.4
DBMS_STATS procedure
use when creating a statistics table, B.2
DBUA. See Database Upgrade Assistant
Developer/2000 Applications
upgrading, 5.4
DGConnectIdentifier property, 4.2.1.9
direct upgrades, 2.1.2
disk group compatibility, 4.6.2
disks
specifying preferred read failure groups, 4.6.3
DMSYS schema objects, A.2.9
downgrading
backing up your database, 6.3
binary XML storage, A.2.12
CATRELOD.SQL, 6.4, 6.4
checking for incompatibilities, 6.2
ORADIM, 6.4
patchset releases, 6.1
procedure for, 6.4
scripts, 6.4
rerunning, 6.4
downstream capture
upgrading, 3.1.8
dump files
generated by export utilities, 7.2

E

enforcing case-sensitivity for passwords, 4.2.1.2
environment variables
required for upgrading, 3.7.3
evaluation of numeric literals, 5.3.1, A.4.21
export and import
recommendations, 2.1.3.3, 7.1
Export utility, 7.1
data copying, 7
requirements, 7.2
Export/Import
advantages and disadvantages, 2.1.3.3
benefits, 2.1.3.3.2
effects on upgraded databases, 2.1.3.3.1
incompatible data, 7.2.3
time requirements, 2.1.3.3.3
upgrading, 7.3
extended distance cluster configurations
preferred read disks, 4.6.3
extents
reading from secondary, 4.6.3
extusrupgrade, 4.1.5

F

FAILED_LOGIN_ATTEMPTS initialization parameter
DEFAULT limit, A.3.7
Fast Recovery Area, 3.7.4.1
file access control
with the SYSASM role, 3.1.3.4
fine-grained access control to network utility packages, 3.3.1.2
Forms
upgrading Oracle Forms applications, 5.4

H

Hardware Assisted Resilient Data (HARD)
upgrading systems, 4.3.6.1

I

Import utility, 7.1
data copying, 7
requirements, 7.2
importing
dump files for downgrades, 7.2
incompatibilities
checking for, 6.2
incompatible data
Export/Import, 7.2.3
initialization parameters
adjusting for Oracle Database 10g, 4.3.6
adjusting for Oracle Database 11g, 3.7.2
ASM_PREFERRED_READ_FAILURE_GROUPS, 4.6.3
compatibility
DB_BLOCK_SIZE, A.4.23
SESSION_CACHED_CURSORS, A.4.22
COMPATIBLE, 1.3.1.1
when to set, 1.3.1.1.4
initialization parameters, COMPATIBLE, 4.6.2
installation
Oracle Database 11g release 1 (11.1), 3.2
instances
starting after a downgrade, 6.4
INTEGER arithmetic
evaluation of numeric literals, 5.3.1, A.4.21
intermediate releases
upgrading, 2.1.2
interoperability, 1.3.2

L

listener.ora file
modifying, 3.4
listeners
modifying with Oracle Net Configuration Assistant, 3.4
load testing, 2.1.5.7
LocalListenerAddress property
Oracle Data Guard, 4.2.1.9
logical standby databases
rolling upgrades, 1.6
login
new DEFAULT limit, A.3.7

M

maintenance tasks
scheduling with AutoTask, A.2.5
manual upgrade
advantages, 2.1.3.2
backup the database, 3.7.1
OCR configuration, 4.3.5
migrating data
to a different operating system, 3.1.7
moving data with export/import, 7.1
multiversioning, 1.2.1
My Oracle Support
link to The Upgrade Companion web site, Preface, 1, 1, 2.1.5.4, 3.1.7

N

network utility packages
access control to, A.2.13.2
networks
granting ACL access to network utility packages, 3.3.1.2
new features
adding after upgrade, 4.2.1.5
NUMBER arithmetic
evaluation of numeric literals, 5.3.1, A.4.21
numeric computation
evaluation of numeric literals, 5.3.1, A.4.21
numeric literals
evaluating, 5.3.1, A.4.21

O

OCI application
statically-linked, 5.2.2.2.2
OCI applications
changing, 5.2.3.3.2
dynamically-linked, 5.2.2.2.3
upgrading, 5.2
upgrading options, 5.2.3
OFA, 1.4
one-off patches, 1.6
OPatch utility
rolling upgrades, 1.6
operating system
migrating data to, 3.1.7
Optimal Flexible Architecture. See OFA
optimizer statistics
collecting for dictionary objects, B
creating a table to collect, B.2
ORA_TZFILE
unsetting after downgrade, 6.4
ORA-00904
"TZ_VERSION"
invalid identifier, 3.7.3
ORA-00942
table or view does not exist, 3.7.3, 3.7.3
ORA-01408 error message, 3.7.4.2
ORA-01722
invalid number, 3.7.3
ORA-01822 error message, 3.7.4.3
Oracle Application Express
apexrelod.sql file, 6.4
update, 4.1.7
Oracle Application Express configuration, 4.1.7
Oracle ASM
installed with Oracle grid infrastructure, 3.1.2
Oracle Cluster Registry (OCR)
upgrading manually, 4.3.5
Oracle Clusterware
upgrading, 3.1.3
Oracle Data Guard
configuring broker properties, 4.2.1.9
rolling upgrades, 1.6
Oracle Database Express Edition
upgrading to Oracle Database, 1.9
Oracle Database XE
upgrading to Oracle Database, 1.9
Oracle Express Edition
recommended tasks after upgrade, 4.2.3
Oracle grid infrastructure home, 3.1.3
upgrading ASM instances, 1.6, 3.8
Oracle home
multiple, 1.2.1.1
Oracle Net Configuration Assistant, 3.4
Oracle Net Services
relinking, 5.1.1
Oracle Real Application Clusters
rolling upgrades with OPatch, 1.6
upgrading, 3.1.3
Oracle release numbers, 1.2
Oracle Restart
for single-instance databases, 3.1.3
Oracle Streams
downstream capture
upgrading, 3.1.8
Oracle Universal Installer, 1.1
Oracle XML Database
binary XML storage, A.2.12
oracle-supplied accounts
change passwords, 4.3.1
ORADIM
downgrading, 6.4
upgrading, 3.7.3
original Export utility
downward compatibility, 7.2.2
Original Export/Import
versus Data Pump Export/Import, 7.1
when to use, 7.1

P

passwords
case sensitive, 4.2.1.2
patchset releases
downgrading, 6.1
physical standby database
performing rolling upgrades, 1.6, 3.1.5
PLS-00306 error, 6.4
PL/SQL Native Compilation, A.2.13.1
post-upgrade status tool, 3.7.3, 3.7.3, 3.7.3, 3.7.3.1, 3.7.3.1
precompilers
applications
changing, 5.2.3.3.1
upgrading options, 5.2.3
upgrading applications, 5.2
preferred read failure groups
setting up, 4.6.3
preparing to upgrade
collecting optimizer statistics, B

R

recovery catalog
upgrading, 4.1.2
releases
definition, 1.2
multiple, 1.2.1
upgrade paths, 2.1.2
relinking with Oracle Net Services, 5.1.1
rollback segments
migrating to automatic undo management, 4.2.1.8
rolling upgrades
methods, 1.6
Oracle Real Application Clusters and OPatch, 1.6
to clustered ASM instances, 3.8
with logical standby databases, 3.1.5
with logical standby databases and SQL Apply, 1.6
with physical standby database, 1.6, 3.1.5
with SQL Apply and logical standby databases, 1.6, 3.1.5
running multiple Oracle releases on the same computer, 1.2.1

S

scheduling
AutoTask, A.2.5
schemas
collecting system component statistics, B.1
scripts
downgrading, 6.4
rerunning, 6.4
upgrading, 3.3, 3.7.3, 3.7.3
security
case-sensitive passwords, 4.2.1.2
server parameter file
migrating to, 4.3.3
SESSION_CACHED_CURSORS
change in behavior, A.4.22
SESSION_CACHED_CURSORS initialization parameter
compatibility, A.4.22
shared pool subpools, A.4.27
SHARED_POOL_SIZE in Oracle Database 10g Release 1 (10.1), A.4.27
single-instance ASM upgrade
ASM
single-instance upgrade, 4.5.2
SPFILE
upgrading systems with HARD-compliant storage, 4.3.6.1
SPNC_COMMANDS file
release 10.1, A.4.20
SQL Access Advisor, A.2.17
SQL Apply
performing rolling upgrades, 1.6, 3.1.5
SQL Management Base (SMB), 2.1.5.6.3
SQL Performance Analyzer, 2.1.5.6.2
SQL plan baseline, A.2.11
SQL plan management, 2.1.5.6.3, 2.1.5.6.3, A.2.11
SQL Tuning Set (STS), 2.1.5.6.3
SQL*Plus
scripts
upgrading, 5.3
Standard Edition
moving to Enterprise Edition, 1.7
starter database, A.2.18
STARTUP UPGRADE command, 6.4
statistics
collecting for dictionary objects, B
collecting for system component schemas, B.1
creating a table for, B.2
importing with DBMS_STATS PL/SQL procedure, B.2
statistics tables
upgrading, 4.1.4
status tools
for upgrades and post-upgrade, 3.7.3, 3.7.3, 3.7.3, 3.7.3.1, 3.7.3.1
subpools, A.4.27
SYSASM Privilege, A.2.6
SYSASM role
ASM file access control, 3.1.3.4
system component schemas
collecting statistics for, B.1

T

testing
applications for upgrade, 2.3, 4.2.1.11
developing a plan, 2.1.5
functional for upgrade, 2.1.5.3
high availability for upgrading, 2.1.5.4
integration for upgrading, 2.1.5.5
minimal for upgrade, 2.1.5.2
performance for upgrade, 2.1.5.6
the upgrade process, 2.2
the upgraded test database, 2.3
using Database Replay, 2.1.5.6.1
volume/load stress for upgrade, 2.1.5.7
time zone file
unsetting after downgrade, 6.4
time zone file version mismatch, 3.7.4.3
TIMESTAMP WITH TIMEZONE data type, 3.3.1.4
troubleshooting
upgrades, 3.7.4

U

UNDO_MANAGEMENT initialization parameter, 4.2.1.8
default, A.2.20
Upgrade Companion
link to web site from My Oracle Support, Preface, 1, 1, 2.1.5.4, 3.1.7
upgrade methods
choosing, 2.1.3
Database Upgrade Assistant, 1.1, 2.1.3.1
Export/Import, 2.1.3.3, 7.3
manual, 2.1.3.2, 3.7
silent mode, 3.6.1
upgrade paths, 2.1.2
upgrade status tool, 3.7.3, 3.7.3, 3.7.3, 3.7.3.1, 3.7.3.1
upgrading
abandoning, 3.7.5
applications, 5
compatibility rules, 5.2.2
options, 5.2.3
relinking, 5.2.2
ASM, 3.1.3
backup strategy, 2.1.6
binary XML storage, A.2.12
initialization parameters, 3.7.2
new administrative procedures, 4.2.1.6
Oracle Application Express, 4.1.7
Oracle Clusterware, 3.1.3
Oracle Forms applications, 5.4
Oracle Real Application Clusters, 3.1.3
ORADIM, 3.7.3
post upgrade actions, 4
preparation, 2.1
recovery catalog, 4.1.2
rolling upgrades, 1.6
running the CATUPGRD.SQL script, 3.7.3
scripts, 3.3, 3.7.3, 3.7.3
SQL*Plus scripts, 5.3
statistics tables, 4.1.4
testing, 2.1.5
troubleshooting, 3.7.4
using the Database Upgrade Assistant, 3.5
when to set the COMPATIBLE initialization parameter, 1.3.1.1.4
utlu112s.sql
example, 3.7.3, 3.7.3, 3.7.3, 3.7.3.1, 3.7.3.1

W

word size
64-bit software, 1.5
workloads
capturing and replaying, 2.1.5.6.1

X

xsrelod.sql script, 6.4