Forum Stats

  • 3,853,958 Users
  • 2,264,299 Discussions
  • 7,905,517 Comments

Discussions

OBIEE 12c: DB Repository migration from 11g to 12c

Carsten Weber
Carsten Weber Member Posts: 65 Blue Ribbon

Hi guys,

fist of all I want to state my versions I am using for the upcoming scenario / question:

OBIEE: Version 12.2.1.1.0

Oracle Essbase: Version 11.1.2.4.008.28

In the next two months our Oracle database administrator is on planning to migrate all our Oracle databases (EE) from version 11g to 12c (on a new server) and this task will also affect all repository tables for above mentioned tools which have been created during the process of installation in the past.

For migration our DBA would simply take a snapshot / dump of the productive 11g environment schemas and he would load it into the 12c environment on the new server.

User names and passwords will stay the same as on the 11g environment so I would only need to point our OBIEE and Essbase application to the new server IP address.

We have already done this kind of migration of a Hyperion Interactive Reporting environment in the past by using a config-tool which was located on the application server.

My question is at which points (maybe Enterprise Manager 12c) I would need to make an adjustment to the setup which points to the database repository?

Best regards and thanks in advance

Carsten

Tagged:
Carsten WeberRobert AngelChristian Berg-0racle

Best Answer

«1

Answers

  • Joel Acha
    Joel Acha Member Posts: 1,373 Gold Trophy
    edited Oct 24, 2018 9:04AM

    The steps you need to follow in order to migrate your RCU can be found in this thread.

    Carsten Weber
  • Christian Berg-0racle
    Christian Berg-0racle Everything Analytics And Data Member Posts: 9,676 Gold Crown
    edited Oct 24, 2018 10:12AM Answer ✓

    Hi Carsten,

    Joel war schneller, aber hier der direkte Link nochmal: https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?id=2177562.1

    Carsten Weber
  • Carsten Weber
    Carsten Weber Member Posts: 65 Blue Ribbon
    edited Oct 25, 2018 7:35AM

    Hi Joel and Christian,

    thank you very much for your quick response.

    I will check the links and afterwards I will highlight the correct anwser.

    Best regards

    Carsten

    Update (25.10.2018 / 13:33 CET):

    Okay, I have just read the instructions and I think I understood what to modify in the respective directories.

    Eventhough there is still the question, of setting upthe adjustments for our Essbase instance since the user data (e.g. admin login) is also stored within the Oracle database.

    Can anyone give me a hint on that one?

  • Robert Angel
    Robert Angel Member Posts: 4,535 Bronze Crown
    edited Oct 25, 2018 7:42AM

    If this is OBIEE reporting Essbase data then it will be in the connection pool, which is the question I misread you as asking the first time....

  • Carsten Weber
    Carsten Weber Member Posts: 65 Blue Ribbon
    edited Oct 26, 2018 12:46AM

    Hi Robert,

    indeed we use Essbase for a multi-demensional data source but I am pretty sure I don't need to make any adjustments to my RPD within the OBI administration tool since the Essbase application (also the cube data / rule files) and our OBIEE application is stored on the same application server.

    Still I think I would need to make a modification to the configuration which connects the Essbase application to the Oracle 11g / 12c database which is used to store data (e.g. login information for Essbase) which keeps the application running.

    Best regards

    Carsten

  • Robert Angel
    Robert Angel Member Posts: 4,535 Bronze Crown
    edited Oct 26, 2018 3:01AM

    Hi Carsten,

    whilst OBIEE and Essbase are complimentary products they are not so tightly tied together that OBIEE will use Essbase as a data source without some work within the rpd.

    Originally someone will have; -

    • set up a connection pool to your Essbase instance using the (albeit local) connection details, user and password
    • imported Essbase into the physical layer
    • probably altered some of the default characteristics
    • modelled it into the business model layer
    • modelled (sic) it into the presentation layer

    Like this => https://www.ecapitaladvisors.com/blog/import-essbase-cube-obiee-11g-administration-tool/

    (I know this is 11g - the song remains the same....)

    If all of the details used in the first step above are still valid, then the Essbase subject area will still work as is in OBIEE, if not then you need to revisit the first step and reconfigure any changes in the connection pool as previously advised.

  • Carsten Weber
    Carsten Weber Member Posts: 65 Blue Ribbon
    edited Nov 6, 2018 12:55AM

    Hi Robert,

    thanks for your reply.

    Anyways it was still not what I was looking for since I do not want to change the connection between Oracle BI (within OBI admin tool) and Essbase but I want to change the connection between Essbase application and its repository which is located within an Oracle 11g database.

    I think that I have just found what I need do since Essbase application seems to be quite similar to Hyperion Interactive Reporting when it comes to configuration:

    1. Stop all Essbase services on the application server

    2. Modify the db repository information within "eas_datasource-jdbc.xml" and "EPMSystemRegistry-jdbc.xml" (/opt/oracle/base/product/epm/user_projects/domains/EPMSystem/config/jdbc)

    3. Modify "/opt/oracle/base/product/12.1.0/client_1/network/admin" (/opt/oracle/base/product/12.1.0/client_1/network/admin)

    4. Restart all Essbase services on the application server

    Actually step 2 should be do-able by using "config-tool.sh" but somehow my putty session always shows an error when trying to start it.

    I will keep you updated how things went as soon as I did the migration in the upcoming week ... hopefully it will be a success.

    Best regards


    Carsten

  • Robert Angel
    Robert Angel Member Posts: 4,535 Bronze Crown
    edited Nov 6, 2018 6:57AM

    Hi,

    sorry it was where you were pitching the question (OBIEE space!) that threw me, you would be have been better with  Essbase on-premise  for that perhaps...

  • Carsten Weber
    Carsten Weber Member Posts: 65 Blue Ribbon
    edited Nov 13, 2018 7:52AM

    Our migration of Oracle BI repository and Oracle Essbase repository from database version 11g to 12c was successful.

    Thanks again for everyones help and for providing the useful link (regarding Oracle BI).

    For Oracle Essbase it is important to run the registry-cleanup.sh after making all the changes.

    Robert AngelChristian Berg-0racle