Index

A B C D E F G H I K L M N O P Q R S T U V W X

A

access control lists (ACLs)

changed behavior in 11g release 1 (11.1), A.2.15

granting access to network utility packages, 2.5.2.1

access control to network utility packages, A.2.13.2

adding ACLs for network utility packages, 2.5.2.2

ALTER DATABASE RECOVER TO LOGICAL STANDBY statement, 2.2.8

application code

not changing after upgrade, 5.6.1

applications

compatibility, 5.2

linked and upgrading, 5.5.2

linking with newer libraries, 5.5.2.1

running against older server, 5.5.1.2

upgrading, 5

client/server configurations, 5.4

compatibility rules, 5.5

options, 5.6

relinking rules, 5.5

apxrelod.sql file

reloading after downgrade, 6.4

ASM_PREFERRED_READ_FAILURE_GROUPS, 4.8.4

attributes

xdb:defaultTableSchema (deprecated), 8.7.2

xdb:maintainOrder (deprecated), 8.7.2

xdb:mapUnboundedStringToLob (deprecated), 8.7.2

xdb:maxOccurs (deprecated), 8.7.2

xdb:SQLCollSchema (deprecated), 8.7.2

xdb:SQLSchema (deprecated), 8.7.2

xdb:srclang (deprecated), 8.7.2

xdb:storeVarrayAsTable (deprecated), 8.7.2

xdb:translate (deprecated), 8.7.2

auditing

unified auditing migration

about, 4.6.13

audit options, 4.6.13.1

documentation references for non-unified auditing, 4.6.13.5

managing earlier audit records after migration, 4.6.13.3

procedure, 4.6.13.2

removing unified auditing, 4.6.13.4

Automatic Diagnostic Repository (ADR), 1.1.3

automatic maintenance tasks management

AutoTask, A.2.5

Automatic Storage Management (ASM)

upgrading, 2.2.5

automatic undo management

migrating to, 4.6.10

UNDO_MANAGEMENT, A.2.20

AutoTask, A.2.5

B

backing up the database, 2.6

backup

backup mode, files in, 2.5.2.9

backups

after upgrading, 4.6.1

before downgrading, 6.3

preparing a strategy, 2.1.6

benchmarks, 2.1.5.7

benefits of options for upgrading precompiler and Oracle Call Interface (OCI) applications, 5.6

binary XML storage, A.2.12

C

capturing and replaying database workload, 2.1.5.6.1

case sensitivity

for passwords, 4.6.4

catcon.pl, 1.1.2, 3.4, 3.5, 6.5

catctl.pl, 1.1.2

catdwgrd.sql, 1.1.2

catdwgrd.sql script, 6.5, 6.5, 6.5, 6.5, 6.5

catnoamd.sql, 1.1.2

catnoexf.sql, 1.1.2

CATRELOD.SQL script, 6.5, 6.6

CATUPGRD.SQL script

manual upgrade and. See CATCTL.PL script

manual upgrade and

catuppst.sql, 1.1.2

CDBs, 3.2.1

upgrading and, 3.1

change passwords

for Oracle-supplied accounts, 4.11.1

changing scripts to use new features, 5.7

client and server

configurations and upgrading, 5.4.2

types of upgrades, 5.4.1

client software

upgrading, 5.5.2

client-server configurations, 1.6

client-side dynamic library, 5.5.2.3

CLUSTER_DATABASE initialization parameter, 2.7, 3.10.1

compatibility

applications, 5.2

between Oracle releases, 1.7

checking for incompatibilities, 6.2

COMPATIBLE initialization parameter, 1.7.1.1

downgrading, 1.7.1.4

overview for Oracle Database, 1.7.1

COMPATIBLE initialization parameter, 1.7.1.1, 4.8.3

checking the level of, 1.7.1.6

considerations for downgrading, 1.7.1.4

default, 1.7.1.1

Oracle recommendation, 1.7.1.7

setting, 4.11.6.1

values, 1.7.1.2

component status, 3.10.11

compression

sqlnet.ora file parameters and, 2.8

compression scheme, 2.8

SQLNET.COMPRESSION, 2.8

SQLNET.COMPRESSION_LEVELS, 2.8

SQLNET.COMPRESSION_THRESHOLD, 2.8

configuration files

copying, 2.7

copying configuration files, 2.7

CREATE pfile FROM spfile, 2.7

CREATE TABLE AS, 1.1.1

crsuser user, 2.2.6

CSS daemon

cluster synchronization services daemon, 2.2.6

cursor cache, SMB, 2.1.5.6.3

D

data copying

using Export/Import, 7

data dictionary

about changes that affect applications, 5.2

data files

relocating to upgraded environment, 2.2.1

data mining models, A.2.9

Data Pump Export/Import

advantages of using, 2.1.3.3

recommendations, 7.1

versus Original Export/Import, 7.1

when to use, 7.1

with subsets of production database, 2.9

Database Links, 2.5.2.3

database recycle bin

purging, 2.5.2.11

Database Replay

database workloads before upgrading, 2.1.5.6.1

Database Upgrade Assistant (DBUA)

advantages, 2.1.3.1

registering the database in the listener.ora file, 2.8

running, 3.2

silent mode, 3.2.6

starting, 3.2.2, 3.2.3

Database XE, 1.13

databases

downgrading, 6.5

upgrading the client software, 5.5.2

DBA_RECYCLEBIN statement, 2.5.2.11

DBA_REGISTRY view, 3.10.11

DBMS_DST package, 2.5.2.4

DBMS_DST PL/SQL package

ORA-01822 time zone region not found error, 3.10.9

DBMS_LDAP package, 2.5.2.1

DBMS_LDAP.init parameter, 2.5.2.1

DBMS_NETWORK_ACL_ADMIN package, 2.5.2.2

DBMS_STATS package

upgrading statistics tables, 4.3.7

DBMS_STATS.GATHER_DICTIONARY_STATS procedure, 2.5.2.5

DBUA. See Database Upgrade Assistant

defaultTableSchema attribute (deprecated), 8.7.2

deprecated parameters and desupported parameters display, 2.7

developer applications

upgrading forms and, 5.8

diagnostic log files

location of, 1.1.3

DIAGNOSTIC_DEST, 1.1.3

direct upgrade, 2.1.2, 2.1.2

disk group compatibility, 4.8.3

disks

specifying preferred read failure groups, 4.8.4

distributed transactions

resolving outstanding, 2.5.2.10

DMSYS schema objects, A.2.9

downgrading

backing up your database, 6.3

binary XML storage, A.2.12

CATRELOD.SQL, 6.5, 6.6

checking for incompatibilities, 6.2

Oracle Enterprise Manager and, 6.7.5

ORADIM and, 6.5

patchset releases, 6.1

procedure for, 6.5

scripts, 6.5

rerunning, 6.5

downstream capture

Oracle Streams, 2.2.11

E

emca -restore command, 6.7.5

emdwgrd, 1.1.2

emdwgrd utility, 1.1.2, 2.2.3, 6.7.5

emptying the database recycle bin, 2.5.2.11

emremove.sql, 1.1.2

enforcing case-sensitivity for passwords, 4.6.4

environment variables

required for upgrading, 3.4, 3.5

evaluation of numeric literals, 5.7.1

Export utility, 7.1

data copying, 7

export/import

advantages and disadvantages, 2.1.3.3

benefits, 2.1.3.3.2

effects on upgraded databases, 2.1.3.3.1

recommendations, 7.1

time requirements, 2.1.3.3.3

extended distance cluster configurations

preferred read disks, 4.8.4

extents

reading from secondary, 4.8.4

externally authenticated SSL users, 4.3.8

extusrupgrade script, 4.3.8

F

FAILED_LOGIN_ATTEMPTS initialization parameter

DEFAULT limit, A.3.7

Fast Recovery Area, 3.10.4

file access control

with the SYSASM role, 2.2.6.6

files in backup mode, 2.5.2.9

getting a list of, 2.5.2.9

fine-grained access control

network utility packages, 2.5.2.1

fn:matches XQuery function, 8.7.2

fn:replace XQuery function, 8.7.2

Forms

upgrading Oracle Forms applications, 5.8

Full Transportable Export/Import, 3.9

G

gathering statistics, 2.5.2.5

getting a list of files in backup mode, 2.5.2.9

H

Hardware Assisted Resilient Data (HARD)

upgrading systems, 4.11.6.1

HttpUriType type, 2.5.2.1

I

identifying invalid objects, 2.5.2.6

IFILE (include file)

editing entry, 2.7

See also text initialization parameter file (PFILE),

Import utility, 7.1

data copying, 7

incompatibilities

checking for, 6.2

initialization parameters

adjusting, 2.7

adjusting for Oracle Database 10g, 4.11.6

ASM_PREFERRED_READ_FAILURE_GROUPS, 4.8.4

COMPATIBLE, 1.7.1.1, 4.8.3

See also server parameter file (SPFILE),

install logs, 3.10.11

installation

Oracle Database software, 2.3

installation owners, 2.2.6

instances

starting after a downgrade, 6.5

INTEGER arithmetic

evaluation of numeric literals, 5.7.1

interim upgrade, 2.1.2

intermediate releases

interim upgrading, 2.1.2

interoperability, 1.7.2

invalid non-SYS or non-SYSTEM objects, 2.5.2.6

invalid objects

utlrp.sql script and, 3.4, 3.5, 3.10.11, 6.5

invalid objects, identifying, 2.5.2.6

INVALID status, 3.10.11

invalid SYS or SYSTEM objects, 2.5.2.6

K

KEEP IDENTITY clause, 2.2.8

knowledge base, 1.2

L

listener.ora file, 2.8

modifying, 2.8

listeners

modifying with Oracle Net Configuration Assistant, 2.8

load

level of concurrent demand when upgrading, 2.1.5.7

load testing, 2.1.5.7

localconfig command, 2.2.6

logical standby databases

rolling upgrades, 1.10.1

new DEFAULT limit, A.3.7

lsinventory command, 4.2

lsnrctl command

Oracle Grid Infrastructure home and, 2.8

M

maintainOrder attribute (deprecated), 8.7.2

maintenance release upgrade, 5.4.1.2

maintenance tasks

scheduling with AutoTask, A.2.5

major database release upgrade, 5.4.1.1

manual upgrade, 1.1.1

advantages, 2.1.3.2

backing up the database, 2.6

OCR configuration, 4.11.5

mapUnboundedStringToLob attribute (deprecated), 8.7.2

matches XQuery function, 8.7.2

materialized view refreshes

query status, 2.5.2.7

maxOccurs attribute in xdb namespace (deprecated), 8.7.2

media recovery, 2.5.2.8

migrating data, 1.1

to a different operating system, 2.2.10

migrating listener from Oracle home with lsnrctl command, 2.8

moving data with Data Pump Export/Import, 7.1

multitenant container database, 3.1, 3.5

multiversioning, 1.6

My Oracle Support

knowledge base, 1.2

link to Upgrade Companion, 1.2, 2.1.5.4

N

network time protocol (NTP), 2.2.6.4

network utility packages

access control to, A.2.13.2

networks

granting ACL access to network utility packages, 2.5.2.1

new features

adding after upgrade, 4.6.7

changing scripts to use and, 5.7

new features, learning about, 2.1.1

NO SCRIPT status, 3.10.11

not relinking upgraded application, 5.6.1

NTP. See network time protocol

NUMBER arithmetic

evaluation of numeric literals, 5.7.1

numeric computation

evaluation of numeric literals, 5.7.1

numeric literals

evaluating, 5.7.1

O

OCI applications

changing, 5.6.3.2

changing to use new features, 5.6.3.2

dynamically-linked, 5.5.2.3

statically-linked, 5.5.2.2

upgrade and linking, 5.5.2.1

upgrading, 5.3

upgrading options, 5.6

OFA, 1.8

olspreupgrade.sql, 1.1.2

one-off patches, 1.10

OPatch lsinventory command, 4.2

operating system

migrating data to, 2.2.10

operating system requirements, 2.2.9

optimizer statistics, gathering, 2.5.2.5

OPTION OFF status, 3.10.11

options for upgrading precompiler and Oracle Call Interface (OCI) applications, 5.6

ORA_TZFILE

unsetting after downgrade, 6.4

ora:matches Oracle XQuery function (deprecated), 8.7.2

ora:replace Oracle XQuery function (deprecated), 8.7.2

ORA-00336 log file size xxxx blocks error, 3.10.1

ORA-00401 value for parameter compatible error, 3.10.1

Ora-00704 bootstrap failure error, 3.10.1

ORA-00904 "TZ_VERSION" invalid identifier error, 3.10.3

ORA-00942

table or view does not exist, 3.10.3

ORA-00942 table or view does not exist error, 3.10.3

ORA-01408 error message, 3.10.6

ORA-01562 failed to extend rollback segment number error, 3.10.4

ORA-01722 invalid number error, 3.10.3

ORA-01822 time zone region not found error, 3.10.9

ORA-04031 unable to allocate nnn bytes of shared memory error, 3.10.4

ORA-19815 WARNING db_recovery_file_dest_size error, 3.10.4

ORA-24247

network access denied by access control list (ACL) error, 2.5.2.1

ORA-39700 database must be opened with UPGRADE error, 3.10.1

ORA-39701 database must be mounted EXCLUSIVE error, 3.10.1

Oracle Application Express

apexrelod.sql file, 6.4

update, 4.3.11

Oracle Application Express configuration, 4.3.11

Oracle ASM

database upgrade after, 4.5

disk group compatibility, A.2.7

optional tasks after upgrade, 4.5

Oracle ASM Cluster Assistant, 2.2.6

Oracle ASM Configuration Assistant (ASMCA), 2.2.6.5

Oracle Automatic Storage Management, 1.10

disk group compatibility, 4.8.3

file access control, 2.2.6.6

preferred read failure groups, 4.8.4

rolling upgrades and, 1.10, 1.10.1

upgrading, 2.2.6

Oracle Call Interface (OCI

upgrading applications and, 2.9.1

Oracle Change Data Capture. See Oracle GoldenGate, 8.1.7, 8.2.2, 8.2.2, A.1.6, A.1.6

Oracle Cluster Registry (OCR)

upgrading manually, 4.11.5

Oracle Cluster Time Synchronization Service, 2.2.6.4

Oracle Clusterware

upgrading, 2.2.6

Oracle Data Guard

rolling upgrades, 1.10.1

Oracle Data Pump, 1.1.1

Oracle Database Enterprise Edition

converting to Standard Edition, 1.12

Oracle Database Express Edition, 1.13

recommended tasks after upgrade, 4.9

upgrading to Oracle Database, 1.13

Oracle Database Standard Edition

converting to Enterprise Edition, 1.11

Oracle Database Vault, 2.2.13.1, 2.3

Oracle Database XE, 1.13

upgrading to Oracle Database, 1.13

Oracle home

copying configuration files from, 2.7

multiple, 1.6.1

ORACLE_HOME database directory on Windows, 2.7

ORACLE_HOME dbs directory on Linux or UNIX, 2.7

Oracle Label Security, 2.3

Oracle Names support, 8.6.2

Oracle Net Configuration Assistant, 2.8

Oracle Real Application Clusters

rolling upgrades and, 1.10

upgrading, 2.2.6

Oracle release numbers, 1.5

Oracle RMAN

backing up the database, 2.6

running, 2.6

Oracle software installation owners, 2.2.6

Oracle Streams

downstream capture, 2.2.11

Oracle Text-supplied knowledge bases

upgrading and, 4.3.10

Oracle Universal Installer, 1.1.1, 2.3

Oracle user accounts, 2.2.6

Oracle Warehouse Builder (OWB)

upgrading and, 3.4, 3.5

Oracle XML Database

binary XML storage, A.2.12

ORACLE_BASE

DIAGNOSTIC_DEST and, 1.1.3

Oracle-supplied accounts

change passwords, 4.11.1

ORADIM

downgrading and, 6.5

upgrading and, 3.4, 3.5

orapwSID password file, 2.7

Original Export/Import

versus Data Pump Export/Import, 7.1

OSDBA group, 2.2.6.6

P

Parallel Upgrade Utility

catctl.pl, Preface

parameter file

backing up, 2.7

passwords

case sensitive, 4.6.4

patch set updates, 2.4

patches

one-off, 1.10

patchset releases

downgrading, 6.1

PDBs, Preface, 3.2.1

physical standby database

performing rolling upgrades, 2.2.8

rolling upgrades, 1.10.1

PL/SQL Native Compilation, A.2.13.1

PL/SQL packages

upgrading those not installed by default, 2.2.2

Pluggable Databases, Preface

unified auditing migration and, 4.6.13.2

postupgrade_fixups.sql, 1.1.2

precompiler application

changing to use new features, 5.6.3.1

precompiler applications

upgrading and, 2.9.1

precompilers

applications

changing, 5.6.3.1

upgrading options, 5.6

upgrading applications, 5.3

preferred read failure groups

setting up, 4.8.4

preprocessing script

OLS and DV, 1.1.2

preupgrade directory, 2.5.1

Pre-Upgrade Information Tool

deprecated parameters and desupported parameters display, 2.7

running, 2.5.1

warnings and actions to take, 2.5.2

working with, 2.5.2

preupgrd.sql, 1.1.2

PRKH-1014 error, 2.3

Pro*C/C++ applications, 2.1.5.5

procedure for gathering optimizer statistics, 2.5.2.5

PURGE DBA_RECYCLE_BIN system privilege, 2.5.2.11

PURGE statement, 2.5.2.11

purging the database recycle bin, 2.5.2.11

Q

query for status of materialized view refreshes, 2.5.2.7

R

RDBMS DST patch, 2.5.2.4

read-only and offline tablespaces, 2.2.7

recompiling invalid objects, 3.4, 3.5, 6.5

recovery catalog

upgrading, 4.3.5

refreshes

materialized view, 2.5.2.7

registry$nonsys_inv_objs table, 2.5.2.6

registry$sys_inv_objs table, 2.5.2.6

release numbers, 1.5

releases

definition, 1.5

multiple, 1.6

upgrade paths, 2.1.2

releasing storage space, 2.5.2.11

REMOVED status, 3.10.11

REPCAT$_AUDIT_COLUMN_IDX1 index, 3.10.6

replace XQuery function, 8.7.2

reserved words

additions and applications, 5.2

role-allocated software owner, 4.5

rollback segments

migrating to automatic undo management, 4.6.10

Rolling Upgrade Using Active Data Guard, 2.2.8

rolling upgrades

methods, 1.10

Oracle Clusterware and, 1.10.1

physical standby database, 1.10.1

summary of methods, 1.10.1

to clustered ASM instances, 2.2.5

with logical standby databases, 2.2.8

with physical standby database, 2.2.8

with SQL Apply and logical standby databases, 1.10.1, 2.2.8

root.sh script, 2.2.6.5

rootupgrade.sh script, 2.3

-rpath option for linking, 5.5.2.3

running multiple Oracle releases, 1.6

run-time library search path, 5.5.2.3

S

scheduling

AutoTask, A.2.5

scripts

downgrading, 6.5

manual upgrade and, 3.4, 3.5

rerunning, 6.5

running the Pre-Upgrade Information tool, 2.5.1

security

case-sensitive passwords, 4.6.4

server

compatibility rules, 5.5.1

server parameter file (SPFILE), 2.7

migrating to, 4.11.3

upgrading systems with HARD-compliant storage, 4.11.6.1

SP2-1540 "Oracle Database cannot startup in an Edition session" error, 3.10.5

spool upgrade results to a log file, 2.5.1

SQL Access Advisor, A.2.17

SQL Apply

performing rolling upgrades, 2.2.8

rolling upgrades, 1.10.1

SQL execution plans, 2.1.5.6.3

SQL Management Base (SMB), 2.1.5.6.3

cursor cache, 2.1.5.6.3

SQL Performance Analyzer, 2.1.5.6.2

SQL plan baselines, A.2.11

unpacking, 2.1.5.6.3

SQL plan management, 2.1.5.6.3, A.2.11

SQL Management Base and, 2.1.5.6.3

SQL queries

testing, 2.1.5.6.3

SQL workload, 2.1.5.6.2

SQL*Plus

scripts

upgrading, 5.7

SQLCollSchema attribute (deprecated), 8.7.2

sqlnet.ora file

compression and, 2.8

SQLSchema attribute (deprecated), 8.7.2

srclang attribute (deprecated), 8.7.2

SSL external users conversion, 4.3.8

staging table

creating, 2.1.5.6.3

Standard Edition, 1.12

Export utility, 1.12

starter database, 3.10.12, A.2.18

standby databases, 2.2.8

STARTUP UPGRADE command, 6.5

statically linked Oracle client-side library code, 5.5.2.2

statistics

gathering optimizer, 2.5.2.5

statistics tables

upgrading, 4.3.7

status

INVALID, 3.10.11

materialized view refreshes, 2.5.2.7

NO SCRIPT, 3.10.11

OPTION OFF, 3.10.11

REMOVED, 3.10.11

UPGRADED, 3.10.11

storeVarrayAsTable attribute (deprecated), 8.7.2

support note 472937.1, Information On Installed Database Components, 2.5.2

support note 730365.1, Oracle Database Upgrade Path Reference List, 2.4

support note 753041.1, How to Diagnose Components with NON VALID Status, 2.5.2

support note 854428.1, Patch Set Updates for Oracle Products, 2.4

support note ID 412160.1, for RDBMS DST patches, 2.5.2.4

supported releases for direct upgrade, 1.3

symbolic link

Oracle Universal Installer and, 5.5.2.3

synchronizing the standby database, 2.5.2.12

syntax check

application code, 5.6.2

SYSASM role, A.2.6

Oracle ASM file access control, 2.2.6.6

SYS.LINK$ table, 2.5.2.3

system considerations and requirements, 2.2

T

tablespaces

read-only and offline, 2.2.7

testing

applications for upgrade, 2.10, 4.6.14

developing a plan, 2.1.5

functional for upgrade, 2.1.5.3

high availability for upgrade, 2.1.5.4

integration for upgrade, 2.1.5.5

minimal for upgrade, 2.1.5.2

performance for upgrade, 2.1.5.6

the upgraded test database, 2.10

using Database Replay, 2.1.5.6.1

volume/load stress for upgrade, 2.1.5.7

testing the upgrade process, 2.9

text initialization parameter file (PFILE), 2.7

time synchronization on Oracle RAC, 2.2.6.4

time zone file

how to resolve a mismatch, 2.5.2.4

unsetting after downgrade, 6.4

version mismatch, 3.10.9

TIMESTAMP WITH TIME ZONE data type, 2.5.2.4

TIMESTAMP WITH TIMEZONE data type, 2.5.2.4

training, where to find, 2.1.1

transactions

distributed

resolving outstanding, 2.5.2.10

translate attribute (deprecated), 8.7.2

Transportable Export/Import, 3.9

troubleshooting

EDITION session error, 3.10.5

Flash Recovery Area, 3.10.4

ORA-00942 table or view does not exist, 3.10.3

ORA-01408 index error, 3.10.6

rollback segments/undo tablespace, 3.10.4

running out of resources, 3.10.4

shared memory, 3.10.4

starting database in upgrade mode, 3.10.1

SYSTEM and SYSAUX tablespaces, 3.10.4

upgrade termination

due to ORA_00904, 3.10.3

due to ORA_01722, 3.10.3

upgrades, 3.10

troubleshooting the upgrade

termination due to ORA_00942, 3.10.3

type of software upgrade, 5.4

U

UNDO_MANAGEMENT initialization parameter, 4.6.10

default, A.2.20

unified auditing

removal of schema and roles, 2.2.15

See auditing

Upgrade Companion

link to on My Oracle Support, 1.2, 2.1.5.4

upgrade methods

choosing, 2.1.3

Data Pump Export/Import, 2.1.3.3

Database Upgrade Assistant, 1.1.1

Database Upgrade Assistant (DBUA), 2.1.3.1

manual, 2.1.3.2

silent mode, 3.2.6

upgrade path

determining, 2.1.2

table, 2.1.2

upgrade procedures

summary of major steps, 1.4

workflow, 1.4

upgrade process testing, 2.9

UPGRADED status, 3.10.11

upgraded test database, 2.10

upgrading

applications, 5

compatibility rules, 5.5

options, 5.6

relinking, 5.5

backup strategy, 2.1.6

binary XML storage, A.2.12

initialization parameters, 2.7

new administrative procedures, 4.6.8

Oracle Application Express, 4.3.11

Oracle Automatic Storage Management, 2.2.6

Oracle Clusterware, 2.2.6

Oracle Forms applications, 5.8

Oracle Real Application Clusters, 2.2.6

ORADIM and, 3.4, 3.5

post upgrade actions, 4

preparation, 2.1

recovery catalog, 4.3.5

rolling upgrades and, 1.10

scripts and manual upgrade, 3.4, 3.5

SQL*Plus scripts, 5.7

statistics tables, 4.3.7

testing, 2.1.5

troubleshooting, 3.10

using the Database Upgrade Assistant, 3.2

where to find information about, 1.2

upgrading a cluster database

setting the CLUSTER_DATABASE initialization parameter, 2.7

upgrading and plugging into a CDB, 3.1.2

UTL_INADDR package, 2.5.2.1

UTL_MAIL package, 2.5.2.1

UTL_SMTP package, 2.5.2.1

UTL_TCP package, 2.5.2.1

utlrp.sql, 1.1.2

utlrp.sql script

for recompiling invalid objects, 3.4, 3.5, 6.5

utlu121s.sql, 1.1.2

utluiobj.sql, 1.1.2

utluiobj.sql script, 2.5.2.6

V

V$OPTION view, 3.10.11

volume

amount of data to be upgraded, 2.1.5.7

W

word size

64-bit software, 1.9

workloads

capturing and replaying, 2.1.5.6.1

X

xdb:defaultTableSchema attribute (deprecated), 8.7.2

xdb:maintainOrder attribute (deprecated), 8.7.2

xdb:mapUnboundedStringToLob attribute (deprecated), 8.7.2

xdb:maxOccurs attribute (deprecated), 8.7.2

xdb:SQLCollSchema attribute (deprecated), 8.7.2

xdb:SQLSchema attribute (deprecated), 8.7.2

xdb:srclang attribute (deprecated), 8.7.2

xdb:storeVarrayAsTable attribute (deprecated), 8.7.2

xdb:translate attribute (deprecated), 8.7.2

XE, 1.13

XQuery language

functions

fn:matches, 8.7.2

fn:replace, 8.7.2

ora:,matches (deprecated, Oracle), 8.7.2

ora:replace (deprecated, Oracle), 8.7.2