Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

DB update impact on OBIEE 12.2.1.3

Received Response
41
Views
6
Comments
Kaushik D
Kaushik D Rank 1 - Community Starter
edited Aug 13, 2024 5:53PM in Oracle Analytics Cloud and Server

Hi

Here is my system info:

OS: Windows 10

DB: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

OBIEE: 12.2.1.3

OBIEE is running successfully with this configuration. Now I want to update my db to 12c(12.2.0.1) version. Can someone please help me how to do the activity so the installed OBIEE will not be impacted.

Thanks in advance.

Kaushik

Answers

  • Andris Perkons-Oracle
    Andris Perkons-Oracle Rank 1 - Community Starter

    A couple of things to consider:

    There is no XE database for Oracle 12. That means that you may need some licenses for either SE2 or EE.

    Then, there is no direct upgrade path from 11.2.0.2 to 12.2.0.1. That means that you will either have to do do two upgrades or you will have to migrate your data e.g. with data pump.

    The 12c (12.1) upgrade guide has a chapter on upgrading from XE: "Moving from Oracle Database Express Edition (Oracle Database XE) to Oracle Database". Check https://docs.oracle.com/database/121/UPGRD/intro.htm for details.

    Then, as usual:

    Make sure you have a good backup.

    Read the upgrade guides thoroughly

    Test your upgrade first on an unimportant system

    Andris

  • Kaushik D
    Kaushik D Rank 1 - Community Starter

    Thanks Andris for your assitance. So my strategy for backup will be:

    Take a exp from the XE db

    uninstall XE db

    install 12c db

    imp the exported dump

    But in between these process I am not sure how my installed OBIEE 12c will be impacted, as the metadata is already existing in XE db. My intention is to upgrage the DB without having impact on OBIEE. Please let me know if it is feasible.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    Kaushik D wrote: OBIEE 12c will be impacted, as the metadata is already existing in XE db. My intention is to upgrage the DB without having impact on OBIEE. Please let me know if it is feasible.

    "without having impact"? No, most certainly not.

    Read the documentation link that Andris posted: "To upgrade Oracle Database 11g Express Edition (Oracle Database XE) to Oracle Database 12c, you must install the new Oracle Database software on the same system as Oracle Database XE and use DBUA to perform the upgrade."

    So you will have a new DB instance with a new address which then must be correctly referenced by all components using this. REfer to MOS Doc ID 2177562.1

  • Kaushik D
    Kaushik D Rank 1 - Community Starter

    So if I assume correct the approach will be like this:

    • Uninstall OBIEE
    • Uninstall XE DB
    • install 12c DB
    • install OBIEE

    right Christian?

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

    Safest way but have you looked at the MOS Doc I referenced?

  • Kaushik D
    Kaushik D Rank 1 - Community Starter

    Yes, it was very helpful and understood in my context. thanks again Chris.