When trying to expdp or impdp you got error below:
#################################################################################################
Export: Release 11.2.0.3.0 - Production on Tue Mar 5 11:57:03 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39006: internal error
ORA-39213: Metadata processing is not available
#################################################################################################
Run the procedure below to fix the problem:
sqlplus / as sysdba
SQL> execute sys.dbms_metadata_util.load_stylesheets;
Best Regards,
Paulo Portugal
#################################################################################################
Export: Release 11.2.0.3.0 - Production on Tue Mar 5 11:57:03 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39006: internal error
ORA-39213: Metadata processing is not available
#################################################################################################
Run the procedure below to fix the problem:
sqlplus / as sysdba
SQL> execute sys.dbms_metadata_util.load_stylesheets;
Best Regards,
Paulo Portugal
Thank you so much! I have a question: Why this?
ReplyDeleteHi Jefferson,
ReplyDeleteThis could happens if you have a logon_trigger. This is a BUG 9858539 .
Best Regards,
Paulo Portugal
thank you very much. is it happened because of oracle installation problem ?
ReplyDeleteAl ejecutar el comando: SQL> execute sys.dbms_metadata_util.load_stylesheets;
ReplyDeleteme salen estos errores
SQL*Plus: Release 11.2.0.2.0 Production on Vie Ene 16 15:53:12 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> conn sys as sysdba
Enter password:
Connected.
SQL> execute sys.dbms_metadata_util.load_stylesheets;
BEGIN sys.dbms_metadata_util.load_stylesheets; END;
*
ERROR at line 1:
ORA-31609: error loading file "kucolumn.xsl" from file system directory
"C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\xml\xsl"
ORA-06512: at "SYS.DBMS_METADATA_UTIL", line 2397
ORA-06512: at line 1
SQL>
Muito obrigado pela a dica...
ReplyDelete