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]$

UPGRADE OPATCH to 13.9.4.2.2

UPGRADE OPATCH to 13.9.4.2.2

Installation of bug correction patches for Oracle WLS / FMW 12.2.1.4 is done with the new OPatch 13.9.4.2.2

1. Download p28186730_139422_Generic.zip

[abtid1@indelbtidfap01 Middleware]$ unzip p28186730_139422_Generic.zip
Archive:  p28186730_139422_Generic.zip
   creating: 6880880/
  inflating: 6880880/README.txt
  inflating: 6880880/opatch_generic.jar
  inflating: 6880880/version.txt
[abtid1@indelbtidfap01 Middleware]$ cd 6880880
[abtid1@indelbtidfap01 6880880]$ ls
README.txt  opatch_generic.jar  version.txt


2. Install the software with the following command:

    UNIX Only:
        java -jar <PATCH_LOCATION>/6880880/opatch_generic.jar -silent oracle_home=$ORACLE_HOME

ORACLE_HOME is set to installed Middleware home.

[abtid1@indelbtidfap01 6880880]$ java -jar /btid1ap/bi/abtid1/Middleware/6880880/opatch_generic.jar -silent oracle_home=$ORACLE_HOME
Launcher log file is /tmp/OraInstall2020-06-01_02-20-23AM/launcher2020-06-01_02-20-23AM.log.
Extracting the installer . . . . Done
Checking if CPU speed is above 300 MHz.   Actual 2095.148 MHz    Passed
Checking swap space: must be greater than 512 MB.   Actual 16383 MB    Passed
Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)
Checking temp space: must be greater than 300 MB.   Actual 9321 MB    Passed
Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2020-06-01_02-20-23AM
Installation Summary


Disk Space : Required 35 MB, Available 92,882 MB
Feature Sets to Install:
        Next Generation Install Core 13.9.4.0.0
        OPatch 13.9.4.2.2
        OPatch Auto OPlan 13.9.4.2.2
        OPatch Auto FMW 13.9.4.2.2
Session log file is /tmp/OraInstall2020-06-01_02-20-23AM/install2020-06-01_02-20-23AM.log

Loading products list. Please wait.
 1%
 40%

.....................

[abtid1@indelbtidfap01 6880880]$ opatch version
OPatch Version: 13.9.4.2.2

[abtid1@indelbtidfap01 6880880]$ opatch lspatches
26355633;One-off
26287183;One-off
26261906;One-off
26051289;One-off

OPatch succeeded.

Apply Weblogic Security patch 30463097 - JWEB

Security patch name - p30463097_1036_Generic.zip
Middleware Home -  /test1ap/bi/atest1/Middleware_ODI

[atest1@indlbtdb11 30463097]$ cp p30463097_1036_Generic.zip  /test1ap/bi/atest1/Middleware_ODI/utils/bsu/cache_dir
[atest1@indlbtdb11 cache_dir]$ unzip p30463097_1036_Generic.zip
[atest1@indlbtdb11 cache_dir]$
[atest1@indlbtdb11 cache_dir]$ cd /test1ap/bi/atest1/Middleware_ODI/utils/bsu
[atest1@indlbtdb11 bsu]$ cp bsu.sh bsu.sh_bkp

----- Increase JAVA Heap size


Open bsu.sh change  MEM_ARGS="-Xms256m -Xmx512m"    to MEM_ARGS="-Xms1024m -Xmx3072m"

[atest1@indlbtdb11 bsu]$ ./bsu.sh -install -patch_download_dir=/test1ap/bi/atest1/Middleware_ODI/utils/bsu/cache_dir -patchlist=JWEB -prod_dir=/test1ap/bi/atest1/Middleware_ODI/wlserver_10.3
Checking for conflicts.........................
Conflict(s) detected - resolve conflict condition and execute patch installation again
Conflict condition details follow:
Patch JWEB is mutually exclusive and cannot coexist with patch(es): BUNQ
You have mail in /var/spool/mail/atest1

 ----- Remove earlier conflict patch

[atest1@indlbtdb11 bsu]$ ./bsu.sh -remove  -patchlist=BUNQ -prod_dir=/test1ap/bi/atest1/Middleware_ODI/wlserver_10.3
Checking for conflicts..........................
No conflict(s) detected

Removing Patch ID: BUNQ..
Result: Success



-------    Apply JWEB patch

[atest1@indlbtdb11 bsu]$ ./bsu.sh -install -patch_download_dir=/test1ap/bi/atest1/Middleware_ODI/utils/bsu/cache_dir -patchlist=JWEB -prod_dir=/test1ap/bi/atest1/Middleware_ODI/wlserver_10.3
Checking for conflicts.....................
No conflict(s) detected

Installing Patch ID: JWEB..
Result: Success

You have mail in /var/spool/mail/atest1
[atest1@indlbtdb11 bsu]$


------    Verify JWEB patch

[atest1@indlbtdb11 bin]$ pwd
/test1ap/bi/atest1/Middleware_ODI/wlserver_10.3/server/bin
[atest1@indlbtdb11 bin]$ source setWLSEnv.sh
[atest1@indlbtdb11 bin]$ java weblogic.version | grep "WebLogic Server"
WebLogic Server 10.3.6.0.200114 PSU Patch for BUG30463097 Sun Jan 19 00:03:46 PST 2020
WebLogic Server 10.3.6.0  Tue Nov 15 08:52:36 PST 2011 1441050
[atest1@indlbtdb11 bin]$

Get Weblogic version

Three steps to know Weblogic version in case Weblogic is down.

1.
source $ORACLE_HOME/wlserver/server/bin/setWLSEnv.sh
cd $ORACLE_HOME/wlserver/server/lib

java -cp weblogic.jar weblogic.version


2.

cd $ORACLE_HOME/inventory

 more registry.xml | grep weblogic





3.

cd $ORACLE_HOME/wlserver/server/bin

source setWLSEnv.sh
java weblogic.version | grep "WebLogic Server"

SmartView connection configuration

SmartView connection configuration.

 

 

 

Enter your OBIEE credentials.

  

 

 

Once again provide your OBIEE credentials.