BI Applications - Oct 2023 CPU

 Oct 2023 CPU

FINAL ACTION PLAN:
====================
  - Perform pre-health checks (ckHealth)

  - Shutdown services on luframfobidl313 and luframfobidl314 (stopBI)

  - Take a count/list of invalid objects
  - Apply DB patches using OCI console

  - Take backup
      export ORACLE_HOME=$MW_HOME
      cd $ORACLE_HOME/..
      tar czvf 122_preOct2023CPU_`hostname`.tar.gz 122
      Remove old zip files from previous CPUs

which java
/u02/hhsfobidev/local/jdk/bin/java -version
cd /u02/ramfobidev/local
mv jdk jdk.1.8.0_381
tar -xvf /ood_repository/Patches/jdk-8u391-linux-x64.tar
mv jdk1.8.0_391 jdk
tar czvf jdk.1.8.0_381_`hostname`.tar.gz  jdk.1.8.0_381

      cd /u02/ramfobidev
      tar czvf oraInventory_preOct2023.tar.gz oraInventory
      Remove old zip files from previous CPUs
  - Apply Patches on application tier nodes

Stage patch zip files in /u01/stage/CPU/Oct2023              
   
    * Apply PSU patches
      export ORACLE_HOME=$MW_HOME
      mkdir -p /u02/stage/CPU/Oct2023 ; cd /u02/stage/CPU/Oct2023
      unzip -o /ood_repository/Patches/p34703053_122130_Generic.zip

     * 35261722 WLS STACK PATCH BUNDLE 12.2.1.3.230405

cd WLS_SPB_12.2.1.3.221014/tools/spbat/generic/SPBAT
./spbat.sh -phase precheck -oracle_home $ORACLE_HOME -invPtrLoc $ORACLE_HOME/oraInst.loc 
date; time ./spbat.sh -phase apply -oracle_home $ORACLE_HOME

     * OBI Bundle Patch 12.2.1.4.220628
        export ORACLE_HOME=$MW_HOME
cd /u02/stage/CPU/Oct2023/
        unzip -o /ood_repository/Patches/p35907889_122140_Linux-x86-64.zip
        cd OBI_SPB_12.2.1.4.231013/tools/spbat/generic/SPBAT
date;./spbat.sh -phase precheck -oracle_home $ORACLE_HOME;date
date; time ./spbat.sh -phase apply -oracle_home $ORACLE_HOME;date
cd ..

     * DATABASE RELEASE UPDATE 19.21.0.0.0
mkdir -p /u02/stage/CPU/Oct2023 ; cd /u02/stage/CPU/Oct2023
unzip -o /ood_repository/Patches/p35643107_190000_Linux-x86-64.zip
cd 35643107
        $ORACLE_HOME/OPatch/opatch lspatches
$ORACLE_HOME/OPatch/opatch apply -silent -invPtrLoc $ORACLE_HOME/oraInst.loc
cd ..
  - Start all the MT services(startBI)
  - Perform post-health checks (ckHealth)
    

==============

cd $FMW_HOME/utils/bsu

./bsu.sh -report -bea_home=$FMW_HOME -output_file=bsu_patch_report.log

perl $FND_TOP/patch/115/bin/TXKScript.pl 

-script=$FND_TOP/patch/115/bin/txkInventory.pl 

-txktop=$APPLTMP  

-contextfile=$CONTEXT_FILE 

-appspass=$APPS_PWD 

-outfile=$APPLTMP/Report_Inventory.html

==============