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
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
Comments
Post a Comment