Simple Steps to upgrade non CDB 11g to 12C CDB

-

 This blog explains the basic steps which we need to follow to upgrade 11g database to 12c database  and preferably moving to PDB databases

I have tried to read oracle MOS standard document
(How to Download and Run Oracle's Database Pre-Upgrade Utility (Doc ID 884522.1)) 

 which actually directs to different links explaining upgrade steps. But my intention is just to keep it simple to everyone when they were about to jumpstart the upgrade activity.


We can follow couple of methods to perform the upgrade activity 

  • Manual Method
  • DBUA tool
I prefer to go with manual method because automated method will always makes our life difficult when we struck during the upgrade process. But this have been fixed with 18c and 19c upgrades.

Supported Upgrade Paths:
================= 

Destination                Source
===========                ======
12c Release 1 (12.1.0.2)   10.2.0.5+, 11.1.0.7+, 11.2.0.2+ or 12.1.0.1
12c Release 2 (12.2.0.1)   11.2.0.3+ or 12.1.0.1 or 12.1.0.2

Step1 -> Download and install the oracle 12c software into new home 

Step 2-> Before you start upgrade process , you need to perform the prechecks

  1. login to the 11g database and check for invalid objects , if yes please compile the objects 
  2. check for duplicate objects owned by system and sys users 
  3. run the utlrp.sql script to check the invalid objects 
  4. Run the preupgrade.sql script , this you will get it from the new 12c oracle home 
  5. This script will generate 3 scripts (preupgrade.log/preupgrade_fixups..sql and postupgrade_fixups.sql)
  6. gather optimizer statistics 
  7. purge the recyclebin 
  8. Make sure all the data files in no backup mode 
  9. if using dataguard make sure standby is in sync with primary 
  10. disable dbms scheduler jobs 
  11. remove EM repository 

Step 3 -> Now start the upgrade process

  • Stop the listener 
  • copy the parameter file and password file to the new 12c home/dbs  and also update the oratab entries 
  • shutdown the database 
  • start the database in the startup upgrade mode
  • Now you can use catctl.pl script to run the catupgrade.sql script with multiple parallel process  
  • $ORACLE_HOME/perl/bin/perl catctl.pl -n 6 catupgrd.sql
Step 4 -> Post upgrade 

  1.  Run the post upgrade script (utlu121s.sql)
  2. run the catupst.sql script if the installation returns with no errors 
Do not run this in UPGRADE mode. Run catuppst.sql, located in the ORACLE_HOME/rdbms/admin directory, to perform remaining upgrade actions that do not require the database to be in UPGRADE mode. If an Oracle bundle patch or patch set update (PSU or BP) is installed in the Oracle home, then this script automatically applies that patch set update to the database.

Caution: If you perform a manual upgrade, and you do not run catuppst.sql,, then your database suffers performance degradation over time.

  3. run the postupgrade_script.sql


This completes the upgradation 







Comments

Post a Comment

Popular posts from this blog

How to make CRS and ASM not to restart after server reboot

-
I have noticed that server rebooting is taking lot of time on a VM machine for every reboot, so I have decided to auto start of the crs and ASM service During this phase I have noticed an attribute called auto_start when I try to execute the below command crsctl stat res -p This AUTO_START attribute is there for several resources like ora.ASM ,ora.crs,ora.DATA_DG it has got 2 options restore(0) , never(2) and always (1) always (1)  Causes the resource to restart when the node restarts regardless of the resource’s state when the node stopped -restore (0)  Does not start the resource at restart time if it was in an offline state, such as STATE=OFFLINE, TARGET=OFFLINE, when the node stopped. The resource is restored to its state when the node went down. The resource is started only if it was online before and not otherwise. -never (2)  Oracle Clusterware never restarts the resource regardless of the resource’s state when the node is stopped. So I have dec...
Read more

Understanding Terraform

-
 Terraform is a tool used  for building, changing, and versioning infrastructure safely and efficiently. A Terraform can manage multiple cloud services using a provider plugin  Terraform work flow? Terraform work flow will be comprised of validate -> plan -> apply and finally destroy. what is the important file of terraform which records the actions of Terraform apply? For every Terraform execution the action will be recorded in a file called Terraform state file .  The terraform init command is used to initialise a working directory containing Terraform configuration files. During init, the configuration is searched for module blocks, and the source code for referenced modules is retrieved from the locations given in  their source arguments. The terraform plan command is used to create an execution plan. It will not modify things in infrastructure. The terraform apply command is used to apply the changes required to reach the desired state of the configur...
Read more

How to repair ASM disk header

-
Image
What is ASM disk header corruption? ASM disk header corruption is a loss or damage to the disk header which contains the metadata essential for the operation and availability of an ASM disk group in Oracle. Imagine that you have an ASM disk corruption in any of the ASM diskgroups that have critical business data and the diskgroup has been configured as "EXTERNAL" redundancy, meaning that if one disk is inaccessible the whole diskgroup will be unavailable. Now what? Is your only option to restore it from backup by recreating the diskgroup or are there any other faster ways to recover the data? Here you need to find out whether it’s a complete loss of data in the ASM disk or is it just a header corruption. Hopefully for you, this is just a header corruption. Because, yes, there is a way out!  Below find the steps to restore from the ASM header corruption. Most of the data in the ASM disk header is of interest to that disk only. However, some information in the ASM disk header ...
Read more