Upgrade EBS 12.2.11

Buenas a todos!! Este sería mi primer entrada del 2023 y como ya estamos con la versión 12.2.12 de EBS, me parecio interesante volver un poco para atras y guiarlos en los pasos que se deben tomar en cuenta para el upgrade de 12.2.10 a 12.2.11. (serían los mismos para 12.2.12)

Antes de seguir, me ayudarian si siguen el blog:  SEGUIR !! Gracias

Les dejo los blog de Oracle con los anuncios:

EBS 12.2.11 https://blogs.oracle.com/ebstech/post/oracle-e-business-suite-12211-now-available

EBS 12.2.12 https://blogs.oracle.com/ebstech/post/oracle-e-business-suite-12212-now-available

Notas Importantes:

Oracle E-Business Suite Release 12.2.11 Readme (MOS Note 2758997.1)
After Upgrade Of EBS From 12.2.10 To 12.2.11 PA_PPCC_ECC_PVT Is Invalid (Doc ID 2878294.1)
Oracle E-Business Suite Release 12.2.11 Readme (Doc ID 2758997.1)
Patch 17537119: EBS 12.2 TECHNOLOGY CODELEVEL CHECKER (ETCC)
Oracle E-Business Suite Release 12.2 System Schema Migration (Doc ID 2755875.1)

Pasos Generales:

1. Chequeos de Sanidad , previos a cualquier cambio.
2. Ejecutar ETCC y aplicar los parches
3. Upgrade AD and TXK
4. update Filesystem y appsutil nodo DB
5. Sync FileSystem
6. ValidarADOP
7. Aplicar Parche 12.2.11
8. Aplicar Online Help Patch
9. Migrar objetos sys/system a EBS_SYSTEM (paso importante si nunca se realizo, obligatorio a partir de AD 13)

1) Chequeos 

A que me refiero con este punto?, básicamente antes de tocar cualquier entorno, tenemos que estar seguros que la situación actual de EBS es correcta y funciona en todo sentido, para no encontrarnos con problemas post implementación.

No voy a entrar en detalle en cada uno de estos, se supone que cuentan con conocimientos básicos de Apps DBA EBS.

• Update snapshot
• preclone db
• preclone as
• autoconfig db
• autoconfig as
• reinicio de servicios.
• Validar Objetos descompilados actuales

2) Ejecución ETCC

Para este punto que es bastante largo, arme una entrada distinta. La ejecución del ETCC es standard para cualquier versión de EBS y es mandatoria la ejecución e instalación de Parches que recomienda el etcc.

https://cristianpeque.blogspot.com/2023/01/ejecucion-etcc-para-ebs.html

3) Upgrade AD y TXK

Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1) tomar en cuenta que para 12.2.12 ya esta la versión AD 14. 2.1 Apply Required Database Patches Los parches del punto 2.1 de la nota fueron cumplidos al instalar los parches del ETCC en los pasos previos. Section 3: Apply R12.AD.C.Delta.13 and R12.TXK.C.Delta.13 Release Update Packs Abrimos la nota de la sección 6 y descargamos el último AD and TXK Vamos a omitir el análisis de toda la nota y vamos a los puntos importantes. Download and unzip the following patches into the $PATCH_TOP directory: Patch 32394134 (R12.AD.C.Delta.13) Patch 32392507 (R12.TXK.C.Delta.13) Patch 33441060:R12.AD.C (Additional critical AD patch) Patch 33550674:R12.TXK.C (Additional critical TXK patch) ESTAMOS EN UN ABIENTE LAB, ASI QUE NO ES NECESARIO APLICAR EL PARCHE SOBRE EL PATCH fs, VAMOS DIRECOT AL RUN EDITION.   Desde el NODO o ENv DB. Copiamos el adgrant  cp /u01/install/APPS/fs_ne/EBSapps/patch/33441060/admin/adgrants.sql $ORACLE_HOME/appsutil/admin  $ source $ORACLE_HOME/<CDB_NAME>_<HOSTNAME>.env $ export ORACLE_PDB_SID=<PDB_SID>  [oracle@apps 19.0.0]$ source EBSCDB_apps.env [oracle@apps 19.0.0]$ export ORACLE_PDB_SID=EBSDB  $ sqlplus /nolog SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql apps  Change password [oracle@apps 19.0.0]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 27 01:48:45 2022 Version 19.9.0.0.0 Copyright (c) 1982, 2020, Oracle.  All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.0.0.0 SQL> ALTER USER EBS_SYSTEM ACCOUNT UNLOCK; User altered. SQL> ALTER USER EBS_SYSTEM IDENTIFIED BY manager; User altered. Validar Schema desde AS Environment $ perl $PATCH_TOP/32394134/ad/bin/adValidateEbssystemSchema.pl Aplicar Parche AD Delta 13 Copiamos los parches al $PATCH_TOP adop phase=apply patches=32394134,33441060 hotpatch=yes merge=yes . . . Running finalize actions for the patches being applied.     Log: @ADZDSHOWLOG.sql "2022/08/27 02:28:45"   Running cutover actions for the patches being applied.     Creating workers to process cutover DDL in parallel     Log: /u01/install/APPS/fs_ne/EBSapps/log/adop/36/20220827_015243/apply/apps/log/ cutover.log     Performing database cutover in Quick mode Generating post apply reports. Generating log report.     Output: /u01/install/APPS/fs_ne/EBSapps/log/adop/36/20220827_015243/apply /apps/adzdshowlog.out The apply phase completed successfully. adop exiting with status = 0 (Success) As per 4.1 Critical AD Patches, apply any applicable AD patches $ adop phase=apply patches=33862025 hotpatch=yes On the run edition application tier file system, use adop hotpatch mode to apply Patch 32392507 (R12.TXK.C.Delta.13 + critical adop phase=apply patches=32392507,33550674,34207577,33535778 hotpatch=yes  merge=yes As per 4.2 Critical TXK Patches, y Update your database tier with the latest patches.  ·  Run the admkappsutil.pl utility to create the appsutil.zip file in <INST_TOP>/admin/out. $ perl $AD_TOP/bin/admkappsutil.pl

Update DB Node y Sync Filesystem

On the application tier (as the applmgr user):      Source the run edition file system environment file.      UNIX:     $ . <EBS_ROOT>/EBSapps.env run     Run the admkappsutil.pl utility to create the appsutil.zip file in <INST_TOP>/admin/out.      $ perl <AD_TOP>/bin/admkappsutil.pl  On the database tier (as the oracle user):      Source the environment for the <RDBMS ORACLE_HOME>.     UNIX:     $ cd <RDBMS ORACLE_HOME>     $ . ./<RDBMS ORACLE_HOME>/<CONTEXT_NAME>.env     Change directory to the <RDBMS ORACLE_HOME> and uncompress appsutil.zip. $ cp /u01/install/APPS/fs1/inst/apps/EBSDB_apps/admin/out/appsutil.zip $ORACLE_HOME     $ cd $ORACLE_HOME     $ unzip -o appsutil.zip Run AutoConfig on the <RDBMS ORACLE_HOME>.     Note: For Oracle RAC systems, the steps in this section need to be run on each Oracle RAC node. For more details, refer to Oracle E-Business Suite Setup Guide, Release 12.2.     UNIX:     $ sh $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adautocfg.sh Run AutoConfig on the run edition file system. Note: Before running AutoConfig, if you are using the AutoConfig Customizations feature you must merge any customizations with the AutoConfig templates provided in the AD-TXK Delta 13 RUPs. As the applmgr user, run AutoConfig on all application tier nodes by running the appropriate command for your system: UNIX: $ sh $INST_TOP/admin/scripts/adautocfg.sh Synchronize the file systems. This action copies the new run edition code and configuration to the other file system. After you apply AD-TXK Delta 13, you should run fs_clone to synchronize the run and patch file systems with the configuration changes that the new codelevel introduces. If you do not run fs_clone, it will run automatically in the next prepare phase, which will consequently take more time. $ adop phase=fs_clone

6. Validar Cyclo de ADOP

Es importante que el ciclo de adop este cerrado antes de comenzar. Caso contrario cerrarlo o resolver los parches pendientes.

Validate the environment for path $ adop -validate  adop exiting with status = 0 (Success)

7. Aplicar Parche 12.2.11

Start an online patching cycle. $ adop phase=prepare Running this   adnodemgrctl.sh: check the logfile /u01/oracle/EBS1228/fs2/inst/apps/EBS1228_laborasrv1036/logs/appl/admin/log/adnodemgrctl.txt for more information ...    The prepare phase completed successfully.   adop exiting with status = 0 (Success)

Me encontre algunos errores. ORA-06512: at "APPS.AD_ZD_ADOP", line 274 ORA-06512: at line 4 (DBD ERROR: OCIStmtExecute) Reference of statement-handler is valid, not attempting database reconnect. Failed to execute SQL statement: declare ret_value number; begin ret_value:= AD_ZD_ADOP.WAIT_FOR_CP_TO_RUN(7746942); end;   uring the Prepare Phase the ADZDPATCH Concurrent Program Fails With AD_ZD_ADOP.WAIT_FOR_CP_TO_RUN and Internal Manager Log Shows Routine AFPCAL Received Failure Code While Parsing or Running Your Concurrent Program CPMGR (Doc ID 2334520.1)

run adadmin .  Java was not working so implemented jar signing again; regenerated jar files; and forms were accessible. Note: Please contact the Java team if assistance is needed. 2.  Recompile the APPS schema using adadmin. a. Open the adadmin application on the applications tier. b. Provide the "SYSTEM" schema password in the prompt. c. Provide the "APPS" schema password in the prompt. d. After login, select option 3 "Compile/Reload Applications Database Entities menu". e. Select option 1 from the menu that reads "Compile APPS schema". 3. Recreate grants/synonyms using adadmin. a. Open the Main AD Administration menu. b. Go to the Maintain Applications Database Entities menu. c. Select the "Recreate grants and synonyms for APPS schema" task. d. Exit the adadmin application. 4. Run the following to identify any invalid objects: SQL> select OBJECT_NAME,OWNER,CREATED,LAST_DDL_TIME,OBJECT_TYPE from dba_objects where status='INVALID' and owner like 'APPS' order by OBJECT_TYPE; 5. Recompile all invalid objects.

Start an online patching cycle. $ adop phase=prepare Running this

Apply Oracle E-Business Suite Release 12.2.11 Patch 31856789. UNIX: $ adop phase=apply patches=31856789 patchtop="/stage/12211patch"     El punto que más demora y puede estimar el tiempo que puede demorar esto: El proceso se quedo en este status por bastante tiempo, sin procesos en la DB. Procedi a quitar el Works Inicimos la herramienta adctrl Lo vuelvo a iniciar  adop phase=apply patches=31856789 patchtop="/stage/12211patch" restart=yes Hasta aca: 5hs Es necesario Volver a ejecutar el adctrl y marcar el workers como fixeado

Finalizar el Ciclo de ADOP:

$ adop phase=finalize
$ adop phase=cutover
$ adop phase=cleanup
$ adop phase=fs_clone

nota: Esta última tarea demora varias horas.

8. Parche Online Help 12.2.11

·  Apply Oracle E-Business Suite Release 12.2.11 Online Help Using adop hotpatch mode on the run file system, apply Oracle E-Business Suite Release 12.2.11  Online Help Patch 31856799. $ adop phase=apply patches=31856799 hotpatch=yes patchtop="/stage"

Quedaron algunos objetos descompilados que se compilo siguiendo la siguiente nota:

How To Compile Oracle Fast Formulas? (Doc ID 155737.1)

9. Migrate sys/system objects.

En este paso les voy a dejar la nota, luego voy a crear otro post. A partir de la versión de AD 13, Oracle movio todos los objetos que usaba EBS de los schemas sys y system a un nuevo schema llamado EBS_SYSTEM, a nivel seguridad esto es un cambio muy importante.

En laboratorios nunca tuve problemas en ejecutarlo porque son todos objetos standards, hay que hacer un doble check en caso de tener muchos objetos custom, pero en los mismos procedimientos se los puede ir listando.

Nota:

Oracle E-Business Suite Release 12.2 System Schema Migration (Doc ID 2755875.1) 

Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (Doc ID 1577661.1)

Espero que les sirva el post, para entender los pasos grales de una migración de EBS (realmente es aplicar un parche).  Si les gusto por favor los invito a subscribirse:

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.