Tuesday, June 27, 2017

BAR file migration from BI 12c to upgraded version of 12c or another host.

1. Invoke wlst prompt

/test1ap/obiee/fmw/Middleware_12c/oracle_common/common/bin/wlst.sh

2. Source env. List current BI service instances.


listBIServiceInstances('/test1ap/obiee/fmw/Middleware_12c/user_projects/domains/bi')


3. create export BI Archive file (BAR file) of the source service instance - In this case everything would be exported, use command exportServiceInstance

- Domain Home: e.g. $OBIEE_HOME/user_projects/domains/bi   (in my case domain name is bi12c)
- Service Instance Key:  ssi   (default value is ssi and same in my case too)
- The working directory: -  /test1ap/obiee/obiapp/workdir
- The export directory:  -  /test1ap/obiee/obiapp/exportkdir
- There are then three unused parameters, might be reserved for future.
- Include Catalog Runtime Info: default value is set to ‘false’. Use ‘true’ if you want user info. This parameter is optional.
- Include Credentials: This is a password field to encrypt the database connection credentials in the RPD. This field is optional and if not included the connection credentials are not exported.

exportServiceInstance('/test1ap/obiee/fmw/Middleware_12c/user_projects/domains/bi12c','ssi','/test1ap/obiee/obiapp/workdir','/test1ap/obiee/obiapp/exportdir','','','',true,'Welcome1')

4. Move BAR file to the instance on which it is to be imported.
   
   scp ssi.bar vikas@test23bi.dev.com:/tmp

5. Target env. List current BI service instances.

listBIServiceInstances('/test2ap/obiee/fmw/Middleware_12c1/user_projects/domains/bi')

6. Import BAR file in a service instance - In this case everything would be exported, use command importServiceInstance


- Domain Home: e.g. $OBIEE_HOME/user_projects/domains/bi   (in my case domain name is bi)
- Service Instance Key: ssi (default value is ssi and in my case its same, it might be different)
- BAR file to import: The full path and filename of the BAR file
- Import the RPD?: The default value is true, change to false if not wanted.
- Import the WebCat?:  The default value is true, change to false if not wanted.
- Import the Security model: The default value is true, change to false if not wanted.
- Include Credentials: This is the password used to encrypt the database connection credentials in the RPD. If not provided the connection credentials will not be imported.

importServiceInstance('/test2ap/obiee/fmw/Middleware_12c1/user_projects/domains/bi','ssi','/tmp/ssi.bar',true,true,true,'Welcome1')

No comments:

Post a Comment