Index

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

Numerics

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

A

access control to network utility packages, 5.4.9.2

access-control lists (ACLs)

changed behavior in 11g release 1 (11.1), 5.4.11

applications

compatibility, 6.1.1

linking with newer libraries, 6.2.2.2.1

running against older server, 6.2.2.1.2

upgrading, 6

client/server configurations, 6.2.1

compatibility rules, 6.2.2

options, 6.2.3

relinking rules, 6.2.2

ASM

cluster ASM upgrade, 4.6.2

database upgrade after, 4.6.3

disk group compatibility, 5.4.3

optional tasks after upgrade, 4.6

ASM_PREFERRED_READ_FAILURE_GROUPS, 4.5.3

automatic maintenance tasks management

AutoTask, 5.4.1

Automatic Storage Management (ASM)

disk group compatibility, 4.5.2

file access control, 3.1.1.2

post-upgrade topics, 4.2.1.3

preferred read failure groups, 4.5.3

rolling upgrade, 1.5

upgrading, 3.1.1

automatic undo management

migrating to, 4.2.1.7

UNDO_MANAGEMENT, A.2.1.1

AutoTask, 5.4.1

B

backups

after upgrading, 4.2.1.1

before downgrading, 7.3

preparing a strategy, 2.1.6

binary XML storage, 5.4.8

C

capturing and replaying database workload, 2.1.5.5.1

case sensitivity

for passwords, 4.2.1.2

catdwgrd.sql script, 7.4

CATRELOD.SQL script, 7.4

CATUPGRD.SQL script, 3.8.3

change passwords

for oracle-supplied accounts, 4.3.1

client software

upgrading, 6.2.2.2

client-server configurations, 1.2.1

cluster ASM, 4.6.2

collecting optimizer statistics, B

command line options

for Database Upgrade Assistant, 3.7.2

compatibility

applications, 6.1.1

checking for incompatibilities, 7.2

compatibility level, 5.1.1.3

COMPATIBLE initialization parameter, 5.1.1

downgrading, 5.1.1.1

initialization parameters, A.2

original Export utility, 8.2.2

COMPATIBLE initialization parameter, 5.1.1

checking, 5.1.1.4

database structures, 5.1.1.2

setting, 5.1.2

when to set, 5.1.1.5

D

data copying

using Export/Import, 8

data mining models, 5.4.5

Data Pump

advantages of using, 2.1.3.3

Data Pump Export/Import

recommendations, 2.1.3.3, 8.1

versus Original Export/Import, 8.1

when to use, 8.1

data type

NCHAR, 5.6.13

Database Replay

database workloads before upgrading, 2.1.5.5.1

Database Upgrade Assistant (DBUA)

advantages, 2.1.3.1

command line options, 3.7.2

Oracle RAC enhancements, Preface

registering the database in the listener.ora file, 3.6

running, 3.7

silent mode, 3.7.2

single-instance database enhancements, Preface

single-instance database enhancements 11g, Preface

starting, 3.7.1

database upgrade process

overview, 1.1

Database Vault Administrator

deploy manually, 4.1.9

databases

downgrading, 7.4

upgrading, 1.1

upgrading the client software, 6.2.2.2

DB_BLOCK_SIZE

new default value, A.2.2.2

DB_BLOCK_SIZE initialization parameter

compatibility, A.2.2.2

DBMS_STATS package

upgrading statistics tables, 4.1.3

DBMS_STATS procedure

use when creating a statistics table, B.2

DBUA. See Database Upgrade Assistant

deprecated dynamic performance views, A.4.1

deprecated features

initialization parameters, A.1.1

static data dictionary views, A.3.1

Developer/2000 Applications

upgrading, 6.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, 5.4.5

downgrading

backing up your database, 7.3

binary XML storage, 5.4.8

CATRELOD.SQL, 7.4

checking for incompatibilities, 7.2

ORADIM, 7.4

patchset releases, 7.1

procedure for, 7.4

scripts, 7.4

rerunning, 7.4

downstream capture

upgrading, 3.1.6

dump files

generated by export utilities, 8.2

dynamic performance views

changes, A.4

deprecated, A.4.1

obsolete, A.4.2

with dropped columns, A.4.4

with renamed columns, A.4.3

E

enforcing case-sensitivity for passwords, 4.2.1.2

environment variables

required for upgrading, 3.8.3, 3.10.3

evaluation of numeric literals, 5.6.15, 6.3.1

export and import

recommendations, 2.1.3.3, 8.1

Export utility, 8.1

data copying, 8

requirements, 8.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, 8.2.3

time requirements, 2.1.3.3.3

upgrading, 8.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, 5.5.4

file access control

with the SYSASM role, 3.1.1.2

Flash Recovery Area, 3.8.4.1

Forms

upgrading Oracle Forms applications, 6.4

H

Hardware Assisted Resilient Data (HARD)

upgrading systems, 5.1.2

I

Import utility, 8.1

data copying, 8

requirements, 8.2

importing

dump files for downgrades, 8.2

incompatibilities

checking for, 7.2

incompatible data

Export/Import, 8.2.3

initialization parameters

adjusting for Oracle Database 10g, 3.8.2, 3.10.2, 4.3.5

ASM_PREFERRED_READ_FAILURE_GROUPS, 4.5.3

changes, A.1

compatibility, A.2

DB_BLOCK_SIZE, A.2.2.2

SESSION_CACHED_CURSORS, A.2.2.1

COMPATIBLE, 5.1.1

when to set, 5.1.1.5

deprecated, A.1.1

obsolete, A.1.2

INIT.ORA parameters. See initialization parameters

installation

Oracle Database 11g release 1 (11.1), 3.2

instances

starting after a downgrade, 7.4

INTEGER arithmetic

evaluation of numeric literals, 5.6.15, 6.3.1

intermediate releases

upgrading, 2.1.2

interoperability, 5.2

L

listener.ora file

modifying, 3.6

listeners

modifying with Oracle Net Configuration Assistant, 3.6

load testing, 2.1.5.6

LocalListenerAddress property

Oracle Data Guard, 4.2.1.8

logical standby databases

rolling upgrades, 1.5

new DEFAULT limit, 5.5.4

M

maintenance tasks

scheduling with AutoTask, 5.4.1

manual upgrade

advantages, 2.1.3.2

backup the database, 3.8.1

OCR configuration, 4.3.4

migrating data

to a different operating system, 3.1.5

moving data with export/import, 8.1

multiversioning, 1.2.1

N

NCHAR data type

limitations, 5.6.13

network utility packages

access control to, 5.4.9.2

new features

adding after upgrade, 4.2.1.4

NUMBER arithmetic

evaluation of numeric literals, 5.6.15, 6.3.1

numeric computation

evaluation of numeric literals, 5.6.15, 6.3.1

numeric literals

evaluating, 5.6.15, 6.3.1

O

obsolete features

dynamic performance views, A.4.2

initialization parameters, A.1.2

static data dictionary views, A.3.2

OCI application

statically-linked, 6.2.2.2.2

OCI applications

changing, 6.2.3.3.2

dynamically-linked, 6.2.2.2.3

upgrading, 6.2

upgrading options, 6.2.3

OFA, 1.3

one-off patches, 1.5

OPatch utility

rolling upgrades, 1.5

operating system

migrating data to, 3.1.5

Optimal Flexible Architecture. See OFA

optimizer statistics

collecting for dictionary objects, B

creating a table to collect, B.2

Oracle Application Express

update, 4.1.6

Oracle Application Express configuration, 4.1.6

Oracle Cluster Registry (OCR)

upgrading manually, 4.3.4

Oracle Clusterware

upgrading, 3.1.1

Oracle Clusterware configuration

downgrade, 7.5.1

Oracle Data Guard

configuring broker properties, 4.2.1.8

rolling upgrades, 1.5

Oracle Database Express Edition

upgrading to Oracle Database, 1.7

Oracle Database XE

upgrading to Oracle Database, 1.7

Oracle Express Edition

recommended tasks after upgrade, 4.2.3

Oracle home

multiple, 1.2.1.1

Oracle Net Configuration Assistant, 3.6

Oracle Net Services

relinking, 6.1.1

Oracle Real Application Clusters

11gR1 enhancements, Preface

rolling upgrades with OPatch, 1.5

upgrading, 3.1.1

Oracle release numbers, 1.2

Oracle Streams

downstream capture

upgrading, 3.1.6

rolling upgrades, 1.5

Oracle Universal Installer, 1.1

Oracle XML Database

binary XML storage, 5.4.8

oracle-supplied accounts

change passwords, 4.3.1

ORADIM

downgrading, 7.4

upgrading, 3.8.3, 3.10.3

original Export utility

downward compatibility, 8.2.2

Original Export/Import

versus Data Pump Export/Import, 8.1

when to use, 8.1

P

passwords

case sensitive, 4.2.1.2

patchset releases

downgrading, 7.1

PL/SQL Native Compilation, 5.4.9.1

post-upgrade status tool, 3.8.3

precompilers

applications

changing, 6.2.3.3.1

upgrading options, 6.2.3

upgrading applications, 6.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, 6.1.1

rollback segments

migrating to automatic undo management, 4.2.1.7

rolling upgrades, 1.5

Oracle Real Application Clusters and OPatch, 1.5

with logical standby databases and SQL Apply, 1.5

with Streams, 1.5

running multiple Oracle releases on the same computer, 1.2.1

S

scheduling

AutoTask, 5.4.1

schemas

collecting system component statistics, B.1

scripts

downgrading, 7.4

rerunning, 7.4

upgrading, 3.4, 3.8.3, 3.8.3

security

case-sensitive passwords, 4.2.1.2

server parameter file

migrating to, 4.3.2

SESSION_CACHED_CURSORS

change in behavior, A.2.2.1

SESSION_CACHED_CURSORS initialization parameter

compatibility, A.2.2.1

single-instance ASM upgrade

ASM

single-instance upgrade, 4.6.1

SPFILE

upgrading systems with HARD-compliant storage, 5.1.2

SPNC_COMMANDS file

release 10.1, 5.6.14

SQL Access Advisor, 5.4.13

SQL Performance Analyzer, 2.1.5.5.2

SQL plan baseline, 5.4.7

SQL plan management, 2.1.5.5.3, 5.4.7

SQL*Plus

scripts

upgrading, 6.3

Standard Edition

moving to Enterprise Edition, 1.6

starter database, 5.4.14

STARTUP UPGRADE command, 7.4

static data dictionary views

changes, A.3

deprecated, A.3.1

obsolete, A.3.2

with dropped columns, A.3.3

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

status tools

for upgrades and post-upgrade, 3.8.3

SYSASM Privilege, 5.4.2

SYSASM role

ASM file access control, 3.1.1.2

system component schemas

collecting statistics for, B.1

T

testing

applications for upgrade, 2.3

developing a plan, 2.1.5

functional for upgrade, 2.1.5.3

integration for upgrading, 2.1.5.4

minimal for upgrade, 2.1.5.2

performance for upgrade, 2.1.5.5

the upgrade process, 2.2

the upgraded test database, 2.3

using Database Replay, 2.1.5.5.1

volume/load stress for upgrade, 2.1.5.6

TIMESTAMP WITH TIMEZONE data type, 3.5.3

troubleshooting

upgrades, 3.8.4

U

UNDO_MANAGEMENT initialization parameter, 4.2.1.7

default, A.2.1.1

upgrade methods

choosing, 2.1.3

Database Upgrade Assistant, 1.1, 2.1.3.1

Export/Import, 2.1.3.3, 8.3

manual, 2.1.3.2, 3.8

silent mode, 3.7.2

upgrade paths, 2.1.2

upgrade status tool, 3.8.3

upgrading

abandoning, 3.8.5

applications, 6

compatibility rules, 6.2.2

options, 6.2.3

relinking, 6.2.2

ASM, 1.5, 3.1.1

backup strategy, 2.1.6

binary XML storage, 5.4.8

initialization parameters, 3.8.2, 3.10.2

new administrative procedures, 4.2.1.5

Oracle Application Express, 4.1.6

Oracle Clusterware, 3.1.1

Oracle Forms applications, 6.4

Oracle Real Application Clusters, 3.1.1

ORADIM, 3.8.3, 3.10.3

post upgrade actions, 4

preparation, 2.1

recovery catalog, 4.1.2

rolling upgrades, 1.5

running the CATUPGRD.SQL script, 3.8.3

scripts, 3.4, 3.8.3, 3.8.3

SQL*Plus scripts, 6.3

statistics tables, 4.1.3

testing, 2.1.5

troubleshooting, 3.8.4

using the Database Upgrade Assistant, 3.7

when to set the COMPATIBLE initialization parameter, 5.1.1.5

utlu111s.sql

example, 3.8.3

W

word size

64-bit software, 1.4

workloads

capturing and replaying, 2.1.5.5.1