19 de enero de 2023

Ejecución ETCC para EBS

 Buenas a todos!!

Les voy adejar los pasos simples para descargar y ejecutar el ETCC (TECHNOLOGY CODELEVEL CHECKER). Para que estén al tanto Oracle actualiza constantemente este parche y es un requerimiento mandatorio de cualquier instalación de EBS contar con todos los parches que trae la metadata de este validador.

El nro de parche suele ser siempre el mismo: 17537119

Al día de la fecha, este parche fue actualizado hace 2 meses (la actualización va de la mano con las nuevas versiones de EBS, en este caso la 12.2.12)






En este ejemplo vamos a instalar los siguientes Parches:
* BSU
* Form & Report
* MDW
* Web Tier


Una vez descargado, la ejecución es muy simple:
El path depende de donde lo descarguen, lo importante es ejecutarlo en cada nodo con el usuario que corresponda (oraprod o applprod)

DB:

   . EBSDB_apps.env

   cd $ORACLE_HOME/appsutil/etcc/

 sh checkDBpatch.sh

 

APP:

cd /u01/stage/ETCC

 sh checkMTpatch.sh

 Depende los recursos y cantidad de parches pendientes, puede demorar entre 20 y 40minutos


Output de Ejemplo:

 

Output reporte:

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

PATCH RECOMMENDATION SUMMARY

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

One or more products have bugfixes missing.

The default patch recommendations to install these missing bugfixes are:

 -------------------------------------------------------------------------------

Oracle Forms and Reports 10.1.2.3.0

-------------------------------------------------------------------------------

  Patch 32922089

    - Filename: p32922089_101232_LINUX.zip

 -------------------------------------------------------------------------------

Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0

-------------------------------------------------------------------------------

  Patch 32287205 [IMPORTANT: Follow Note 2555355.1 before applying.]

    - Filename: p32287205_111190_Linux-x86-64.zip

   Patch 34251646

    - Filename: p34251646_111190_Linux-x86-64.zip

   Patch 32928416

    - Filename: p32928416_111190_Linux-x86-64.zip

   Patch 33144848

    - Filename: p33144848_111190_Linux-x86-64.zip

   Patch 34067016

    - Filename: p34067016_11119210420OSS_Linux-x86-64.zip

  -------------------------------------------------------------------------------

Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0

-------------------------------------------------------------------------------

  Patch 26933408

    - Filename: p26933408_111190_Generic.zip

   Patch 34330735

    - Filename: p34330735_111190_Generic.zip

 Apply the required patches and rerun this script.

 +-----------------------------------------------------------------------------+

A consolidated zip file with the required application tier patches is

available on My Oracle Support via:

   Patch 34105303

    - EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JUL 2022

 +-----------------------------------------------------------------------------+

[WARNING] Patch 32746843 SU Patch [AXXI]: WLS PSU 10.3.6.0.210420 is missing.

     Filename:  p32746843_R12_GENERIC.zip



Al final del reporte de ETCC, se puede observar que nos recomienda descargar un único parche con el consolidado de todos los reportados.

Patch 34105303

- EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JUL 2022

Sugiero bajar ese primero y luego ver en particular si hace falta algúno en particular.

BSU

Algunos reportes nos pueden solicitar actualizar el BSU (instalador de parches de Weblogic

Del reporte del ETCC, podemos ver que nos recomienda actualizar el BSU. (Parche 33845432)

$ cd $FMW_HOME/utils/bsu/

$ cp /stage/etcc-bundle/LINUX_X86-64/BSU_HOME/5/p33800106_1036_Generic.zip .

$ cd ..

$ cp -Rfp bsu bsu_bkp

$ cd bsu

$  unzip -o p33800106_1036_Generic.zip

[oracle@apps bsu]$ chmod 755 bsu_update.sh

[oracle@apps bsu]$ ./bsu_update.sh install

Installing Smart Update V5...

Updating bsu modules

Update was successful. 


FORMS & REPORTS

Oracle Forms and Reports 10.1.2.3.0

-------------------------------------------------------------------------------

  Patch 32922089

    - Filename: p32922089_101232_LINUX.zip

 Validar que el home sea de Form & Reports

 [oracle@apps ~]$ echo $ORACLE_HOME

/u01/install/APPS/fs1/EBSapps/10.1.2

 [oracle@apps ~]$ $ORACLE_HOME/OPatch/opatch lsinventory

Validar prereq

 [oracle@apps ~]$ cd /stage/FR_Patch/32922089/

[oracle@apps 32922089]$ $ORACLE_HOME/OPatch/opatch apply

[oracle@apps 32922089]$ $ORACLE_HOME/OPatch/opatch apply

 

Oracle Interim Patch Installer version 1.0.0.0.64

Copyright (c) 2011 Oracle Corporation. All Rights Reserved..

Oracle recommends you to use the latest OPatch version and read the OPatch documentation available in the OPatch/docs directory for usage. For information about the latest OPatch and other support-related issues, refer to document ID 293369.1 available on My Oracle Support (https://myoraclesupport.oracle.com)

 

Oracle Home           : /u01/install/APPS/fs1/EBSapps/10.1.2

Oracle Home Inventory : /u01/install/APPS/fs1/EBSapps/10.1.2/inventory

Central Inventory     : /u01/install/APPS/oraInventory

   from               : /etc/oraInst.loc

OUI location          : /u01/install/APPS/fs1/EBSapps/10.1.2/oui

OUI shared library    : /u01/install/APPS/fs1/EBSapps/10.1.2/oui/lib/linux/liboraInstaller.so

Java location         : /u01/install/APPS/fs1/EBSapps/10.1.2/jdk/jre/bin/java

Log file location     : /u01/install/APPS/fs1/EBSapps/10.1.2/.patch_storage/<patch ID>/*.log

 

Creating log file "/u01/install/APPS/fs1/EBSapps/10.1.2/.patch_storage/32922089/Apply_32922089_08-26-2022_21-17-26.log"

 

Invoking fuser to check for active processes.

Patch "32922089" overlays " 14825718 ". Conflict check between them is skipped.

Subset patches:  26825525,

The fixes for Patch 26825525,  are included in the patch currently

being installed (32922089).  OPatch will roll back the subset patch(es) and

install the new patch (32922089).

Provide your email address to be informed of security issues, install and

initiate Oracle Configuration Manager. Easier for you if you use your My

Oracle Support Email address/User Name.

Visit http://www.oracle.com/support/policies.html for details.

Email address/User Name:

You have not provided an email address for notification of security issues.

Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y

Oracle Configuration Manager has been installed but not configured. OCM enables

Oracle to provide superior, proactive support for our customers. Oracle

strongly recommends customers configure OCM. To complete the configuration of

OCM, refer to the OCM Installation and Administration Guide

(http://www.oracle.com/technology/documentation/ocm.html).

Backing up comps.xml ...

 

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

 

Please shut down Oracle instances running out of this ORACLE_HOME

(Oracle Home = /u01/install/APPS/fs1/EBSapps/10.1.2)

Is this system ready for updating?

Please respond Y|N >

Y

 

Rolling back with all-node mode.

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

 

Oracle instances have been shut down, proceeding with auto-rollback.

Removing patch 26825525...

Restoring archive files...

Restoring copied files...

Running make for target  sharedlibs.

Running make for target  sharedlib.

Running make for target  install.

Updating inventory...

Back to applying patch 32922089...

Backing up 2nd copy of comps.xml ...

Applying patch 32922089...

Patching archive files...

Patching copy files...

Running make for target sharedlibs.

Running make for target sharedlib.

Running make for target install.

Inventory is good and does not have any dangling patches.

Updating inventory...

Verifying patch...

Backing up comps.xml ...

OPatch succeeded.


FMW

-------------------------------------------------------------------------------

Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0

-------------------------------------------------------------------------------

[oracle@apps FMW_common]$ cd /stage/FMW_common/26933408

[oracle@apps 26933408]$ $ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 11.1.0.12.9

Copyright (c) 2022, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/install/APPS/fs1/FMW_Home/oracle_common

Central Inventory : /u01/install/APPS/oraInventory

   from           : /u01/install/APPS/fs1/FMW_Home/oracle_common/oraInst.loc

OPatch version    : 11.1.0.12.9

OUI version       : 11.1.0.11.0

Log file location : /u01/install/APPS/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/

26933408_Aug_26_2022_21_39_42/apply2022-08-26_21-39-42PM_1.log

OPatch detects the Middleware Home as "/u01/install/APPS/fs1/FMW_Home"

Applying interim patch '26933408' to OH '/u01/install/APPS/fs1/FMW_Home/oracle_common'

Verifying environment and performing prerequisite checks...

All checks passed.

Provide your email address to be informed of security issues, install and

initiate Oracle Configuration Manager. Easier for you if you use your My

Oracle Support Email address/User Name.

Visit http://www.oracle.com/support/policies.html for details.

Email address/User Name:

Backing up files...

Patching component oracle.jrf.thirdparty.jee, 11.1.1.9.0...

Verifying the update...

Patch 26933408 successfully applied

Log file location: /u01/install/APPS/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/

26933408_Aug_26_2022_21_39_42/apply2022-08-26_21-39-42PM_1.log

OPatch succeeded.

 

[oracle@apps]$ cd /stage/FMW_common/34330735/oui

[oracle@apps oui]$ $ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 11.1.0.12.9

Copyright (c) 2022, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/install/APPS/fs1/FMW_Home/oracle_common

Central Inventory : /u01/install/APPS/oraInventory

   from           : /u01/install/APPS/fs1/FMW_Home/oracle_common/oraInst.loc

OPatch version    : 11.1.0.12.9

OUI version       : 11.1.0.11.0

Log file location : /u01/install/APPS/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/

34330735_Aug_26_2022_21_42_38/apply2022-08-26_21-42-37PM_1.log

OPatch detects the Middleware Home as "/u01/install/APPS/fs1/FMW_Home"

Applying interim patch '34330735' to OH '/u01/install/APPS/fs1/FMW_Home/oracle_common'

Verifying environment and performing prerequisite checks...

 

Conflicts/Supersets for each patch are:

Patch : 34330735

 

        Bug Superset of 30368663

        Super set bugs are:

        28368196,  30153175,  22998551,  22660018,  26957170,  29702340,  24335626,  

}29997425,  24913281,  20055551

Interim patch 34330735 is a superset of the patch(es) [  30368663 ] in the Oracle Home

OPatch will roll back the subset patches and apply the given patch.

All checks passed.

Provide your email address to be informed of security issues, install and

initiate Oracle Configuration Manager. Easier for you if you use your My

Oracle Support Email address/User Name.

Visit http://www.oracle.com/support/policies.html for details.

Email address/User Name:

 

You have not provided an email address for notification of security issues.

Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/install/APPS/fs1/FMW_Home/oracle_common')

Is the local system ready for patching? [y|n]

Y

Backing up files...

Rolling back interim patch '30368663' from OH '/u01/install/APPS/fs1/FMW_Home/

oracle_common'

Patching component oracle.jrf.adfrt, 11.1.1.9.0...

RollbackSession removing interim patch '30368663' from inventory

OPatch back to application of the patch '34330735' after auto-rollback.

Patching component oracle.jrf.adfrt, 11.1.1.9.0...

Verifying the update...

Patch 34330735 successfully applied

Log file location: /u01/install/APPS/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/

34330735_Aug_26_2022_21_42_38/apply2022-08-26_21-42-37PM_1.log

OPatch succeeded.


WebTier

[oracle@apps FR_Patch]$ source $FMW_HOME/SetWebtier.env

[oracle@apps FR_Patch]$ echo $ORACLE_HOME

/u01/install/APPS/fs1/FMW_Home/webtier

[oracle@apps patch]$ cd /stage/FMW_WebTier/patch

[oracle@apps patch]$ ls

32928416  33144848  34067016  34251646 32287205

$ $ORACLE_HOME/OPatch/opatch napply

Oracle Home       : /u01/install/APPS/fs1/FMW_Home/webtier

Central Inventory : /u01/install/APPS/oraInventory

   from           : /u01/install/APPS/fs1/FMW_Home/webtier/oraInst.loc

OPatch version    : 11.1.0.12.9

OUI version       : 11.1.0.11.0

Log file location : /u01/install/APPS/fs1/FMW_Home/webtier/cfgtoollogs/opatch/opatch2022-08-29_23-02-49PM_1.log

OPatch detects the Middleware Home as "/u01/install/APPS/fs1/FMW_Home"

Verifying environment and performing prerequisite checks...

Conflicts/Supersets for each patch are:

Patch : 32287205

        Bug Superset of 31304503

        Super set bugs are:

        25205368,  25635149,  23115139,  19697993,  18604692,  25555252,  16354467,  18166013,  26318200,  21656630,  26245237,  17983206,  21063322,  26434300,  25775213,  20856766,  19718981,  20725343,  25288078,  25914276,  20273319,  26243698,  23266217,  22750215,  19891090,  29389063,  25879984,  25760218,  23055182,  31285797,  23140259

Patch : 34067016

        Conflict with 31304503

        Conflict details:

        /u01/install/APPS/fs1/FMW_Home/webtier/lib/libnnz11.so

        /u01/install/APPS/fs1/FMW_Home/webtier/lib/libnnz11.a:/nzos.o

Patch : 34251646

        Bug Superset of 31047338

        Super set bugs are:

        21305938,  26752325,  26101975,  20900385,  26929226,  25191174,  30876572,  26837992,  22218211,  23107407,  24681614,  24567879,  30146419,  19571821,  20580842,  30887923,  20913582,  21520649,  27577851

Patches [   31304503   31047338 ] will be rolled back.

Do you want to proceed? [y|n]

y

User Responded with: Y

OPatch continues with these patches:   32287205  32928416  33144848  34067016  34251646 

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

Provide your email address to be informed of security issues, install and

initiate Oracle Configuration Manager. Easier for you if you use your My

Oracle Support Email address/User Name.

Visit http://www.oracle.com/support/policies.html for details.

Email address/User Name:

You have not provided an email address for notification of security issues.

Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y

 

Backing up files...

Applying interim patch '32287205' to OH '/u01/install/APPS/fs1/FMW_Home/webtier'

ApplySession: Optional component(s) [ oracle.idm.oid, 11.1.1.9.0 ]  not present in the Oracle Home or a higher version is found.

Rolling back interim patch '31304503' from OH '/u01/install/APPS/fs1/FMW_Home/webtier'

Patching component oracle.ldap.rsf, 11.1.1.9.0...

Patching component oracle.rdbms.rsf, 11.1.0.7.0...

RollbackSession removing interim patch '31304503' from inventory

Rolling back interim patch '31047338' from OH '/u01/install/APPS/fs1/FMW_Home/webtier'

Patching component oracle.ohs2, 11.1.1.9.0...

RollbackSession removing interim patch '31047338' from inventory

OPatch back to application of the patch '32287205' after auto-rollback.

Patching component oracle.ldap.rsf, 11.1.1.9.0...

Patching component oracle.rdbms.rsf, 11.1.0.7.0...

Verifying the update...

Applying interim patch '32928416' to OH '/u01/install/APPS/fs1/FMW_Home/webtier'

Patching component oracle.opmn, 11.1.1.9.0...

Verifying the update...

Applying interim patch '33144848' to OH '/u01/install/APPS/fs1/FMW_Home/webtier'

Patching component oracle.wlsplugins, 11.1.1.9.0...

Verifying the update...

Applying interim patch '34067016' to OH '/u01/install/APPS/fs1/FMW_Home/webtier'

ApplySession: Optional component(s) [ oracle.idm.oid, 11.1.1.9.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.ldap.rsf, 11.1.1.9.0...

Patching component oracle.rdbms.rsf, 11.1.0.7.0...

Verifying the update...

Applying interim patch '34251646' to OH '/u01/install/APPS/fs1/FMW_Home/webtier'

Patching component oracle.ohs2, 11.1.1.9.0...

Verifying the update...

Patches 32287205,32928416,33144848,34067016,34251646 successfully applied.

OPatch Session completed with warnings.

Log file location: /u01/install/APPS/fs1/FMW_Home/webtier/cfgtoollogs/opatch/opatch2022-08-29_23-02-49PM_1.log

OPatch completed with warnings.

Si vemos warning se refieren a los rollback que se realizaron, por lo cual es aceptable.



WEBLOGIC

En este punto tomar en cuenta que por lo gral hay que hacer un rollback de varios parches y es normal

[WARNING] Patch 32746843 SU Patch [AXXI]: WLS PSU 10.3.6.0.210420 is missing.

     Filename:  p32746843_R12_GENERIC.zip

  $ . $FMW_HOME/wlserver_10.3/server/bin/setWLSEnv.sh

  $ java weblogic.version

WebLogic Server Temporary Patch for BUG13845626 Wed Oct 07 21:29:29 PDT 2020

WebLogic Server 10.3.6.0.201020 PSU Patch for BUG31641257 Tue Sep 29 15:19:33 UTC 2020

WebLogic Server Temporary Patch for BUG13964737 Fri Dec 20 11:32:08 IST 2013

WebLogic Server Temporary Patch for BUG20474010 Sun Mar 01 17:22:18 IST 2015

WebLogic Server Temporary Patch for ${CRS} Mon Jul 30 16:45:20 EDT 2012

WebLogic Server Temporary Patch for ${CRS} Mon Jul 30 16:45:20 EDT 2012

WebLogic Server 10.3.6.0  Tue Nov 15 08:52:36 PST 2011 1441050

export ORACLE_HOME=$FMW_HOME/webtier

export WL_HOME=$FMW_HOME/wlserver_10.3

cd $FMW_HOME/utils/bsu/cache_dir

$ cp /stage/WLS/p32832785_1036_Generic.zip .

[oracle@apps cache_dir]$ unzip p32832785_1036_Generic.zip

Archive:  p32832785_1036_Generic.zip

extracting: 3NVW.jar               

  inflating: patch-catalog_27641.xml 

  inflating: README.html            

  inflating: README.txt  

mv patch-catalog_27641.xml patch-catalog.xml

cd $FMW_HOME/utils/bsu

./bsu.sh -prod_dir=$FMW_HOME/wlserver_10.3 -patchlist=3NVW -verbose -install

remove prev patch for resolve conflict:

Patch GFWX is mutually exclusive and cannot coexist with patch(es): KYRS,NA7A,IHJW

./bsu.sh -prod_dir=$FMW_HOME/wlserver_10.3 -patchlist=KYRS -verbose -remove

./bsu.sh -prod_dir=$FMW_HOME/wlserver_10.3 -patchlist=IHJW -verbose -remove

./bsu.sh -prod_dir=$FMW_HOME/wlserver_10.3 -patchlist=NA7A -verbose -remove

./bsu.sh -prod_dir=$FMW_HOME/wlserver_10.3 -patchlist=3NVW -verbose -install

 

Luego es necesario aplicar los siguientes parches que surgen de la re ejecución del etcc nuevamente.

[oracle@apps 10.3.6.0.210720]$ cd $FMW_HOME/utils/bsu/cache_dir

[oracle@apps cache_dir]$ cp /stage/etcc-bundle/LINUX_X86-64/wls/10.3.6.0.210720/p13845626_10360210720_Generic.zip .

$ cp /stage/etcc-bundle/LINUX_X86-64/wls/10.3.6.0.210720/p13964737_10360210720_Generic.zip .

$ cp /stage/etcc-bundle/LINUX_X86-64/wls/10.3.6.0.210720/p31241365_1036_Linux-x86-64.zip .

$ cp /stage/etcc-bundle/LINUX_X86-64/wls/10.3.6.0.210720/p33560682_1036_Generic.zip .

 

[oracle@apps cache_dir]$ unzip p13845626_10360210720_Generic.zip

Archive:  p13845626_10360210720_Generic.zip

  inflating: patch-catalog_27597.xml

replace README.txt? [y]es, [n]o, [A]ll, [N]one, [r]ename: y

  inflating: README.txt

  inflating: QFQ3.jar

cd $FMW_HOME/utils/bsu

 

./bsu.sh -prod_dir=$FMW_HOME/wlserver_10.3 -patchlist=QFQ3-verbose -install

[oracle@apps cache_dir]$ unzip p13964737_10360210720_Generic.zip

  inflating: README.txt             

  inflating: patch-catalog_27630.xml 

  inflating: UEYM.jar  

./bsu.sh -prod_dir=$FMW_HOME/wlserver_10.3 -patchlist=UEYM -verbose -install

[oracle@apps cache_dir]$ unzip p31241365_1036_Linux-x86-64.zip

Archive:  p31241365_1036_Linux-x86-64.zip

  inflating: CW7X.jar               

  inflating: patch-catalog_27153.xml 

./bsu.sh -prod_dir=$FMW_HOME/wlserver_10.3 -patchlist=CW7X -verbose -install

[oracle@apps cache_dir]$ unzip p33560682_1036_Generic.zip

Archive:  p33560682_1036_Generic.zip

  inflating: 9UNH.jar               

replace README.txt? [y]es, [n]o, [A]ll, [N]one, [r]ename: y

  inflating: README.txt             

  inflating: patch-catalog_27793.xml 

./bsu.sh -prod_dir=$FMW_HOME/wlserver_10.3 -patchlist=DN1F -verbose -remove

./bsu.sh -prod_dir=$FMW_HOME/wlserver_10.3 -patchlist=9UNH -verbose -install



DB:

El ETCC, tambien nos va a recomendar parches de base de datos, los cuales se instalan con opatch como cualquier parche de base de datos.

Me interesaba más que nada mostrarles el mecanismo de ejecución y ejemplos de parches de Aplicación que podemos llegar a encontrarnos.

Si te gusto subscribite al blog por favor.




No hay comentarios.:

Publicar un comentario