Wednesday, February 12, 2014

Oracle Database 12.1 Upgrade New Features and Changes

New DBUA Interface

  • DBUA is now divided into 2 panels (initially introduced with 11.2 OUI), the left panel lists all the steps executed by DBUA and the right panel executes and shows the progress of all operations listed in the left panel.

New Pre-Upgrade Information Tool

  • Oracle Database 12c introduces the preupgrd.sql Pre-Upgrade Information Tool which replaces the utlu121i.sql script and earlier versions
  • With the new Pre-Upgrade Information Tool, the default behavior of the prerequisite upgrade checks has been enhanced in the following ways:
    • A log file, preupgrade.log, is created containing the output of the Pre-Upgrade Information Tool.
    • The preupgrade_fixups.sql script is created
    • The postupgrade_fixups.sql script is created
    • These files are created under $ORACLE_BASE/cfgtoollogs/<SID>/preupgrade

Enhanced Upgrade Automation

  • New parallel upgrade script which is a default feature in Oracle Database
  • SERVER ( catalog , catproc ) component upgrade scripts get executed in parallel, for independent sub-components
  • Parallel upgrade is driven by a PERL script:
    $ catctl.pl

Command Line Upgrade

  • In this release, the new Parallel Upgrade Utility, catctl.pl, provides parallel upgrade options that reduce downtime.
    cd $ORACLE_HOME%rdbms\admin
    $ORACLE_HOME\perl\bin\perl catctl.pl catupgrd.sql