7 Replies Latest reply: May 16, 2013 2:34 AM by Rob_J RSS

    dbupgdiag.sql  and utlu112i.sql

    1009000
      Hello,

      Planning to upgrade from 10.2.0.4 to 11.2.0.3. I am having few queries regarding upgrade.

      1) Do i need to run dbupgdiag.sql script before starting upgrade?

      2) Is it mandatory to run utlu112i.sql script?

      3) When should i use DBUA method and when should i use manual method?

      Thanks
        • 1. Re: dbupgdiag.sql  and utlu112i.sql
          MadhurendraS
          1) yes.
          2) yes.

          i suggest you to read Best Practices for Upgrading to Oracle Database 11g Release 2
          http://www.oracle.com/technetwork/products/upgrade/best-practices-for-upgrading-11gr2-1605003.pdf

          Oracle Database 11g Upgrade page
          http://www.oracle.com/technetwork/products/upgrade/index.html

          Oracle database upgrade guide 11g Release 2
          http://docs.oracle.com/cd/E11882_01/server.112/e23633/toc.htm

          Regards,
          madhurendra
          • 2. Re: dbupgdiag.sql  and utlu112i.sql
            DK2010
            Hi

            Welcome to the forum.

            1) Do i need to run dbupgdiag.sql script before starting upgrade?
            Better you should use this it will give you the all the diag info. rather you collect manually using different type of Query like timezone info,audit,archive etc..
            2) Is it mandatory to run utlu112i.sql script?
            Yes, this run give you the information about the Parameters need to update,Obsolete/Deprecated Parameters,DB Components and and its Status etc
            3) When should i use DBUA method and when should i use manual method?
            you can use any method for upgrade DBUA or Manual. DBUA guides you through the whole upgrade process, including all the steps  in the manual upgrade process.
            if possible use DBUA
            HTH
            • 3. Re: dbupgdiag.sql  and utlu112i.sql
              Rob_J
              Hello,

              Here are my notes on how I did the upgrade which might help you, too. What the guys say about the .sql files you mentioned is correct.

              http://www.ora00600.com/wordpress/articles/oracle-10g-to-11g-upgrade-guide/

              Hope that helps,
              Rob
              • 4. Re: dbupgdiag.sql  and utlu112i.sql
                MadhurendraS
                Interestingly i was originally thought to post that link. :)
                • 5. Re: dbupgdiag.sql  and utlu112i.sql
                  Rob_J
                  @Madhurendra S, :). Hopefully it answers some people's questions, as it shows more of a worked example.
                  • 6. Re: dbupgdiag.sql  and utlu112i.sql
                    Srini Chavali-Oracle
                    Good stuff Rob ! May I point out two improvements ?

                    1. "DBCA vs Manual upgrade" - I believe you meant to say "DBUA" instead of "DBCA". DBUA is the Upgrade Assistant, while DBCA is the tool used to create databases. DBUA is recommended by Oracle and it has performed flawlessly in the past for me - manual upgrades are prone to human errors.

                    2. Pre-upgrade utility script (utlu1121.sql) - You should always run the latest version of this script available via MOS Doc 884522.1

                    Srini
                    • 7. Re: dbupgdiag.sql  and utlu112i.sql
                      Rob_J
                      Hi Srini,

                      You're improvement suggestions are welcome :). Thank you very much for pointing those out to me, I will change them as they are wrong. For the 2nd point I believe that I took the notes from an earlier upgrade to 11g so that's why that came about.

                      Thanks again,
                      Rob