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/