Label

Tuesday, June 27, 2017

Migrate OBIEE 11g instance to OBIEE 12c.

This step will migrate Catalog, rpd and security components from 11g to 12c. 

export ORACLE_HOME=/test1ap/obiee/fmw/Middleware_11g/Oracle_BI1
export JAVA_HOME=/test1ap/obiee/fmw/jdk1.8.0_111
export PATH=$ORACLE_HOME/bin:$JAVA_HOME/bin:$PATH


create a migration tool jar file from target server.

cd $ORACLE_HOME/user_projects/domains/bi/bitools/bin
-bash-4.1$  ./migration-tool.sh package bi-migration-tool.jar 

copy the migration tool jar file to 11g server or domain to create export jar of it 
-bash-4.1$ scp bi-migration-tool.jar vikas@test1ap.dev.com:$HOME on 11g server change the permission to 777 of bi-migration-tool.jar -bash-4.1$ chmod 777 bi-migration-tool.jar 

-bash-4.1$ java -jar bi-migration-tool.jar out $ORACLE_HOME /test1ap/obiee/fmw/Middleware_11g/user_projects/domains/bifoundation_domain1 /test1ap/obiee/obiapp/export12c.jar

Oracle BI Migration Tool

Logging to: /test1ap/obiee/fmw/Middleware_11g/user_projects/domains/bifoundation_domain1/bilogs/migration/migration-2016-03-03-18-21-18.log
Performing export with top-level install directory /test1ap/obiee/fmw/Middleware_11g, domain home=/test1ap/obiee/fmw/Middleware_11g/user_projects/domains/bifoundation_domain1, output file = /test1ap/obiee/obiapp/export12c.jar
Removed the node credstore
Removed the node keystore
Find the policy store node policystore.xml
Removed the node audit
Removed the node trust
Removed the node pdp.service
Removed the node attribute
Removed the node idstore.ldap
true-
Successfully created file /test1ap/obiee/fmw/Middleware_11g/user_projects/domains/bifoundation_domain1/config/fmwconfig/jps-config-migration.xml
Migration policy store executed successfully: [policyStore, /test1ap/obiee/fmw/Middleware_11g/user_projects/domains/bifoundation_domain1/config/fmwconfig/jps-config-migration.xml, default, policystore_dest_context]
Export succeeded
Migration action succeeded

copy the export jar file to 12c server.

-bash-4.1$ scp export12c.jar vikas@test12c.dev.com:/tmp

-bash-4.1$ export TZ='UTC'     -  if you are working on Linux server.

stop obiee server using stop.sh located in $ORACLE_HOME/user_projects/domains/bi/bitools/bin
Before import, find the service instance name. By default it is ssi and mine too.

Import jar file into 12c providing permission of 777 to jar file (export12c.jar)
-bash-4.1$ ./migration-tool.sh in /tmp/export12c.jar ssi 


Start bi server using start.sh
 -bash-4.1$ ./start.sh

1 comment: