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

Hello Friends,

Error with the patch "Unable to obtain current patch information due to error: 20001, ORA-20001: Latest xml inventory is not loaded into table"

So the scenario is :

After opening database in resetlogs mode getting error "Unable to obtain current patch information due to error: 20001, ORA-20001: Latest xml inventory is not loaded into table"

Error In alertlog :

********************  END OF WARNING *******************

Completed: alter database open resetlogs
2023-06-30T09:16:33.935407+03:00
Unable to obtain current patch information due to error: 20001, ORA-20001: Latest xml inventory is not loaded into table
ORA-06512: at "SYS.DBMS_QOPATCH", line 2327
ORA-06512: at "SYS.DBMS_QOPATCH", line 854
ORA-06512: at "SYS.DBMS_QOPATCH", line 937
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_QOPATCH", line 932
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-01157: cannot identify/lock data file 203 - see DBWR trace file
ORA-01110: data file 203: '/oracle/DMZ/sapdata4/temp_1/temp.data10'
ORA-06512: at "SYS.DBMS_QOPATCH", line 919
ORA-06512: at "SYS.DBMS_QOPATCH", line 2286
ORA-06512: at "SYS.DBMS_QOPATCH", line 817
ORA-06512: at "SYS.DBMS_QOPATCH", line 2309

===========================================================
Dumping current patch information
===========================================================
Unable to obtain current patch information due to error: 20001
===========================================================.

Solution to error :

SQL> select * from dba_temp_files;
select * from dba_temp_files
              *
ERROR at line 1:
ORA-01157: cannot identify/lock data file 202 - see DBWR trace file
ORA-01110: data file 202: '/oracle/DMZ/sapdata4/temp_1/temp.data11'

Do a tempfile rollover :

SQL> CREATE TEMPORARY TABLESPACE TEMP_NEW TEMPFILE '+DATA' size 20G;

Tablespace created.

SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP_NEW;

Database altered.

SQL> select name from v$tablespace;

NAME
------------------------------
SYSTEM
SYSAUX
PSAPUNDO
PSAPTEMP
PSAPSR3
PSAPSR3700
PSAPSR3USR
PSAPYBMCD
PSAPYBMCI
TEMP_NEW

10 rows selected.

SQL> DROP TABLESPACE PSAPTEMP including contents and datafiles;

Tablespace dropped.

SQL> CREATE TEMPORARY TABLESPACE PSAPTEMP TEMPFILE '+DATA' size 20G autoextend on next 1G maxsize unlimited;

Tablespace created.

SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE PSAPTEMP;

Database altered.

SQL> DROP TABLESPACE TEMP_NEW including contents and datafiles;

Tablespace dropped.

• Tweet
• Share
• Share
• Share
• Share

Related Post