Skip Headers
Oracle® Database Upgrade Guide
11g Release 1 (11.1)

B28300-03
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
PDF · Mobi · ePub

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 lists (ACLs)
granting access to network utility packages, 3.5.2
access control to network utility packages, A.1.13.2
access-control lists (ACLs)
changed behavior in 11g release 1 (11.1), A.1.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
ASM
cluster ASM upgrade, 4.4.3
database upgrade after, 4.6.1
disk group compatibility, A.1.7
optional tasks after upgrade, 4.6
ASM_PREFERRED_READ_FAILURE_GROUPS, 4.5.3
automatic maintenance tasks management
AutoTask, A.1.5
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.6
upgrading, 3.1.1
automatic undo management
migrating to, 4.2.1.7
UNDO_MANAGEMENT, A.1.20
AutoTask, A.1.5

B

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

C

capturing and replaying database workload, 2.1.5.5.1
case sensitivity
for passwords, 4.2.1.2
catdwgrd.sql script, 6.4
CATRELOD.SQL script, 6.4
CATUPGRD.SQL script, 3.8.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.7.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.1.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
data type
NCHAR, A.3.19
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, 6.4
upgrading, 1.1
upgrading the client software, 5.2.2.2
DB_BLOCK_SIZE
new default value, A.3.23
DB_BLOCK_SIZE initialization parameter
compatibility, A.3.23
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
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.1.9
downgrading
backing up your database, 6.3
binary XML storage, A.1.12
CATRELOD.SQL, 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.6
dump files
generated by export utilities, 7.2

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.3.1, A.3.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.2.7
file access control
with the SYSASM role, 3.1.1.2
fine-grained access control to network utility packages, 3.5.2
Flash Recovery Area, 3.8.4.1
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.2, 3.10.2, 4.3.5
ASM_PREFERRED_READ_FAILURE_GROUPS, 4.5.3
compatibility
DB_BLOCK_SIZE, A.3.23
SESSION_CACHED_CURSORS, A.3.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.3.21
intermediate releases
upgrading, 2.1.2
interoperability, 1.3.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.6
login
new DEFAULT limit, A.2.7

M

maintenance tasks
scheduling with AutoTask, A.1.5
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, 7.1
multiversioning, 1.2.1

N

NCHAR data type
limitations, A.3.19
network utility packages
access control to, A.1.13.2
networks
granting ACL access to network utility packages, 3.5.2
new features
adding after upgrade, 4.2.1.4
NUMBER arithmetic
evaluation of numeric literals, 5.3.1, A.3.21
numeric computation
evaluation of numeric literals, 5.3.1, A.3.21
numeric literals
evaluating, 5.3.1, A.3.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.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, 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 home
multiple, 1.2.1.1
Oracle Net Configuration Assistant, 3.6
Oracle Net Services
relinking, 5.1.1
Oracle Real Application Clusters
11gR1 enhancements, Preface
rolling upgrades with OPatch, 1.6
upgrading, 3.1.1
Oracle release numbers, 1.2
Oracle Streams
downstream capture
upgrading, 3.1.6
rolling upgrades, 1.6
Oracle Universal Installer, 1.1
Oracle XML Database
binary XML storage, A.1.12
OracleMetalink
link to The Upgrade Companion web site, 1, 3.1.5
oracle-supplied accounts
change passwords, 4.3.1
ORADIM
downgrading, 6.4
upgrading, 3.8.3, 3.10.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
PL/SQL Native Compilation, A.1.13.1
post-upgrade status tool, 3.8.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, 1.6
Oracle Real Application Clusters and OPatch, 1.6
with logical standby databases and SQL Apply, 1.6
with Streams, 1.6
running multiple Oracle releases on the same computer, 1.2.1

S

scheduling
AutoTask, A.1.5
schemas
collecting system component statistics, B.1
scripts
downgrading, 6.4
rerunning, 6.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.3.22
SESSION_CACHED_CURSORS initialization parameter
compatibility, A.3.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.3.20
SQL Access Advisor, A.1.17
SQL Management Base (SMB), 2.1.5.5.3
SQL Performance Analyzer, 2.1.5.5.2
SQL plan baseline, A.1.11
SQL plan management, 2.1.5.5.3, A.1.11
SQL Tuning Set (STS), 2.1.5.5.3
SQL*Plus
scripts
upgrading, 5.3
Standard Edition
moving to Enterprise Edition, 1.7
starter database, A.1.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.3
status tools
for upgrades and post-upgrade, 3.8.3
SYSASM Privilege, A.1.6
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, 4.2.1.10
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.4
troubleshooting
upgrades, 3.8.4

U

UNDO_MANAGEMENT initialization parameter, 4.2.1.7
default, A.1.20
Upgrade Companion
link to web site from Oracle Metalink, 1, 3.1.5
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.8
silent mode, 3.7.2
upgrade paths, 2.1.2
upgrade status tool, 3.8.3
upgrading
abandoning, 3.8.5
applications, 5
compatibility rules, 5.2.2
options, 5.2.3
relinking, 5.2.2
ASM, 1.6, 3.1.1
backup strategy, 2.1.6
binary XML storage, A.1.12
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, 5.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.6
running the CATUPGRD.SQL script, 3.8.3
scripts, 3.4, 3.8.3, 3.8.3
SQL*Plus scripts, 5.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, 1.3.1.1.4
utlu111s.sql
example, 3.8.3

W

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