Table of Contents
- Title and Copyright Information
- Preface
-
1
Introduction to Upgrading Oracle Database
- Oracle Database Releases That Support Direct Upgrade
- Overview of Oracle Database Upgrade Tools and Processes
- Major Steps in the Upgrade Process for Oracle Database
-
Compatibility and Interoperability Between Oracle Database Releases
- About Oracle Database Release Numbers
- Convention for Referring to Release Numbers in Upgrade Topics
-
What Is Oracle Database Compatibility?
- Understanding Oracle Database Compatibility
- When to Set the COMPATIBLE Initialization Parameter in Oracle Database
- About the COMPATIBLE Initialization Parameter in Oracle Database
- Values for the COMPATIBLE Initialization Parameter in Oracle Database
- About Downgrading and Compatibility for Upgrading Oracle Database
- How the COMPATIBLE Initialization Parameter Operates in Oracle Database
- Checking the Compatibility Level of Oracle Database
- What Is Interoperability for Oracle Database Upgrades?
- About Invalid Schema Objects and Database Upgrades
- About Running Multiple Oracle Database Releases
-
About Converting Databases During Upgrades
- Overview of Converting Databases During Upgrades
- About Upgrading Using Standby Databases
- Overview of Steps for Upgrading Oracle Database Using Oracle GoldenGate
- Migrating From Standard Edition to Enterprise Edition of Oracle Database
- Migrating from Enterprise Edition to Standard Edition of Oracle Database
- Migrating from Oracle Database Express Edition (Oracle Database XE) to Oracle Database
- About Upgrading Platforms for a New Oracle Database Release
- About Image-Based Oracle Database Installation
-
2
Preparing to Upgrade Oracle Database
-
Tasks to Prepare for Oracle Database Upgrades
- Become Familiar with New Oracle Database Features
- Pre-Upgrade Information Check with AutoUpgrade
- Review Deprecated and Desupported Features
-
Choose an Upgrade Method for Oracle Database
- The AutoUpgrade Utility Method for Upgrading Oracle Database
- The Replay Upgrade Method for Upgrading Oracle Database
- The Graphical User Interface Method for Upgrading Oracle Database
- The Manual, Command-Line Method for Upgrading Oracle Database
- The Export/Import Method for Migrating Data When Upgrading Oracle Database
- Choose a New Location for Oracle Home when Upgrading
-
Develop a Test Plan for Upgrading Oracle Database
- Upgrade Testing
- Minimal Testing
- Functional Testing After Upgrades
- High Availability Testing
- Integration Testing to Ensure Applications are Compatible
- Performance Testing an Upgraded Oracle Database
- Volume and Load Stress Testing for Oracle Database Upgrades
- Test Plan Guidelines for Oracle Database Upgrade Planning
- Schema-Only Accounts and Upgrading EXPIRED Password Accounts
- Back Up Files to Preserve Downgrade and Recovery Options
- Installing the New Oracle Database Software for Single Instance
- Installing the New Oracle Database Software for Oracle RAC
-
Database Preparation Tasks to Complete Before Starting Oracle Database Upgrades
- Release Updates and Requirements for Upgrading Oracle Database
- Upgrades and Transparent Data Encryption
- Recommendations for Oracle Net Services When Upgrading Oracle Database
- When You Must Disable Oracle Database Vault
- Create or Migrate Your Password File with ORAPWD
- Understanding Password Case Sensitivity and Upgrades
- Checking for Accounts Using Case-Insensitive Password Version
- Resource and Password Parameter Updates for STIG and CIS Profiles
- Check for Profile Scripts (glogin.sql and login.sql)
- Running Upgrades with Read-Only Tablespaces
- High Availability Options for Oracle Database
- Options for High Availability with Oracle Database Standard Edition
- Moving Operating System Audit Records into the Unified Audit Trail
- Non-CDB Upgrades and Oracle GoldenGate
- Back Up Very Large Databases Before Using AutoUpgrade
- Preparing the New Oracle Home for Upgrading
- Prerequisites for Preparing Oracle Home on Windows
- Performing Preupgrade Checks Using AutoUpgrade
- Testing the Upgrade Process for Oracle Database
- Requirements for Upgrading Databases That Use Oracle Label Security and Oracle Database Vault
- Back Up Oracle Database Before Upgrading
-
Tasks to Prepare for Oracle Database Upgrades
-
3
Upgrading Databases with Oracle
Data Guard Standbys
- Preparing for Database Rolling Upgrades Using Oracle Data Guard
- Before You Patch or Upgrade the Oracle Database Software
- Recovering After the NOLOGGING Clause Is Specified
- Enable an Appropriate Logging Mode
- Creating a Physical Standby Task 1: Create a Backup Copy of the Primary Database Data Files
- Creating a Physical Standby Task 2: Create a Control File for the Standby Database
- Creating a Physical Standby Task 3: Create a Parameter File for the Standby Database
- Upgrading Oracle Database with a Physical Standby Database in Place
- Creating a Physical Standby Task 4: Copy Files from the Primary System to the Standby System
- Creating a Physical Standby Task 5: Set Up the Environment to Support the Standby Database
- Creating a Physical Standby Task 6: Start the Physical Standby Database
- Creating a Physical Standby Task 7: Verify the Physical Standby Database Is Performing Properly
-
4
Using AutoUpgrade for Oracle Database Upgrades
- About Oracle Database AutoUpgrade
- Examples of How to Use AutoUpgrade
- AutoUpgrade Messages and Process Description Terms
- About AutoUpgrade Processing Modes
- Understanding AutoUpgrade Workflows and Stages
- Understanding Non-CDB to PDB Upgrades with AutoUpgrade
- Understanding Unplug-Plug Upgrades with AutoUpgrade
- AutoUpgrade Command-Line Parameters and Options
- AutoUpgrade Utility Configuration Files
-
AutoUpgrade and Oracle Database
Configuration Options
- Non-CDB to PDB Upgrade Guidelines and Examples
- AutoUpgrade Process Flow for Oracle Grid Infrastructure Managed Configurations
- Oracle RAC Requirements for Upgrade with AutoUpgrade
- Preparing for Oracle RAC Upgrades Using AutoUpgrade
- AutoUpgrade and Oracle Data Guard
- How to Run AutoUpgrade Using the Fast Deploy Option
-
AutoUpgrade Configuration File
Examples
- Updating the TDE Wallet Store Location During Upgrade Using AutoUpgrade
- AutoUpgrade Configuration File with Two Database Entries
- Standardizing Upgrades With AutoUpgrade Configuration File Entries
- AutoUpgrade Configuration File for Incremental Upgrade of a Set of PDBs
- How to Run AutoUpgrade in a Script or Batch job
- AutoUpgrade before_action Local Parameter Example
- AutoUpgrade Internal Settings Configuration File
- AutoUpgrade Log File Structure
- Enabling Full Deployments for AutoUpgrade
- Examples of How to Use the AutoUpgrade Console
- How to Override Default Fixups
- Local Configuration File Parameter Fixups Checklist Example
- Proper Management of AutoUpgrade Database Changes
- AutoUpgrade and Microsoft Windows ACLs and CLIs
-
5
Upgrading Oracle Database Using Parallel
Upgrade Utility or Replay Upgrade
- Upgrading Manually with Parallel Upgrade Utility
-
Manual Upgrade Scenarios for Multitenant Architecture Oracle Databases
- About Oracle Multitenant Oracle Database Upgrades
- Coordinate Upgrades of Proxy PDBs with Multitenant Upgrades
- Manually Upgrading a Multitenant Container Oracle Database (CDB)
- About Upgrading PDBs Using the Parallel Upgrade Utility with Priority Lists
- About PDB Upgrades Using Priority Lists, Inclusion Lists, and Exclusion Lists
- Oracle Label Security Integration in a Multitenant Environment
- Upgrading Multitenant Architecture In Parallel
- Upgrading Multitenant Architecture Sequentially Using Unplug-Plug
- About Transporting and Upgrading a Database (Full Transportable Export/Import)
-
Upgrading Oracle Database Releases
Using Replay Upgrade
- Upgrading CDBs or PDBs Using Replay Upgrade
- How to Disable or Enable Replay Upgrade
- About Upgrading Non-CDBs to PDBs Using Replay Upgrade
- Adopting and Upgrading a Non-CDB as a PDB with Replay Upgrade
- How the Replay Upgrade Procedure is Enabled or Disabled on CDBs and PDBs
- Failure and Recovery Scenarios for Replay Upgrade Processes
- Manual Non-CDB Oracle Database Release Upgrades to Multitenant Architecture
- Upgrading Oracle Database Using Fleet Patching and Provisioning
- Rerunning Upgrades for Oracle Database
-
6
Troubleshooting the Upgrade for Oracle
Database
- Error Upgrading Non-CDB Oracle Databases
- Fixed View Queries Restriction When Starting Oracle Database in Upgrade Mode
- Resolving PDBs in Restricted Mode After Successful Upgrades
- Invalid Object Warnings and DBA Registry Errors
- Invalid Objects and Premature Use of Postupgrade Tool
- Resolving Oracle Database Upgrade Script Termination Errors
- Troubleshooting Causes of Resource Limits Errors while Upgrading Oracle Database
- Resolving SQL*Plus Edition Session Startup Error for Oracle Database
- Error ORA-00020 Maximum Number of Processes Exceeded When Running utlrp.sql
- Fixing ORA-28365: Wallet Is Not Open Error
- Resolving issues with view CDB_JAVA_POLICY
- Continuing Upgrades After Server Restarts (ADVM/ACFS Driver Error)
- Component Status and Upgrades
- Standard Edition Starter Database and Components with Status OPTION OFF
- Adjusting Oracle ASM Password File Location After Upgrade
- Fixing "Warning XDB Now Invalid" Errors with Pluggable Database Upgrades
- Fixing ORA-27248: sys.dra_reevaluate_open_failures is running
- Fixing Failed Upgrades Where Only Datapatch Fails
- Fixing Failures to Complete Registration of Listeners with DBUA
-
7
Postupgrade Tasks for Oracle Database
- Check the Upgrade With Post-Upgrade Status Tool
- How to Show the Current State of the Oracle Data Dictionary
-
Required Tasks to Complete After Upgrading Oracle Database
- Setting Environment Variables on Linux and Unix Systems After Manual Upgrades
- Recompiling All Invalid Objects
- Track Invalid Object Recompilation Progress
- Update Listener Files Location on Oracle RAC Cluster Member Upgrades
- Setting oratab and Scripts to Point to the New Oracle Location After Upgrading Oracle Database
- Check PL/SQL Packages and Dependent Procedures
- Upgrading Tables Dependent on Oracle-Maintained Types
- Upgrading Statistics Tables Created by the DBMS_STATS Package After Upgrading Oracle Database
- Configuring the FTP and HTTP Ports and HTTP Authentication for Oracle XML DB
- Install Oracle Text Supplied Knowledge Bases After Upgrading Oracle Database
- Drop Earlier Release Oracle Application Express
- Replace the DEMO Directory in Read-Only Oracle Homes
- Configure Access Control Lists (ACLs) to External Network Services
- Enabling Oracle Database Vault After Upgrading Oracle Database
- Check for the SQLNET.ALLOWED_LOGON_VERSION Parameter Behavior
-
Recommended and Best Practices to Complete After Upgrading Oracle Database
- Back Up the Database
- Run AutoUpgrade Postupgrade Checks
- Gathering Dictionary Statistics After Upgrading
- Regathering Fixed Objects Statistics with DBMS_STATS
- Reset Passwords to Enforce Case-Sensitivity
- Finding and Resetting User Passwords That Use the 10G Password Version
- Understand Oracle Grid Infrastructure, Oracle ASM, and Oracle Clusterware
- Oracle Grid Infrastructure Installation and Upgrade and Oracle ASM
- Add New Features as Appropriate
- Develop New Administrative Procedures as Needed
- Migrating From Rollback Segments To Automatic Undo Mode
- Migrating Tables from the LONG Data Type to the LOB Data Type
-
Migrate Your Upgraded Oracle Databases to Use Unified Auditing
- Understanding Unified Auditing Migration Process for Oracle Database
- Migrating to Unified Auditing for Oracle Database
- About Managing Earlier Audit Records After You Migrate to Unified Auditing
- Removing the Unified Auditing Functionality
- Obtaining Documentation References if You Choose Not to Use Unified Auditing
- Identify Oracle Text Indexes for Rebuilds
- Dropping and Recreating DBMS_SCHEDULER Jobs
- Transfer Unified Audit Records After the Upgrade
- About Recovery Catalog Upgrade After Upgrading Oracle Database
- Enabling Disabled Release Update Bug Fixes in the Upgraded Database
- About Testing the Upgraded Production Oracle Database
- Upgrading the Time Zone File Version After Upgrading Oracle Database
- Recommended Tasks After Upgrading an Oracle RAC Database
- Recommended Tasks After Upgrading Oracle ASM
- Recommended Tasks After Upgrading Oracle Database Express Edition
-
Tasks to Complete Only After Manually Upgrading Oracle Database
- Changing Passwords for Oracle Supplied Accounts
- Migrating Your Initialization Parameter File to a Server Parameter File
- Identifying and Copying Oracle Text Files to a New Oracle Home
- Upgrading the Oracle Clusterware Configuration
- Adjust the Initialization Parameter File for the New Release
- Set CLUSTER_DATABASE Initialization Parameter For Oracle RAC After Upgrade
-
8
Upgrading Applications After Upgrading Oracle Database
- Overview of Upgrading Applications on a New Oracle Database Release
- Compatibility Issues for Applications on Different Releases of Oracle Database
- Software Upgrades and Client and Server Configurations for Oracle Database
- Compatibility Rules for Applications When Upgrading Oracle Database Client or Server Software
- About Upgrading Precompiler and OCI Applications in Oracle Database
- Schema-Only Accounts and Upgrading EXPIRED Password Accounts
- About Upgrading Options for Oracle Precompiler and OCI Applications
- Upgrading SQL*Plus Scripts and PL/SQL after Upgrading Oracle Database
- About Upgrading Oracle Forms or Oracle Developer Applications
-
9
Downgrading Oracle Database to an Earlier Release
- Supported Releases for Downgrading Oracle Database
- Check for Incompatibilities When Downgrading Oracle Database
- Perform a Full Backup Before Downgrading Oracle Database
- Performing Required Predowngrade Steps for Oracle Database
- Using Scripts to Downgrade Oracle Database 21c
- Downgrading a Single Pluggable Oracle Database (PDB)
- Downgrading PDBs That Contain Oracle Application Express
-
Post-Downgrade Tasks for Oracle Database Downgrades
- Reapply Release Update and Other Patches After Downgrade
- Re-enabling Oracle Database Vault after Downgrading Oracle Database
- Restoring the Configuration for Oracle Clusterware
-
Restoring Oracle Enterprise Manager after Downgrading Oracle Database
- Requirements for Restoring Oracle Enterprise Manager After Downgrading
-
Running EMCA to Restore Oracle Enterprise Manager After Downgrading
- Running emca on a Single-Instance Oracle Database Without Oracle ASM
- Running EMCA on an Oracle RAC Database Without Oracle ASM
- Running EMCA on a Single-Instance Oracle ASM Instance
- Running emca on an Oracle ASM on Oracle RAC Instance
- Running emca on a Single-Instance Oracle Database With Oracle ASM
- Running emca on an Oracle RAC Database and Oracle ASM Instance
- Running the emdwgrd utility to restore Enterprise Manager Database Control
- Restoring Oracle Application Express to the Earlier Release
- Gathering Dictionary Statistics After Downgrading
- Regathering Fixed Object Statistics After Downgrading
- Regathering Stale CBO Statistics After Downgrade
- Troubleshooting the Downgrade of Oracle Database
-
10
Behavior Changes, Deprecated and Desupported Features for Oracle Database
- About Deprecated and Desupported Status
-
Behavior Changes, Deprecations and
Desupports in Oracle Database 21c
- Behavior Changes for Oracle Database 21c Upgrade Planning
-
Deprecated Features in Oracle
Database 21c
- Deprecation of FILE_DATASTORE Type
- Deprecation of URL_DATASTORE Text Type
- Deprecation of AUTO OPTIMIZE Framework
- Deprecation of CTXFILTERCACHE Query Operator
- Deprecation of Policy-Managed Databases
- Deprecation of Traditional Auditing
- Deprecation of Older Encryption Algorithms
- Deprecation of Cluster Domain - Domain Services Cluster
- Deprecation of Enterprise User Security (EUS) User Migration Utility
- Logical Standby and New Data Types
- Deprecation of Sharded Queues
- Deprecation of MySQL Client Library Driver for Oracle
- Deprecation of TLS 1.0 and 1.1 Transport Layer Security
- Deprecation of Unix Crypt (or MD5crypt) Password Verifier
- Deprecation of ODP.NET OracleConfiguration.DirectoryType Property
- Deprecation of Weaker Encryption Key Strengths
- Deprecation of DBSNMP Packages for Adaptive Thresholds Feature
- Deprecation of Oracle GoldenGate Replication for Oracle Sharding High Availability
- Deprecation of Anonymous Cipher Suites with Outbound TLS Connections
- Deprecation of the KERBEROS5PRE Adapter
- Deprecation of Oracle Wallet Manager
- Deprecation of Oracle Enterprise Manager Database Express
- Deprecation of SHA-1 use for SQLNET and DBMS_CRYPTO
- Deprecation of Repository Events
- Deprecation of Service Attribute Value SESSION_STATE_CONSISTENCY = STATIC
- Deprecation of ACFSUTIL REPL REVERSE
- Deprecation of Oracle OLAP
- Deprecated Views in Oracle Database 21c
- Deprecated Parameters in Oracle Database 21c
-
Desupported Features in Oracle
Database 21c
- Desupport of DBMS_OBFUSCATION_TOOLKIT Package
- Desupport of Several XML Database (XDB) features
- Desupport of DBMS_LOB.LOADFROMFILE and LOB Buffering
- Desupport of Oracle Data Guard Broker Properties and Logical Standby
- Desupport of DBMS_CRYPTO_TOOLKIT_TYPES and DBMS_CRYPTO_TOOLKIT
- Desupport of Non-CDB Oracle Databases
- Desupport of Cluster Domain Member Clusters
- Desupport of Unicode Collation Algorithm (UCA) 6.1 Collations
- Desupport of ACFS on Microsoft Windows
- Desupport of Oracle ACFS Security (Vault) and ACFS Auditing
- Desupport of Oracle ACFS on Member Clusters (ACFS Remote)
- Desupport of ACFS Encryption on Solaris and Windows
- Desupport of ACFS Replication REPV1
- Desupport of Vendor Clusterware Integration with Oracle Clusterware
- Desupport of VERIFY_FUNCTION and VERIFY_FUNCTION_11G
- Desupport of Deprecated Oracle Database Vault Roles
- Desupport of Anonymous RC4 Cipher Suite
- Desupport of Adobe Flash-Based Oracle Enterprise Manager Express
- Desupport of Intelligent Data Placement (IDP)
- Desupport of XML DB Content Connector
- Desupport of DBMS_XMLSAVE
- Desupport of DBMS_XMLQUERY
- Desupport of FIPS Protect and Process Strength 0
- Desupport of PDB Flat File Dictionary Dumps
- Desupport of Oracle Fail Safe
- Desupported Initialization Parameters in Oracle Database 21c
-
Behavior Changes, Deprecations and Desupports in Oracle Database 19c
-
Behavior Changes for Oracle Database 19c Upgrade Planning
- Changes to Oracle Data Guard Properties Management
- Rapid Home Provisioning (RHP) Name Change
- Resupport of Direct File Placement for OCR and Voting Disks
- Optional Install for the Grid Infrastructure Management Repository
- Support for DBMS_JOB
- About Standard Edition High Availability
- Manage "Installed but Disabled" Module Bug Fixes with DBMS_OPTIM_BUNDLE
-
Deprecated Features in Oracle Database 19c
- Oracle Data Guard Broker Deprecated Properties
- Oracle Data Guard Logical Standby Properties Deprecated
- Deprecation of ASMCMD PWCREATE On Command Line
- Deprecation of Addnode Script
- Deprecation of clone.pl Script
- Deprecation of Oracle Fail Safe
- Deprecation of GDSCTL Operating System Command-Line Password Resets
- Deprecation of Oracle Enterprise Manager Express
- Deprecation of DV_REALM_OWNER Role
- Deprecation of DV_REALM_RESOURCE Role
- Deprecation of DV_PUBLIC Role
- Deprecation of Oracle ACFS Replication Protocol REPV1
- Deprecation of Oracle ACFS Encryption on Solaris and Windows
- Deprecation of Oracle ACFS on Windows
- Deprecation of Oracle ACFS Security (Vault) and ACFS Auditing
- Deprecation of Oracle ACFS on Member Clusters (ACFS Remote)
- Deprecation of Cluster Domain - Member Clusters
- Deprecation of Vendor Clusterware Integration with Oracle Clusterware
- Deprecated Initialization Parameters in Oracle Database 19c
-
Desupported Features in Oracle Database 19c
- Desupport of Oracle Data Provider for .NET Promotable Transaction Setting
- Desupport of Oracle Multimedia
- Desupport of the CONTINUOUS_MINE feature of LogMiner
- Desupport of Extended Datatype Support (EDS)
- Data Guard Broker MaxConnections Property Desupported
- Desupport of Leaf Nodes in Flex Cluster Architecture
- Desupport of Oracle Streams
- Desupport of PRODUCT_USER_PROFILE Table
- Desupport of Oracle Real Application Clusters for Standard Edition 2 (SE2) Database Edition
- Desupported Parameters in Oracle Database 19c
-
Behavior Changes for Oracle Database 19c Upgrade Planning
-
Behavior Changes, Deprecations and Desupports in Oracle Database 18c
-
Behavior Changes for Oracle Database 18c Upgrade Planning
- Simplified Image-Based Oracle Database Installation
- Support Indexing of JSON Key Names Longer Than 64 Characters
- Upgrading Existing Databases is Replaced With Image Installations
- About RPM-Based Oracle Database Installation
- Token Limitations for Oracle Text Indexes
- Changes to /ALL/USER/DBA User View and PL/SQL External Libraries
- Symbolic Links and UTL_FILE
- Deprecation of Direct Registration of Listeners with DBCA
- UNIFORM_LOG_TIMESTAMP_FORMAT Changes in INIT.ORA
-
Deprecated Features in Oracle Database 18c
- Data Guard MAX_CONNECTIONS Attribute is Deprecated
- Extended Datatype Support (EDS) is Deprecated
- GET_* Functions Deprecated in the DBMS_DATA_MINING Package
- Package DBMS_XMLQUERY is deprecated
- Package DBMS_XMLSAVE is Deprecated
- Deprecated Columns in Oracle Label Security Views
- Returning JSON True or False Values using NUMBER is Deprecated
- Deprecation of MAIL_FILTER in Oracle Text
- Deprecation of asmcmd showversion Option
- Deprecation of NEWS_SECTION_GROUP in Oracle Text
- Oracle Net Services Support for SDP is Deprecated
- Deprecation of Flex Cluster (Hub/Leaf) Architecture
- Deprecation of PRODUCT_USER_PROFILE Table
-
Desupported Features in Oracle Database 18c
- Oracle Administration Assistant for Windows is Desupported
- Oracle Multimedia DICOM Desupported Features
- Oracle Multimedia Java Client Classes Desupported
- Oracle XML DB Desupported Features
- ODP.NET, Managed Driver - Distributed Transaction DLL Desupported
- Data Guard Broker DGMGRL ALTER Syntax is Desupported
- Desupport of CRSUSER on Microsoft Windows Systems
- Desupported Initialization Parameters in Oracle Database 18c
- Deprecation of Oracle Multimedia
- Terminal Release of Oracle Streams
-
Behavior Changes for Oracle Database 18c Upgrade Planning
-
Behavior Changes, Deprecations and Desupports in Oracle Database 12c Release 2 (12.2)
-
Behavior Changes in Oracle Database 12c Release 2 (12.2)
- Initialization Parameter Default Changes in Oracle Database 12c Release 2 (12.2)
- Database Upgrade Assistant (DBUA) Enhancements and Changes
- Enhancements to Oracle Data Guard Broker and Rolling Upgrades
- About Changes in Default SGA Permissions for Oracle Database
- Network Access Control Lists and Upgrade to Oracle Database 12c
- Parallel Upgrade Utility Batch Scripts
- Unified Auditing AUDIT_ADMIN and AUDIT_VIEWER Roles Changes
- Oracle Update Batching Batch Size Settings Disabled
- About Upgrading Tables Dependent on Oracle-Maintained Types
- Case-Insensitive Passwords and ORA-1017 Invalid Username or Password
- About Deploying Oracle Grid Infrastructure Using Oracle Fleet Patching and Provisioning
- Restrictions Using Zero Data Loss Recovery Appliance Release 12.1 Backups
- Client and Foreground Server Process Memory Changes
- Deprecated Initialization Parameters in Oracle Database 12c Release 2 (12.2)
-
Deprecated Features in Oracle Database 12c Release 2 (12.2)
- Deprecation of ALTER TYPE REPLACE
- Deprecation of configToolAllCommands Script
- Deprecation of DBMS_DEBUG Package
- Deprecation of Intelligent Data Placement (IDC)
- Deprecation of CONTINUOUS_MINE Option
- Deprecation of Non-CDB Architecture
- Deprecation of Oracle Administration Assistant for Windows
- Deprecation of Oracle Data Provider for .NET PromotableTransaction Setting
- Deprecation of oracle.jdbc.OracleConnection.unwrap()
- Deprecation of oracle.jdbc.rowset Package
- Deprecation of oracle.sql.DatumWithConnection Classes
- Deprecation of Oracle Multimedia Java APIs
- Deprecation of Oracle Multimedia Support for DICOM
- Deprecation of Multimedia SQL/MM Still Image Standard Support
- Deprecation of Unicode Collation Algorithm (UCA) 6.1 Collations
- Deprecation of UNIFIED_AUDIT_SGA_QUEUE_SIZE
- Deprecation of VERIFY_FUNCTION and VERIFY_FUNCTION_11G
- Deprecation of V$MANAGED_STANDBY
- Deprecation of Some XML DB Functions
- Deprecated Features for Oracle XML Database
- Desupported Initialization Parameters in Oracle Database 12c Release 2 (12.2)
-
Desupported Features in Oracle Database 12c Release 2 (12.2)
- Desupport of Advanced Replication
- Desupport of Direct File System Placement for OCR and Voting Files
- Desupport of JPublisher
- Desupported Oracle Data Provider for .NET APIs for Transaction Guard
- Desupported Views in Oracle Database 12c Release 2 (12.2)
- SQLJ Support Inside Oracle Database
- Desupport of Some XML DB Features
-
Behavior Changes in Oracle Database 12c Release 2 (12.2)
- A Oracle Database Upgrade Utilities
-
B
Upgrading with Oracle Database Upgrade Assistant (DBUA)
- Requirements for Using DBUA
- About Stopping DBUA When Upgrading
- How DBUA Processes the Upgrade for Oracle Database
- Upgrade Scripts Started by DBUA
- Using DBUA to Upgrade the Database on Linux, Unix, and Windows Systems
- Moving a Database from an Existing Oracle Home
- Using DBUA in Silent Mode to Upgrade Oracle Database
- Running DBUA with Different ORACLE_HOME Owner
- Migrating from Oracle ACFS to Alternative Storage Before Using DBUA
- C AutoUpgrade Error Messages
- Index