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

OracleMetalink

link to The Upgrade Companion web site, 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 Companion

link to web site from Oracle Metalink, 1

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