What you need to know before we begin:

OBIEE 12c has already been installed and configured, therefore our bi-migration-tool.jar file has been generated. Also, this example is migrating from an OBIEE 11.1.1.9 release.

Create the Export Bundle

The export bundle is a .jar file that consists of metadata information from the 11g Oracle home.

1. From the command line enter into this folder path (this should be where your bi-migration-tool.jar file is located)

[ORACLE_HOME]\bi\migration-tool\jlib

2. Run the following command to generate the export bundle

java -jar bi-migration-tool.jar out <oracle 11g home> <domain home> <output export bundle path>

Where

  • out is telling the migration tool to perform the export operation
  • <oracle 11g home> is the Oracle BI home directory
  • <domain home> is the 11g domain directory
  • <output export bundle path> is the location where you want the export bundle. NOTE: the file must have a .jar extension

Picture2

  • e:\obiee\middleware\oracle_bi1 is the Oracle BI home
  • e:\obiee\middleware\user_projects\domains\bifoundation_domain is the domain home
  • e:\11g\11gexport.jar is the export bundle

If everything is successful you will receive an Export succeeded message from the command prompt and you should be able to locate your export file in the location specified in the previous command.

12

Import the Export Bundle

Again, 12c has been installed and configured, so our domain and BI instance have already been created. With that in mind, we will be using the BI Migration script to import the export bundle. You can use the BI 12c Configuration Assistant to reference the export bundle if you’re configuring 12c for the first time.

1. You should be in the same file location as before:

[ORACLE_HOME]\bi\migration-tool\jlib

2. Run the following command:

java -jar bi-migration-tool.jar in <12c Oracle Home> <12c domain home> <export bundle> <service instance name>

Where

  • in tells the migration tool to perform an import operation
  • e:\obiee12c\middleware\oracle_home is the Oracle Home
  • e:\obiee12c\middleware\oracle_home\user_projects\domains\bat_domain is the 12c domain directory
  • e:\11g\11gexport.jar is the previously created export bundle
  • ssi is the BI service instance

3. You will be prompted to enter the RPD password

4. If the migration is successful you will receive a Migration action succeeded message

Picture3

To verify login to OBIEE 12c and you should see your dashboards, subject areas, etc that have been imported from your 11g.

10

Questions? Comments? Feel free to drop me a line at:

Kristi Smith, ksmith@ecapitaladvisors.com