ORA-06512

Error:

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP,
Data Mining, Oracle Database Vault and Real Application Testing options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_IMPORT_FULL_01 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 736
ORA-31615: routine CREATE_QUEUES received this error:
Timeout

 

Solution:

The parameter aq_tm_processes is set to 0 and Oracle cannot create the queues needed for datapump export.

Set *.aq_tm_processes > 0 to be able to create the queues when exporting , using the below syntax

alter system set aq_tm_processes = 5 scope = both;  

or in RAC:  

alter system set aq_tm_processes = 5 scope = both sid ='*';

Issue occurred when export the datafile

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

ORA-31626: job does not exist

ORA-31637: cannot create job SYS_IMPORT_SCHEMA_01 for user SYS

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPV$FT", line 1569

ORA-39062: error creating master process DM00

ORA-39105: Master process DM00 failed during startup. Master error:

ORA-28031: maximum of  enabled roles exceeded

 

连到Toad，检查Role，删除多余无用的role。查看schedule job，是不是有正在

oracle实例内存（SGA和PGA）调整
http://log-cd.iteye.com/blog/562052

aq_tm_processes 参数误设引起的服务器load average居高不下
http://www.5ilinux.com/2014/04/aq_tm_processes_load-average.html

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26477398/viewspace-1409759/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26477398/viewspace-1409759/