After migrating the 11g configuration to a new 12c environment, you must migrate the scheduler jobs and the job history data from the 11g BIPLATFORM schema to a 12c BIPLATFORM schema. You can connect to 12c BIPLATFROM schema through SQL*PLUS or any other tool and execute the script.
The bip_12c_scheduler_migration.sql script requires the user ID, the password, and the connection string for 11
g BIPLATFROM schema. The script creates a database link called BIP11g_DBLINK and imports all schedule objects using that link. You must have Database Administrator privileges to run the script.
Note:
You cannot migrate scheduler data from DB2 and SQL Server databases. You can migrate scheduler data only from Oracle databases.
To migrate scheduler jobs and job history:
- The bip_12c_scheduler_migration.sql script is available in a zip file format called
BIP12CUpgrade.zip
which is located in the following directory:
(UNIX) NEW_ORACLE_HOME/bi/modules/oracle.bi.publisher
(Windows) NEW_ORACLE_HOME\bi\modules\oracle.bi.publisher
Replace NEW_ORACLE_HOME with the actual path to the 12c Oracle home you created when you installed the 12c software.
- To use the bip_12c_scheduler_migration.sql script, decompress the BIP12CUpgrade.zip file by entering the following command:
unzip BIP12CUpgrade.zip
- Change directory to
NEW_ORACLE_HOME/bi/modules/oracle.bi.publisher/BIP12CUpgrade
.
- Run the bip_12c_scheduler_migration.sql script by entering the following command:
mysql -u <username> -p bip_12c_scheduler_migration.sql
When prompted, enter your password.
- Enter the command-line parameters
11g_RCU_SCHEMA
, 11G_PASSWORD
, 11G_CONNECTION_STRING
, and 12C_BIPLATFORM_SCHEMA
.
Usage:
SQL > @bip_12c_scheduler_migrationg.sql 11g_userid 11g_password 11g_connection_string
SQL> @bip_12c_scheduler_migration.sql 11g_RCU_USERNAME 11g_PASSSWORD 11G_hostname.us.oracle.com:1521/orcl.us.oracle.com 12C_BIPLATFROM_SCHEMA_NAME
System output:
old 1: &&1
new 1: adc00ccq_biplatform
old 2: &&2
new 2: welcome1
old 3: '&&3'
new 3: 'bipdev4.us.oracle.com:1521/ora11g.us.oracle.com'
old 4: '&&4'
new 4: 12C_BIPLATFROM_SCHEMA_NAME
Database link created.
9979 rows created.
9769 rows created.
9739 rows created.
4159 rows created.
6 rows created.
6 rows created.
6 rows created.
Commit complete.
Database link dropped.
SQL>
After the import operation completes, the database link is deleted.