Migrating OBIA-7964 warehouse to another DB Server — Oracle Analytics

Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

Migrating OBIA-7964 warehouse to another DB Server

Received Response
54
Views
9
Comments
User_N8YMF
User_N8YMF Rank 3 - Community Apprentice
in Oracle Business Intelligence Applications

Hi Experts,

We have a running OBIA-7964 system in our production environment.

Now we have a requirement to move the application server (containing Informatica 951 and DAC11g and OBIEE11g) and the DB server to another server with higher capacity.

As a first step, OBIEE movement is done with the latest RPD, catalog and the security. Now to move the OBIA Data warehouse and to continue the incremental load from the new server, we would need to know what all steps to be taken care and acted up on.

Like for eg: To do an incremental load with the same set of data in the existing warehouse, what all steps to be taken care?

I understand we move the database dmp from existing to the new Data warehouse, next the parameter files of DAC.

Kindly help me in achieving the same.

Thanks,

Rajesh.

Answers

  • User_N8YMF
    User_N8YMF Rank 3 - Community Apprentice

    have anybody done this before? Kindly help

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

    Not but it's not rocket science just something which needs to be done precise and meticulously. That's nothing a 5-minute forum-written answer can do for you. If it was then our projects would take minutes or hours instead of days/weeks/months.

    You're not being very specifc either: "As a first step, OBIEE movement is done with the latest RPD, catalog and the security."

    So what? You totally installed the new server from scratch and are moving "content" from old to new?

  • User_N8YMF
    User_N8YMF Rank 3 - Community Apprentice

    Let me clarify again if its not clear.

    Server1 has OBIA 7964, with daily incremental load running from January 2016.

    Server2 has all fresh installations, moved OBIEE rpd and catalog, Informatica and DAC exports. I need the whole data existing in the Server1 and from now on I need to stop the incremental load in Server1 and start the incremental load from Server2.

    Let me know the steps to do the same even if it is 5 minute forum.

    Thanks in advance.

    Rajesh.

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

    Just on the OBI side one quick additional thing: RPD + catalog is just part of the total. What about custom styles and skins, images/artifacts, security setup in WLS and EM?

    As for your server bit: You're not putting much information here but staying on the same level of detail as your specification and question above: basically you need to stop loading with server 1 and start loading with server 2.

  • User_N8YMF
    User_N8YMF Rank 3 - Community Apprentice

    OBIEE part is complete with all aspects covered. Done with the custom styles, skins, images/artifacts, securtity setup in WLS and EM.

    My concern is about the data load. Yes I need to stop loading with server 1 and start loading with server 2, but there should not be any data loss(aggregate tables which has the snapshots for all previous months). I can not start a full load from server 2.

    Thanks,

    Rajesh.

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

    Why would or should there be any data loss of all that's happening is that machine 2 instead of machine 1 does the work? Did you put machine-dependent logic into your data loading routines? Is machine 2 not allowed to read the same sources as machine 1?

  • User_N8YMF
    User_N8YMF Rank 3 - Community Apprentice

    Okay.

    The data loss which I said about is from the data warehouse. The aggregate tables have already loaded with the monthly snapshot data in Server1. So if I start a fresh load from Server2, it will not contain the snapshot data which is available in the Server1.

    Server2 is connected to the same source as machine 1.

    Please clarify the below.

    I have moved the Informatica latest repository from Server1 to Server2, Source files and lkp files are also copied and DAC is also configured same as Server1.

    If I Will move the database dmp from Server 1 to Server 2, copy the DAC parameter files from DAC in server1 and DAC server2.

    Now If I start the incremental load from Server2, will it work properly?

    OR is there anything else to be taken care like Informatica indexes or DB indexes or ETL_PROC_WID

    Thanks,

    Rajesh.

  • User_N8YMF
    User_N8YMF Rank 3 - Community Apprentice

    Any help on this pls?

    Thanks

    Rajesh

  • S R Battula
    S R Battula Rank 4 - Community Specialist

    yes, it is possible to load incremental from  server2.

    1) complete DAC load with  Server1.

    2) migrate the DAC meta data DB from server1 to server2.

    3) connect Server2 DB with  Server2 DAC.

    4) you can find all the server2 DAC setup looks  same as Server1 DAC setup

    5) validate refresh dates and  infromatica , source and  target connections and build the Execution plan

    6)  run the execution plan , it  will start the incremental data load.