4 Replies Latest reply on Nov 7, 2012 3:35 PM by Srini Chavali-Oracle

    Post upgradation checklist

      Hi Experts,

      We are planning to upgrade our database from oracle 10g to oracle 11g. We are using this database in every phase/layer of end to end solution for our BI reporting, starting from
      1. staging data (to capture the core data)
      2. datawarehouse (in the form of start and snowflake schemas)
      3. metadata repository for BODS
      4. BO web intelligence reports

      Could you please let me know, the checkpoints I need to keep in mind post this upgradation?

        • 1. Re: Post upgradation checklist
          Iordan Iotzov
          Verify that the software that uses that database (ETL tools, reporting tools, etc) is certified to run against Oracle 11g.

          Iordan Iotzov
          • 2. Re: Post upgradation checklist
            Srini Chavali-Oracle
            Pl identify exact versions (to 4 digits) of "10g" and "11g". To directly upgrade to 11gR2, is the minimum required version


            Post-upgrade steps are documented - http://docs.oracle.com/cd/E11882_01/server.112/e23633/afterup.htm

            • 3. Re: Post upgradation checklist
              Thanks Iordan and Srini for your prompt help.
              And apology for the missing information.
              The compatibility and other requried checks have already been checked and confirmed. And all the necessary checks will be done by DBA only. Here, I am just looking for the checklist which I need to take care from the BI developer/tester/user point of view. like
              1. checklist for DWH post this upgradation.
              2. checklist for BODS post this upgradation.
              3. checklist for Universe/web intelligence server post this upgradation
              4. checklist for all other stuff which directly or indirectly link with any BI solution.

              Or it seems like I raised the request to the wrong forum. Please help.
              • 4. Re: Post upgradation checklist
                Srini Chavali-Oracle
                After you perform a test upgrade to 11gR2, your application team needs to perform tests on the upgraded database to ensure that the upgrade has not caused any issues.


                1 person found this helpful