Catalog Migration from OBIEE 11.1.1.7 to 11.1.1.9 — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Catalog Migration from OBIEE 11.1.1.7 to 11.1.1.9

Received Response
51
Views
5
Comments
Sher Ullah Baig
Sher Ullah Baig Rank 3 - Community Apprentice

Hi,

We develop custom BI analytics in OBIEE 11.1.1.7 and we want to migrate to our new OBIEE 11.1.1.9 environment. Is there any migration utlitle in OBIEE 11.1.1.9 cause we try to open old OBIEE 11.1.1.7 reports we didn't got any success.

regards

Answers

  • user11183570
    user11183570 Rank 3 - Community Apprentice

    Hello,

    Please go to [ORACLE_HOME]\bin\ua.bat to run Upgrade Assistant.

    Please use the below link for further step by step guide -

    Upgrading Oracle Business Intelligence from 10g to 11g

    Mark if this is helpful.

    Thanks,

    Avishek

  • Ebin
    Ebin Rank 3 - Community Apprentice

    Hi,

    Have you performed the below mentioned step ?


    Upgrade Web Catalog Objects

      1. Login to BI Answers as weblogic user
      2. Update Catalog Objects (click Administration->Scan and Update Catalog Objects That Require Updates->Update Catalog Objects)


  • More in general the way you write it sounds like if it's something you will do many times? If you really have a dev system in 11.1.1.7 and when done you must deploy to your official system (prod) being 11.1.1.9 I highly suggest you quickly update your dev system to the same version.

    The XML of catalog objects changes between versions, so you will always have surprises if it's something you will do often.

    If it's just a one shot to migrate to a new environment then it's the mandatory way: upgrade your objects to match the new version of the XML.

  • Sher Ullah Baig
    Sher Ullah Baig Rank 3 - Community Apprentice

    Thanks mate it worked perfectly.

  • Sher Ullah Baig
    Sher Ullah Baig Rank 3 - Community Apprentice

    Thanks Gianni. i do agree with you but it quite hard to chase oracle New releases but its a good practice to do so.

    Regards