Tuesday, January 24, 2023

Patch 34935010 - DATABASE MRP 19.17.0.0.230117

 

Issues while applying Oracle 19.17.0 MRP [34935010]

#################################################################

 

Error:

[oracle@localhost 34935010]$ opatch apply /home/oracle/34935010/ -oh /opt/oracle/product/19c/dbhome_1

Oracle Interim Patch Installer version 12.2.0.1.36

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

 

 

ZOP-51: The patch location is not valid for apply, because it doesn't have correct metadata, or it points to a patch directory.

Argument(s) Error... Patch location is not valid for apply

 

Please check the arguments and try again.

 

OPatch failed with error code 135

 

Reason For this Error:

 

Instead of “opatch”, We should use “opatchauto” to apply the patch.

 

Command:

 opatchauto apply -binary /home/oracle/34935010/ -oh /opt/oracle/product/19c/dbhome_1 -target_type oracle_database

 

Sample Upgrade Output:

[oracle@localhost 34935010]$ opatchauto apply -binary /home/oracle/34935010/ -oh /opt/oracle/product/19c/dbhome_1 -target_type oracle_database

Oracle Home : /opt/oracle/product/19c/dbhome_1

 

OPatchAuto binary patching Tool

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

 

OPatchauto Version : 13.9.5.0.0

Running from       : /opt/oracle/product/19c/dbhome_1

 

opatchauto log file: /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/opatchauto_2023-01-24_03-18-28_binary.log

 

Target type : oracle_database

 

Patch selected: /home/oracle/34935010

 

 

Analysing this list of patches :

[/home/oracle/34935010/33838019, /home/oracle/34935010/34938232, /home/oracle/34935010/34545238, /home/oracle/34935010/34724125, /home/oracle/34935010/34366627, /home/oracle/34935010/34538232, /home/oracle/34935010/34333986, /home/oracle/34935010/34715072, /home/oracle/34935010/32295794, /home/oracle/34935010/34816203, /home/oracle/34935010/34574048, /home/oracle/34935010/34953559] ...

 

Analysis completed.

 

Applying the patches ...

 

 

Patches successfully applied.

 

 

 

 

==Following patches were SUCCESSFULLY applied:

 

Patch: /home/oracle/34935010/32295794

Log: /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-01-24_03-18-30AM_1.log

 

Patch: /home/oracle/34935010/33838019

Log: /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-01-24_03-18-30AM_1.log

 

Patch: /home/oracle/34935010/34333986

Log: /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-01-24_03-18-30AM_1.log

 

Patch: /home/oracle/34935010/34366627

Log: /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-01-24_03-18-30AM_1.log

 

Patch: /home/oracle/34935010/34538232

Log: /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-01-24_03-18-30AM_1.log

 

Patch: /home/oracle/34935010/34545238

Log: /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-01-24_03-18-30AM_1.log

 

Patch: /home/oracle/34935010/34574048

Log: /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-01-24_03-18-30AM_1.log

 

Patch: /home/oracle/34935010/34715072

Log: /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-01-24_03-18-30AM_1.log

 

Patch: /home/oracle/34935010/34724125

Log: /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-01-24_03-18-30AM_1.log

 

Patch: /home/oracle/34935010/34816203

Log: /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-01-24_03-18-30AM_1.log

 

Patch: /home/oracle/34935010/34938232

Log: /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-01-24_03-18-30AM_1.log

 

Patch: /home/oracle/34935010/34953559

Log: /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-01-24_03-18-30AM_1.log

 

 

opatchauto SUCCEEDED.

 

 

[oracle@localhost 34935010]$

[oracle@localhost 34935010]$ datapatch

SQL Patching tool version 19.17.0.0.0 Production on Tue Jan 24 03:30:01 2023

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

 

Log file for this invocation: /opt/oracle/cfgtoollogs/sqlpatch/sqlpatch_12121_2023_01_24_03_30_01/sqlpatch_invocation.log

 

Connecting to database...OK

Gathering database info...done

 

Note:  Datapatch will only apply or rollback SQL fixes for PDBs

       that are in an open state, no patches will be applied to closed PDBs.

       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation

       (Doc ID 1585822.1)

 

Bootstrapping registry and package to current versions...done

Determining current state...done

 

Current state of interim SQL patches:

  No interim patches found

 

Current state of release update SQL patches:

  Binary registry:

    19.17.0.0.0 Release_Update 220924224051: Installed

  PDB CDB$ROOT:

    Applied 19.17.0.0.0 Release_Update 220924224051 successfully on 19-JAN-23 04.56.50.910268 AM

  PDB ORCLPDB1:

    Applied 19.17.0.0.0 Release_Update 220924224051 successfully on 23-JAN-23 07.19.12.154816 AM

  PDB PDB$SEED:

    Applied 19.17.0.0.0 Release_Update 220924224051 successfully on 19-JAN-23 04.56.55.596701 AM

 

Adding patches to installation queue and performing prereq checks...done

Installation queue:

  For the following PDBs: CDB$ROOT PDB$SEED ORCLPDB1

    No interim patches need to be rolled back

    No release update patches need to be installed

    No interim patches need to be applied

 



 



No comments:

Post a Comment