This discussion is archived
4 Replies Latest reply: Nov 7, 2012 7:28 AM by 972817 RSS

Post upgradation checklist

972817 Newbie
Currently Being Moderated
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?
Thanks

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

    Iordan Iotzov
    http://iiotzov.wordpress.com/
  • 2. Re: Post upgradation checklist
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl identify exact versions (to 4 digits) of "10g" and "11g". To directly upgrade to 11gR2, 10.2.0.2 is the minimum required version

    http://docs.oracle.com/cd/E11882_01/server.112/e23633/preup.htm#i1007814

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

    HTH
    Srini
  • 3. Re: Post upgradation checklist
    972817 Newbie
    Currently Being Moderated
    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.
    Thanks.
  • 4. Re: Post upgradation checklist
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    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.

    http://docs.oracle.com/cd/E11882_01/server.112/e23633/app.htm

    HTH
    Srini

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points