Skip Headers
Oracle® Database Upgrade Guide
10g Release 2 (10.2)

Part Number B14238-01
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
Feedback

Go to previous page
Previous
View PDF

Index

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

Numerics

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

A

AL24UTFFSS character set
desupported, 5.6.3.3
applications
client/server configurations
upgrading, 6.2.1
compatibility, 6.1.1
linking with newer libraries, 6.2.2.2.1
running against older server, 6.2.2.1.2
upgrading, 6
compatibility rules, 6.2.2
options, 6.2.3
relinking rules, 6.2.2
automatic segment-space managed tablespaces
change in compatibility level, 5.5.4

B

backups
after upgrading, 4.1.1
preparing a strategy, 2.1.6

C

CATRELOD.SQL script, 7.4
CATUPGRD.SQL script, 3.7.3
change passwords
for oracle-supplied accounts, 4.2.1
character sets
upgrading the database, 5.6.3.2
client-server configurations, 1.2.1
collecting optimizer statistics, C
command line options
for Database Upgrade Assistant, 3.6.2
comments
differences between Server Manager and SQL*Plus, B.3.1
COMMIT command
differences between Server Manager and SQL*Plus, B.3.6
compatibility
applications, 6.1.1
automatic segment-space managed tablespaces, 5.5.4
checking for incompatibilities, 7.2
compatibility level, 5.1.1.3
COMPATIBLE initialization parameter, 5.1.1
datafiles, 5.6.2
datatypes, 5.6.3
dictionary managed tablespaces, 5.5.3
downgrading, 5.1.1.1
initialization parameters, A.2
object types, 5.5.5
Oracle Managed Files, 5.5.6
Oracle OLAP, 5.5.7
replication, 5.6.5
STARTUP, 5.6.1
tablespaces, 5.6.2
user-defined datatypes, 5.6.4
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
control files
renaming or removing for migration, 3.7.3
CREATE TYPE command
differences between Server Manager and SQL*Plus, B.3.5

D

data copying, 2.1.3.4
using Export/Import, 8
Database Upgrade Assistant
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, 7.4
datafiles
compatibility, 5.6.2
datatypes
compatibility, 5.6.3
DB_BLOCK_CHECKSUM
new default value, A.2.8
DB_BLOCK_CHECKSUM initialization parameter
compatibility, A.2.8
DB_BLOCK_SIZE
new default value, A.2.2
DB_BLOCK_SIZE initialization parameter
compatibility, A.2.2
DBMS_STATS package
upgrading statistics tables, 4.1.8
DBMS_STATS procedure
use when creating a statistics table, C.2
DBUA. See Database Upgrade Assistant
deprecated dynamic performance views, A.4.1
deprecated features
dictionary managed tablespaces, 5.5.3
Oracle Dynamic Services, 5.5.9
Oracle Syndication Server, 5.5.10
deprecated initialization parameters, A.1.1
deprecated static data dictionary views, A.3.1
Developer/2000 Applications
upgrading, 6.4
dictionary managed table, 5.5.3
dictionary managed tablespaces
compatibility, 5.5.3
deprecated, 5.5.3
downgrading
CATRELOD.SQL, 7.4
checking for incompatibilities, 7.2
ORADIM, 7.4
procedure for, 7.4
scripts, 7.4
rerunning, 7.4
dynamic performance views
changes in Oracle Database 10g, A.4
deprecated, A.4.1
obsolete, A.4.2
with dropped columns, A.4.4
with renamed columns, A.4.3

E

environment variables
required for upgrading, 3.7.3
Export utility
data copying, 8
requirements, 8.1
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.1.1
time requirements, 2.1.3.3.3
upgrading, 8.2

F

Forms
upgrading Oracle Forms applications, 6.4

I

Import utility
data copying, 8
requirements, 8.1
incompatibilities
checking for, 7.2
incompatible data
Export/Import, 8.1.1
initialization parameters
adjusting for Oracle Database 10g, 3.7.2, 4.2.5
changes in Oracle Database 10g, A.1
compatibility, A.2
DB_BLOCK_CHECKSUM, A.2.8
DB_BLOCK_SIZE, A.2.2
JOB_QUEUE_PROCESSES, A.2.9
LOG_CHECKPOINT_TIMEOUT, A.2.10
O7_DICTIONARY_ACCESSIBILITY, A.2.11
SESSION_CACHED_CURSORS, A.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 10g software, 3.2
Oracle9i software, 8.2
interoperability, 5.2
dictionary managed tablespaces, 5.5.3
object types, 5.5.5
Oracle Managed Files, 5.5.6
Oracle OLAP, 5.5.7
replication, 5.6.5

J

JOB_QUEUE_PROCESSES
maximum number of job queue processes, A.2.9
JOB_QUEUE_PROCESSES initialization parameter
compatibility, A.2.9

L

listener.ora file
modifying, 3.5
listeners
modifying with Oracle Net Configuration Assistant, 3.5
LOG_CHECKPOINT_TIMEOUT
new default value, A.2.10
LOG_CHECKPOINT_TIMEOUT initialization parameter
compatibility, A.2.10
logical standby databases
rolling upgrades, 1.5

M

manual upgrade
advantages, 2.1.3.2
analyze the database, 3.4.1
backup the database, 3.7.1
OCR configuration, 4.2.4
migrating data
to a different operating system, 3.1.5
migration
control files, 3.7.3
multiversioning, 1.2.1

N

NCHAR columns
upgrading, 4.3.1
new features
adding after upgrade, 4.1.15

O

O7_DICTIONARY_ACCESSIBILITY initialization parameter
compatibility, A.2.11
object types
compatibility, 5.5.5
interoperability, 5.5.5
obsolete dynamic performance views, A.4.2
obsolete initialization parameters, A.1.2
obsolete static data dictionary views, A.3.2
OCI
applications
changing, 6.2.3.3.2
upgrading applications, 6.2
OCI applications
upgrading options, 6.2.3
OFA, 1.3
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, C
creating a table to collect, C.2
Oracle Cluster Registry (OCR)
upgrading manually, 4.2.4
Oracle Data Guard
rolling upgrades, 1.5
Oracle Database 10g
changes to dynamic performance views, A.4
changes to initialization parameters, A.1
changes to static data dictionary views, A.3
new features
adding after upgrade, 4.1.15
Oracle Dynamic Services
deprecated, 5.5.9
Oracle home
multiple, 1.2.1.1
Oracle Managed Files
compatibility, 5.5.6
interoperability, 5.5.6
Oracle Net Configuration Assistant, 3.5
Oracle Net Services
relinking, 6.1.1
Oracle OLAP
compatibility, 5.5.7
interoperability, 5.5.7
Oracle release numbers, 1.2
Oracle Streams
rolling upgrades, 1.5
Oracle Syndication Server
deprecated, 5.5.10
Oracle Universal Installer, 1.1
oracle-supplied accounts
change passwords, 4.2.1
ORADIM
downgrading, 7.4
upgrading, 3.7.3

P

precompilers
applications
changing, 6.2.3.3.1
upgrading options, 6.2.3
upgrading applications, 6.2
preparing to upgrade, 2.1
collecting optimizer statistics, C

R

Real Application Clusters
rolling upgrades with opatch, 1.5
upgrading, 3.1.1
recovery catalog
upgrading, 4.1.7
releases
definition, 1.2
multiple, 1.2.1
relinking with Oracle Net Services, 6.1.1
replication
compatibility, 5.6.5
interoperability, 5.6.5
rolling upgrades, 1.5
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

S, B.3.5
schemas
collecting system component statistics, C.1
scripts
downgrading, 7.4
rerunning, 7.4
upgrading, 3.4.1, 3.7.3, 3.7.3
Server Manager
differences with SQL*Plus
ampersands, B.3.4
blank lines, B.3.2
commands, B.2
comments, B.3.1
COMMIT command, B.3.6
CREATE TYPE command, B.3.5
hyphen continuation character, B.3.3
startup, B.1
syntax, B.3
migrating scripts to SQL*Plus, B
not supported, 4.3.2, B
server parameter file
migrating to, 4.2.2
SESSION_CACHED_CURSORS
change in behavior, A.2.1
SESSION_CACHED_CURSORS initialization parameter
compatibility, A.2.1
SQL*Plus
differences with Server Manager
ampersands, B.3.4
blank lines, B.3.2
commands, B.2
comments, B.3.1
COMMIT command, B.3.6
CREATE LIBRARY command, B.3.5
CREATE TYPE command, B.3.5
hyphen continuation character, B.3.3
startup, B.1
syntax, B.3
migrating scripts from Server Manager, B
scripts
upgrading, 6.3
STARTUP
compatibility, 5.6.1
static data dictionary views
changes in Oracle Database 10g, A.3
deprecated, A.3.1
obsolete, A.3.2
with dropped columns, A.3.4
with renamed columns, A.3.3
statistics
collecting for dictionary objects, C
collecting for system component schemas, C.1
creating a table for, C.2
importing with DBMS_STATS PL/SQL procedure, C.2
statistics tables
upgrading, 4.1.8
system component schemas
collecting statistics for, C.1

T

tablespaces
compatibility, 5.6.2
testing
applications for upgrade, 2.3
developing a plan, 2.1.5
EXPLAIN PLAN, 2.1.5.7
functional for upgrade, 2.1.5.3
integration for upgrading, 2.1.5.4
INTO clause, 2.1.5.7
minimal for upgrade, 2.1.5.2
performance for upgrade, 2.1.5.5
pre-upgrade and post-upgrade, 2.1.5.7
the upgrade process, 2.2
the upgraded test database, 2.3
volume/load stress for upgrade, 2.1.5.6
troubleshooting
upgrades, 3.7.4

U

Upgrade Information Tool, 3.4.1
upgrade methods
choosing, 2.1.3
copying data, 2.1.3.4
Database Upgrade Assistant, 2.1.3.1
Export/Import, 2.1.3.3
manual upgrade, 2.1.3.2
upgrading
abandoning, 3.7.5
after upgrading, 4
applications, 6
compatibility rules, 6.2.2
options, 6.2.3
relinking, 6.2.2
backup strategy, 2.1.6
CATUPGRD.SQL, 3.7.3
character sets, 5.6.3.2
initialization parameters, 3.7.2
NCHAR columns, 4.3.1
new administrative procedures, 4.1.16
Oracle Forms applications, 6.4
ORADIM, 3.7.3
post upgrade actions, 4
Real Application Clusters, 3.1.1
recovery catalog, 4.1.7
rolling upgrades, 1.5
scripts, 3.4.1, 3.7.3, 3.7.3
SQL*Plus scripts, 6.3
statistics tables, 4.1.8
testing, 2.1.5
troubleshooting, 3.7.4
using the Database Upgrade Assistant, 3.6
when to set the COMPATIBLE initialization parameter, 5.1.1.5
upgrading a database
choosing an upgrade method, 2.1.3
manually, 3.7
analyze the database, 3.4.1
backing up the database, 3.7.1
performing a manual upgrade, 1.1
preparing to, 2.1
using Export/Import, 8.2
using silent mode, 3.6.2
using the Database Upgrade Assistant, 1.1
user-defined datatypes
compatibility, 5.6.4

W

word size
64-bit software, 1.4