Re: Error Applying October Patch - 19c

For a change, I had no issues with this release upgrade patch, but datapatch utility  is, generally speaking, rather unreliable. The good, old  _at_?/rdbms/admin/catbundle psu apply thing was much more reliable, if somewhat more tedious. I wonder whether Oracle has switched to agile development methodology and eliminated QA?

On Tue, 2020-11-03 at 19:32 +0000, Tefft, Michael J wrote:
> We had success following Symptom 23 in Doc ID 1602089.1 (setting 2
> underscore parameters).
>  
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-
> bounce_at_freelists.org]On Behalf Of Scott Canaan
> Sent: Friday, October 23, 2020 6:05 PM
> To: 'oracle-l_at_freelists.org' <oracle-l_at_freelists.org>
> Subject: Error Applying October Patch - 19c
>  
> CAUTION: This email originated from outside of Snap-on. Do not click
> on links or open attachments unless you have validated the sender,
> even if it is a known contact. Contact the sender by phone to
> validate the contents.
> I installed the Oracle 19c combo patch this afternoon.  Now when I
> try to run ./datapatch –verbose from the $ORACLE_HOME/OPatch
> directory, I get the following output:
>  
> oracle_at_vmora00a7:ORA19000>./datapatch -verbose
> SQL Patching tool version 19.9.0.0.0 Production on Fri Oct 23
> 17:46:48 2020
> Copyright (c) 2012, 2020, Oracle.  All rights reserved.
>  
> Log file for this invocation:
> /oracle/app/cfgtoollogs/sqlpatch/sqlpatch_22541_2020_10_23_17_46_48/s
> qlpatch_invocation.log
>  
> Connecting to database...OK
> Gathering database info...done
> Bootstrapping registry and package to current versions...done
> Error: prereq checks failed!
> verify_queryable_inventory returned ORA-20001: Latest xml inventory
> is not loaded into table
> Prereq check failed, exiting without installing any patches.
>  
> Please refer to MOS Note 1609718.1 and/or the invocation log
> /oracle/app/cfgtoollogs/sqlpatch/sqlpatch_22541_2020_10_23_17_46_48/s
> qlpatch_invocation.log
> for information on how to resolve the above errors.
>  
> SQL Patching tool complete on Fri Oct 23 17:48:35 2020
>  
> I’ve tried to follow all the varied scenarios in Doc ID 1602089.1. 
> However, when I try to query any of the opatch “tables”, nothing ever
> comes back, it just hangs and I end up having to shutdown abort the
> database to get out of it.  Since I can’t match up the issues I’m
> seeing with any of the errors listed in that document, I’m not sure
> where to go with this.  Does anyone have any other ideas?
>  
> Scott Canaan ‘88
> Sr Database Administrator
> Information & Technology Services
> Finance & Administration
> Rochester Institute of Technology
> o: (585) 475-7886 | f: (585) 475-7520
> srcdco_at_rit.edu | c: (585) 339-8659
> CONFIDENTIALITY NOTE: The information transmitted, including
> attachments, is intended only for the person(s) or entity to which it
> is addressed and may contain confidential and/or privileged material.
> Any review, retransmission, dissemination or other use of, or taking
> of any action in reliance upon this information by persons or
> entities other than the intended recipient is prohibited. If you
> received this in error, please contact the sender and destroy any
> copies of this information.
>  

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l