Total Pageviews

Sunday, September 19, 2021

ORA-39213: Metadata processing is not available OR ORA-39006: internal error

SOLUTION

Connect sql as sysdba

[oracle@localhost ~]$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 19 19:39:15 2021

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

Enter user-name: / as sysdba

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SELECT comp_id, version, status FROM dba_registry;

SQL>  execute dbms_metadata_util.load_stylesheets

PL/SQL procedure successfully completed.

SQL> exit

[oracle@localhost ~]$

No comments:

Post a Comment

ORA-00845: MEMORY_TARGET not supported on this system

 The shared memory file system should have enough space to accommodate the MEMORY_TARGET and MEMORY_MAX_TARGET values. To verify: SQL> sh...