Oracle Database Upgrade From 11g To 12c Manually User Guide

/how-to-download-fit-clients-for-android-phones.html. That run a proprietary operating system and have their own set of apps.BlackBerries use the (BES) to integrate with corporate mail servers running Microsoft Exchange, Novell GroupWise, and the like. Exchange users can also use Outlook Web Access (OWA) on the web browser.BlackBerry was first to provide 'push' email, whereby messages are delivered to the device as soon as they come into the email server, rather than the device having to be periodically synchronized. BlackBerries can also support POP mail accounts. BES relays messages sent from the corporate mail server to the wireless carrier's network to be delivered to the BlackBerry device. BES is not required to get email through a BlackBerry; another option is (BIS), but the SIM needs to provisioned for BIS.

Upgrading Oracle Database to 12.1.0.1.0 Using DBUA

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. For migrating your Emptoris applications, you must upgrade your database to Oracle 11g or later. How to download books on phone for free. Upgrading to Oracle 11g or Oracle 12c using Import/Export data pump For migrating your Emptoris® applications, you must upgrade your database to Oracle 11g or later.

New Features

I will list out some of the new feature for upgrading your databases to 12c. You can review the complete details of the new feature by clicking the link in the references section.
  • New Pre-Upgrade Information Tool- A new Pre-Upgrade Information Tool has been created for this release. The preupgrd.sql script replaces the utlu121s.sql script.
  1. Parallel Processing for Database Upgrade- In Oracle Database 12c, the catupgrd.sql Upgrade Utility has been replaced with the new catctl.pl Parallel Upgrade Utility.
  2. DBUA Can Be Restarted During the Upgrade Process- In this release, there are more options for recovering from failures during upgrade and for restarting the upgrade from the point where the failure occurred.
  3. Enhanced Pre-Upgrade and Post-Upgrade Summary Report- DBUA generates HTML reports before and after the upgrade.

Upgrade Database

Make sure you have a full valid database backup.

  • Make sure your database is in archivelog mode
  • Take a full backup using RMAN.

Pre-Upgrade Information Tool

Copy SQL scripts preupgrd.sql and utluppkg.sq

  1. $cd <12c_home>/rdbms/admin
  2. $cp preupgrd.sql /home/oracle/scripts/
  3. $cp utluppkg.sql /home/oracle/scripts/
  4. Under your ORACLE_HOME/cfgtoollogs or ORACLE_BASE/cfgtoollogs create directory <db_unique_name>/preupgrade

Execute Pre-Upgrade Scripts

Upgrade
  1. Login to the database you want to upgrade with SYS account
  2. Execute the preupgrd.sql script from the location where you copied the file.
  • SQL>@preupgrd
Example Output

Review Fixup and Log Files

Example Output from Preupgrade.log



After you have reviewed the scripts, Oracle recommends that you execute preupgrade_fixups.sql on the source database. The preupgrade_fixups.sql script will attempt to resolve issues reported by the preupgrade process.
Execute the preupgrade_fixups.sql before upgrading your database.

Make any manual changes to your database as needed based on the output from the preupgrade.log
References:
Pre-Upgrade Information Tool Warnings and Recommendations for Oracle Database

Upgrade Database Using DBUA


2. Select upgrade Oracle database click next



3. Select the source Oracle home and the database to be upgraded click next.
4. Prerequisite checks will begin
5. Prerequisite check dialog will show any issue encounter during the checks and will have the option to fix it the validation is fixable. Click next

6. There is an option now to have the upgrade run in parallel so select the upgrade parallelism. Upgrade options can be set to recompile invalid objects during post upgrade. There are other options for Timezone, gather stats and set user tablespace to read-only during upgrade. There is options to change file location if needed. In the custom SQL scripts tab you can set a before and after custom SQL script to be executed.
Click next
7. Managment options can be set to configure EM Express of Cloud Control click next
In my case I left both unchecked.
8. In the move database files there are options to move the datafile and flash recovery area as part of the upgrade. Click next
In my case I left blank as I did not need to move my datafiles.
9. Network configuration give the options of registering to any listener running. Click next
In my case the database dbtest2 that I am upgrading is already registered to my default listener.
10. 12c DBUA now has the options of recovering from an upgrade failure. In the recovery options dialog you select different options for recovery. The select are RMAN backup creating a new backup or using existing backup. There is an option for flashback and guaranteed restore point (GPR). There is also the options of having your own backup and recovery strategy. Click next.
In my case I choose RMAN backup with existing RMAN backup.
Upgrade11. Review summary and click finish

Oracle 11g To 12c Migration


12. Upgrade will being and progress can be monitored.
12.1 Click the activity log button to review the detail progress

12.2 Click the alert log button to review alert log entries during the upgrade process.

13. When upgrade is complete click upgrade results


14. Review results if there were any issues here you would have the option of restoring the database. Click close

Upgrade From 11g To 12c


Oracle 11g 12c Differences

15. Database has been upgraded

Once you feel that your upgraded database is good change the compatible to 12.1.0.1.0
SQL>alter system set compatible='12.1.0.1.0' scope=spfile;
SQL>startup
If you want to see this installation in a video demo see below from my YouTube channel.

Oracle 12c Upgrade Guide

Require Post Upgrade Task

Recommend and Best Practices to Complete After Upgrade


Follow me on Twitter


My webpages
http://db12c.blogspot.com/
http://cloudcontrol12c.blogspot.com/

http://www.youtube.com/user/jfruiz11375

Good Source for Database 12c

11g To 12c Upgrade Document

Oracle Upgrade Guide
Using DBUA to Upgrade the Database on Linux, UNIX, and Windows Systems