Queryable inventory could not determine the current opatch status.

[oracle@Testing02 OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.2.0.1.0 Production on Fri May 15 15:54:19 2020
Copyright (c) 2012, 2019, Oracle.  All rights reserved.

Log file for this invocation: /testing/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29313_2020_05_15_15_54_19/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
/testing/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29313_2020_05_15_15_54_19/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
/testing/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29313_2020_05_15_15_54_19/sqlpatch_invocation.log
for information on how to resolve the above errors.

SQL Patching tool complete on Fri May 15 15:54:25 2020



After checking we found:

[oracle@Testing02 OPatch]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri May 15 15:56:10 2020

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;

VERIFY_QUERYABLE_INVENTORY
--------------------------------------------------------------------------------
ORA-20001: Latest xml inventory is not loaded into table

SQL> select * from OPATCH_XML_INV ;
ERROR:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-25153: Temporary Tablespace is Empty



no rows selected



Solution:

SQL> select file_name,bytes/1024/1024/1024 from dba_temp_files;

no rows selected


SQL> alter tablespace TEMP add tempfile '/Testprod_data/oradata/Testprod/tempfile/temp01.dbf' size 20G;

Tablespace altered.

SQL> exit


[oracle@Testing02 tempfile]$ cd $ORACLE_HOME/bin
[oracle@Testing02 bin]$ cd ../OPatch
[oracle@Testing02 OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.2.0.1.0 Production on Fri May 15 15:59:31 2020
Copyright (c) 2012, 2019, Oracle.  All rights reserved.

Log file for this invocation: /testing/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_31032_2020_05_15_15_59_31/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 DBRU:
  ID 200114 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:
    30593149 (DATABASE JAN 2020 RELEASE UPDATE 12.2.0.1.200114)

Installing patches...
Patch installation complete.  Total patches installed: 1

Validating logfiles...
Patch 30593149 apply: SUCCESS
  logfile: /testing/app/oracle/cfgtoollogs/sqlpatch/30593149/23299902/30593149_apply_TestPROD_2020May15_15_59_39.log (no errors)
SQL Patching tool complete on Fri May 15 16:01:21 2020