ORA-06512: at SYS.DBMS_METADATA_UTIL Error

-

 If you face an error like the following while performing “impdp” operations:


Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

ORA-39006: internal error

ORA-39065: unexpected master process exception in DISPATCH

ORA-01001: invalid cursor

ORA-06512: at "SYS.DBMS_METADATA_UTIL", line 3343

ORA-06512: at "SYS.KUPM$MCP", line 2636

ORA-39097: Data Pump job encountered unexpected error -1001


Solution:


execute the following command:

SQL> exec dbms_metadata_util.load_stylesheets;


If the above query executes sucessfully then try the “impdp” command again.


Connected to:

Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

Version 18.3.0.0.0

SQL> exec dbms_metadata_util.load_stylesheets;

PL/SQL procedure successfully completed.

SQL>



Comments

Post a Comment

Popular posts from this blog

RC-00118: Error occurred during creation of database Raised by oracle.apps.ad.clone.ApplyDatabase

-
Error Occurred :– Trying to connect using SID as ServiceName.DomainName getConnectionUsingServiceName() –> JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oratest.tipl.com)(PORT=1532))(CONNECT_DATA=(SERVICE_NAME=TIR12.ticfg.com))) Exception occurred: java.sql.SQLException: The Network Adapter could not establish the connection Connection could not be obtained; returning null RC-00118: Error occurred during creation of database StackTrace: java.lang.Exception: Control file creation failed at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:661) at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:328) at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:304) at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:154) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.re...
Read more

The install cannot proceed as service OracleServiceXE is present on the system

-
If you are not able to remove oracle from the above workaround. Please follow below steps to remove OracleServiceXE. Solution:– Try to delete the service using the command prompt: Click Start, type ‘cmd’ in the search field, and when ‘cmd’ shows up in the list of options, right click it and select ‘Run as Administrator’. At the Command Prompt window, type “sc delete OracleServiceXE” without the quotes and press Enter. Type “Exit” and press Enter. Hope it helps. C:\> sc stop OracleServiceXE                      (to Stop service) C:\> sc delete OracleServiceXE                      (to remove)
Read more