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

-
I make backup script for database in which 12c is installed in it as when i wrote script i show me EXPDP – ORA-39006,ORA-39213 Metadata processing is not available for which i do following things :

While Taking full database export using “EXPDP” i was getting below mentioned error :
###############################################
bash-3.2$ expdp directory=datapump dumpfile=expdp_hrs92dmo.dmp logfile=expdp_hrs92dmo.log full=y
Export: Release 11.2.0.2.0 – Production on Thu Feb 27 10:48:09 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Username : sys@hrs92dmo as sysdba
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.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
###############################################
I tried it many times but the error remains the same.
==> Problem Solution :
(1) Check all the oracle registry entry are in valid state. If not check the issue :
###########################################################
SQL> SELECT comp_id, version, status FROM dba_registry;
COMP_ID VERSION STATUS
—————————— —————————— ———–
EM 11.2.0.4.0 VALID
CATALOG 11.2.0.4.0 VALID
CATPROC 11.2.0.4.0 INVALID
###########################################################

(2) Check for Permission :
During dbms_metadata_util.load_stylesheets we read the directory $ORACLE_HOME/rdbms/xml/xsl and load the XSL files using DBMS_LOB package.
If the files cannot be read (most of cases by missing rwx privileges for oracle user), then we raise the errors above.
Re-load the stylesheets using the dbms_metadata_util.load_stylesheets procedure after the permission issue is solved and then retry DataPump export ( expdp ).
###########################################################
SQL> execute dbms_metadata_util.load_stylesheets
PL/SQL procedure successfully completed.
###########################################################

(3) Repair Registry :
In case you have INVALID status in dba_registry. Check it and try to find a solution for it. In my case “CATPROC” was invalid. To resolve this i run “CATPROC.sql” file which is present in “$ORACLE_HOME/RDBMS/admin/” directory :
###########################################################
SQL> ?/rdbms/admin/catproc.sql
###########################################################
I HOPE THIS WILL SOLVE YOUR PROBLEM !!

thanks
DONT FORGET TO COMMENT !!

Comments

Post a Comment

Popular posts from this blog

Query for Tablespace usage with Autoextend

-
                                         Monitoring Tablespace Usage in Oracle I often see questions in Oracle newsgroups and forums about monitoring space in tablespaces, and many of those questions are regarding Enterprise Manager 12c and the alerts it generates reporting the percentage of used space. Of course how you monitor free space depends on whether or not the datafiles are autoextensible. Let's look at several ways to monitor free and used space, starting with methods used in older releases. In versions prior to Oracle 10 DBA_TABLESPACES, DBA_DATA_FILES and DBA_FREE_SPACE were used to generate such reports. One script, from MOS, uses these three views to compute the used space percentage: SELECT SUM(s.used_gb)/SUM(f.total_gb)*100 FROM dba_tablespaces t, ( SELECT tablespace_name, SUM(NVL(bytes,0))/(1024*1024*1024) total_gb FROM dba_data_files ...
Read more

How to configure multiple Oracle listeners

-
How to configure multiple Oracle listeners It happened to me few times during the stress tests that Oracle listener became a bottleneck and not be able to handle the required workload. It was resolved by creating  multiple  listeners which appeared to be a quick solution.  Here is a short step-by-step procedure to configure multiple Oracle listeners  on Solaris for standalone Oracle 9i and 10g environment. 1)  First of all, add additional NIC and cables. They can be on separate subnetwork or the same. In the later, make sure to set static route if needed.    2) Assume that we are going to configure two listeners,   LISTENER and LISTENER2 Modify listener.ora and tnsnames.ora as following: Here is a sample of   listener.ora  LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.3)(PORT = 1521))     ) ...
Read more

sheel script - automatic tablespace addition in oracle 11g

-
      sheel script - automatic tablespace addition in oracle 11g #!/bin/bash a=`sqlplus -s / as sysdba <<END set pagesize 0 feedback off verify off heading off echo off; select tablespace_name from dba_segments group by tablespace_name having SUM(BYTES)/1024/1024>700; END` f=${#a} c=0 for file in $a ; do eval "var$c=$file"; c=$((c+1)); done echo $var0 array1=$(df -kh | grep '/u0*'|awk '{ print $6}') array2=$(df -kh | grep '/u0*'|awk '{ print $5}') size=${#array1} size1=${#array2} if ["$size" -eq 4] && ["$size1" -eq 3] && ["$array2" -gt 85%] && ["$f" -eq 1] then d=${array1[0]:0:4} sqlplus /nolog <<END connect /as sysdba alter tablespace $a add datafile '$d/$a01.dbf' size 10m autoextend on maxsize 28G; END` fi if ["$size" -eq 9] && ["$size1" -eq 3] && ["$array2 -gt...
Read more