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
-
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
- Updating 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
- Choose a New Location for Oracle Home when Upgrading or Patching
-
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
- Upgrade Oracle Call Interface (OCI) and Precompiler Applications
- Requirements for Upgrading Databases That Use 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 Upgrades of Databases Using Oracle Data Guard
- Manual Non-CDB to PDB Conversion and Upgrade with Data Guard Standby
- 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 Parameters and Options
-
Locally Modifiable Global Parameters for AutoUpgrade Configuration File
- defer_standby_log_shipping
- dictionary_stats_after
- dictionary_stats_before
- drop_grp_after_upgrade
- enable_local_undo
- export_rman_backup_for_noncdb_to_pdb
- fixed_stats_before
- manage_network_files
- patch_in_upgrade_mode
- remove_underscore_parameters
- restoration
- rman_catalog_connect_string
- target_base
- target_home
- target_version
-
Local Parameters for the AutoUpgrade Configuration File
- add_after_upgrade_pfile
- add_during_upgrade_pfile
- after_action
- before_action
- catctl_options
- checklist
- close_source
- del_after_upgrade_pfile
- del_during_upgrade_pfile
- delete_wincredential_file
- download
- drop_win_src_service
- env
- exclusion_list
- folder
- home_settings.ru_apply
- ignore_errors
- keep_pdb_save_state
- keep_source_pdb
- log_dir
- manage_standbys_clause
- method
- parallel_pdb_creation_clause
- patch
- patch_in_upgrade_mode
- pdbs
- platform
- raise_compatible
- remove_rac_config
- remove_underscore_parameters
- replay
- restoration
- revert_after_action
- revert_before_action
- run_dictionary_health
- run_utlrp
- sid
- skip_tde_key_import
- source_base
- source_dblink
- source_home
- source_ldap_admin_dir
- source_tns_admin_dir
- start_time
- target_base
- target_cdb
- target_pdb_copy_option=file_name_convert
- target_pdb_name
- target_ldap_admin_dir
- target_tns_admin_dir
- timezone_upg
- tune_setting
- upgrade_node
- wincredential
-
Global Parameters for the AutoUpgrade User Configuration File
- add_after_upgrade_pfile
- add_during_upgrade_pfile
- after_action
- autoupg_log_dir
- before_action
- catctl_options
- del_after_upgrade_pfile
- del_during_upgrade_pfile
- drop_grp_after_upgrade
- global_log_dir
- json_progress_writing_interval
- keystore
- raise_compatible
- replay
- target_base
- target_home
- target_version
- upgradexml
-
Locally Modifiable Global Parameters for AutoUpgrade Configuration File
-
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
- How to Perform an Unplug-Plug Upgrade of an Encrypted PDB
- How to Perform a Non-CDB to PDB Conversion of an Encrypted PDB
- AutoUpgrade Patching
-
AutoUpgrade Configuration File
Examples
- Create Configuration File for AutoUpgrade
- 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
- AutoUpgrade Configuration File For Upgrading PDBs Already in the Target CDB
- How to Run AutoUpgrade in a Script or Batch job
- Unplug-Plug Relocate Upgrades With AutoUpgrade
- Ignore Fixups and Checks Using the AutoUpgrade Configuration File
- Run Custom Scripts Using AutoUpgrade
- AutoUpgrade Internal Settings Configuration File
- AutoUpgrade Log File Structure
- Enabling Full Deployments for AutoUpgrade
- Examples of How to Use the AutoUpgrade Console
- Known Restrictions for AutoUpgrade
- Proper Management of AutoUpgrade Database Changes
- How to Override Default Fixups
- Local Configuration File Parameter Fixups Checklist Example
- AutoUpgrade and Microsoft Windows ACLs and CLIs
- 5 Upgrades of PDBs and Non-CDBs Using Replay Upgrade, AutoUpgrade or FPP Gold Image
-
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 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
- 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 Failed Upgrades Where Only Datapatch Fails
-
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
- Recompile Invalid Objects in the Database
- 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
- Install Oracle Text Supplied Knowledge Bases After Upgrading Oracle Database
- Drop Earlier Release Oracle APEX
- 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
- Upgrading Statistics Tables Created by the DBMS_STATS Package After Upgrading Oracle Database
- Regathering Fixed Objects Statistics with DBMS_STATS
- Reset Passwords to Enforce Case-Sensitivity
- Configuring the FTP and HTTP Ports and HTTP Authentication for Oracle XML DB
- 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
- Migrating Tables from Basic LOBs to SecureFiles
- Turn Off Traditional Auditing in Upgraded Oracle Databases
- 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
- Upgrading the Time Zone File Version After Upgrading Oracle Database
- Enabling Disabled Release Update Bug Fixes in the Upgraded Database
- About Testing the Upgraded Production Oracle Database
- Recommended Tasks After Upgrading an Oracle RAC Database
- Recommended Tasks After Upgrading Oracle ASM
- Migrating Oracle Database Express Edition to Oracle Database Free
-
Tasks to Complete After Testing Your Oracle
Database Upgrade
- 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
- Setting the COMPATIBLE Initialization Parameter 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
- Prepare to Downgrade a Standby Database with the Primary
- Check COMPATIBLE Parameter when Downgrading Oracle Database
- Perform a Full Backup Before Downgrading Oracle Database
- Using Scripts to Downgrade Oracle Database 23ai
- Downgrading a Single Pluggable Oracle Database (PDB)
- Downgrading PDBs That Contain Oracle APEX
-
Post-Downgrade Tasks for Oracle Database Downgrades
- Reapply Release Update and Other Patches After Downgrade
- Reenabling Oracle RAC After Downgrading Oracle Database
- Reenabling Oracle Database Vault after Downgrading Oracle Database
- Downgrade the Oracle Grid Infrastructure Configuration for the Database
-
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 APEX to the Earlier Release
- Gathering Dictionary Statistics After Downgrading
- Regathering Fixed Object Statistics After Downgrading
- Regathering Stale CBO Statistics After Downgrade
- Checking Validity of Registry Components After Downgrade
- Troubleshooting the Downgrade of Oracle Database
-
10
Oracle Database Changes,
Desupports, and Deprecations
- About Deprecated and Desupported Status
- Desupported and Deprecated Release Notice Dates
- Using the ORADiff Tool to Find Release Changes
-
Oracle Database 23ai Behavior
Changes, Desupports, and Deprecations
-
Behavior Changes for Oracle
Database 23ai Upgrade Planning
- Oracle Database Release Number Changes
- Oracle Spatial and Obsolete Objects
- REST APIs for AutoUpgrade
- XML JSON Search Index Enhancements
- SQL/JSON Function JSON_VALUE With a Boolean JSON Value
- Migrate from Non-AES Algorithms in FIPS Before Upgrade
- Oracle OLAP Deprecation Extended
- About Read-Only Oracle Homes
- SYSDATE and SYSTIMESTAMP Reflect PDB Time Zone
- Oracle Spatial GeoRaster JPEG Compression on 4-band Raster Blocks
- Document-Identifier Field Names for Duality Views Requirements
- BIGFILE Is the Default for SYSAUX, SYSTEM, and USER Tablespaces
- Terminal Release of Stored Outlines
-
Desupported Features in Oracle
Database 23ai
- ODP.NET OracleConfiguration.DirectoryType Property and .NET Configuration File DIRECTORY_TYPE Setting Desupported
- Original Export Utility (EXP) Desupported
- MySQL Client Library Driver for Oracle Desupported
- ACFSUTIL REPL REVERSE Desupported
- Cluster Domain - Domain Services Cluster Desupported
- DBSNMP Packages for Adaptive Thresholds Feature Desupported
- Policy-Managed Database Deployment Desupported
- Enterprise User Security User Migration Utility Desupport
- Oracle Enterprise Manager Database Express Desupported
- Oracle Wallet Manager (OWM) Desupported
- RASADM Desupported
- Oracle Label Security Parameters and Functions Desupported
- Oracle Internet Directory with Oracle Label Security Desupported
- Granting Administrative Privilege to RADIUS Users Desupported
- Transparent Data Encryption PKI Keys Desupported
- GOST and SEED TDE Cryptographic Encryption Algorithms Desupported
- Oracle Database 10G Password Verifier Desupported
- Transport Layer Security versions 1.0 and 1.1 Desupported
- Unix Crypt (MD5crypt) Password Verifier Desupported
- FIPS Strength 80 Encryption Desupported
- Diffie-Hellman Anonymous Ciphers Desupported
- Oracle Database Extensions for .NET Desupported
- Quality of Service Management Desupported
- Traditional Auditing Desupported
- Desupport of config.sh
- OLS Table LABELS Column Desupport
- Desupport of 32-Bit Oracle Database Clients
- Desupport of Oracle GoldenGate Replication for Oracle Globally Distributed Database High Availability
- Grid Infrastructure Management Repository (GIMR) Desupported
- Data Recovery Advisor (DRA) Desupport
- DBUA and Manual Upgrade Methods Desupported
- Desupport of Oracle Data Masking and Subsetting with Oracle Real Application Testing
- Desupport of Shared Grid Naming Service Option for Addresses
- DBMS_AUDIT_MGMT.FLUSH_UNIFIED_AUDIT_TRAIL Procedure Desupported
- AUDIT_TRAIL_WRITE Mode of the AUDIT_TRAIL_PROPERTY Parameter Desupported
- Cluster Time Synchronization Service Desupported
- Oracle Connection Manager Parameter (CMAN) Password Access Desupported
- Desupport of EUS Current User Database Links
- Desupport of oracle.jdbc.rowset Package
- Desupport of ACFS on IBM AIX
- RECOVER…SNAPSHOT TIME Desupported
-
Desupported Parameters in Oracle
Database 23ai
- EXTERNAL_NAME Parameter in SYS_CONTEXT USERENV Desupported
- Service Attribute Value SESSION_STATE_CONSISTENCY = STATIC Desupported
- Oracle Label Security Parameters and Functions Desupported
- ENCRYPTION_WALLET_LOCATION Parameter Desupported
- ADD_SSLV3_TO_DEFAULT SQLNET.ORA Parameter (and SSLv3) Desupported
- Desupport of OPTIMIZER_SECURE_VIEW_MERGING Parameter
-
Deprecated Features in Oracle
Database 23ai
- PROXY_ONLY_CONNECT Deprecation
- Oracle Database 11g SHA-1 Verifier Deprecated
- RADIUS API Based on RFC-2138 is Deprecated
- Enterprise User Security (EUS) Deprecated
- Auto-Login Wallet Version 6 Deprecated
- WALLET_LOCATION Parameter Deprecated
- RAS Mid-Tier Session Support for Fusion Middleware Deprecated
- Oracle Data Provider for .NET, Unmanaged Driver Deprecation
- GOST and SEED Algorithms Deprecation
- Oracle Persistent Memory Deprecation
- PMEM Support in Oracle Memory Speed File System Deprecation
- Service Name with Partial DN Matching and Server-only Certificate Check Deprecation
- Deprecation of the mkstore Command-Line Utility
- Network Data Model (NDM) XML API Deprecation
- Two Subprograms in SDO_GEOR_ADMIN Package Deprecation
- SDO_GEOR.importFrom and SDO_GEOR.exportTo subprograms in SDO_GEOR Package Deprecations
- WAIT Option of Oracle Data Guard SWITCHOVER Command
- DBMS_RESULT_CACHE Function Name Deprecations
- Oracle ACFS Snapshot Remastering Deprecation
- Oracle ACFS Compression Deprecation
- Oracle Virtual Directory with Real Application Security Deprecation
- BIG_IO Attribute in Oracle Text Deprecation
- ASYNCHRONOUS_UPDATE in Oracle Text Deprecation
- Oracle Text CTXCAT Indextype Deprecation
- Oracle XML DB Repository Deprecation
- DBMS_XMLGEN Deprecation
- DBMS_XMLSTORE Deprecation
- Deprecation of Unstructured XML Indexes
- DBMS_HANG_MANAGER Package Deprecation
- Zero Downtime Upgrade (ZDU) Deprecation
- Highly Available Grid Naming Service (GNS) Deprecation
- Traditional Auditing Packages and Functions Deprecated
- MDSYS-Owned RDF Graph Networks Deprecated
- TREAT (expr AS JSON) Deprecated
- Deprecation of Out-of-Place Patching with Opatch and OPatchAuto
- RCONFIG Utility Deprecation
- UPDATE_SDATA API Deprecation
- Oracle JDBC-OCI Thick Driver Deprecation
- Deprecation of SQLJ
- Oracle JDBC Proprietary BLOB/CLOB Open and Close Methods Deprecation
- Deprecated Views in Oracle Database 23ai
-
Deprecated Parameters in Oracle
Database 23ai
- ENCRYPT_NEW_TABLESPACES Deprecation
- ALLOW_MD5_CERTS and ALLOW_SHA1_CERTS sqlnet.ora Parameter Deprecation
- MY_WALLET_DIRECTORY Connect String Deprecated
- FIPS Parameters Deprecated
- ONE_STEP_PLUGIN_FOR_PDB_WITH_TDE Initialization Parameter Deprecated
- Traditional Audit Initialization Parameters Deprecated
- PRE_PAGE_SGA Initialization Parameter Deprecated
- REMOTE_OS_ROLES Initialization Parameter Deprecated
-
Behavior Changes for Oracle
Database 23ai Upgrade Planning
-
Oracle Database 21c Behavior
Changes, Desupports, and Deprecations
-
Behavior Changes for Oracle
Database 21c Upgrade Planning
- About Read-Only Oracle Homes in Oracle Database 21c
- Multitenant Upgrades Only in Oracle Database 21c
- Logical Standby and New Data Types
- Relocation of HR Sample Schema
- Manage DRCP on PDBs
- Oracle Advanced Cluster File System (Oracle ACFS) Name Change
- Windows Authentication No Longer Uses NTLM by Default
-
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
- Desupport of EUS Current User Database Links
- Desupported Views in Oracle Database 21c
- Desupported Initialization Parameters in Oracle Database 21c
-
Deprecated Features in Oracle
Database 21c
- 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 Service Attribute Value SESSION_STATE_CONSISTENCY = STATIC
- Deprecation of SHA-1 use for SQLNET and DBMS_CRYPTO
- Deprecation of ACFSUTIL REPL REVERSE
- Deprecation of Oracle OLAP
- Deprecation of Oracle Database Extensions for .NET
- Deprecation of Repository Events
- Deprecation of Quality of Service Management
- Grid Infrastructure Management Repository Deprecation
- Deprecated Views in Oracle Database 21c
- Deprecated Parameters in Oracle Database 21c
-
Behavior Changes for Oracle
Database 21c Upgrade Planning
-
Oracle Database 19c Behavior
Changes, Desupports, and Deprecations
-
Behavior Changes for Oracle Database 19c Upgrade Planning
- All Time Zone Files (DST) Included in Release Updates (RUs)
- 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
- Windows Authentication No Longer Uses NTLM by Default
-
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
-
Deprecated Features in Oracle Database 19c
- Deprecation of URL_DATASTORE Text Type
- Deprecation of FILE_DATASTORE Type
- 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 OLAP
- 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
- Deprecation of Black Box Virtual Machine Management Using Oracle Clusterware
- Deprecation of OPatch and OPatchAuto for Out-of-Place Patching
- Data Recovery Advisor (DRA) Deprecation
- DBUA and Manual Upgrade Deprecated
- Cluster Time Synchronization Service Deprecation
- ACFS Deprecation on IBM AIX
- RECOVER…SNAPSHOT TIME Deprecated
- Oracle Data Masking and Subsetting with Oracle Real Application Testing Deprecated
- Deprecated Initialization Parameters in Oracle Database 19c
-
Behavior Changes for Oracle Database 19c Upgrade Planning
-
Oracle Database 18c Behavior
Changes, Desupports, and Deprecations
-
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
-
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
- Terminal Release of Oracle Streams
-
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
- Deprecation of Oracle Multimedia
-
Behavior Changes for Oracle Database 18c Upgrade Planning
-
Oracle Database 12c Release 2
(12.2) Behavior Changes, Desupports, and Deprecations
-
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
-
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
- Desupport of preupgrd.sql and utluppkg.sql
- 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
- Desupported 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
- Deprecated Initialization Parameters in Oracle Database 12c Release 2 (12.2)
-
Behavior Changes in Oracle Database 12c Release 2 (12.2)
-
Oracle Database 12c Release 1
(12.1) Behavior Changes, Desupports, and Deprecations
-
Behavior Changes for Oracle Database 12c Release 1 (12.1)
- Error Associated with catupgrd.sql Run Without PARALLEL=NO
- Change for Standalone Deinstallation Tool
- Changes to Security Auditing Features
- Upgrading a System that Did Not Have SQLNET.ALLOWED_LOGON_VERSION Parameter Setting
- Oracle Warehouse Builder (OWB) Not Installed with Oracle Database
- About Upgrading Oracle Database Release 10.2 or 11.1 and OCFS and RAW Devices
- Change to VARCHAR2, NVARCHAR2, and RAW Datatypes
- Changed Default for RESOURCE_LIMIT Parameter
- Oracle XML DB is Mandatory and Cannot Be Uninstalled
- Direct NFS Enabled By Default for Oracle RAC
-
Desupported Features in Oracle
Database 12c Release 1 (12.1)
- Desupport for Raw Storage Devices
- Desupport of ALTER INDEX OPTIMIZE for Text Indexes
- Desupport of CLEANUP_ORACLE_BASE Property
- Desupport of Oracle Enterprise Manager Database Control
- Desupported Cipher Suites for Secure Sockets Layer (SSL)
- Desupport of Database Rules Manager (RUL) and Expression Filter (EXF)
- Desupport of cluvfy comp cfs for OCFS
- Desupport of Change Data Capture
- Desupported Features in Oracle Data Mining
- Desupported Implicit Connection Caching
- Desupport of ABN Models for Oracle Data Mining Upgrades
- Desupport of OLAP Catalog (AMD)
- Desupport of CSSCAN and CSALTER for Oracle Globalization
- Desupport of Oracle Net Connection Pooling
- Desupport of Oracle Net Listener Password
- Desupport of Oracle Names
- Desupport of Oracle Names Control Utility for Oracle Net Services
- Desupport of CTXXPATH in Oracle Text and Oracle XML DB
- Desupport of SQLNET.KERBEROS5_CONF_MIT Parameter for Oracle Net Services
- Desupport of ALTER INDEX OPTIMIZE for Text Indexes
- Desupport of SYNC [MEMORY memsize] for Text Indexes
- Desupported Features on Microsoft Windows Platforms
-
Deprecated Features in Oracle Database 12c Release 2 (12.2)
- Deprecation of Non-CDB Architecture
- Deprecation of catupgrd.sql Script and Introduction of Parallel Upgrade Utility
- DELETE_CATALOG_ROLE Deprecated
- Deprecated Functions and Parameters in Oracle Label Security
- Deprecated API for Oracle Database Vault
- Deprecated Default Realms for Oracle Database Vault
- Deprecated Default Rule Sets for Oracle Database Vault
- Deprecation of Windows NTS Authentication Using the NTLM Protocol
- Deprecation of Public Key Infrastructure for Transparent Data Encryption
- Oracle Data Guard Broker Deprecated Features
- Deprecated EndToEndMetrics-related APIs
- Deprecation of Oracle Restart
- Deprecation of -checkpasswd for QOSCTL Quality of Service (QoS) Command
- Deprecated NT LAN Manager (NTLM) Protocol for Oracle Net Services
- Deprecated Features for Oracle Call Interface
- Deprecation of Oracle Streams
- Oracle Data Provider for .NET Deprecated Programming Interfaces
- VPD Support in Oracle Database Semantic Technologies is Deprecated
- Version-Enabled Models Support In Oracle Database Semantic Technologies
- Deprecation of Advanced Replication
- Deprecation of Single-Character SRVCTL CLI Options
- Deprecation of Stored List of Administrative Users for Cluster Administration
- Deprecation of SQLJ Inside the Server
- Deprecated Oracle Update Batching
- Deprecated EndToEndMetrics-related APIs
- Deprecated Stored Outlines
- Deprecated Concrete Classes in oracle.sql Package
- Deprecated defineColumnType Method
- Deprecated CONNECTION_PROPERTY_STREAM_CHUNK_SIZE Property
- Oracle Data Pump Export Utility Features
- Version-Enabled Models Support In Oracle Database Semantic Technologies
- Deprecated defineColumnType Method
- Deprecated NT LAN Manager (NTLM) Protocol for Oracle Net Services
- Deprecated Features for Oracle Call Interface
- Deprecation of Stored List of Administrative Users for Cluster Administration
- Deprecation of -cleanupOBase
- Deprecated Features for Oracle XML Database
- Deprecation of Advanced Replication
- DICOM in Oracle Multimedia Deprecated in Oracle Database 12c Release 1 (12.1)
- Deprecation of JPublisher
- Deprecated Initialization Parameters in Oracle Database 12c Release 1 (12.1)
- Deprecated Views in Oracle Database 12c Release 1 (12.1)
-
Behavior Changes for Oracle Database 12c Release 1 (12.1)
- A Oracle Database Upgrade Utilities
- B AutoUpgrade Error Messages
- C AutoUpgrade REST APIs
- Index