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.
- Oracle 11g To 12c Migration
- Upgrade From 11g To 12c
- Oracle 11g 12c Differences
- Oracle 12c Upgrade Guide
- 11g To 12c Upgrade Document
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.
- 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.
- 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.
- 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
- $cd <12c_home>/rdbms/admin
- $cp preupgrd.sql /home/oracle/scripts/
- $cp utluppkg.sql /home/oracle/scripts/
- Under your ORACLE_HOME/cfgtoollogs or ORACLE_BASE/cfgtoollogs create directory <db_unique_name>/preupgrade
Execute Pre-Upgrade Scripts
- Login to the database you want to upgrade with SYS account
- Execute the preupgrd.sql script from the location where you copied the file.
- SQL>@preupgrd
Review Fixup and Log Files
Upgrade Database Using DBUA
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.
11. Review summary and click finish
Oracle 11g To 12c Migration
12. Upgrade will being and progress can be monitored.
Upgrade From 11g To 12c
Oracle 11g 12c Differences
15. Database has been upgradedOracle 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
Using DBUA to Upgrade the Database on Linux, UNIX, and Windows Systems