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.4.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, 6.5.4

ASM

cluster ASM upgrade, 4.4.3

database upgrade after, 4.6.1

disk group compatibility, A.2.7

optional tasks after upgrade, 4.6

ASM_PREFERRED_READ_FAILURE_GROUPS, 4.5.3

automatic maintenance tasks management

AutoTask, A.2.5

Automatic Storage Management (ASM)

disk group compatibility, 4.5.2

file access control, 3.1.2.2

post-upgrade topics, 4.2.1.3

preferred read failure groups, 4.5.3

rolling upgrades

ASM, 1.6

upgrading, 3.1.2, 3.8

automatic undo management

migrating to, 4.2.1.7

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.4.3

collecting optimizer statistics, B

command line options

for Database Upgrade Assistant, 3.6.2

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

checking, 1.3.1.1.3

database structures, 1.3.1.1.2

setting, 4.3.5.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.2

registering the database in the listener.ora file, 3.5

running, 3.6

silent mode, 3.6.2

starting, 3.6.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.8

direct upgrades, 2.1.2

disk group compatibility, 4.5.2

disks

specifying preferred read failure groups, 4.5.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.7

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, 3.8.1.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.5.3

extents

reading from secondary, 4.5.3

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.2.2

fine-grained access control to network utility packages, 3.4.1.2

Forms

upgrading Oracle Forms applications, 5.4

H

Hardware Assisted Resilient Data (HARD)

upgrading systems, 4.3.5.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, 3.8.1.2, 4.3.5

adjusting for Oracle Database 11g, 3.7.2

ASM_PREFERRED_READ_FAILURE_GROUPS, 4.5.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

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.5

listeners

modifying with Oracle Net Configuration Assistant, 3.5

load testing, 2.1.5.7

LocalListenerAddress property

Oracle Data Guard, 4.2.1.8

logical standby databases

rolling upgrades, 1.6

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.4

migrating data

to a different operating system, 3.1.6

moving data with export/import, 7.1

multiversioning, 1.2.1

My Oracle Support

link to The Upgrade Companion web site, Preface, 1, 2.1.5.4, 3.1.6

N

network utility packages

access control to, A.2.13.2

networks

granting ACL access to network utility packages, 3.4.1.2

new features

adding after upgrade, 4.2.1.4

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.6

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, 6.5.4

reloading after downgrade, 6.5.4

update, 4.1.7

Oracle Application Express configuration, 4.1.7

Oracle ASM

installed with Oracle grid infrastructure, 3.1.1

Oracle Cluster Registry (OCR)

upgrading manually, 4.3.4

Oracle Clusterware

upgrading, 3.1.2

Oracle Clusterware configuration

downgrade, 6.5.1

Oracle Data Guard

configuring broker properties, 4.2.1.8

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.2

upgrading ASM instances, 1.6, 3.8

Oracle home

multiple, 1.2.1.1

Oracle Net Configuration Assistant, 3.5

Oracle Net Services

relinking, 5.1.1

Oracle Real Application Clusters

rolling upgrades with OPatch, 1.6

upgrading, 3.1.2

Oracle release numbers, 1.2

Oracle Restart

for single-instance databases, 3.1.2

Oracle Streams

downstream capture

upgrading, 3.1.7

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, 3.8.1.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.4

PLS-00306 error, 6.4

PL/SQL Native Compilation, A.2.13.1

post-upgrade status tool, 3.7.3

precompilers

applications

changing, 5.2.3.3.1

upgrading options, 5.2.3

upgrading applications, 5.2

preferred read failure groups

setting up, 4.5.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.7

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.4

with logical standby databases and SQL Apply, 1.6

with physical standby database, 1.6, 3.1.4

with SQL Apply and logical standby databases, 1.6, 3.1.4

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.4, 3.7.3, 3.7.3

security

case-sensitive passwords, 4.2.1.2

server parameter file

migrating to, 4.3.2

SESSION_CACHED_CURSORS

change in behavior, A.4.22

SESSION_CACHED_CURSORS initialization parameter

compatibility, A.4.22

single-instance ASM upgrade

ASM

single-instance upgrade, 4.4.2

SPFILE

upgrading systems with HARD-compliant storage, 4.3.5.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.4

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

SYSASM Privilege, A.2.6

SYSASM role

ASM file access control, 3.1.2.2

system component schemas

collecting statistics for, B.1

T

testing

applications for upgrade, 2.3, 4.2.1.10

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.4.1.4

troubleshooting

upgrades, 3.7.4

U

UNDO_MANAGEMENT initialization parameter, 4.2.1.7

default, A.2.20

Upgrade Companion

link to web site from My Oracle Support, Preface, 1, 2.1.5.4, 3.1.6

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.2

upgrade paths, 2.1.2

upgrade status tool, 3.7.3

upgrading

abandoning, 3.7.5

applications, 5

compatibility rules, 5.2.2

options, 5.2.3

relinking, 5.2.2

ASM, 3.1.2

backup strategy, 2.1.6

binary XML storage, A.2.12

initialization parameters, 3.7.2, 3.8.1.2

new administrative procedures, 4.2.1.5

Oracle Application Express, 4.1.7

Oracle Clusterware, 3.1.2

Oracle Forms applications, 5.4

Oracle Real Application Clusters, 3.1.2

ORADIM, 3.7.3, 3.8.1.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.4, 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.6

when to set the COMPATIBLE initialization parameter, 1.3.1.1.4

utlu112s.sql

example, 3.7.3

W

word size

64-bit software, 1.5

workloads

capturing and replaying, 2.1.5.6.1

X

xsrelod.sql script, 6.4