ORA-20001: Latest xml inventory is not loaded into table
SYMPTON
SYS@XXXXXXX> select * from OPATCH_XML_INV ;
ERROR:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04004: error while reading file
/u01/app/oracle/product/12.1.0.2/dbhome_1/QOpatch/qopiprep.bat
DETAILS
[oracle@xxxxxxxxx OPatch]$./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 on Thu Aug 4 16:00:59 2016
Copyright (c) 2016, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_40851_2016_08_04_16_00_59/sqlpatch_invocation.log
Connecting to database...OK
Bootstrapping registry and package to current versions...done
Queryable inventory could not determine the current opatch status.
Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual'
and/or check the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_40851_2016_08_04_16_00_59/sqlpatch_invocation.log
for the complete error.
Prereq check failed, exiting without installing any patches.
Please refer to MOS Note 1609718.1 and/or the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_40851_2016_08_04_16_00_59/sqlpatch_invocation.log
for information on how to resolve the above errors.
SQL Patching tool complete on Thu Aug 4 16:01:08 2016
SYS@xxxxxxx> select dbms_sqlpatch.verify_queryable_inventory from dual;
VERIFY_QUERYABLE_INVENTORY
--------------------------------------------------------------------------------
ORA-20001: Latest xml inventory is not loaded into table
[oracle@FCIMHCQADB1 OPatch]$more /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_40851_2016_08_04_16_00_59/sqlpatch_invocation.log
SQL Patching tool version 12.1.0.2.0 on Thu Aug 4 16:00:59 2016
Copyright (c) 2016, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_40851_2016_08_04_16_00_59/sqlpatch_invocation.log
SQL Patching arguments:
verbose: 1
force: 0
prereq: 0
upgrade_mode_only:
oh:
bundle_series:
ignorable_errors:
bootstrap:
skip_upgrade_check:
userid:
pdbs:
Connecting to database...OK
catcon: ALL catcon-related output will be written to /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_40851_2016_08_04_16_00_59/sqlpatch_catcon__catcon_40851.lst
catcon: See /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_40851_2016_08_04_16_00_59/sqlpatch_catcon_*.log files for output generated by scripts
catcon: See /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_40851_2016_08_04_16_00_59/sqlpatch_catcon__*.lst files for spool files, if any
Bootstrapping registry and package to current versions...done
verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table
Queryable inventory could not determine the current opatch status.
Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual'
and/or check the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_40851_2016_08_04_16_00_59/sqlpatch_invocation.log
for the complete error.
Prereq check failed, exiting without installing any patches.
Please refer to MOS Note 1609718.1 and/or the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_40851_2016_08_04_16_00_59/sqlpatch_invocation.log
for information on how to resolve the above errors.
SQL Patching tool complete on Thu Aug 4 16:01:08 2016
[oracle@xxxxxxx 23054246]$$ORACLE_HOME/OPatch/opatch apply
[WARN ][jrockit] MaxPermSize=128M ignored: Not a valid option for JRockit
Oracle Interim Patch Installer version 12.2.0.1.5
Copyright (c) 2016, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.5
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2016-08-04_15-19-13PM_1.log
OPatch detects the Middleware Home as "/u01/app/oracle/product/middleware"
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 19769480 20299023 20831110 21359755 21948354 22291127 23054246
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0.2/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '19769480' to OH '/u01/app/oracle/product/12.1.0.2/dbhome_1'
ApplySession: Optional component(s) [ oracle.oraolap, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.deconfig, 12.1.0.2.0...
Patching component oracle.xdk, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.util, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
RESOLUTION
$view qopatch_log.log
Field Definitions for table OPATCH_XML_INV
Record format DELIMITED BY NEWLINE
Data in file has same endianness as the platform
Reject rows with all null fields
Fields in Data Source:
XML_INVENTORY CHAR (100000000)
Terminated by "UIJSVTBOEIZBEFFQBL"
Trim whitespace same as SQL Loader
KUP-04004: error while reading file /u01/app/oracle/product/12.1.0.2/dbhome_1/QOpatch/qopiprep.bat
KUP-04017: OS message: Error 0
KUP-04017: OS message: [WARN ][jrockit] MaxPermSize=128M ignored: Not a valid option for JRockit
KUP-04118: operation "pipe read", location "skudmir"
unset the JAVA_HOME and execute datapatch command
$unset JAVA_HOME
========================
@> connect / as sysdba
Connected.
SYS@xxxxxx> select dbms_sqlpatch.verify_queryable_inventory from dual;
VERIFY_QUERYABLE_INVENTORY
--------------------------------------------------------------------------------
OK
SYS@xxxxxx>
********************************************************
[oracle@xxxxxxx OPatch]$datapatch -verbose
SQL Patching tool version 12.1.0.2.0 on Thu Aug 4 20:07:04 2016
Copyright (c) 2016, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_10277_2016_08_04_20_07_04/sqlpatch_invocation.log
Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Bundle series PSU:
ID 160719 in the binary registry and not installed in the SQL registry
Adding patches to installation queue and performing prereq checks...
Installation queue:
Nothing to roll back
The following patches will be applied:
23054246 (Database Patch Set Update : 12.1.0.2.160719 (23054246))
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...
Patch 23054246 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/23054246/20464632/23054246_apply_ITRACQA_2016Aug04_20_07_52.log (no errors)
SQL Patching tool complete on Thu Aug 4 20:08:29 2016
No comments:
Post a Comment