Visit Counter

Tuesday, November 10, 2020

Upgrade Oracle ERP 12.2.0 To 12.2.5

 

Env:  Oracle Linux 6    DB:  12.1.0   EBS: 12.2.0

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

1. Download Required Patches

2. 









Download Patches  and move to below directory and unzip all.

p17204589_12.2.0_R12_GENERIC.zip

p17537119_R12_GENERIC.zip

p21900871_12.2.0_R12_GENERIC.zip

[applmgr@oraebs12 patch]$  cd /u01/oracle/PROD/fs_ne/EBSapps/patch

[applmgr@oraebs12 patch]$ ls

17204589  checkDBpatch.cmd  checkMTpatch.cmd  db  p17204589_12.2.0_R12_GENERIC.zip  p21900871_12.2.0_R12_GENERIC.zip

21900871  checkDBpatch.sh   checkMTpatch.sh   mw  p17537119_R12_GENERIC.zip         README.txt

[applmgr@oraebs12 patch]$ unzip p17204589_12.2.0_R12_GENERIC.zip

[applmgr@oraebs12 patch]$ unzip p17537119_R12_GENERIC.zip

[applmgr@oraebs12 patch]$ unzip p21900871_12.2.0_R12_GENERIC.zip

[applmgr@oraebs12 appl]$ cd /u01/oracle/PROD/fs1/EBSapps/appl

[applmgr@oraebs12 appl]$ . ./APPSPROD_oraebs12.env run

[applmgr@oraebs12 appl]$ cd $ADMIN_SCRIPTS_HOME

[applmgr@oraebs12 scripts]$ ./adadminsrvctl.sh status

You are running adadminsrvctl.sh version 120.10.12020000.2

Enter the WebLogic Admin password:

Enter the APPS Schema password:

 The AdminServer is running

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/oracle/PROD/fs1/inst/apps/PROD_oraebs12/logs/appl/admin/log/adadminsrvctl.txt for more information ...

 

Step1A:(75 Mins) Apply Consolidated seed table upgrade Patch on run file sysetm patch 17204589

[applmgr@oraebs12 scripts]$ adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes

Enter the APPS password:

Enter the SYSTEM password:

Enter the WLSADMIN password:

 Please wait. Validating credentials...

Enter the RUN file system context file name [/u01/oracle/PROD/fs1/inst/apps/PROD_oraebs12/appl/admin/PROD_oraebs12.xml]:    (Press Enter)

 

[STATEMENT] [END   2020/11/06 20:26:02] Performing verification of parameters

[STATEMENT] [START 2020/11/06 20:26:02] Checking for the required ENV setup

[STATEMENT] [END   2020/11/06 20:26:02] Checking for the required ENV setup

 

************* Start of  session *************

 version: 12.2.0

 started at: Fri Nov 06 2020 20:26:02

 

APPL_TOP is set to /u01/oracle/PROD/fs1/EBSapps/appl

[STATEMENT] [START 2020/11/06 20:26:03] Determining admin node

[STATEMENT] [END   2020/11/06 20:26:05] Determining admin node

[STATEMENT]  Recommended Worker Count:  1 Max Allowed Workers: 10

[STATEMENT] [START 2020/11/06 20:26:09] Acquiring lock on sessions table

[STATEMENT] [END   2020/11/06 20:26:10] Acquiring lock on sessions table

[STATEMENT] [START 2020/11/06 20:26:10] Checking for any pending sessions

[STATEMENT] [START 2020/11/06 20:26:14] Staging the current session

  [STATEMENT] [START 2020/11/06 20:26:18] Checking if node "oraebs12" is abandoned

  [STATEMENT] [END   2020/11/06 20:26:20] Checking if node "oraebs12" is abandoned

[STATEMENT] [END   2020/11/06 20:26:22] Staging the current session

[STATEMENT] [START 2020/11/06 20:26:24] Unlocking sessions table

[STATEMENT] [END   2020/11/06 20:26:25] Unlocking sessions table

[STATEMENT] [START 2020/11/06 20:26:25] adzdoptl.pl run

  [STATEMENT] Session ID: 2

  [STATEMENT] Phase: apply

  [STATEMENT] Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/adop_20201106_182842.log

  [STATEMENT] [START 2020/11/06 20:26:35] Invoking admerge

    [STATEMENT] [START 2020/11/06 20:26:37] Running AD Merge Normal Mode

      [STATEMENT] Calling: /u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/admerge.pl

 

      [STATEMENT] Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201106_182842/PROD_oraebs12/admrgpch.log

 

    [STATEMENT] [END   2020/11/06 20:26:37] Running AD Merge Normal Mode

    [STATEMENT] [START 2020/11/06 20:26:37] Running AD Merge in AD Mode

      [STATEMENT] Calling: /u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/admerge.pl

 

      [STATEMENT] Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201106_182842/PROD_oraebs12/admrgpch.log -console off

 

 

Executing the merge of the patch drivers

 -- Processing patch: /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20201106_1604679996/src/17204589

 -- Processing file: /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20201106_1604679996/src/17204589/u17204589.drv

 -- Done processing patch: /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20201106_1604679996/src/17204589

 

 -- Processing patch: /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20201106_1604679996/src/21900871

 -- Processing file: /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20201106_1604679996/src/21900871/u21900871.drv

 -- Done processing patch: /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20201106_1604679996/src/21900871

 

 

 

Copying files...

 

100% complete. Copied 0 files of 0...

 

Character-set converting files...

 

  0 unified drivers merged.

 

Patch merge completed successfully

 

Please check the log file at /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201106_182842/PROD_oraebs12/admrgpch.log.

    [STATEMENT] [END   2020/11/06 20:26:37] Running AD Merge in AD Mode

  [STATEMENT] [END   2020/11/06 20:26:38] Invoking admerge

  [STATEMENT] [START 2020/11/06 20:26:39] apply phase

    [STATEMENT] APPLY Phase START TIME: 06-11-2020 20:26:40

    [STATEMENT] [START 2020/11/06 20:26:42] Performing Check for Logon Trigger existence and enablement

    [STATEMENT] [END   2020/11/06 20:26:45] Performing Check for Logon Trigger existence and enablement

sh: module: line 1: syntax error: unexpected end of file

sh: error importing function definition for `module'

    [STATEMENT] [Start 2020/11/06 20:26:49] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop

      [STATEMENT] Reading defaults file /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt

      [STATEMENT] Substituting tokens ...

      [STATEMENT] Regenerating defaults file ...

    [STATEMENT] [End   2020/11/06 20:26:49] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop

    [STATEMENT] Calling: adpatch  workers=1    options=hotpatch    flags=autoskip   console=no interactive=no  defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20201106_1604679996 driver=u_20201106_1604679996.drv logfile=u_20201106_1604679996.log

    [STATEMENT] ADPATCH Log directory: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201106_182842/PROD_oraebs12/ADOP_MRG_20201106_1604679996/log

    [STATEMENT] Running: adpatch  workers=1    options=hotpatch    flags=autoskip   console=no interactive=no  defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20201106_1604679996 driver=u_20201106_1604679996.drv logfile=u_20201106_1604679996.log stdin=yes

sh: module: line 1: syntax error: unexpected end of file

sh: error importing function definition for `module'

 

Successfully created out directory

    [STATEMENT] [START 2020/11/06 21:57:45] Running finalize since in hotpatch mode

    [STATEMENT] [END   2020/11/06 22:01:00] Running finalize since in hotpatch mode

    [STATEMENT] [START 2020/11/06 22:01:01] Performing Automatic DB cutover

      [STATEMENT] [Start 2020/11/06 22:01:04] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop

        [STATEMENT] Reading defaults file /u01/oracle/PROD/fs2/EBSapps/appl/admin/PROD_patch/adalldefaults.txt

        [STATEMENT] Substituting tokens ...

        [STATEMENT] Regenerating defaults file ...

      [STATEMENT] [End   2020/11/06 22:01:05] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop

      [STATEMENT] Calling: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=1 restart=no abandon=yes defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cutover.log driver=ucutover.drv

      [STATEMENT] ADPATCH Log directory: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201106_182842/PROD_oraebs12/log

      [STATEMENT] Running: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=1 restart=no abandon=yes defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cutover.log driver=ucutover.drv stdin=yes

sh: module: line 1: syntax error: unexpected end of file

sh: error importing function definition for `module'

 

Successfully created out directory

    [STATEMENT] [END   2020/11/06 22:02:34] Performing Automatic DB cutover

    [STATEMENT] [START 2020/11/06 22:02:36] Running cutover since in hotpatch mode

    [STATEMENT] [END   2020/11/06 22:02:39] Running cutover since in hotpatch mode

    [STATEMENT] [START 2020/11/06 22:02:40] Compiling Invalid Objects

    [STATEMENT] [END   2020/11/06 22:02:48] Compiling Invalid Objects

sh: module: line 1: syntax error: unexpected end of file

sh: error importing function definition for `module'

  [STATEMENT] [END   2020/11/06 22:02:52] apply phase

  [STATEMENT] [START 2020/11/06 22:02:53] Generating Post Apply Reports

    [STATEMENT] APPLY Phase END TIME: 06-11-2020 22:02:54

      [STATEMENT] [START 2020/11/06 22:02:56] Generating Report to spool all logs from ad_zd_logs

        [STATEMENT] Report: /u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql

        [STATEMENT] Output: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201106_182842/PROD_oraebs12/adzdshowlog.out

      [STATEMENT] [END   2020/11/06 22:03:01] Generating Report to spool all logs from ad_zd_logs

  [STATEMENT] [END   2020/11/06 22:03:03] Generating Post Apply Reports

[STATEMENT] [END   2020/11/06 22:03:07] adzdoptl.pl run

[STATEMENT] adop phase=apply - Completed Successfully

 

[STATEMENT] Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/adop_20201106_182842.log

 

adop exiting with status = 0 (Success)

[applmgr@oraebs12 scripts]$

 

 

 

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

 

[oracle@oraebs12 OPatch]$ pwd

/u01/oracle/PROD/12.1.0/OPatch

[oracle@oraebs12 OPatch]$ ls

checkDBpatch.cmd  emdpatch.pl     opatchdiag        oracle_common

checkDBpatch.sh   jlib            opatchdiag.bat    p17537119_R12_GENERIC.zip

checkMTpatch.cmd  mw              opatch.pl         patch

checkMTpatch.sh   ocm             opatchprereqs     README.txt

datapatch         opatch          operr             scripts

datapatch.bat     opatchauto      operr.bat         version.txt

db                opatchauto-dir  operr_readme.txt

docs              opatch.bat      oplan

[oracle@oraebs12 OPatch]$ ./checkDBpatch.sh

 

 +===============================================================+

 |    Copyright (c) 2005, 2020 Oracle and/or its affiliates.     |

 |                     All rights reserved.                      |

 |             Oracle E-Business Suite Release 12.2              |

 |          Database EBS Technology Codelevel Checker            |

 +===============================================================+

 

Validating context file: /u01/oracle/PROD/12.1.0/appsutil/PROD_oraebs12.xml

 

Using context file from currently set database environment:

/u01/oracle/PROD/12.1.0/appsutil/PROD_oraebs12.xml

Starting Database EBS Technology Codelevel Checker, Version 120.81

Fri Nov  6 23:26:21 +04 2020

Log file for this session : /u01/oracle/PROD/12.1.0/OPatch/log/checkDBpatch_17603.log

Identifying database release.

Database release set to 12.1.0.2.

Connecting to database.

Database connection successful.

Database PROD is in READ WRITE mode.

Identifying APPS and APPLSYS schema names.

 - APPS schema : APPS

 - APPLSYS schema : APPLSYS

Checking for DB-ETCC results table.

Table to store DB-ETCC results already exists in the database.

Checking if InMemory option is enabled.

InMemory option is not enabled in the database.

Bugfix file ./db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.56

This file will be used for identifying missing bugfixes.

Mapping file ./db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.31

This file will be used for mapping bugfixes to patches.

[WARNING] DB-ETCC: Bugfix XML file (./db/onprem/txk_R1220_DB_base_bugs.xml) is more than 30 days old.

 Check if a newer version is available in patch 17537119.

Identified RDBMS DST version 18.

Checking Bugfix XML file for 12.1.0.2

Obtained list of bugfixes to be applied and the list to be rolled back.

Now checking Database ORACLE_HOME.

The opatch utility is version 12.1.0.1.10.

DB-ETCC is compatible with this opatch version.

Found patch records in the inventory.

Checking Mapping XML file for 12.1.0.2

  Missing Bugfix: 8975044  ->  Patch 8975044

  Missing Bugfix: 14666816  ->  Patch 27264965

  Missing Bugfix: 18793246  ->  Patch 18793246

  Missing Bugfix: 18881811  ->  Patch 25599890

  Missing Bugfix: 19068380  ->  Patch 19068380

  Missing Bugfix: 19239846  ->  Patch 30092105

  Missing Bugfix: 19509982  ->  Patch 29748518

  Missing Bugfix: 19591608  ->  Patch 19591608

  Missing Bugfix: 20627866  ->  Patch 30092105

  Missing Bugfix: 20766180  ->  Patch 20766180

  Missing Bugfix: 20868862  ->  Patch 27264965

  Missing Bugfix: 21028698  ->  Patch 22098146

  Missing Bugfix: 21106027  ->  Patch 30092105

  Missing Bugfix: 21321429  ->  Patch 21321429

  Missing Bugfix: 21387964  ->  Patch 30092105

  Missing Bugfix: 21614112  ->  Patch 29748518

  Missing Bugfix: 21751519  ->  Patch 27264965

  Missing Bugfix: 21813400  ->  Patch 30092105

  Missing Bugfix: 21864513  ->  Patch 21864513

  Missing Bugfix: 21904072  ->  Patch 21904072

  Missing Bugfix: 21967332  ->  Patch 21967332

  Missing Bugfix: 22024071  ->  Patch 30092105

  Missing Bugfix: 22229581  ->  Patch 27264965

  Missing Bugfix: 22452653  ->  Patch 27264965

  Missing Bugfix: 22496904  ->  Patch 22496904

  Missing Bugfix: 22568797  ->  Patch 30092105

  Missing Bugfix: 22660003  ->  Patch 29748518

  Missing Bugfix: 22666802  ->  Patch 30092105

  Missing Bugfix: 22731026  ->  Patch 25599890

  Missing Bugfix: 22737974  ->  Patch 27264965

  Missing Bugfix: 23089357  ->  Patch 23089357

  Missing Bugfix: 23125826  ->  Patch 23125826

  Missing Bugfix: 23220453  ->  Patch 30092105

  Missing Bugfix: 23604553  ->  Patch 27264965

  Missing Bugfix: 23632545  ->  Patch 30092105

  Missing Bugfix: 23645516  ->  Patch 30092105

  Missing Bugfix: 24326444  ->  Patch 30092105

  Missing Bugfix: 24385983  ->  Patch 30092105

  Missing Bugfix: 24560906  ->  Patch 24560906

  Missing Bugfix: 24589081  ->  Patch 30092105

  Missing Bugfix: 25099339  ->  Patch 30092105

  Missing Bugfix: 25139545  ->  Patch 27264965

  Missing Bugfix: 25305405  ->  Patch 25305405

  Missing Bugfix: 25643931  ->  Patch 25643931

  Missing Bugfix: 25906117  ->  Patch 25906117

  Missing Bugfix: 25971286  ->  Patch 30092105

  Missing Bugfix: 26336977  ->  Patch 30092105

  Missing Bugfix: 26654363  ->  Patch 30092105

  Missing Bugfix: 26658759  ->  Patch 30092105

  Missing Bugfix: 26742604  ->  Patch 27264965

  Missing Bugfix: 26798411  ->  Patch 30092105

  Missing Bugfix: 27929509  ->  Patch 30092105

  Missing Bugfix: 27997875  ->  Patch 30092105

  Missing Bugfix: 28507324  ->  Patch 28653113

  Missing Bugfix: 28542455  ->  Patch 29842421

  Missing Bugfix: 29125374  ->  Patch 29748518

  Missing Bugfix: 30758943  ->  Patch 30758943

 

Generating Patch Recommendation Summary.

 

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

PATCH RECOMMENDATION SUMMARY

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

The default patch recommendations to install these missing bugfixes are:

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

Oracle Database Release 12.1.0.2  (No PSU applied)

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

  Patch 8975044

    - Filename: p8975044_121020_Linux-x86-64.zip

 

  Patch 27264965

    - Filename: p27264965_121020_Linux-x86-64.zip

 

  Patch 18793246

    - Filename: p18793246_121020_Generic.zip

 

  Patch 25599890

    - Filename: p25599890_121020_Generic.zip

 

  Patch 19068380

    - Filename: p19068380_121020_Linux-x86-64.zip

 

  Patch 30092105

    - Filename: p30092105_121020_Linux-x86-64.zip

 

  Patch 29748518

    - Filename: p29748518_121020_Linux-x86-64.zip

 

  Patch 19591608

    - Filename: p19591608_121020_Linux-x86-64.zip

 

  Patch 20766180

    - Filename: p20766180_121020_Generic.zip

 

  Patch 22098146

    - Filename: p22098146_121020_Linux-x86-64.zip

 

  Patch 21321429

    - Filename: p21321429_121020_Generic.zip

 

  Patch 21864513

    - Filename: p21864513_121020_Linux-x86-64.zip

 

  Patch 21904072

    - Filename: p21904072_121020_Linux-x86-64.zip

 

  Patch 21967332

    - Filename: p21967332_121020_Linux-x86-64.zip

 

  Patch 22496904

    - Filename: p22496904_121020_Linux-x86-64.zip

 

  Patch 23089357

    - Filename: p23089357_121020_Linux-x86-64.zip

 

  Patch 23125826

    - Filename: p23125826_121020_Linux-x86-64.zip

 

  Patch 24560906

    - Filename: p24560906_121020_Linux-x86-64.zip

 

  Patch 25305405

    - Filename: p25305405_121020_Linux-x86-64.zip

 

  Patch 25643931

    - Filename: p25643931_121020_Linux-x86-64.zip

 

  Patch 25906117

    - Filename: p25906117_121020_Linux-x86-64.zip

 

  Patch 28653113

    - Filename: p28653113_121020_Generic.zip

 

  Patch 29842421

    - Filename: p29842421_121020_Linux-x86-64.zip

 

  Patch 30758943

    - Filename: p30758943_121020_Linux-x86-64.zip

 

 

Apply the required patches and rerun this script

 

You should check the patch READMEs for minimum opatch version requirements.

The latest opatch is available from My Oracle Support via Patch 6880880.

 

 

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

A consolidated zip file with the required patches for Database release

12.1.0.2.0 is available on My Oracle Support via:

 

  Patch 31381618 [12.1.0.2.0 version]

    - EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR JUL 2020

 

Note: This zip does not include database Release Updates, bundles or PSUs.

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

 

See Doc ID 1594274.1 for any special instructions for these patches.

Note: Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.

 

Stored Technology Codelevel Checker results in the database PROD successfully.

 

Finished checking fixes for Oracle Database: Fri Nov  6 23:26:50 +04 2020

 

Log file for this session: /u01/oracle/PROD/12.1.0/OPatch/log/checkDBpatch_17603.log

 

[oracle@oraebs12 OPatch]$

 

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

INSTALLING ORACLE DB PATCHES (Download All Required Patches & Unzip all)  "Shutdown Database"

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

[oracle@oraebs12 19591608]$ pwd

/u01/oracle/PROD/12.1.0/OPatch/patchdb/19591608

[oracle@oraebs12 19591608]$ cd ..

[oracle@oraebs12 patchdb]$ ls

18793246  27264965                           p23089357_121020_Linux-x86-64.zip

19068380  28653113                           p23125826_121020_Linux-x86-64.zip

19591608  29748518                           p24560906_121020_Linux-x86-64.zip

20766180  29842421                           p25305405_121020_Linux-x86-64.zip

21321429  30092105                           p25599890_121020_Generic.zip

21864513  30758943                           p25643931_121020_Linux-x86-64.zip

21904072  8975044                            p25906117_121020_Linux-x86-64.zip

21967332  p18793246_121020_Generic.zip       p27264965_121020_Linux-x86-64.zip

22098146  p19068380_121020_Linux-x86-64.zip  p28653113_121020_Generic.zip

22496904  p19591608_121020_Linux-x86-64.zip  p29748518_121020_Linux-x86-64.zip

23089357  p20766180_121020_Generic.zip       p29842421_121020_Linux-x86-64.zip

23125826  p21321429_121020_Generic.zip       p30092105_121020_Linux-x86-64.zip

24560906  p21864513_121020_Linux-x86-64.zip  p30758943_121020_Linux-x86-64.zip

25305405  p21904072_121020_Linux-x86-64.zip  p8975044_121020_Linux-x86-64.zip

25599890  p21967332_121020_Linux-x86-64.zip  PatchSearch.xml

25643931  p22098146_121020_Linux-x86-64.zip

25906117  p22496904_121020_Linux-x86-64.zip

[oracle@oraebs12 patchdb]$ cd 18793246/

[oracle@oraebs12 18793246]$ ls

etc  files  README.txt

[oracle@oraebs12 18793246]$ opatch apply

Oracle Interim Patch Installer version 12.1.0.1.10

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

Oracle Home       : /u01/oracle/PROD/12.1.0

Central Inventory : /u01/oracle/oraInventory

   from           : /u01/oracle/PROD/12.1.0/oraInst.loc

OPatch version    : 12.1.0.1.10

OUI version       : 12.1.0.2.0

Log file location : /u01/oracle/PROD/12.1.0/cfgtoollogs/opatch/18793246_Nov_07_2020_17_26_13/apply2020-11-07_17-26-13PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   18793246

 

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 '18793246' to OH '/u01/oracle/PROD/12.1.0'

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patch 18793246 successfully applied.

Log file location: /u01/oracle/PROD/12.1.0/cfgtoollogs/opatch/18793246_Nov_07_2020_17_26_13/apply2020-11-07_17-26-13PM_1.log

OPatch succeeded.

[oracle@oraebs12 OPatch]$

[oracle@oraebs12 OPatch]$ opatch apply -force /u01/oracle/PROD/12.1.0/OPatch/patchdb/21967332   ( Used -force option if patch have conflicts with other patch) : [   18893947   21967332 ]

 

Oracle Interim Patch Installer version 12.1.0.1.10

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

 

 

Oracle Home       : /u01/oracle/PROD/12.1.0

Central Inventory : /u01/oracle/oraInventory

   from           : /u01/oracle/PROD/12.1.0/oraInst.loc

OPatch version    : 12.1.0.1.10

OUI version       : 12.1.0.2.0

Log file location : /u01/oracle/PROD/12.1.0/cfgtoollogs/opatch/opatch2020-11-08_16-57-54PM_1.log

 

Verifying environment and performing prerequisite checks...

 

Conflicts/Supersets for each patch are:

 

Patch : 21967332

 

        Conflict with 18893947

        Conflict details:

        /u01/oracle/PROD/12.1.0/lib/libgeneric12.a:qcdo.o

 

 

Following patches have conflicts: [   18893947   21967332 ]

Refer to My Oracle Support Note 1299688.1 for instructions on resolving patch conflicts.

Do you want to proceed? [y|n]

y

User Responded with: Y

OPatch continues with these patches:   21967332

 

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

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

(Oracle Home = '/u01/oracle/PROD/12.1.0')

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

y

User Responded with: Y

Backing up files...

Applying interim patch '21967332' to OH '/u01/oracle/PROD/12.1.0'

Rolling back interim patch '18893947' from OH '/u01/oracle/PROD/12.1.0'

 

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

 

Patching component oracle.rdbms, 12.1.0.2.0...

RollbackSession removing interim patch '18893947' from inventory

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

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patch 21967332 successfully applied.

N-Apply process is complete. Bugs [ 18893947  ] are lost. Please verify and re-run.

OPatch Session completed with warnings.

Log file location: /u01/oracle/PROD/12.1.0/cfgtoollogs/opatch/opatch2020-11-08_16-57-54PM_1.log

 

OPatch completed with warnings.

[oracle@oraebs12 OPatch]$

 

[oracle@oraebs12 1patch]$ ./checkDBpatch.sh

 +===============================================================+

 |    Copyright (c) 2005, 2020 Oracle and/or its affiliates.     |

 |                     All rights reserved.                      |

 |             Oracle E-Business Suite Release 12.2              |

 |          Database EBS Technology Codelevel Checker            |

 +===============================================================+

Validating context file: /u01/oracle/PROD/12.1.0/appsutil/PROD_oraebs12.xml

Using context file from currently set database environment:

/u01/oracle/PROD/12.1.0/appsutil/PROD_oraebs12.xml

Starting Database EBS Technology Codelevel Checker, Version 120.81

Sun Nov  8 17:12:41 +04 2020

Log file for this session : /u01/oracle/PROD/12.1.0/1patch/log/checkDBpatch_19422.log

Identifying database release.

Database release set to 12.1.0.2.

Connecting to database.

Database connection successful.

Database PROD is in READ WRITE mode.

Identifying APPS and APPLSYS schema names.

 - APPS schema : APPS

 - APPLSYS schema : APPLSYS

Checking for DB-ETCC results table.

Table to store DB-ETCC results already exists in the database.

Checking if InMemory option is enabled.

InMemory option is not enabled in the database.

Bugfix file ./db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.56

This file will be used for identifying missing bugfixes.

Mapping file ./db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.31

This file will be used for mapping bugfixes to patches.

[WARNING] DB-ETCC: Bugfix XML file (./db/onprem/txk_R1220_DB_base_bugs.xml) is more than 30 days old.

 Check if a newer version is available in patch 17537119.

Identified RDBMS DST version 18.

Checking Bugfix XML file for 12.1.0.2

Obtained list of bugfixes to be applied and the list to be rolled back.

Now checking Database ORACLE_HOME.

The opatch utility is version 12.1.0.1.10.

DB-ETCC is compatible with this opatch version.

Found patch records in the inventory.

Checking Mapping XML file for 12.1.0.2

  Missing Bugfix: 18607546  ->  Patch 18607546

Generating Patch Recommendation Summary.

 

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

PATCH RECOMMENDATION SUMMARY

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

The default patch recommendations to install these missing bugfixes are:

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

Oracle Database Release 12.1.0.2  (No PSU applied)

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

  Patch 18607546

 - Filename: p18607546_121020_Linux-x86-64.zip

Apply the required patches and rerun this script

You should check the patch READMEs for minimum opatch version requirements.

The latest opatch is available from My Oracle Support via Patch 6880880.

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

A consolidated zip file with the required patches for Database release

12.1.0.2.0 is available on My Oracle Support via:

  Patch 31381618 [12.1.0.2.0 version]

    - EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR JUL 2020

Note: This zip does not include database Release Updates, bundles or PSUs.

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

See Doc ID 1594274.1 for any special instructions for these patches.

Note: Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.

Stored Technology Codelevel Checker results in the database PROD successfully.

Finished checking fixes for Oracle Database: Sun Nov  8 17:13:05 +04 2020

Log file for this session: /u01/oracle/PROD/12.1.0/1patch/log/checkDBpatch_19422.log

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

Oracle EBS APPLICATION PATCHES Information

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

[applmgr@oraebs12 patch]$ ./checkMTpatch.sh

 

 +===============================================================+

 |    Copyright (c) 2005, 2020 Oracle and/or its affiliates.     |

 |                     All rights reserved.                      |

 |             Oracle E-Business Suite Release 12.2              |

 |        Application Tier Technology Codelevel Checker         |

 +===============================================================+

 

Using context file from currently set applications environment:

/u01/oracle/PROD/fs1/inst/apps/PROD_oraebs12/appl/admin/PROD_oraebs12.xml

 

Starting Application Tier Technology Codelevel Checker

Version: 120.0.12020000.42.

Sun Nov  8 17:19:04 +04 2020

Log file for this session: /u01/oracle/patch/log/checkMTpatch_20456.log

 

Bugfix XML file version: 120.0.12020000.46

This file will be used for identifying missing bugfixes.

 

Mapping XML file version: 120.0.12020000.32

This file will be used for mapping bugfixes to patches.

 

Checking for prerequisite bugfixes in File Edition: run

 

Enter the password for the APPS user:

Connecting to database.

Database connection successful.

The installed AD.C codelevel does not support storing the results in the databas                                                                                                             e.

 

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

Oracle Forms and Reports

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

Now examining product Oracle Forms and Reports.

 

Oracle Home = /u01/oracle/PROD/fs1/EBSapps/10.1.2.

Product version = 10.1.2.3.0.

Checking required bugfixes for Oracle Forms and Reports 10.1.2.3.0.

  Missing Bugfix: 17353142  ->  Patch 26825525

  Missing Bugfix: 20643256  ->  Patch 26825525

  Missing Bugfix: 16041055  ->  Patch 26825525

  Missing Bugfix: 16910762  ->  Patch 26825525

  Missing Bugfix: 20270659  ->  Patch 26825525

  Missing Bugfix: 17372642  ->  Patch 26825525

  Missing Bugfix: 17566694  ->  Patch 26825525

  Missing Bugfix: 20240480  ->  Patch 26825525

  Missing Bugfix: 19304738  ->  Patch 26825525

  Missing Bugfix: 20391574  ->  Patch 26825525

  Missing Bugfix: 22351071  ->  Patch 26825525

  Missing Bugfix: 21024122  ->  Patch 26825525

  Missing Bugfix: 19588847  ->  Patch 26825525

  Missing Bugfix: 19639173  ->  Patch 26825525

  Missing Bugfix: 20545718  ->  Patch 26825525

  Missing Bugfix: 22524329  ->  Patch 26825525

  Missing Bugfix: 23123655  ->  Patch 26825525

  Missing Bugfix: 23728755  ->  Patch 26825525

  Missing Bugfix: 24315226  ->  Patch 26825525

  Missing Bugfix: 24480018  ->  Patch 26825525

  Missing Bugfix: 24808044  ->  Patch 26825525

  Missing Bugfix: 24620875  ->  Patch 26825525

  Missing Bugfix: 25355211  ->  Patch 26825525

  Missing Bugfix: 23538157  ->  Patch 26825525

  Missing Bugfix: 23538170  ->  Patch 26825525

  Missing Bugfix: 13557392  ->  Patch 26825525

  Missing Bugfix: 25506193  ->  Patch 26825525

  Missing Bugfix: 25342269  ->  Patch 25342269

  Missing Bugfix: 26048089  ->  Patch 26825525

  Missing Bugfix: 25990479  ->  Patch 26825525

  Missing Bugfix: 1770039  ->  Patch 26825525

  Missing Bugfix: 27491934  ->  Patch 27491934

The above list shows missing bugfixes for Oracle Forms and Reports.

 

Checking required bugfixes for RSF within Forms 10.1.0.5.0.

All required bugfixes are present for RSF within Forms.

 

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

Oracle Fusion Middleware (FMW) - Web Tier

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

Now examining product Oracle Fusion Middleware (FMW) - Web Tier.

 

Oracle Home = /u01/oracle/PROD/fs1/FMW_Home/webtier.

Product Version = 11.1.1.9.0

Checking required bugfixes for FMW - Web Tier 11.1.1.9.0.

  Missing Bugfix: 21300463  ->  Patch 22288381

  Missing Bugfix: 21892015  ->  Patch 22288381

  Missing Bugfix: 24567879  ->  Patch 31047338

  Missing Bugfix: 20900385  ->  Patch 31047338

  Missing Bugfix: 25205368  ->  Patch 31304503

  Missing Bugfix: 26837992  ->  Patch 31047338

  Missing Bugfix: 21305938  ->  Patch 31047338

  Missing Bugfix: 20913582  ->  Patch 31047338

  Missing Bugfix: 22218211  ->  Patch 31047338

  Missing Bugfix: 23107407  ->  Patch 31047338

  Missing Bugfix: 19571821  ->  Patch 31047338

  Missing Bugfix: 26929226  ->  Patch 31047338

  Missing Bugfix: 25191174  ->  Patch 31047338

  Missing Bugfix: 26101975  ->  Patch 31047338

  Missing Bugfix: 21520649  ->  Patch 31047338

  Missing Bugfix: 23266217  ->  Patch 31304503

  Missing Bugfix: 23115139  ->  Patch 31304503

  Missing Bugfix: 26318200  ->  Patch 31304503

  Missing Bugfix: 23140259  ->  Patch 31304503

  Missing Bugfix: 25914276  ->  Patch 31304503

  Missing Bugfix: 20856766  ->  Patch 31304503

  Missing Bugfix: 26434300  ->  Patch 31304503

  Missing Bugfix: 25879984  ->  Patch 31304503

  Missing Bugfix: 19891090  ->  Patch 31304503

  Missing Bugfix: 18604692  ->  Patch 31304503

  Missing Bugfix: 29389063  ->  Patch 31304503

  Missing Bugfix: 20273319  ->  Patch 31304503

  Missing Bugfix: 25775213  ->  Patch 31304503

  Missing Bugfix: 26245237  ->  Patch 31304503

  Missing Bugfix: 18166013  ->  Patch 31304503

  Missing Bugfix: 19718981  ->  Patch 31304503

  Missing Bugfix: 21656630  ->  Patch 31304503

  Missing Bugfix: 19697993  ->  Patch 31304503

  Missing Bugfix: 23055182  ->  Patch 31304503

  Missing Bugfix: 25760218  ->  Patch 31304503

  Missing Bugfix: 20725343  ->  Patch 31304503

  Missing Bugfix: 16354467  ->  Patch 31304503

  Missing Bugfix: 22750215  ->  Patch 31304503

  Missing Bugfix: 25635149  ->  Patch 31304503

  Missing Bugfix: 25555252  ->  Patch 31304503

  Missing Bugfix: 17983206  ->  Patch 31304503

  Missing Bugfix: 21063322  ->  Patch 31304503

  Missing Bugfix: 26243698  ->  Patch 31304503

  Missing Bugfix: 23716938  ->  Patch 23716938

  Missing Bugfix: 23716938  ->  Patch 23716938

  Missing Bugfix: 24681614  ->  Patch 31047338

  Missing Bugfix: 30146419  ->  Patch 31047338

  Missing Bugfix: 20580842  ->  Patch 31047338

  Missing Bugfix: 27577851  ->  Patch 31047338

  Missing Bugfix: 25288078  ->  Patch 31304503

  Missing Bugfix: 30887923  ->  Patch 31047338

  Missing Bugfix: 26752325  ->  Patch 31047338

  Missing Bugfix: 30876572  ->  Patch 31047338

  Missing Bugfix: 31285797  ->  Patch 31304503

The above list shows missing bugfixes for FMW - Web Tier.

 

Checking required bugfixes for RSF within FMW Web tier 11.1.0.7.0.

  Missing Bugfix: 20004021  ->  Patch 22290164

  Missing Bugfix: 20004087  ->  Patch 22290164

  Missing Bugfix: 16872333  ->  Patch 22290164

  Missing Bugfix: 19699191  ->  Patch 22290164

  Missing Bugfix: 20558005  ->  Patch 22290164

  Missing Bugfix: 20331945  ->  Patch 22290164

The above list shows missing bugfixes for RSF within FMW Web tier.

 

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

Oracle Fusion Middleware (FMW) - oracle_common

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

Now examining product Oracle Fusion Middleware (FMW) - oracle_common.

 

Oracle Home = /u01/oracle/PROD/fs1/FMW_Home/oracle_common.

Product Version = 11.1.1.9.0

Checking required bugfixes for FMW - oracle common 11.1.1.9.0.

  Missing Bugfix: 9905685  ->  Patch 9905685

  Missing Bugfix: 17428617  ->  Patch 17428617

  Missing Bugfix: 21366277  ->  Patch 21366277

  Missing Bugfix: 21628307  ->  Patch 21628307

  Missing Bugfix: 24606362  ->  Patch 24606362

  Missing Bugfix: 24843064  ->  Patch 24843064

  Missing Bugfix: 13544814  ->  Patch 13544814

  Missing Bugfix: 16089637  ->  Patch 16089637

  Missing Bugfix: 20141119  ->  Patch 20141119

  Missing Bugfix: 24335626  ->  Patch 30368663

  Missing Bugfix: 22998551  ->  Patch 30368663

  Missing Bugfix: 22660018  ->  Patch 30368663

  Missing Bugfix: 24913281  ->  Patch 30368663

  Missing Bugfix: 20055551  ->  Patch 30368663

  Missing Bugfix: 27212806  ->  Patch 27212806

  Missing Bugfix: 28371189  ->  Patch 28708563

  Missing Bugfix: 26957170  ->  Patch 30368663

  Missing Bugfix: 28368196  ->  Patch 30368663

  Missing Bugfix: 30153175  ->  Patch 30368663

  Missing Bugfix: 29702340  ->  Patch 30368663

  Missing Bugfix: 29997425  ->  Patch 30368663

The above list shows missing bugfixes for FMW - oracle common.

 

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

Oracle WebLogic Server (WLS)

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

Now examining product Oracle WebLogic Server (WLS).

 

Oracle Home = /u01/oracle/PROD/fs1/FMW_Home/wlserver_10.3.

Product Version = 10.3.6.0.7

 

Note that for Oracle WebLogic Server, patches rather than bugfixes are verified.

 

Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.7.

  Missing Patch ID: 29204678

The above list shows missing patches for Oracle WebLogic Server.

If you have applied other Oracle WebLogic Server patches, they may have included the bugfixes needed.

Contact Oracle Support if you require assistance in determining whether this is the case.

 

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

 

Generating Patch Recommendation Summary.

 

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

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 26825525

  - Filename: p26825525_101232_LINUX.zip

  Patch 25342269

  - Filename: p25342269_101232_Generic.zip

  Patch 27491934

   - Filename: p27491934_101232_LINUX.zip

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

Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0

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

  Patch 22288381

 - Filename: p22288381_111190_Generic.zip

  Patch 31047338

 - Filename: p31047338_111190_Linux-x86-64.zip

  Patch 31304503

 - Filename: p31304503_111190_Linux-x86-64.zip

 Patch 23716938

 - Filename: p23716938_111190_Generic.zip

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

RSF within FMW Web tier 11.1.0.7.0

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

  Patch 22290164

 - Filename: p22290164_111070_Linux-x86-64.zip

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

Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0

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

  Patch 9905685

 - Filename: p9905685_111190_Generic.zip

  Patch 17428617

 - Filename: p17428617_111190_Generic.zip

  Patch 21366277

 - Filename: p21366277_111190_Generic.zip

  Patch 21628307

- Filename: p21628307_111190_Generic.zip

  Patch 24606362

 - Filename: p24606362_111190_Generic.zip

  Patch 24843064

 - Filename: p24843064_111190_Generic.zip

  Patch 13544814

- Filename: p13544814_111190_Generic.zip

  Patch 16089637

- Filename: p16089637_111190_Generic.zip

 Patch 20141119

- Filename: p20141119_111190_Generic.zip

Patch 30368663

- Filename: p30368663_111190_Generic.zip

 Patch 27212806

- Filename: p27212806_111190_Generic.zip

 Patch 28708563

- Filename: p28708563_111190_Generic.zip

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

Oracle WebLogic Server (WLS) 10.3.6.0.7

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

  Bugfix 29204678 [Warning: No patch mapping data found.]

    - Use Doc ID 1594274.1 to find the patch that delivers this bugfix.

  Patch data missing for bugfix 29204678

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 31381605

    - EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JUL 2020

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

See Doc ID 1594274.1 for any special instructions regarding these patches.

Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.

Finished checking prerequisite patches for File Edition: run.

Sun Nov  8 17:20:09 +04 2020

Log file for this session: /u01/oracle/patch/log/checkMTpatch_20456.log

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

[applmgr@oraebs12 patch]$

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

Installing Oracle EBS Apps

[applmgr@oraebs12 patch]$ cd 26825525

[applmgr@oraebs12 26825525]$ ls

etc  files  README.txt

[applmgr@oraebs12 26825525]$ which opatch

/u01/oracle/PROD/fs1/EBSapps/10.1.2/OPatch/opatch

[applmgr@oraebs12 26825525]$ 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/oracle/PROD/fs1/EBSapps/10.1.2

Oracle Home Inventory : /u01/oracle/PROD/fs1/EBSapps/10.1.2/inventory

Central Inventory     : /u01/oracle/oraInventory

   from               : /etc/oraInst.loc

OUI location          : /u01/oracle/PROD/fs1/EBSapps/10.1.2/oui

OUI shared library    : /u01/oracle/PROD/fs1/EBSapps/10.1.2/oui/lib/linux/liboraInstaller.so

Java location         : /u01/oracle/PROD/fs1/EBSapps/10.1.2/jdk/jre/bin/java

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

 

Creating log file "/u01/oracle/PROD/fs1/EBSapps/10.1.2/.patch_storage/26825525/Apply_26825525_11-08-2020_22-48-25.log"

 

Invoking fuser to check for active processes.

 

 

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

 

 

Subset patches:  8557019, 18620223, 19434967,

 

The fixes for Patch 8557019, 18620223, 19434967,  are included in the patch currently

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

install the new patch (26825525).

 

 

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/oracle/PROD/fs1/EBSapps/10.1.2)

Is this system ready for updating?

Please respond Y|N >

y

Rolling back patch 8557019...

 

Creating log file "/u01/oracle/PROD/fs1/EBSapps/10.1.2/.patch_storage/8557019/RollBack_8557019_11-08-2020_22-49-03.log"

 

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 8557019...

 

Restoring archive files...

 

Running make for target  install.

 

 

Updating inventory...

Rolling back patch 18620223...

 

Creating log file "/u01/oracle/PROD/fs1/EBSapps/10.1.2/.patch_storage/18620223/RollBack_18620223_11-08-2020_22-49-18.log"

 

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 18620223...

 

Restoring archive files...

 

Running make for target  sharedlib.

 

Running make for target  install.

 

 

Updating inventory...

Rolling back patch 19434967...

 

Creating log file "/u01/oracle/PROD/fs1/EBSapps/10.1.2/.patch_storage/19434967/RollBack_19434967_11-08-2020_22-49-38.log"

 

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 19434967...

Restoring archive files...

Restoring copied files...

Running make for target  sharedlib.

Running make for target  install.

Running make for target  sharedlibs.

Updating inventory...

Back to applying patch 26825525...

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

Applying patch 26825525...

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 ...

Patch succeeded.

[applmgr@oraebs12 26825525]$

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

FMW HOME Installation Patches

 

$ which opatch

/u01/oracle/PROD/fs1/EBSapps/10.1.2/Opatch/opatch

[applmgr@oraebs12 22288381]$ $ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 11.1.0.12.9

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

 

 

Oracle Home       : /u01/oracle/PROD/fs1/FMW_Home/webtier

Central Inventory : /u01/oracle/oraInventory

   from           : /u01/oracle/PROD/fs1/FMW_Home/webtier/oraInst.loc

OPatch version    : 11.1.0.12.9

OUI version       : 11.1.0.11.0

Log file location : /u01/oracle/PROD/fs1/FMW_Home/webtier/cfgtoollogs/opatch/22288381_Nov_08_2020_23_10_07/apply2020-11-08_23-10-06PM_1.log

 

 

OPatch detects the Middleware Home as "/u01/oracle/PROD/fs1/FMW_Home"

 

Applying interim patch '22288381' to OH '/u01/oracle/PROD/fs1/FMW_Home/webtier'

Verifying environment and performing prerequisite checks...

 

Conflicts/Supersets for each patch are:

 

Patch : 22288381

 

        Bug Superset of 20922780

        Super set bugs are:

        20922780

Interim patch 22288381 is a superset of the patch(es) [  20922780 ] 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

 

 

Backing up files...

Rolling back interim patch '20922780' from OH '/u01/oracle/PROD/fs1/FMW_Home/webtier'

 

Patching component oracle.as.clone.ohs, 11.1.1.9.0...

Updating jar file "/u01/oracle/PROD/fs1/FMW_Home/webtier/clone/provision/ohscloning.jar" with "/u01/oracle/PROD/fs1/FMW_Home/webtier/.patch_storage/20922780_May_28_2015_05_58_51/files//clone/provision/ohscloning.jar/oracle/as/clone/ohs/constants/OHSComponentCloningConstants$WebGateInfo.class"

Updating jar file "/u01/oracle/PROD/fs1/FMW_Home/webtier/clone/provision/ohscloning.jar" with "/u01/oracle/PROD/fs1/FMW_Home/webtier/.patch_storage/20922780_May_28_2015_05_58_51/files//clone/provision/ohscloning.jar/oracle/as/clone/ohs/helper/MovePlanHelper.class"

Updating jar file "/u01/oracle/PROD/fs1/FMW_Home/webtier/clone/provision/ohscloning.jar" with "/u01/oracle/PROD/fs1/FMW_Home/webtier/.patch_storage/20922780_May_28_2015_05_58_51/files//clone/provision/ohscloning.jar/oracle/as/clone/ohs/helper/MovePlanHelper$MovePlanValidationHandler.class"

Updating jar file "/u01/oracle/PROD/fs1/FMW_Home/webtier/clone/provision/ohscloning.jar" with "/u01/oracle/PROD/fs1/FMW_Home/webtier/.patch_storage/20922780_May_28_2015_05_58_51/files//clone/provision/ohscloning.jar/oracle/as/clone/ohs/resources/OHSComponentCloningResources.class"

RollbackSession removing interim patch '20922780' from inventory

 

 

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

 

 

Patching component oracle.as.clone.ohs, 11.1.1.9.0...

 

Verifying the update...

Patch 22288381 successfully applied

Log file location: /u01/oracle/PROD/fs1/FMW_Home/webtier/cfgtoollogs/opatch/22288381_Nov_08_2020_23_10_07/apply2020-11-08_23-10-06PM_1.log

 

OPatch succeeded.

[applmgr@oraebs12 22288381]$ cd ..

[applmgr@oraebs12 patch]$ ls

17204589                      p16089637_111190_Generic.zip       p25342269_101232_Generic.zip

21900871                      p17204589_12.2.0_R12_GENERIC.zip   p26825525_101232_LINUX.zip

22288381                      p17428617_111190_Generic.zip       p27212806_111190_Generic.zip

26825525                      p17537119_R12_GENERIC.zip          p27491934_101232_LINUX.zip

27491934                      p20141119_111190_Generic.zip       p28708563_111190_Generic.zip

checkDBpatch.cmd              p21366277_111190_Generic.zip       p30368663_111190_Generic.zip

checkDBpatch.sh               p21628307_111190_Generic.zip       p31047338_111190_Linux-x86-64.zip

checkMTpatch.cmd              p21900871_12.2.0_R12_GENERIC.zip   p31304503_111190_Linux-x86-64.zip

checkMTpatch.sh               p22288381_111190_Generic.zip       p9905685_111190_Generic.zip

db                            p22290164_111070_Linux-x86-64.zip  README.txt

mw                            p23716938_111190_Generic.zip

p13544814_111190_Generic.zip  p24606362_111190_Generic.zip

[applmgr@oraebs12 patch]$ unzip p31047338_111190_Linux-x86-64.zip

Archive:  p31047338_111190_Linux-x86-64.zip

   creating: 31047338/

   creating: 31047338/files/

   creating: 31047338/files/ohs/

   creating: 31047338/files/ohs/modules/

  inflating: 31047338/files/ohs/modules/mod_ossl.so

   creating: 31047338/files/ohs/bin/

  inflating: 31047338/files/ohs/bin/httpd.worker

  inflating: 31047338/files/ohs/bin/httpd.prefork

  inflating: 31047338/files/ohs/bin/httpd

   creating: 31047338/files/ohs/conf/

  inflating: 31047338/files/ohs/conf/httpd.conf

  inflating: 31047338/files/ohs/conf/ssl.conf

   creating: 31047338/files/ohs/lib/

  inflating: 31047338/files/ohs/lib/libxml2.so

   creating: 31047338/etc/

   creating: 31047338/etc/config/

  inflating: 31047338/etc/config/actions.xml

  inflating: 31047338/etc/config/inventory.xml

  inflating: 31047338/etc/config/deploy.xml

   creating: 31047338/etc/xml/

  inflating: 31047338/etc/xml/GenericActions.xml

  inflating: 31047338/etc/xml/ShiphomeDirectoryStructure.xml

  inflating: 31047338/README.txt

[applmgr@oraebs12 patch]$ cd 31047338/

[applmgr@oraebs12 31047338]$ $ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 11.1.0.12.9

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

 

 

Oracle Home       : /u01/oracle/PROD/fs1/FMW_Home/webtier

Central Inventory : /u01/oracle/oraInventory

   from           : /u01/oracle/PROD/fs1/FMW_Home/webtier/oraInst.loc

OPatch version    : 11.1.0.12.9

OUI version       : 11.1.0.11.0

Log file location : /u01/oracle/PROD/fs1/FMW_Home/webtier/cfgtoollogs/opatch/31047338_Nov_08_2020_23_11_26/apply2020-11-08_23-11-26PM_1.log

 

 

OPatch detects the Middleware Home as "/u01/oracle/PROD/fs1/FMW_Home"

 

Applying interim patch '31047338' to OH '/u01/oracle/PROD/fs1/FMW_Home/webtier'

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:

 

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/oracle/PROD/fs1/FMW_Home/webtier')

 

 

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

y

User Responded with: Y

Backing up files...

 

Patching component oracle.ohs2, 11.1.1.9.0...

 

Verifying the update...

Patch 31047338 successfully applied

Log file location: /u01/oracle/PROD/fs1/FMW_Home/webtier/cfgtoollogs/opatch/31047338_Nov_08_2020_23_11_26/apply2020-11-08_23-11-26PM_1.log

 

OPatch succeeded.

[applmgr@oraebs12 31047338]$

 

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

Oracle WebLogic Server (WLS)    When you apply patch on WLS First set the ORACLE_HOME Variable

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

Now examining product Oracle WebLogic Server (WLS).

$ Export Oracle Home = /u01/oracle/PROD/fs1/FMW_Home/wlserver_10.3

$ echo $ORACLE_HOME

/u01/oracle/PROD/fs1/FMW_Home/wlserver_10.3

 

     






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

ADGRANTS.SQL Scripts (Download Patch 20745242) 

/u01/oracle/PROD/fs_ne/EBSapps/patch/PatchTXKAD/20745242/admin/adgrants.sh

[applmgr@oraebs12 admin]$ cp adgrants.sql /u01/oracle/PROD/fs1/EBSapps/appl/admin/

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


[oracle@oraebs12 12.1.0]$ . ./PROD_oraebs12.env

[oracle@oraebs12 12.1.0]$ cd bin

[oracle@oraebs12 bin]$ ./sqlplus /nolog


SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 10 17:26:41 2020


Copyright (c) 1982, 2014, Oracle.  All rights reserved.


SQL> conn / as sysdba

Connected.

SQL> @/u01/oracle/PROD/fs1/EBSapps/appl/admin/adgrants.sql apps

Connected.

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

--- adgrants.sql started at 2020-11-10 17:27:52 ---

Creating PL/SQL profiler objects.

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

--- profload.sql started at 2020-11-10 17:27:52 ---

Session altered.

Package created.

Grant succeeded.

Synonym created.

Session altered.

Session altered.



Library created.



Package body created.



Session altered.


Testing for correct installation

SYS.DBMS_PROFILER successfully loaded.


PL/SQL procedure successfully completed.




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

--- profload.sql completed at 2020-11-10 17:27:59 ---




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

--- proftab.sql started at 2020-11-10 17:27:59 ---



Table dropped.



Table dropped.



Table dropped.



Sequence dropped.



Table created.



Comment created.



Table created.



Comment created.



Table created.



Comment created.



Sequence created.




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

--- profltab.sql completed at 2020-11-10 17:28:02 ---



Installing Hierarchical Profiler.



Table dropped.



Table dropped.



Table dropped.



Sequence dropped.



Table created.



Comment created.



Table created.



Comment created.



Table created.



Comment created.



Sequence created.



Session altered.



Package created.



Synonym created.



Session altered.



Grant succeeded.



Grant succeeded.



Grant succeeded.



Grant succeeded.



Loading Stylesheets if missing



PL/SQL procedure successfully completed.



Start of Creating AD_JAR context



PL/SQL procedure successfully completed.



PL/SQL procedure successfully completed.



End of Creating AD_JAR context



Creating PL/SQL Package AD_DBMS_METADATA.



Package created.



Package body created.



End of Creating PL/SQL Package AD_DBMS_METADATA.



Creating PL/SQL Package AD_ZD_SYS.



Package created.



Package body created.



End of Creating PL/SQL Package AD_ZD_SYS.


Start of giving grants. This may take few minutes.


PL/SQL procedure successfully completed.



Start of PURGE DBA_RECYCLEBIN.



PL/SQL procedure successfully completed.



End of PURGE DBA_RECYCLEBIN.



Commit complete.


Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oracle@oraebs12 bin]$






======================================================================
Installing Patch on 20745242 on APPLICATION

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

[applmgr@oraebs12 patch]$ cd 20745242/
[applmgr@oraebs12 20745242]$ ls
ad     b20745242.ldt  j20745242_ad.zip   patch_metadata.xml  u20745242.drv
admin  f20745242.ldt  j20745242_fnd.zip  README.html
au     fnd            marker1.txt        README.txt
[applmgr@oraebs12 20745242]$ adop phase=apply patches=20745242 hotpatch=yes

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

 Please wait. Validating credentials...


Enter the RUN file system context file name [/u01/oracle/PROD/fs1/inst/apps/PROD_oraebs12/                                                                                                   appl/admin/PROD_oraebs12.xml]:

[STATEMENT] [END   2020/11/10 18:19:24] Performing verification of parameters
[STATEMENT] [START 2020/11/10 18:19:24] Checking for the required ENV setup
[STATEMENT] [END   2020/11/10 18:19:25] Checking for the required ENV setup

************* Start of  session *************
 version: 12.2.0
 started at: Tue Nov 10 2020 18:19:25

APPL_TOP is set to /u01/oracle/PROD/fs1/EBSapps/appl
[STATEMENT] [START 2020/11/10 18:19:25] Determining admin node
[STATEMENT] [END   2020/11/10 18:19:28] Determining admin node
[STATEMENT]  Recommended Worker Count:  1 Max Allowed Workers: 10
[STATEMENT] [START 2020/11/10 18:19:32] Acquiring lock on sessions table
[STATEMENT] [END   2020/11/10 18:19:34] Acquiring lock on sessions table
[STATEMENT] [START 2020/11/10 18:19:34] Checking for any pending sessions
[STATEMENT] Using the session id which is not complete for all phases
[STATEMENT] [START 2020/11/10 18:19:45] Unlocking sessions table
[STATEMENT] [END   2020/11/10 18:19:45] Unlocking sessions table
[STATEMENT] [START 2020/11/10 18:19:45] adzdoptl.pl run
  [STATEMENT] Session ID: 2
  [STATEMENT] Phase: apply
  [STATEMENT] Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/adop_20201110_181854.log
  [STATEMENT] [START 2020/11/10 18:20:00] Invoking admerge
  [STATEMENT] [END   2020/11/10 18:20:01] Invoking admerge
  [STATEMENT] [START 2020/11/10 18:20:02] apply phase
    [STATEMENT] APPLY Phase START TIME: 10-11-2020 18:20:03
    [STATEMENT] [START 2020/11/10 18:20:06] Performing Check for Logon Trigger existence a                                                                                                   nd enablement
    [STATEMENT] [END   2020/11/10 18:20:09] Performing Check for Logon Trigger existence a                                                                                                   nd enablement
sh: module: line 1: syntax error: unexpected end of file
sh: error importing function definition for `module'
    [STATEMENT] [Start 2020/11/10 18:20:14] ADOP::DefaultsFileUtil::substituteDefaultsFile                                                                                                   TokensForPatchApplTop
      [STATEMENT] Reading defaults file /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adall                                                                                                   defaults.txt
      [STATEMENT] Substituting tokens ...
      [STATEMENT] Regenerating defaults file ...
    [STATEMENT] [End   2020/11/10 18:20:15] ADOP::DefaultsFileUtil::substituteDefaultsFile                                                                                                   TokensForPatchApplTop
    [STATEMENT] Calling: adpatch  workers=1    options=hotpatch    flags=autoskip   consol                                                                                                   e=no interactive=no  defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaul                                                                                                   ts.txt patchtop=/u01/oracle/PROD/fs_ne/EBSapps/patch/20745242 driver=u20745242.drv logfile                                                                                                   =u20745242.log
    [STATEMENT] ADPATCH Log directory: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_202                                                                                                   01110_181854/PROD_oraebs12/20745242/log
    [STATEMENT] Running: adpatch  workers=1    options=hotpatch    flags=autoskip   consol                                                                                                   e=no interactive=no  defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaul                                                                                                   ts.txt patchtop=/u01/oracle/PROD/fs_ne/EBSapps/patch/20745242 driver=u20745242.drv logfile                                                                                                   =u20745242.log stdin=yes
sh: module: line 1: syntax error: unexpected end of file
sh: error importing function definition for `module'

Successfully created out directory
    [STATEMENT] [START 2020/11/10 18:35:28] Running finalize since in hotpatch mode

    [STATEMENT] [END   2020/11/10 18:35:47] Running finalize since in hotpatch mode
    [STATEMENT] [START 2020/11/10 18:35:48] Performing Automatic DB cutover
      [STATEMENT] [Start 2020/11/10 18:35:51] ADOP::DefaultsFileUtil::substituteDefaultsFi                                                                                                   leTokensForPatchApplTop
        [STATEMENT] Reading defaults file /u01/oracle/PROD/fs2/EBSapps/appl/admin/PROD_pat                                                                                                   ch/adalldefaults.txt
        [STATEMENT] Substituting tokens ...
        [STATEMENT] Regenerating defaults file ...
      [STATEMENT] [End   2020/11/10 18:35:53] ADOP::DefaultsFileUtil::substituteDefaultsFi                                                                                                   leTokensForPatchApplTop
      [STATEMENT] Calling: adpatch options=hotpatch,nocompiledb interactive=no console=no                                                                                                    workers=1 restart=no abandon=yes defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD                                                                                                   /adalldefaults.txt patchtop=/u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver l                                                                                                   ogfile=cutover.log driver=ucutover.drv
      [STATEMENT] ADPATCH Log directory: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_2                                                                                                   0201110_181854/PROD_oraebs12/log
      [STATEMENT] Running: adpatch options=hotpatch,nocompiledb interactive=no console=no                                                                                                    workers=1 restart=no abandon=yes defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD                                                                                                   /adalldefaults.txt patchtop=/u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver l                                                                                                   ogfile=cutover.log driver=ucutover.drv stdin=yes
sh: module: line 1: syntax error: unexpected end of file
sh: error importing function definition for `module'
    [STATEMENT] [END   2020/11/10 18:42:37] Performing Automatic DB cutover
    [STATEMENT] [START 2020/11/10 18:42:39] Running cutover since in hotpatch mode
    [STATEMENT] [END   2020/11/10 18:42:44] Running cutover since in hotpatch mode
    [STATEMENT] [START 2020/11/10 18:42:45] Compiling Invalid Objects
    [STATEMENT] [END   2020/11/10 18:43:10] Compiling Invalid Objects
sh: module: line 1: syntax error: unexpected end of file
sh: error importing function definition for `module'
  [STATEMENT] [END   2020/11/10 18:43:15] apply phase
  [STATEMENT] [START 2020/11/10 18:43:16] Generating Post Apply Reports
    [STATEMENT] APPLY Phase END TIME: 10-11-2020 18:43:18
      [STATEMENT] [START 2020/11/10 18:43:21] Generating Report to spool all logs from ad_                                                                                                   zd_logs
        [STATEMENT] Report: /u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sq                                                                                                   l

        [STATEMENT] Output: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201110_18185                                                                                                   4/PROD_oraebs12/adzdshowlog.out

      [STATEMENT] [END   2020/11/10 18:43:28] Generating Report to spool all logs from ad_                                                                                                   zd_logs
  [STATEMENT] [END   2020/11/10 18:43:30] Generating Post Apply Reports
[STATEMENT] [END   2020/11/10 18:43:36] adzdoptl.pl run
[STATEMENT] adop phase=apply - Completed Successfully

[STATEMENT] Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/adop_20201110_181854.log

adop exiting with status = 0 (Success)
[applmgr@oraebs12 20745242]$
[applmgr@oraebs12 20745242]$

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


==================================================
[applmgr@oraebs12 oracle]$ cd PROD/fs_ne/EBSapps/patch/
[applmgr@oraebs12 patch]$ cd 22123818/
[applmgr@oraebs12 22123818]$ cd admin
[applmgr@oraebs12 admin]$ cp adgrants.sql /u01/oracle/PROD/fs1/EBSapps/appl/admin/
[applmgr@oraebs12 admin]$


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

ADGRANTS.SQL Scripts (Download Patch 22123818/

/u01/oracle/PROD/fs_ne/EBSapps/patch/22123818/admin/adgrants.sh

[applmgr@oraebs12 admin]$ cp adgrants.sql /u01/oracle/PROD/fs1/EBSapps/appl/admin/

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


[oracle@oraebs12 bin]$ ./sqlplus /nolog


SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 10 18:58:11 2020


Copyright (c) 1982, 2014, Oracle.  All rights reserved.


SQL> conn / as sysdba

Connected.

SQL> @/u01/oracle/PROD/fs1/EBSapps/appl/admin/adgrants.sql apps

Connected.



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

--- adgrants.sql started at 2020-11-10 18:58:30 ---



Creating PL/SQL profiler objects.




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

--- profload.sql started at 2020-11-10 18:58:30 ---



Session altered.



Package created.



Grant succeeded.



Synonym created.



Session altered.



Session altered.



Library created.



Package body created.



Session altered.


Testing for correct installation

SYS.DBMS_PROFILER successfully loaded.


PL/SQL procedure successfully completed.




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

--- profload.sql completed at 2020-11-10 18:58:35 ---




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

--- proftab.sql started at 2020-11-10 18:58:35 ---



Table dropped.



Table dropped.



Table dropped.



Sequence dropped.



Table created.



Comment created.



Table created.



Comment created.



Table created.



Comment created.



Sequence created.




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

--- profltab.sql completed at 2020-11-10 18:58:35 ---



Installing Hierarchical Profiler.



Table dropped.



Table dropped.



Table dropped.



Sequence dropped.



Table created.



Comment created.



Table created.



Comment created.



Table created.



Comment created.



Sequence created.



Session altered.



Package created.



Synonym created.



Session altered.



Grant succeeded.



Grant succeeded.



Grant succeeded.



Grant succeeded.



Loading Stylesheets if missing



PL/SQL procedure successfully completed.



Start of Creating AD_JAR context



PL/SQL procedure successfully completed.



PL/SQL procedure successfully completed.



End of Creating AD_JAR context



Creating PL/SQL Package AD_DBMS_METADATA.



Package created.



Package body created.


End of Creating PL/SQL Package AD_DBMS_METADATA.

Creating PL/SQL Package AD_ZD_SYS.

Package created.

Package body created.

End of Creating PL/SQL Package AD_ZD_SYS.

Start of giving grants. This may take few minutes.

PL/SQL procedure successfully completed.

Start of PURGE DBA_RECYCLEBIN.

PL/SQL procedure successfully completed.

End of PURGE DBA_RECYCLEBIN.

Commit complete.


Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oracle@oraebs12 bin]$


[applmgr@oraebs12 22123818]$ adop phase=apply patches=22123818 hotpatch=yes


Enter the APPS password:

Enter the SYSTEM password:

Enter the WLSADMIN password:


Validating credentials.


Initializing.

    Run Edition context  : /u01/oracle/PROD/fs1/inst/apps/PROD_oraebs12/appl/admin/PROD_oraebs12.xml

    Patch edition context: /u01/oracle/PROD/fs2/inst/apps/PROD_oraebs12/appl/admin/PROD_oraebs12.xml

Reading driver file (up to 50000000 bytes).

    Patch file system free space: 85.76 GB


Validating system setup.




    Node registry is valid.

    [WARNING]   ETCC: The following required database fixes have not been applied to node oraebs12:

                  18607546

                Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.


Checking for existing adop sessions.

    Application tier services are down.

    Continuing with the existing session [Session ID: 2].


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

ADOP (C.Delta.7)

Session ID: 2

Node: oraebs12

Phase: apply

Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/adop_20201110_195755.log

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

sh: module: line 1: syntax error: unexpected end of file

sh: error importing function definition for `module'


Applying patch 22123818.

    Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201110_195755/PROD_oraebs12/22123818/log/u22123818.log

sh: module: line 1: syntax error: unexpected end of file

sh: error importing function definition for `module'


Running finalize actions for the patches being applied.

    Log: @ADZDSHOWLOG.sql "2020/11/10 20:11:07"


Running cutover actions for the patches being applied.

    Creating addtional workers to process cutover DDL in parallel

    Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201110_195755/PROD_oraebs12/log/cutover.log

sh: module: line 1: syntax error: unexpected end of file

sh: error importing function definition for `module'

    Performing database cutover in Quick mode

sh: module: line 1: syntax error: unexpected end of file

sh: error importing function definition for `module'


Generating post apply reports.


Generating log report.

    Output: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201110_195755/PROD_oraebs12/adzdshowlog.out


The apply phase completed successfully.



adop exiting with status = 0 (Success)

[applmgr@oraebs12 22123818]$



[applmgr@oraebs12 patch]$ adop phase=apply patches=20784380,22363475,22495069 hotpatch=yes                                                                                                   

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
    Run Edition context  : /u01/oracle/PROD/fs1/inst/apps/PROD_oraebs12/appl/admin/PROD_or                                                                                                   aebs12.xml
    Patch edition context: /u01/oracle/PROD/fs2/inst/apps/PROD_oraebs12/appl/admin/PROD_or                                                                                                   aebs12.xml
Reading driver file (up to 50000000 bytes).
Reading driver file (up to 50000000 bytes).
Reading driver file (up to 50000000 bytes).
    Patch file system free space: 85.74 GB

Validating system setup.
    Node registry is valid.
    [WARNING]   ETCC: The following required database fixes have not been applied to node                                                                                                    oraebs12:
                  18607546
                Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.

Checking for existing adop sessions.
    Application tier services are down.
    Continuing with the existing session [Session ID: 2].

===========================================================================
ADOP (C.Delta.7)
Session ID: 2
Node: oraebs12
Phase: apply
Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/adop_20201110_204232.log
===========================================================================
sh: module: line 1: syntax error: unexpected end of file
sh: error importing function definition for `module'

Applying patch 20784380.
    Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201110_204232/PROD_oraebs12/207                                                                                                   84380/log/u20784380.log
sh: module: line 1: syntax error: unexpected end of file
sh: error importing function definition for `module'
        New product CMI spliced. Use FNDCPASS to change the password.
        New product YMS spliced. Use FNDCPASS to change the password.

Applying patch 22363475.
    Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201110_204232/PROD_oraebs12/223                                                                                                   63475/log/u22363475.log
sh: module: line 1: syntax error: unexpected end of file
sh: error importing function definition for `module'

Applying patch 22495069.
    Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201110_204232/PROD_oraebs12/224                                                                                                   95069/log/u22495069.log
sh: module: line 1: syntax error: unexpected end of file
sh: error importing function definition for `module'

Running finalize actions for the patches being applied.
    Log: @ADZDSHOWLOG.sql "2020/11/10 21:10:46"

Running cutover actions for the patches being applied.
    Creating addtional workers to process cutover DDL in parallel
    Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201110_204232/PROD_oraebs12/log                                                                                                   /cutover.log
sh: module: line 1: syntax error: unexpected end of file
sh: error importing function definition for `module'
    Performing database cutover in Quick mode
sh: module: line 1: syntax error: unexpected end of file
sh: error importing function definition for `module'

Generating post apply reports.

Generating log report.
    Output: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201110_204232/PROD_oraebs12/                                                                                                   adzdshowlog.out
sh: module: line 1: syntax error: unexpected end of file
sh: error importing function definition for `module'

The apply phase completed successfully.


adop exiting with status = 0 (Success)
[applmgr@oraebs12 patch]$

===========================================================                                                                          Patch 19676458
===========================================================
========================================================================

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



No comments:

Post a Comment