Migrate the customized 11g BI Publisher configuration settings to the 12c environment using the BI Publisher Migration Tool (BIP12CUpgrade.sh).
To migrate the configuration:
- Copy BI Publisher Migration Tool from the following path to your scratch directory:
ORACLE_HOME\bi\modules\oracle.bi.publisher\BIP12CUpgrade.zip
Replace ORACLE_HOME with the actual path to the 12c Oracle home you created when you installed the 12c software.
- Decompress the BIP12CUpgrade.zip file. Enter the following command:
unzip BIP12CUpgrade.zip
- Export the configuration from 11g instance to a target directory using the
export_configuration option with the following syntax:
sh BIP12CUpgrade.sh PATH_TO_ORACLE_HOME -export_configuration <Source_BIPDomain_Path> <Export_BIP_Directory_Path>
Sample command:
sh BIP12CUpgrade.sh /scratch/bipublisher/mw_home -export_configuration /scratch/bipublisher/mw_home/user_projects/domains/bifoundation_domain /scratch/user1/Downloads/migrationData
- Import the configuration from the target directory in to the 12c instance using
import_configuration option with the following syntax:
sh BIP12CUpgrade.sh PATH_TO_ORACLE_HOME -import_configuration <Export_BIP_Directory_Path>/export_bip <Target_BIPData_Repository_Path>
Sample command:
sh BIP12CUpgrade.sh /scratch/bip/work/Oracle_Home -import_configuration /scratch/user1/Downloads/migrationData/export_bip /scratch/bip/work/Oracle_Home/user_projects/domains/bi/bidata/components/bipublisher/repository
Next, migrate the scheduler jobs and job history from the 11g BIPLATFORM to the 12c BIPLATFORM.