Saturday, September 26, 2020

Oracle Analytics Server - BAR file migration

-bash-4.1$ cd /testap/obiee/fusion/mwr_OAS/user_projects/domains/bi/bitools/bin

./exportarchive.sh Service_Instance_Name Location_of_BAR_File  <Optional Parameters> 

 
-bash-4.1$ ./exportarchive.sh ssi /shared_fsy/fusion/obiee/Barfile_backup encryptionpassword=test123
Export archive is running...
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
************  BIP inside beginExport ************
List credential (index: connect_string username)
[EL Info]: 2020-09-24 18:43:49.648--ServerSession(1830747664)--EclipseLink, version: Eclipse Persistence Services - 2.6.7.v20190604-418f1a1c56
[EL Info]: 2020-09-24 18:43:49.684--ServerSession(874240738)--EclipseLink, version: Eclipse Persistence Services - 2.6.7.v20190604-418f1a1c56
[EL Info]: connection: 2020-09-24 18:43:49.782--ServerSession(1830747664)--/file:/testap/obiee/fusion/mwr_OAS/bi/modules/oracle.bi.infer/bi-infer-data.jar_INFER_PLUGIN_PU_url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=devtestscan.fsn.com)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=fusiondb)))_user=FSN1_BIPLATFORM login successful
[EL Info]: connection: 2020-09-24 18:43:49.86--ServerSession(874240738)--/file:/testap/obiee/fusion/mwr_OAS/bi/modules/oracle.bi.majel/bi-majel-data.jar_tenantPU_url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=devtestscan.fsn.com)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=fusiondb)))_user=FSN1_BIPLATFORM login successful
[EL Info]: connection: 2020-09-24 18:43:51.088--ServerSession(1830747664)--/file:/testap/obiee/fusion/mwr_OAS/bi/modules/oracle.bi.infer/bi-infer-data.jar_INFER_PLUGIN_PU_url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=devtestscan.fsn.com)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=fusiondb)))_user=FSN1_BIPLATFORM logout successful
[EL Info]: connection: 2020-09-24 18:43:51.108--ServerSession(874240738)--/file:/testap/obiee/fusion/mwr_OAS/bi/modules/oracle.bi.majel/bi-majel-data.jar_tenantPU_url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=devtestscan.fsn.com)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=fusiondb)))_user=FSN1_BIPLATFORM logout successful
Export Archive  completed Successfully
Archive location : /shared_fsy/fusion/obiee/Barfile_backup/1600973247977/ssi.bar
Log dir :/testap/obiee/fusion/mwr_OAS/user_projects/domains/bi/bilogs/metadata/exportbar_20200924_1838194
You have new mail in /var/spool/mail/obifusion
 

Transfer the BAR file to target OAS server.

[obifusion@test-x2 bin]$ pwd
/test2ap_oas/obiee/fusion/mwr_OAS/user_projects/domains/bi/bitools/bin

./importarchive.sh Service_Instance_Name Location_of_BAR_File_including_name  <Optional Parameters> 

 
[obifusion@test-x2 bin]$ ./importarchive.sh ssi /test2ap_oas/obiee/fusion/1600973247977/ssi.bar encryptionpassword=test123
Import archive is running...
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
[EL Info]: 2020-09-24 21:36:14.564--ServerSession(1708098355)--EclipseLink, version: Eclipse Persistence Services - 2.6.7.v20190604-418f1a1c56
[EL Info]: connection: 2020-09-24 21:36:14.941--ServerSession(1708098355)--/file:/test2ap_oas/obiee/fusion/mwr_OAS/bi/modules/oracle.bi.infer/bi-infer-data.jar_INFER_PLUGIN_PU_url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.25.132.187)(PORT=1524)))(CONNECT_DATA=(SERVICE_NAME=fusiondb3)))_user=FSN2_BIPLATFORM login successful
[EL Info]: 2020-09-24 21:36:15.064--ServerSession(1257740559)--EclipseLink, version: Eclipse Persistence Services - 2.6.7.v20190604-418f1a1c56
[EL Info]: connection: 2020-09-24 21:36:15.464--ServerSession(1257740559)--/file:/test2ap_oas/obiee/fusion/mwr_OAS/bi/modules/oracle.bi.majel/bi-majel-data.jar_tenantPU_url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.25.132.187)(PORT=1524)))(CONNECT_DATA=(SERVICE_NAME=fusiondb3)))_user=FSN2_BIPLATFORM login successful
Writing to ssi/actioBarImport/8c466613-2b90-4568-9853-f56fb407b414
Writing to ssi/actioBarImport/8c466613-2b90-4568-9853-f56fb407b414.checksum
Import Archive completed Successfully
Log dir :/test2ap_oas/obiee/fusion/mwr_OAS/user_projects/domains/bi/bilogs/metadata/importbar_20200924_2130477
[obifusion@test-x2 bin]$


3 comments:

  1. Hi Vikas I am getting an error mentioned it he Link While Uprading OBIEE 12c to OAS can you check once
    https://community.oracle.com/mosc/discussion/4508817/obiee-12-2-1-4-to-oas-5-9-upgrade-error/p1

    ReplyDelete
  2. On running command:
    -bash-4.1$ ./exportarchive.sh ssi /shared_fsy/fusion/obiee/Barfile_backup encryptionpassword=test123
    Getting below error :
    Invalid Password. Password should be atleast 8 characters long and should have atleast one numeric and one non-numeric character
    Seems password should be atleast 8 characters long

    ReplyDelete
    Replies
    1. While publishing this blog, I have replaced the actual password with the dummy.

      Delete