image

errors at datapump impdp expdp – ORA-39213: Metadata processing is not available

When i tried to export the database using the expdmp with the following command $expdp username/password dumpfile=export.dmp logfile=export.log full=y parallel=4 I got the following error. Error: With the Partitioning, OLAP and Data Mining options ORA-39006: internal error ORA-39213: Metadata processing is not available   How i solved it ? $sqlplus / as sysdba SQL>execute dbms_metadata_util.load_stylesheets … continue reading

image

ORA-12518 Tns: Listener could not hand off client Connection

What i did & resulted the above problem? $Sqlplus  / as sysdba SQL>show parameter proceses; -1500 SQL> show parameter sessions; SQL> alter system set processes=3000 scope=spfile; SQL>alter system set sessions=2500 scope=spfile; SQL> shutdown immediate; SQL> Startup open; ERROR: ORA-12518: TNS:listener could not hand off client connection. How I solved the problem ORA-12518 Tns: Listener could … continue reading

image

ORA-25153: Temporary Tablespace is Empty

Problem Description: During the Fine Grained Auditing , first i created the following script SQL>connect / as sysdba SQL>begin DBMS_FGA.ADD_POLICY( OBJECT_SCHEMA=>’CMS_USER’, OBJECT_NAME=>’hearing’, POLICY_NAME=>’hearing_policy’, AUDIT_COLUMN=>’hearing_title’, STATEMENT_TYPES=>’UPDATE,DELETE,SELECT’ ); END; After executing the above query , i run the following query SQL>connect cms_user/cms; SQL>select * from hearing Which result the error:  Temporary Tablespace is Empty What the Problem … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube