ITPub博客

首页 > 数据库 > Oracle > ORA-06512

ORA-06512

原创 Oracle 作者:fiona8953 时间:2015-01-21 17:41:40 0 删除 编辑

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博客 ” ,链接:https://blog.itpub.net/26477398/viewspace-1409759/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: elapsed_time
请登录后发表评论 登录
全部评论

注册时间:2014-06-13

  • 博文量
    284
  • 访问量
    222490