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
