1. Index

Index

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

Symbols

  • .NET
    • PromotableTransaction deprecated 10.8.4.8

A

B

  • backing up the database 2.11
  • backups
    • after upgrading 7.4.1
    • before downgrading 9.4
    • Zero Data Loss Recovery Appliance restriction 10.8.1.12
  • benchmarks 2.1.6.7
  • benefits of options for upgrading precompiler and Oracle Call Interface (OCI) applications 8.7
  • BFILE
  • BLOB
  • BP (bundle patches 2.4.1
  • broker configuration

C

  • capturing and replaying database workload 2.1.6.6.1
  • case sensitivity
  • catcon
    • and downgrades 9.8.7
    • running SQL commands with 9.8.9
  • catcon.pl 9.5.2
  • catctl.pl A.2
  • catdwgrd.sql script 9.5.2
  • CATRELOD.SQL script 9.5.2, 9.6
  • CDB_JAVA_POLICY 6.9
  • CDB_REGISTRY 9.8.10
  • CDBs
    • using catcon with 9.8.9
  • cdbs and pdbs 5.1.1
  • change passwords
    • for Oracle-supplied accounts 7.8.1
  • changing scripts to use new features 8.8
  • client and server
    • configurations and upgrading 8.3.1
  • client-server configurations 1.4.4
  • client-side dynamic library 8.4.2.4
  • client software
  • CLOB
  • clone.pl
  • CLUSTER_DATABASE initialization parameter 2.5, 6.2
  • commands
  • compatibility
    • applications 8.2
    • between Oracle releases 1.3
    • checking for incompatibilities 9.3
    • COMPATIBLE initialization parameter 1.3.3.3
    • downgrading 1.3.3.5
    • overview for Oracle Database 1.3.3.1
  • COMPATIBLE initialization parameter 1.3.3.3, 7.6.3
  • component status 6.11.1
  • compression
    • sqlnet.ora file parameters and 2.4.3
  • compression scheme 2.4.3
    • SQLNET.COMPRESSION 2.4.3
    • SQLNET.COMPRESSION_LEVELS 2.4.3
    • SQLNET.COMPRESSION_THRESHOLD 2.4.3
  • configuration files
  • continuous_mine option desupported 10.6.2.3
  • control files
    • copying 3.10
    • creating for standby databases 3.7
  • copying
    • control files 3.10
  • copying configuration files 2.5
  • CREATE pfile FROM spfile 2.5
  • CREATE STANDBY CONTROLFILE clause
    • of ALTER DATABASE 3.7
  • CREATE TABLE AS 1.2.2
  • crsuser deprecated 10.7.2.7
  • cursor cache, SMB 2.1.6.6.3

D

  • database accounts
    • solution for lockouts 2.4.4
  • database options, installing 2.4.4
  • Database Replay
    • database workloads before upgrading 2.1.6.6.1
  • databases
    • downgrading 9.5.1
    • downgrading manually 9.5.2
    • upgrading the client software 8.4.2
  • Database Upgrade Assistant (DBUA)
  • Database Upgrade Assistant (DBUA) new features 10.8.1.2
  • Database XE 1.5.6
  • data definition language (DDL) 1.3.5
  • data dictionary
    • about changes that affect applications 8.2
    • checking the state of 7.2
  • DataGuardSyncLatency deprecated 10.6.4.3
  • Data Pump Export/Import
    • advantages of using 2.1.4.3
    • with subsets of production database 2.8
  • datatypes 10.9.1.7
  • DB_FILE_NAME_CONVERT initialization parameter
    • setting on physical standby database 3.8
  • DBA_ACL_NAME_MAP 10.8.1.5
  • DBA_REGISTERED_MVIEW_GROUPS
  • DBA_REGISTRY 9.8.10
  • DBA_REGISTRY view 6.11.1
  • dbdowngrade utility 9.5.1
  • DbFileNameConvert deprecated 10.6.4.3
  • DBMS_DEBUG
  • DBMS_NETWORK_ACL_ADMIN
  • DBMS_NETWORK_ACL_ADMIN_APPEND_HOST_ACE 10.8.1.5
  • DBMS_PDB package 5.1.4, 5.2.1
  • DBMS_ROLLING 10.8.1.3
  • DBMS_STATS.GATHER_DICTIONARY_STATS 9.8.7
  • DBMS_STATS.GATHER_DICTIONARY_STATS procedure 9.8.9
  • DBMS_STATS.GATHER_FIXED_OBJECTS_STATS 9.8.8
  • DBMS_STATS package
    • upgrading statistics tables 7.4.4
  • DBMS_XMLQUERY, deprecated 10.7.5.4
  • DBT error messages 10.8.1.2
  • dbupgdiag.sql 7.2
  • defaultTableSchema attribute (deprecated) 10.8.4.20, 10.9.3.37
  • demo
    • replace in read-only Oracle homes 7.3.10
  • deprecated features in 18c 10.7.5
  • deprecated initialization parameters 10.8.5
  • deprecated parameters and desupported parameters 2.5
  • DESCRIBE procedure 5.2.1
  • desupported initialization parameters 10.8.3
  • developer applications
    • upgrading forms and 8.9
  • DGMGRL 10.8.1.3
  • diagnostic data 1.4.3
  • direct upgrade 1.1
  • disk group compatibility 7.6.3
  • disks
    • specifying preferred read failure groups 7.6.4
  • distributed upgrades 4.9.2.44
  • downgrades
    • Oracle Data Guard broker configuration file backup 2.1.8.2
    • reapplying patches after 9.8.1
  • downgrading
    • and gathering dictionary statistics 9.8.7
    • backing up your database 9.4
    • CATRELOD.SQL 9.5.2, 9.6
    • checking for incompatibilities 9.3
    • check registry 9.8.10
    • location of downgrade log files 9.5.1
    • Oracle Data Guard standby database 9.2
    • Oracle Enterprise Manager and 9.8.5
    • ORADIM and 9.5.2
    • patchset releases 9.1
    • regathering fixed object statistics 9.8.8
    • regathering stale statistics 9.8.9
    • scripts 9.5.1, 9.5.2
  • DV_PUBLIC
  • DV_REALM_OWNER
  • DV_REALM_RESOURCE
  • dvsys.dbms_macadm.enable_dv() 7.3.12.1

E

  • emca -restore command 9.8.5
  • emdwgrd A.1
  • emdwgrd utility 9.8.5
  • emremove.sql A.1
  • endianness 1.6.2
  • enforcing case-sensitivity for passwords 7.4.6
  • exafusion_enabled desupported 10.6.3.1
  • export/import
  • exporting
  • extended datatype support
  • extended distance cluster configurations
    • preferred read disks 7.6.4
  • extents
    • reading from secondary 7.6.4

F

  • Fast Recovery Area 6.6
  • Fleet Patching and Provisioning
  • Flex Cluster architecture deprecated 10.7.5.12
  • Forms
    • upgrading Oracle Forms applications 8.9
  • Full Transportable Export/Import 2.1.4.3.4

G

H

  • Hardware Assisted Resilient Data (HARD)
    • upgrading systems 7.8.6

I

  • IFILE (include file)
    • editing entry 2.5
  • image
  • incompatibilities
    • checking for 9.3
  • init.ora
  • initialization parameters
  • installation
    • Oracle Database software 2.2, 2.3
  • install logs
    • component upgrade script 6.11.1
  • instances
    • starting after a downgrade 9.5.2
  • Intelligent Data Placement (IDC)
  • interim upgrade 1.1
  • intermediate releases
    • interim upgrading 1.1
  • interoperability 1.3.4
  • invalid objects
  • INVALID objects 6.4
  • INVALID status

K

L

  • listener.ora file 2.4.3
  • listeners
    • and Oracle RAC upgrades 7.5
    • modifying with Oracle Net Configuration Assistant 2.4.3
  • load
    • level of concurrent demand when upgrading 2.1.6.7
  • load testing 2.1.6.7
  • locked out accounts, solution for 2.4.4
  • LOG_ARCHIVE_CONFIG initialization parameter 3.8
  • log_archive_dest max_connections attribute deprecated 10.6.3.2
  • LOG_ARCHIVE_LOCAL_FIRST desupported 10.8.3
  • LOG_FILE_NAME_CONVERT initialization parameter
    • setting on physical standby databases 3.8
  • LogArchiveFormat deprecated 10.6.4.3
  • LogArchiveMaxProcesses deprecated 10.6.4.3
  • LogArchiveMinSucceedDest deprecated 10.6.4.3
  • LogArchiveTrace deprecated 10.6.4.3
  • LogFileNameConvert deprecated 10.6.4.3
  • logical standby databases
  • LogMiner
  • lsnrctl command
    • Oracle Grid Infrastructure home and 2.4.3

M

  • maintainOrder attribute (deprecated) 10.8.4.20, 10.9.3.37
  • manual upgrade
    • backing up the database 2.11
    • OCR configuration 7.8.4
  • mapUnboundedStringToLob attribute (deprecated) 10.8.4.20, 10.9.3.37
  • matches Oracle XQuery function (deprecated) 10.8.4.20, 10.9.3.37
  • matches XQuery function 10.8.4.20, 10.9.3.37
  • max_connections desupported 10.6.2.5
  • maxOccurs attribute in xdb namespace (deprecated) 10.8.4.20, 10.9.3.37
  • migrating
  • migrating data 1.2.1
    • to a different operating system 1.6.2
  • migrating listener from Oracle home with lsnrctl command 2.4.3
  • Monthly Recommended Patches (MRP) 1.3.1
  • Multiple Oracle Homes Support
  • multitenant
    • transferring unified audit records after upgrade 7.4.19.2
  • Multitenant architecture databases
    • and PDB COMPATIBILITY parameter setting 1.3.3.3
  • multiversioning 1.4.4
  • My Oracle Support

N

  • NCLOB
  • network administration file location 7.3.4
  • new features
    • adding after upgrade 7.4.11
    • changing scripts to use and 8.8
  • new features, learning about 2.1.1
  • NO AUTHENTICATION status accounts 2.1.7, 8.6
  • noncdb_to_pdb.sql script 5.1.4, 5.2.2
  • non-CDB architecture
  • non-CDBs 5.1.4
  • non-CDB to CDB and PDB upgrades 1.5.1
  • NO SCRIPT status 6.11.1
  • not relinking upgraded application 8.7.1
  • NVARCHAR2 datatype

O

  • OCI applications
  • OCR 10.8.2.2
  • OFA 1.4, 1.4.3
    • See also: Optimal Flexible Architecture
  • operating system
    • migrating data to 1.6.2
  • operating system requirements 1.6.1
  • Optimal Flexible Architecture 1.4
  • OPTIMIZER_ADAPTIVE_PLANS 10.8.1.1
  • OPTIMIZER_ADAPTIVE_STATISTICS 10.8.1.1
  • optimizer statistics
    • regathering after downgrade 9.8.9
  • OPTION OFF status 6.11.1
  • options for upgrading precompiler and Oracle Call Interface (OCI) applications 8.7
  • ORA-00336 log file size xxxx blocks error 6.2
  • ORA-00401 value for parameter compatible error 6.2
  • ORA-00704: bootstrap process failure 6.2
  • ORA-00904 "TZ_VERSION" invalid identifier error 6.5
  • ORA-00942 table or view does not exist error 6.5
  • ORA-01092: ORACLE instance terminated. Disconnection forced 6.2
  • ORA-01562 failed to extend rollback segment number error 6.6
  • ORA-01650: unable to extend rollback segment 6.6
  • ORA-01651: unable to extend save undo segment 6.6
  • ORA-01652: unable to extend temp segment 6.6
  • ORA-01653: unable to extend table 6.6
  • ORA-01654: unable to extend index 6.6
  • ORA-01655: unable to extend cluster 6.6
  • ORA-01722 invalid number error 6.5
  • ORA-03134: Connections to this server version are no longer supported. 10.8.1.10
  • ORA-04031 unable to allocate nnn bytes of shared memory error 6.6
  • ORA-1017 invalid username/password 10.8.1.10
  • ORA-17500: ODM err:Operation not permitted 10.9.1.10
  • ORA-19815 WARNING db_recovery_file_dest_size error 6.6
  • ORA-20001: Downgrade cannot proceed 9.9.1
  • ORA-24247: network access denied by access control list (ACL) 7.3.11
  • ORA-28040: No matching authentication protocol 7.3.13
  • ORA-28040 "No matching authentication protocol 2.4.6, 2.4.7
  • ORA-28040 No matching authentication protocol. 10.8.1.10
  • ORA-29283: Invalid File Option 10.7.1.7
  • ORA-39700: database must be opened with UPGRADE option 6.2
  • ORA-39701 database must be mounted EXCLUSIVE error 6.2
  • ORA-39709: 9.9.1
  • ORA-39709: Incomplete component downgrade 9.5.2, 9.6
  • oracle.dbc.OracleConnection
  • oracle.jdbc.rowset
  • Oracle ACFS Encryption
    • deprecated on Oracle Solaris and Microsoft Windows 10.6.4.16
  • Oracle ACFS Replication protocol REPV1
  • Oracle Administration Assistant tool 10.7.2.1
  • Oracle ASM
    • change in Oracle home location 7.4.10
  • Oracle Automatic Storage Management
    • disk group compatibility 7.6.3
    • password file (PWFILE) 6.13
    • preferred read failure groups 7.6.4
    • rolling upgrades and 1.5.1
  • Oracle base 1.4.3
  • Oracle Call Interface (OCI
    • upgrading applications and 2.9
  • Oracle Change Data Capture
    • See: Oracle GoldenGate
  • Oracle Cluster Registry (OCR)
    • upgrading manually 7.8.4
  • Oracle Database clients
  • Oracle Database Enterprise Edition
    • converting from Enterprise Edition to Standard Edition 1.5.5
  • Oracle Database Express Edition 1.5.6
    • recommended tasks after upgrade 7.7
    • upgrading to Oracle Database 1.5.6
  • Oracle Database software
    • upgrading 3.3
  • Oracle Database Standard Edition
    • converting to Enterprise Edition 1.5.4
  • Oracle Database Vault 2.2, 2.3
  • Oracle Database Views check 9.8.10
  • Oracle Database XE 1.5.6
    • upgrading to Oracle Database 1.5.6
  • Oracle Data Guard
  • Oracle Data Guard Upgrades 3.2
  • Oracle Data Mining
  • Oracle Data Provider for .NET
    • desupport of Oracle.ManagedDataAccessDTC.dll 10.7.2.5
  • Oracle Data Pump 1.2.2
  • Oracle Enterprise Manager Cloud Control
  • Oracle Fleet Patching and Provisioning 10.8.1.11
  • Oracle FPP 10.8.1.11
  • Oracle GoldenGate 10.9.2.8
  • Oracle Grid Infrastructure
    • file locations for OCR and voting disks 10.8.2.2
  • Oracle home
    • copying configuration files from 2.5
    • ORACLE_HOME database directory on Microsoft Windows 2.5
    • ORACLE_HOME dbs directory on Linux or Unix 2.5
    • out-of-place requirement 2.1.5
  • Oracle Layered File System 10.8.1.11
  • Oracle Multimedia Java APIs
  • Oracle Multitenant
    • upgrade errors 6.14
  • Oracle Names support 10.9.2.16
  • Oracle Net Configuration Assistant 2.4.3
  • Oracle Optimal Flexible Architecture
    • See: Optimal Flexible Architecture
  • Oracle Optimizer
  • Oracle RAC
    • desupported on Oracle Database Standard Edition 2 (SE2) 10.6.2.9
  • Oracle Real Application Clusters 1.3.5
  • Oracle release numbers 1.3.1
  • Oracle RMAN
    • backing up the database 2.11
  • Oracle Streams
  • Oracle-supplied accounts
  • Oracle Text
  • Oracle Text-supplied knowledge bases
  • Oracle Universal Installer 1.2.2, 2.2, 2.3
  • Oracle update batching size disabled 10.8.1.8
  • ORADIM
  • ORA-O1722: invalid number 6.1
  • orapki
  • orapwSID password file 2.5
  • OUI
    • See: Oracle Universal Installer
  • out-of-place patching 2.1.5
  • out-of-place upgrades 2.1.5

P

  • PARALLEL_ADAPTIVE_MULTI_USER deprecated 10.8.5
  • PARALLEL_AUTOMATIC_TUNING desupported 10.8.3
  • PARALLEL_IO_CAP_ENABLED desupported 10.8.3
  • PARALLEL_SERVER_INSTANCE desupported 10.8.3
  • PARALLEL_SERVER desupported 10.8.3
  • Parallel Upgrade Utility 6.2
    • setting tablespaces to READ ONLY 10.8.1.9
  • parameter file
    • and permissions to read and write the SGA 10.8.1.4
    • backing up 2.5
  • passwords
    • 10G password version, finding and resetting 7.4.8
    • case sensitive 7.4.6
    • forgotten, solution for 2.4.4
  • password verifiers 2.4.6
  • password versions 2.4.7
  • patchset releases
    • downgrading 9.1
  • patch sets 1.3.1
  • patch set updates 2.4.1
  • Pause and Continue 10.8.1.2
  • PDB
    • COMPATIBILITY parameter and CDB 1.3.3.3
  • PDBs
  • performance
  • physical standby database
  • physical standby databases
    • converting datafile path names 3.8
    • converting log file path names 3.8
    • upgrading 3.9
  • PL/SQL packages
  • placement on shared storage deprecated 10.8.2.2
  • Pluggable Databases
    • unified auditing migration and 7.4.16.2
  • postupgrade fixups 7.4.2
  • postupgrade status tool
  • Post-Upgrade Status Tool 7.1
  • precompiler application
    • changing to use new features 8.7.4.1
  • precompiler applications
    • upgrading and 2.9
  • precompilers
    • applications
    • upgrading applications 8.5
  • preferred read failure groups
  • PRKH-1014 error 2.2, 2.3
  • Pro*C/C++ applications 2.1.6.5
  • proactive fixups 4.9.2.44
  • PRODUCT_USER_PROFILE
  • PSU 2.4.1

R

  • RAW datatype
  • raw devices
  • read-only oracle home 10.4.1.8, 10.5.1.1
  • read-only Oracle homes
    • replace demo directory 7.3.10
  • read-only tablespaces 2.4.10
  • recompiling invalid objects 7.3.2, 9.5.2
  • RECOVER MANAGED STANDBY DATABASE clause
    • of ALTER DATABASE 3.12
  • recovery catalog
  • Redo Apply
  • release numbers 1.3.1
  • releases
  • Release Update (Update 2.4.1
  • release update (Update, RU) 1.3.1
  • Release Update Revision (Revision) 2.4.1
  • REMOVED status 6.11.1
  • replace Oracle XQuery function (deprecated) 10.8.4.20, 10.9.3.37
  • replace XQuery function 10.8.4.20, 10.9.3.37
  • Replay Upgrade 2.1.4, 5.1, 5.1.1, 5.1.4
  • reserved words
    • additions and applications 8.2
  • reuse standby database files 3.2
  • rollback segments
    • migrating to automatic undo management 7.4.13
  • rolling upgrades
    • Oracle Clusterware and 1.5.1
    • physical standby database 1.5.1
    • rolling upgrades
      • with SQL Apply and logical standby databases 1.5.1
    • SQL Apply
    • summary of methods 1.5.1
  • Rolling Upgrade Using Active Data Guard 1.5.2
  • rootupgrade.sh script 2.2, 2.3
  • rpath option for linking 8.4.2.4
  • RPM-based database installation 10.7.1.4
  • rpm –ivh 10.7.1.4
  • running multiple Oracle releases 1.4.4
  • run-time library search path 8.4.2.4

S

T

  • tablespaces
  • testing
  • testing the upgrade process 2.8
  • text initialization parameter file (PFILE) 2.5
  • TNS-03505: Failed to resolve name 7.3.4
  • tnsnames.ora location 7.3.4
  • token limitations 10.7.1.5
  • training, where to find 2.1.1
  • translate attribute (deprecated) 10.8.4.20, 10.9.3.37
  • Transportable Export/Import 2.1.4.3.4
  • troubleshooting
    • authentication protocol errors 2.4.6, 2.4.7
    • AutoUpgrade 4.4.1
    • Autoupgrade utility 4.13
    • bringing up tablespaces after catastrophic upgrade failures 2.4.10
    • catupgrd.sql deprecation error 10.9.1.1
    • CDB_JAVA_POLICY errors 6.9
    • datapatch failures 6.15
    • EDITION session error 6.7
    • Flash Recovery Area 6.6
    • INVALID objects 6.4
    • locked out accounts 2.4.4
    • ORA-00942 table or view does not exist 6.5
    • ORA-03134: Connections to this server version are no longer supported. 10.8.1.10
    • ORA-1017 invalid username/password 10.8.1.10
    • ORA-39709 9.6
    • ORA-45415 3.1
    • ORA-65394 runtime error 10.7.1.6
    • passwords, forgotten 2.4.4
    • PLS-1919 compile time error 10.7.1.6
    • REMOTE_LOGIN_PASSWORDFILE warning 2.4.5
    • rollback segments/undo tablespace 6.6
    • running out of resources 6.6
    • services running in old Oracle home after upgrade 10.7.1.3
    • shared memory 6.6
    • starting database in upgrade mode 6.2
    • SYSTEM and SYSAUX tablespaces 6.6
    • upgrades 6
    • upgrade termination
      • due to ORA-00904 6.5
      • due to ORA-01722 6.5
  • Troubleshooting
  • troubleshooting the upgrade
    • termination due to ORA_00942 6.5
  • type of software upgrade 8.3

U

  • UNDO_MANAGEMENT initialization parameter 7.4.13
  • unicode collation algorithm 6.1
  • unified auditing
    • See: auditing
    • about transferring audit records after upgrade 7.4.19.1
    • transferring unified audit records after upgrade 7.4.19.2
  • unified audit trail
  • unplug-plug upgrades 2.1.5
  • upg_summary.rpt 6.11.3
  • UPG-3009: There are plugin violations 10.4.1.2
  • UPGRADED status 6.11.1
  • upgraded test databases 2.1.6.8
  • upgrade methods
  • upgrade path
  • upgrade procedures
  • upgrade process testing 2.8
  • upgrade summary report
  • upgrading
    • applications 8
      • compatibility rules 8.4
      • options 8.7
      • relinking 8.4
    • defined 1.2.1
    • initialization parameters 2.5
    • new administrative procedures 7.4.12
    • Oracle Database software 3.3
    • Oracle Forms applications 8.9
    • postupgrade actions 7
    • preparation 2.1
    • recovery catalog 7.4.20
    • SQL*Plus scripts 8.8
    • statistics tables 7.4.4
    • testing 2.1.6
    • troubleshooting 6
    • using the Database Upgrade Assistant D.1
    • where to find information about 1.2.3
  • upgrading a cluster database
    • setting the CLUSTER_DATABASE initialization parameter 2.5
  • UTL_FILE 10.7.1.7
  • UTL_FILE_DIR deprecated 10.8.5
  • utlrp.sql 1.3.5, 7.3.2, A.1
  • utlrp.sql script
    • for recompiling invalid objects 9.5.2
  • utluptabdata.sql 10.8.1.9
  • utlusts.sql 6.4, 6.11.1, 7.1, A.1

V

W

  • warning XDB now invalid error 6.14
  • Windows
  • workloads

X

Z

  • Zero Data Loss Recovery Appliance