Moving OBIEE to new enviroment

 

OBI migration to new enviroment

 

Everyone has at least once had the need to migrate Oracle Business Intelligence (OBI) to a new enviroment. Whether it is a migration from test to production environment or during full server migration, procedure is the same. The OBI environment migration process is described below. All you need is just a few commands using predefined OBI scripts. With this, you will migrate whole OBI metadata to new server (Weblogic Users and Groups, Catalog, Catalog Permissions, Repository metadata etc.).

First, you need to set up variables which depends of your installation:

export BI_PRODUCT_HOME="your BI home directory ex. /omw/bi"
export ORACLE_HOME="your Oracle home directory ex. /omw"
export DOMAIN_HOME="your domain home directory ex. /omw/user_projects/domains/bi"

Export script in 12.2.1.4.0. version of OBI  is located at "/ora01/omw/user_projects/domains/bi/bitools/bin/" directory. You will need to type password for encryption. This password you will need in import procedure.

Full export command you can see below:

/ora01/omw/user_projects/domains/bi/bitools/bin/export_service_instance.sh ssi /tmp/testexp.bar

Import script in 12.2.1.4.0. version of OBI is located at "/ora01/omw/user_projects/domains/bi/bitools/bin/" directory. You must execute this script on new OBI enviroment after you have successfully copied BAR file from previous export described above.

Full importcommand you can see below:

/ora01/omw/user_projects/domains/bi/bitools/bin/importarchive.sh ssi /tmp/testexp.bar encryptionpassword=yourpassword

 
Please, restart your services on new server and check if everything is correct. It must be. :)

/omw/user_projects/domains/bi/bitools/bin/stop.sh
/omw/user_projects/domains/bi/bitools/bin/start.sh

Cheers!