Title and Copyright Information
- Oracle 11g To 12c Migration
- Oracle 11g Client To 12c
- Oracle 11g 12c Differences
- Oracle 12c Upgrade Guide
- 11g To 12c Upgrade Document
- Oracle 12c Upgrade Issues
Apr 11, 2012 Manual database upgrade to oracle 11g on windows. Upgrade Guide for instructions to save the EM data prior to upgrade. Now create the new parameter file for 11g database from the pfile created earlier, changing the parameters as suggested earlier in preupgrade script. Upgrading Oracle Database Manually. Backing Up Oracle Database for a Manual Upgrade; Preparing the New Oracle Home for a Manual Upgrade; Manually Upgrading Oracle Database. About the Post-Upgrade Status Tool; Troubleshooting the Upgrade of Oracle Database. Pre-Upgrade Oracle Home Removal on Oracle RAC; Resource Limits and Oracle Database Upgrade. Then, upgrade the intermediate release database to the new Oracle Database 12c release using the instructions in Chapter 3, 'Upgrading Oracle Database'. For example: If you are upgrading from 11.2.0.1 or 11.1.0.6, then you must first upgrade to Oracle Database 11g Release 2 (11.2.0.2).
Migrating from Oracle Database 11g to Oracle Database 12c in the Cloud You can migrate Oracle Database 11g databases from on-premises to Oracle Database 12c databases in the Database service using several different methods. Oct 14, 2015 The essential documents to follow to upgrade 11g to 12c. SAP ORACLE UPGRADE STEPS FROM 11g TO 12c FOR SAP SYSTEMS ON LINUX. Do not forget to execute catsbp.sql after oracle upgrade. Thanq @Gaurav & @JamesZhang for making my.
Preface
Changes in This Release for Oracle Database Upgrade Guide
1 Introduction to Upgrading Oracle Database
- 1.1 Overview of Oracle Database Upgrade Tools and Processes
- 1.5 About Oracle Database Release Numbers
- 1.6 About Running Multiple Oracle Releases
- 1.7 Compatibility and Interoperability between Oracle Database Releases
- 1.7.1 What Is Oracle Database Compatibility?
- 1.10 About Rolling Upgrades for Oracle ASM and Oracle RAC Databases
2 Preparing to Upgrade Oracle Database
- 2.1 Tasks for Preparing to Upgrade Oracle Database
- 2.1.3 Choose an Upgrade Method for Oracle Database
- 2.1.5 Develop a Test Plan for Upgrading Oracle Database
- 2.2 Requirements for Upgrading Oracle Database
- 2.2.5 About Upgrading an Oracle ASM Instance
- 2.2.6 About Upgrading Oracle Grid Infrastructure and Oracle Clusterware
- 2.2.11 About Oracle GoldenGate and Online Database Upgrade
- 2.2.13 Requirements for Upgrading Databases That Use Oracle Label Security and Oracle Database Vault
- 2.2.14 Requirement for Upgrading Databases that Use Oracle Warehouse Builder (OWB)
- 2.5 About the Pre-Upgrade Information Tool for Oracle Database
- 2.5.2 Pre-Upgrade Information Tool Warnings and Recommendations for Oracle Database
- 2.7 Preparing the New Oracle Home for Upgrading
- 2.9 Testing the Upgrade Process for Oracle Database
3 Upgrading Oracle Database
- 3.1 Upgrade Strategies for Oracle Database
- 3.2 Upgrading with Oracle Database Upgrade Assistant (DBUA)
- 3.2.1 Recommendations for Using DBUA
- 3.2.2 How DBUA Processes the Upgrade for Oracle Database
- 3.2.6 Using DBUA in Silent Mode to Upgrade Oracle Database
- 3.3 About the Parallel Upgrade Utility for Oracle Database
- 3.4 Manually Upgrading a Non-CDB Oracle Database
- 3.6 How the Data Dictionary is Upgraded and Status is Displayed
- 3.10 Troubleshooting the Upgrade for Oracle Database
- 3.10.13 Understanding Component Status of the Post-Upgrade Status Tool
- 3.11 Rerunning the Upgrade for Oracle Database
- 3.11.2 Options for Rerunning the Upgrade for a Multitenant Database (CDB)
4 Post-Upgrade Tasks for Oracle Database
- 4.3 Required Tasks to Complete After Upgrading Oracle Database
- 4.4 Required Task After Oracle Grid Infrastructure Upgrades
- 4.5 Requirement for Role-Allocated Software Owners and Database Upgrade After Oracle ASM Upgrade
- 4.6 Recommended and Best Practices to Complete After Upgrading Oracle Database
- 4.6.13 Migrate Your Upgraded Oracle Databases to Use Unified Auditing
- 4.8 Recommended Tasks After Upgrading Oracle ASM
- 4.11 Tasks to Complete Only After Manually Upgrading Oracle Database
- 4.11.6 Adjust the Initialization Parameter File for the New Release
5 Upgrading Applications After Upgrading Oracle Database
- 5.4 Software Upgrades and Client and Server Configurations for Oracle Database
- 5.4.1 Types of Software Upgrades for Oracle Database Client and Server Software
- 5.4.2 Possible Client and Server Configurations for Oracle Database
- 5.5 Compatibility Rules for Applications When Upgrading Oracle Database Client or Server Software
- 5.5.1 Rules for Upgrading Oracle Database Server Software
- 5.5.2 Upgrading the Oracle Database Client Software
- 5.6 Upgrading Options for Oracle Precompiler and OCI Applications
- 5.6.3 Option 3: Change the Application Code to Use New Oracle Database Features
- 5.7 Upgrading SQL*Plus Scripts and PL/SQL after Upgrading Oracle Database
6 Downgrading Oracle Database to an Earlier Release
- 6.7 Post-Downgrade Tasks for Oracle Database Downgrades
- 6.7.5 Restoring Oracle Enterprise Manager after Downgrading Oracle Database
- 6.8 Troubleshooting the Downgrade of Oracle Database
- 6.8.5 Issue with Password for Database Links After Downgrading
7 Migrating Data Using Oracle Data Pump
- 7.2 Migrating Data With Data Pump When Upgrading Oracle Database
8 Deprecated and Desupported Features for Oracle Database 12c
- 8.1 Oracle Database Changes
- 8.1.4 Changes for Deinstallation and Cleanup of Oracle Base
- 8.1.5 Deprecated and Desupported Parameters
- 8.1.10 Desupported Features on Microsoft Windows Platforms
- 8.1.11 Desupport of Oracle Cluster File System (OCFS) on Windows
- 8.1.17 Changes for Oracle JDBC and SQLJ
- 8.2 Oracle Business Intelligence and Data Warehousing Changes
- 8.3 Oracle Database Security Changes
- 8.3.5 Deprecation of SQLNET.ALLOWED_LOGON_VERSION Parameter
- 8.3.13 Changes for Oracle Database Vault
- 8.3.14 Changes for Oracle Database Semantic Technologies
- 8.4 Oracle Globalization Support Changes
- 8.6 Oracle Net Services Changes
- 8.7 Oracle XML Database Changes
- 8.8 Oracle Text Changes
A Changes for Earlier Releases of Oracle Database
- A.1 Behavior Changes in Oracle Database 11g Release 2 (11.2)
- A.2 Behavior Changes in Oracle Database 11g Release 1 (11.1)
- A.2.12 Binary XML Support for Oracle XML Database
- A.2.13 PL/SQL Native Compilation and Access Control for Network Utility Packages
- A.3 Behavior Changes in Oracle Database 10g Release 2 (10.2)
Index
Oracle 11g To 12c Migration
Title and Copyright Information
Preface
1 Introduction to the Upgrade Process for Oracle Database
- About Oracle Database Release Numbers
- About Running Multiple Oracle Releases
- Compatibility and Interoperability Between Oracle Database Releases
- What Is Compatibility for Oracle Database?
- About Rolling Upgrades for Oracle Database
- Moving From Standard Edition to Enterprise Edition of Oracle Database
2 Preparing to Upgrade Oracle Database
- The Main Steps for Preparing to Upgrade Oracle Database
- Choose an Upgrade Method for Upgrading Oracle Database
- Develop a Testing Plan to Upgrade Oracle Database
![12c 12c](https://www.oracle.com/technetwork/pt/images/upgrade-database-03-2996640.png)
3 Upgrading to the New Release of Oracle Database
Oracle 11g Client To 12c
- System Considerations and Requirements for Upgrading Oracle Database
- Considerations for Upgrading Oracle Clusterware and Oracle ASM Instances
- Using the Pre-Upgrade Information Tool
- Pre-Upgrade Information Tool Miscellaneous Warnings
- Upgrading with Database Upgrade Assistant on Linux, UNIX, and Windows
- About the DBUA Graphical User Interface
- Optionally Performing an In-Place Upgrade (Into the Same Oracle Home)
- In-Place Upgrade on Windows
- Using DBUA in Silent Mode to Upgrade Oracle Database
- Upgrading Oracle Database Manually
- Manually Upgrading Oracle Database
- Troubleshooting the Upgrade of Oracle Database
4 Post-Upgrade Tasks for Oracle Database
- Required Tasks to Complete After Upgrading Oracle Database
- Recommended Tasks to Complete After Upgrading Oracle Database
- Recommended Tasks to Perform After All Database Upgrades
- Recommended Tasks After Upgrading an Oracle Database 10g Release 1 (10.1) Database
- Tasks to Complete Only After Manually Upgrading Oracle Database
- Adjust the Initialization Parameter File for the New Release
- Required Tasks After Oracle Grid Infrastructure Upgrades
- Upgrading An Earlier Release of Oracle ASM to Oracle Grid Infrastructure
- Required Tasks After Oracle ASM Upgrades
- Additional Considerations After Oracle ASM Upgrades
- Recommended Tasks After Oracle ASM Upgrades
5 Upgrading Applications After Upgrading Oracle Database
- Upgrading Precompiler and OCI Applications
- Understanding Software Upgrades and Your Client/Server Configuration
- Compatibility Rules for Applications When Upgrading Client/Server Software
- Upgrading Options for Your Precompiler and OCI Applications
- Upgrading SQL*Plus Scripts and PL/SQL
6 Downgrading Oracle Database to an Earlier Release
Oracle 11g 12c Differences
- Post-Downgrade Tasks for Oracle Database
7 Moving Data Using Oracle Data Pump
- About Data Pump Export and Import for Upgrading Oracle Database
- Export and Import Requirements for Oracle Database Upgrades
- Upgrading the Database Using Data Pump Export/Import
A Behavior Changes After Upgrading Oracle Database
Oracle 12c Upgrade Guide
- Compatibility and Interoperability Issues in Oracle Database 11g Release 2 (11.2)
- Compatibility and Interoperability Issues in Oracle Database 11g Release 1 (11.1)
- Binary XML Support for Oracle XML Database
- PL/SQL Native Compilation and Access Control for Network Utility Packages
- Compatibility and Interoperability Issues in Oracle Database 10g Release 2 (10.2)
- Compatibility and Interoperability Issues in Oracle Database 10g Release 1 (10.1)
- SQL Optimizer
- Shared Server Parameters