Oracle Analytics Cloud and Server

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

Migrate OBI 11g to OAS

Received Response
301
Views
10
Comments
mchorazy
mchorazy Rank 4 - Community Specialist

Hi,

I have question about migration OBI in 11g version to OAS (Oracle Analytics Server).

Must I have the newest of 11g OBI version - 11.1.1.9 to migration to OAS?

For example I have earlier version: 11.1.1.5 and I want go to OAS.

Must I upgrade BI to 11.1.1.9 version and next migrate to OAS or can I have migrate 11.1.1.5 to OAS directly?

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    mchorazy wrote:Must I upgrade BI to 11.1.1.9 version and next migrate to OAS or can I have migrate 11.1.1.5 to OAS directly?

    If you look at the documentation then you will see that the minimum is 11.1.1.7.

    https://docs.oracle.com/middleware/1221/core/BIMIG/GUID-D0867450-1AEF-43DE-8144-7816F7105CB1.htm#BIMIG-GUID-D0867450-1AE…

    https://docs.oracle.com/middleware/bi12214/lcm/OBIUP/GUID-D0867450-1AEF-43DE-8144-7816F7105CB1.htm#OBIUP-GUID-D0867450-1…

    if you look at the OAS documentation you will see that you need to upgrade to 12c before going to OAS:

    https://docs.oracle.com/en/middleware/bi/analytics-server/migrate-upgrade-oas/migrating-and-upgrading-oracle-analytics-s…

    So the process is 11.1.1.5 -> 11.1.1.9 -> 12.2.1.4 -> OAS

    That's the price customers pay when they do not stay up to date as is recommended.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Did you give up on this?

  • mchorazy
    mchorazy Rank 4 - Community Specialist

    Thanks for response.

    I understand that FIRST way to migrate to OAS is:

    1. 11.1.1.5 -> 11.1.1.9 -> 12.2.1.4 -> OAS

    But can I migrate directly form 11.1.1.9 to OAS?

    Like: https://docs.oracle.com/en/middleware/bi/analytics-server/migrate-upgrade-oas/upgrading-oracle-business-intelligence-11g…

    Thats chapter 6 from your documentation link https://docs.oracle.com/en/middleware/bi/analytics-server/migrate-upgrade-oas/migrating-and-upgrading-oracle-analytics-s…

    And the second way is: 11.1.1.5 -> 11.1.1.9 -> OAS?

    What do you think about the second approach? It's possible?

    Which of this two approach is better ?

    Is there any documentation to upgrade 11.1.1.5 to 11.1.1.9?

    Can I follow on this topic: Correct Upgrade Steps for OBIEE 11.1.1.6.8 to 11.1.1.9.0  ?

  • mchorazy wrote:But can I migrate directly form 11.1.1.9 to OAS?

    Yes, from the last 11.1.1.9 you can do an out-of-place upgrade.

    Seeing where you are coming from (11.1.1.5) there isn't really one being better than another: you will probably have a lot to clean-up and fix because you come from quite far away.

  • mchorazy
    mchorazy Rank 4 - Community Specialist

    Thanks Gianni for information.

    How should I understand 'out-of-place upgrade' ?

    I know that from 11.1.1.5 to OAS is a lot of work.

    Now I looking the best way to do this and the first step is upgrade to 11.1.1.9. Is there a list of patches that I must install for upgrade to 11.1.1.9?

    The second step is choose between two ways: 11.1.1.9 -> OAS or 11.1.1.9 -> 12.2.1.4 -> OAS. Are there any advantage or disadvantage for one of this two ways?

  • "out-of-place" means that you aren't going to upgrade the domain you have already, but that your OAS is a fully independent install and you move content there and you have to redo yourself the security config in weblogic and those things.

    As you anyway will have to do that even if you move to 12.2.1.4 first before to be able to do an in-place upgrade to OAS, you aren't losing anything. You come from too far to avoid that part...

    For your 11g upgrade follow the official doc: https://docs.oracle.com/middleware/11119/core/FUGBI/bi_plan.htm#BABECJJH

  • mchorazy
    mchorazy Rank 4 - Community Specialist

    Ok, I think that is clear for me, but please correct me if I wrong:

    I have two steps:

    1. 11.1.1.5 -> 11.1.1.9 -> 12.2.1.4 --- in-place upgrade ---> OAS ---- it is mean that I have installed on server 12.2.1.4 Oracle Home, next I install OAS in pre-existing Oracle Home and overwritten it (I use Upgrade Assistant)

    2. 11.1.1.5 -> 11.1.1.9 --- out-place upgrade ---> OAS ---- it is mean that I must export bundle from 11.1.1.9, install OAS on 'clear machine', import export bundle to OAS

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Giani took over this thread as I wasn't online yesterday, but here's my 10 cents:

    Most implementations experience quite some nasty surprises going from 11g to 12c/OAS since the modern code bases of these versions very brutally make every misconfiguration visible which still "slipped through" in the old version. Imprecise RPD config etc is less and less accepted and caught by the engine - so many old RPDs won't even run "just like that".

    Same for certain security aspects and some front-end bits.

    As of 11.1.1.9 you will always use the export bundle. In-place vs out-of-poace just means (as Gianni said):

    In-place means you get everything running properly in a 12.2.1.4 and then you upgrade that server machine directly - binaries and content and security and setup config. All in one.

    Out of place means that you have 11.1.1.9 or 12.2.1.4 (yes you can also upgrade 12 to OAS out of place) on machine A and have another machine B with vanilla (empty) OAS and then move your BAR file (content and security) over from A to B.

    Having done more than a dozen 11g to 12c / 12c to OAS / 11g to OAS upgrades I definitely suggest to not just go for a "let's get it working somehow" but a proper cleansing and verification of the whole solution while upgrading. Don't carry over old, outdated and unclean things. Orient yourself on the new, not on the old (rpd, security and server config optiobs especially).

    It will save you from a lot of.pain afterwards.

    Also as a side note: many implementations are so.messed up in 11g, that they don't rum throughout.the upgrade bundle process and you need to upgrade manually.

  • Zuhair Amjad
    Zuhair Amjad Rank 3 - Community Apprentice

    Dears ,

    can Migrate reports,users and permission from obiee 11g (11.1.1.7.1) TO OAS 7.0.0 ?

  • Hi @User_Z9MDK ,

    This thread is almost 4 years old. I suggest you to create a new one, so you can properly handle the answers that you will get.