Hello all,
I have an Oracle upgrade to perform from 12.1.0.2 to 18c (SAP over Oracle).
Everything went fine for other 2 systems (similar infrastructure), but this one failed ad components upgrade (DBUA).
OS: AIX 7.2
All prerequisites are met!
2 successful upgrades already performed!
Do we have any command line manual upgrade steps for 18c if DBUA fails? (hope it's not an bug)
The error:
QPI: In opatch_inv_refresh_job
QPI: In REFRESH_OPATCH_DATA
QPI: Caught error while querying opatch_xml_inv
QPI: in REFRESH_OPATCH_DATA, ERROR code -29913 : ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04095: preprocessor command /oracle/
QPI: Releasing lock SUCCESSFUL, qp_result=0 at : 25-JUN-19 05.31.55.281023000 PM +02:00
QPI: Releasing lock FAILED, qp_result=4 at : 25-JUN-19 05.31.55.282957000 PM +02:00
QPI: in get_pending_activity, ERROR code -20001 : ORA-20001: Latest xml inventory is not loaded into table
QPI: org_node and inst resore 2::
QPI: In set_current_opinst
QPI: Releasing lock FAILED, qp_result=4 at : 25-JUN-19 05.31.55.288740000 PM +02:00
verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table
check_global_prereqs returning 1
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.
Database is running now, but I need to continue the steps in order to finish correctly the upgrade (what do you suggest?).
Components are remaining in UPGRADED status:
select substr(COMP_ID, 1,10) compid,substr(COMP_NAME,1,24) compname, STATUS,VERSION from DBA_REGISTRY;
COMPID COMPNAME STATUS VERSION
------------------------------ ------------------------------------------------------------------------ --------------------------------- ------------------------------
CATALOG Oracle Database Catalog UPGRADED 18.0.0.0.0
CATPROC Oracle Database Packages UPGRADED 18.0.0.0.0
XDB Oracle XML Database UPGRADED 18.0.0.0.0
RAC Oracle Real Application OPTION OFF 18.0.0.0.0
BR,
Mihai