Supported oracle database upgrade path

-
Table 1-1 Examples of Upgrade Paths for Oracle Database 12c
Current ReleaseUpgrade Options
12.1.0.1, 12.1.0.2
11.2.0.3 or later
Direct upgrade is supported. Perform the upgrade using the current Oracle Database Upgrade Guide, which is this guide.
11.2.0.1, 11.2.0.2
11.1.0.6, 11.1.0.7
10.2.0.2, 10.2.0.3, 10.2.0.4 and 10.2.0.5
10.1.0.5
9.2.0.8 or earlier
Direct upgrade to Oracle Database 12c is not supported.
Solution: Upgrade to an intermediate Oracle Database release that can be directly upgraded to the current release. You must upgrade Oracle Database releases that are not supported for direct upgrade in this release to an intermediate Oracle Database release that is supported for direct upgrade. When upgrading to an intermediate Oracle Database release, follow the instructions in the intermediate release documentation. After you complete an upgrade to the intermediate release Oracle Database, you can upgrade the intermediate release database to the current Oracle Database 12c release.
This restriction does not apply if you use Oracle Data Pump export/import to migrate data to the new release.
For example:
  • If you are upgrading from release 11.2.0.2 or 11.1.0.7, then you must first upgrade to Oracle Database 11grelease 2 (11.2.0.4).
  • If you are upgrading from release 10.2.0.2, 10.2.0.3, 10.2.0.4,10.2.0.5 or 10.1.0.5, then you must first upgrade to release 11.2.0.4 or 12.1.0.2.
  • If you are upgrading from release 9.2.0.8, then you must first upgrade to a sequence of intermediate Oracle Database releases:
    Upgrade from release 9.2.0.8 to release 11.2.0.3 or 11.2.0.4. Then upgrade from release 11.2.0.4 to 12.2

Comments

Post a Comment

Popular posts from this blog

Installation of Oracle10g on LINUX

-
Table of Contents 1.  Pre-installation Tasks for the ORACLE 10g Database. 2. Installing the ORACLE 10g Database. 3. Post-installation tasks for the ORACLE 10g Database. 4. Testing the installation.  Pre-installation Tasks for the ORACLE 10g Database. Before starting the oracle 10g installation ,several parameters must be checked. To perform these checks login as the root user or switch user to root using the command su – root. Checking Memory and Swap space. For successful installation of Oracle 10g, the system is required to have atleast 512MB of RAM and 1 GB of Swap space.You can verify this using :-- grep MemTotal /proc/meminfo  grep SwapTotal /proc/meminfo Checking /tmp space. The Oracle Universal Installer requires 400 MB of free space in the /tmp directory. The command to check this is as follows:-- df /tmp Checking The Existence of following Softwares/RPM Packages.The following packages or later versions must be installed :--- · make-3.79.1· gcc-3.2.3-...
Read more

RMAN compression

-
RMAN Compression: There are 3 three types of compression by default: 1.       Null compression ·         Usages only till Oracle version 10.1 by default ·         RMAN skips the block that have never been used when backing up datafiles into backup sets. ·         E.g. let’s tablespace having once datafile of size 100MB and out of 100 MB only 50 is used. Then RMAN will backup only 50 MB. 2.       Unused block compression ·         Oracle version 10.2 forward, uses ‘Null’ and ‘unused block’ compression. ·         More compact backups of datafiles by skipping datafile blocks that are not currently used to store data. ·         In previous release, RMAN only supported NULL compression, which skipped space in ...
Read more

Database upgrade -11.2.0.1 to 11.2.0.4

-
Database upgrade -11.2.0.1 to 11.2.0.4 Complete Checklist for out-of-Place Manual Upgrade from Previous 11.2.0.N Version to the Latest 11.2.0.N Patchset (Doc ID 1276368.1) STEP 1) Download the 11.2.0.4 or RDBMS software. STEP 2) Install the latest 11.2.0.4 RDBMS Software into a new ORACLE_HOME. STEP 3 ) After installing the latest 11.2.0.4 RDBMS software, run Pre-upgrade tool (utlu112i.sql) on database (11.2.0.1). You need to review pre-upgrade output and fix if any issues before upgrading to the latest release of 11.2.0.4. STEP 4) Run  dbupgdiag.sql  script from the below My Oracle Support article to verify that all the components in dba_registry are valid and no invalid data dictionary objects exist in dba_objects. Note 556610.1  Script to Collect DB Upgrade/Migrate Diagnostic Information ( dbupgdiag.sql ) $ sqlplus / as sysdba sql> alter session set nls_language=’American’; sql> @ dbupgdiag.sql sql> exit If the  db...
Read more