Oracle Upgrade 11G to 12C

Summary:-

This document contains the steps that how to do the oracle upgrade 11 G to 12C.

Author: Brindavan Mookaiah

Designation: SAP BASIS Consultant


Note: The steps are only suitable for NON SAP Oracle Upgrade.

For SAP oracle upgrade 11g to 12 c on AIX.  kindly find the following Link SAP Oracle upgrade 11G to 12C on AIX


Steps to follow:-

1) Backup Oracle database and profile

2) Take full offline or online backup

3) Stop the database

3) Stop listener

4) Change ORACLE_HOME environment variable in the bash profile of “oracle” user

5) Check the version SQ> Select instance_name,host_name,version,status from  V$INSTANCE;

6) Check the components version SQL> Select from comp_name, version, status from dba_registry ORDER BY status;

7)  Run the installer 12c

8)  Pre-upgrade

9) Upgrade the 11G to 12C

10) Post upgrade



Introduction:-

The oracle release and years

Oracle Release 2

  1. 11.2.0.1.0 (August 2009 -GA)
  2. 11.2.0.2.0 (November 2010)
  3. 11.2.0.3.0 (September 2011)
  4. 11.2.0.4.0 (August 2013)

Oracle 12c Release 1

  1. 12.1.0.1.0 (June 2013 – GA)
  2. 12.1.0.1.1 (October 2013) (PSU)
  3. 12.1.0.1.2 (January 2014) (PSU)


Oracle Database

Direct upgrade 10.2.0.5.0/11.1.0.7.0/11.2.0.2.0 upgrade to 12.1.0.1.0

  • . In -Place Upgrade  -> Install Binaries in same ORACLE_HOME
  • . Out-of-Place Upgrade –> Install binaries in new ORACLE_HOME

Upgrade suing DBUA or Manual

Indirect Upgrade

  • . Migrate using Data pump utility
  • . Transportable Table-space
  • . Golden Gate Replication

There are different ways of oracle upgrading

1) Database Upgrade Assistant (DBUA)

2) Manual Upgrade

3) Transportable Tablespaces

4) Datapump export/import

5) Oracle Streams

6) Oracle GoldenGate


Here we are going to use


Oracle Database Version:            Oracle Database 11gR2 (11.2.0.2.0) (64-bit)

Operating System:                        Oracle Enterprise SUSE Linux

1) Check the release and version

Capture1.PNG

2) check the oratab

Capture2.PNG

3) check the oraInventory

Capture3.PNG

4) stop the database & stop the listener

oracle&hostname > sys /as sysdba

SQL> shutdown immediate;

oracle& hostanme> lsnrctl

LSNRCTL> stop

5) Check the version

Capture4.PNG

6) Check the components

Capture5.PNG

7) set the new ORACLE_HOME

hostname> export ORACLE_HOME=oracle/SID/12.1.0

8) Go to the 12c media directory and run the command

oracle&hostname> ./runInstaller

Capture6.PNG

Click Next

Click “Next” and chose “Skip software updates”.

Capture7.PNG

Click “Next” and chose “Skip software updates”.


Capture8.PNG

Click “Next” and select “Upgrade an existing database”. It automatically launch DBUA to upgrade the databases.

Capture9.PNG

Select the Language eg ” English”

Capture10.PNG

Select Enterprise edition and click “Next”

Capture11.PNG

Click “Next”

Capture12.PNG

Click “Next”

Capture14.PNG

Fix all the warnings are resolved before proceeding with the next step. In here we are ignored and click ” Next”


Capture15.PNG

Click “Install”

Capture16.PNG



Capture17.PNG


Capture18.PNG


Click ” Next”


Capture19.PNG

Click ” Next”


Capture20.PNG



Click ” Next” ignore and continue


Capture21.PNG


Click ” Next”


Capture22.PNG

Click ” Next”:


Capture23.PNG

select “configure Enterprise Manger and Click ” Next”


Capture24.PNG


Click ” Next”


Capture25.PNG

Click ” Next”


Capture26.PNG

select ” I have my own backup ”  and Click ” Next”


Capture28.PNG

click ” Finish”

Capture29.PNG

Capture30.PNG

Capture31.PNG

If you would like to restore the database to be fall-back to previous version then click on restore to revert back.

Capture32.PNG

Well the oracle database upgrade completed successfully.

SQL> select * from v$version;

  —————————————————————————- ———-
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production 0
PL/SQL Release 12.1.0.1.0 – Production      0
CORE 12.1.0.1.0 Production       0
TNS for Linux: Version 12.1.0.1.0 – Production      0
NLSRTL Version 12.1.0.1.0 – Production      0

Capture33.PNG

Capture34.PNG


All steps are completed.



To report this post you need to login first.

24 Comments

You must be Logged on to comment or reply to a post.

    1. Ismail Mirza

      Hi S Basis,

       

      issues for 11g to 12c Upgrade are as follows

       

      1) oracle is not started with <SIDADM> , we have to start manully .

      2) you have to upgrade kernel 721 other wise brtool was not support for 12C.

      3) you have to create a symbolic link for new oracle home and deinstall the old oracle home.

      4)copy old home init<SID>.ora file to new oracle home path oracle/SID/112_64/dbs for (unix/Linux).

      5)Copy old listener.ora file to new oracle home.

      (0) 
  1. Valerio Cicchiello

    Hello Brindavan,

     

    Oracle 12 is not yet officially released by SAP for productive systems (as far as I know). I think you should write this information in your document for now.

     

    Best Regards,

    Valerio

    (0) 
      1. Fidel Vales

        Hi,

        I think you have not understood the comment from Valerio.

        CURRENTLY SAP DOES NOT SUPPORT ORACLE 12.

        This is NOT mentioned in your document.

        SAP has NOT released any UPGRADE documentation.

        This is NOT mentioned in your document.

        This document HAS NOTHING valuable from SAP Oracle Database point of view and it can/will cause confusion if you do NOT mention anything as people will NOT read the OFFICIAL documentation when released, will follow your document, skip steps required by SAP, open “incidents” and get the “nice answer” => “you have not followed a supported upgrade, please, restore backup and start again”.

        Therefore, I strongly recommend that you mention that this document can be used to upgrade NON SAP databases until SAP releases its official document.

        (0) 
            1. Brindavan Mookaiah Post author

              Hi Srinivasan,

               

              The old oracle path and directory can delete. Because already new oracle installed and upgraded by this steps. kindly let me know if you want any other details

               

               

              Thanks,

              Brindavan.

              (0) 
                1. Brindavan Mookaiah Post author

                  Hi ,

                   

                  As per my understanding for you question about the backup of data .During upgrade only new binaries file will placed not the data.

                   

                  You can restore the backup as same procedure you followed previously.

                   

                  Thanks

                  Brindavan

                  (0) 
        1. Brindavan Mookaiah Post author

          Hi,

           

          Just sharing the information…..

           

          Now oracle12c has been certified by SAP!!!!

           

          2133079 – Oracle Database 12c: Integration in SAP environment


          Oracle Database 12c (incl. RDBMS 12c, Grid Infrastructure 12c and Oracle RAC 12c) is certified for SAP NetWeaver based SAP products starting March 31st, 2015. The minimum Oracle version certified is 12.1.0.2 with applied initial 12.1.0.2 SAP Bundle Patch (SBP), 12.1.0.2.2.

          At least SAP Kernel version 7.21_EXT is required for Oracle 12c

           

          Thanks,

          Brindavan

          (0) 
  2. Janos Mucsi-Besze

    Hi.

     

    Nice document. But one realyl important thing to remember is, that in SAP the software owner of Oracle SW is ora<sid>. Except in RAC,EXADATA,ASM or in Oracle Engineered Systems. This means SAP customers using ora<sid> user as SW owner, have to migrate the Oracle SW to ‘oracle’ user, which is not so easy. But SAP will provide a tool that supports this process.

    (0) 
    1. Brindavan Mookaiah Post author

      Hello Siddesh,

       

      This information might be helpful who is going to perform oracle upgrade, but it seem that this document is not reached your knowledge. will try to produce a good document in future.


      Thanks for you comments….

      (0) 
      1. Siddhesh Ghag

        Hello Brindavan,

         

        Apologies, I think you misunderstood me.

         

        I think I should have asked the question in bit more detail.

         

        I believe you wrote the blog, when Oracle 12c was still awaiting certification for usage with SAP Application, so consultants who were interested in experimenting with an upgrade to latest version would have found this pretty useful.

         

        However, Oracle 12c is now certified to be used with SAP and the standard Oracle Upgrade guide from SAP for SAP databases is out ( and I see that you have included here too).

         

        So my question was in which circumstances will the readers use this procedure? Non-SAP Oracle upgrades are covered by Oracle documentation anyways.

         

        You might want to modify this blog and focus on specific issues/features that you would like the readers to take note of.

         

        Regards,

        Siddhesh

        (0) 

Leave a Reply