6 Replies Latest reply: Dec 13, 2012 12:02 AM by Nicholas King RSS

    Migrating from 11.1.2.0 to 11.1.2.2

    928267
      This might have been covered earlier. But really not sure. We are currently upgrading from 11.1.2.0 to 11.1.2.2. Once the installation and configuration of 11.1.2.2 is done, Can we use LCM to migrate the apps from the old to the new version?

      Applications we currrently have are

      1.EPMA
      2.Essbase studio
      3.Planning
      4.Essbase
      5.FR
      6.Web Analysis.
        • 1. Re: Migrating from 11.1.2.0 to 11.1.2.2
          JohnGoodwin
          Apparently it is not supported and LCM require both the source and destination environments to be of the same version.
          It may all work or just certain components migrate successfully, also LCM does not support essbase studio yet.

          Cheers

          John
          http://john-goodwin.blogspot.com/
          • 2. Re: Migrating from 11.1.2.0 to 11.1.2.2
            928267
            Thanks John.

            In that case, would it require a Database restore for EPMA, Planning and Essbase Studio?

            For Essbase Hope I can create a blank application and move the .otl files and calc scripts and data(Level 0 Export, Import and Agg).
            For FR and Web analysis, Hope the reports can be exported and Imported.

            Also would like to know if there is any documentation for migrating from 11.1.2.0 to 11.1.2.2.
            • 3. Re: Migrating from 11.1.2.0 to 11.1.2.2
              928267
              For shared services do we have to migrate the data from 11.1.2.0 to 11.1.2.2 using HSSMigrate.bat?

              Any help is appreciated.
              • 4. Re: Migrating from 11.1.2.0 to 11.1.2.2
                SauravSarkar
                Hi ,

                LCM migrations can take place from 11.1.2.0 to 11.1.2.2 . YOu just need change the folder structure bit of the 11.1.2.0 and add a import and export xml file. The format of the xml files can be obtained by taking a test lcm backup from 11.1.2.2 environment.
                But you will face issues with Business rules. You need to export the business rules for calc manager as 11.1.2.2 does not have business rules.

                Hope this helps.

                Saurav

                Edited by: Saurav Sarkar on 4 Dec, 2012 1:52 AM
                • 5. Re: Migrating from 11.1.2.0 to 11.1.2.2
                  928267
                  Oracle says we have to install 11.1.2.0 on the new servers. Use LCM to migrate the applications from old to new server and then apply 11.1.2.2 as a maintenance release. Is this the recommended path to upgrade from 11.1.2.0 to 11.1.2.2? Just wanted to make sure.
                  • 6. Re: Migrating from 11.1.2.0 to 11.1.2.2
                    Nicholas King
                    What you described is the supported upgrade path.
                    Sometimes you can find other creative ways to migrate the objects depending on what you need migrated - but LCM is not supported between two different versions so you can't use that.

                    Nick