EXPDP – ORA-39006,ORA-39213 Metadata processing is not available

==> Environmental Details :
O/S :Windows Server 2008 64 bits
Oracle Version : 11.2.0.1
==> Error Details :
While Taking full database export using “EXPDP” i was getting below mentioned error :
###############################################
C:\> expdp directory=pump_dir=expdp_test.dmp logfile=expdp_test.log full=y
Export: Release 11.2.0.1.0 – Production on Thu Feb 27 10:48:09 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Username : system/oracle123 as sysdba
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.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

###############################################
Soultion
login  to sys
C:\sqlplus sys as sysdba

SQL> execute dbms_metadata_util.load_stylesheets
PL/SQL procedure successfully completed.
###########################################################

This solved my issue.

Comments

Post a Comment

Popular posts from this blog

Oracle Management Server _ EMGC_OMS1 _1 in windows

12c: EM: OMS Server Fails - error nm home replaced Environment: Oracle Enterprise Manager 12c, Windows 2008 R2 Error: Below error occured on one of the client environment C:\Windows\system32> %OMS_HOME%/bin/emctl start oms Oracle Enterprise Manager Cloud Control 12c Release 3 Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved. Windows service OracleManagementServer_EMGC_OMS1_1 failed to be started Oracle Management Server is Down Please check E://gc_inst/em/EMGC_OMS1\sysman\log\emctl.log for error details Log file showed below 2013-12-22 10:30:54,300 [main] INFO wls.OMSController main.219 - Executing emctl command : start 2013-12-22 10:30:58,536 [main] INFO commands.BaseCommand getEnvProps.456 - nm home replaced : E:/gc_inst/NodeManager/emnodemanager 2013-12-22 10:30:58,581 [main] INFO commands.StartCommand startOMS.371 - net start return code is 2 2013-12-22 10:30:58,582 [main] ERROR commands.BaseCommand logAndPrint.620 - Windows service OracleManagementServe...
Read more

ORA-00600: internal error code, arguments: [qctVCO:csform] ORA-64131 ORA-01403 Errors After Upgrade From 11.2.0.1 To 11.2.0.3 (Doc ID 1394206.1) when database is running in the Chinese language

Solution APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 or 11.2.0.4 [Release 11.2] Information in this document applies to any platform. ***Checked for relevance on 24-Jul-2013*** SYMPTOMS After upgrading the database from 11.2.0.1.0 to 11.2.0.2 or 11.2.0.3.0, XDB upgraded successfully but now there are XDB errors of: Tue Jan 10 13:22:01 2012 XDB installed. XDB initialized. .. ORA-00600: internal error code, arguments: [qctVCO:csform], [0], [0], [0], [0], [1], [2], [213], [], [], [], [] ORA-64131: XMLIndex Metadata: failure during the looking up of the dictionary ORA-01403: no data found And the following object(s) are invalid in the database: SYS ALL_XSC_SECURITY_CLASS_DEP VIEW SYS ALL_XSC_SECURITY_CLASS VIEW SYS ALL_XSC_PRIVILEGE VIEW SYS ALL_XSC_AGGREGATE_PRIVILEGE VIEW SYS ALL_XSC_SECURITY_CLASS_STATUS VIEW Attempts to recompile these objects also fail with the above errors. CAUSE T...
Read more